eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKC_REP_UTIL_PVT dependencies on OKC_REP_CONTRACTS_ALL

Line 54: l_org_id OKC_REP_CONTRACTS_ALL.ORG_ID%type;

50: x_return_status OUT NOCOPY VARCHAR2)
51: IS
52:
53: l_api_name VARCHAR2(30);
54: l_org_id OKC_REP_CONTRACTS_ALL.ORG_ID%type;
55: l_result VARCHAR2(1);
56:
57: CURSOR intents_csr(p_contract_type IN VARCHAR2) IS
58: SELECT NULL

Line 440: l_org_id OKC_REP_CONTRACTS_ALL.ORG_ID%type;

436: x_return_status OUT NOCOPY VARCHAR2)
437: IS
438:
439: l_api_name VARCHAR2(30);
440: l_org_id OKC_REP_CONTRACTS_ALL.ORG_ID%type;
441: l_owner_id OKC_REP_CONTRACTS_ALL.OWNER_ID%type;
442: l_contract_type OKC_REP_CONTRACTS_ALL.CONTRACT_TYPE%type;
443: l_use_acl_flag OKC_REP_CONTRACTS_ALL.USE_ACL_FLAG%type;
444: l_result VARCHAR2(1);

Line 441: l_owner_id OKC_REP_CONTRACTS_ALL.OWNER_ID%type;

437: IS
438:
439: l_api_name VARCHAR2(30);
440: l_org_id OKC_REP_CONTRACTS_ALL.ORG_ID%type;
441: l_owner_id OKC_REP_CONTRACTS_ALL.OWNER_ID%type;
442: l_contract_type OKC_REP_CONTRACTS_ALL.CONTRACT_TYPE%type;
443: l_use_acl_flag OKC_REP_CONTRACTS_ALL.USE_ACL_FLAG%type;
444: l_result VARCHAR2(1);
445: l_user_id FND_USER.USER_ID%type;

Line 442: l_contract_type OKC_REP_CONTRACTS_ALL.CONTRACT_TYPE%type;

438:
439: l_api_name VARCHAR2(30);
440: l_org_id OKC_REP_CONTRACTS_ALL.ORG_ID%type;
441: l_owner_id OKC_REP_CONTRACTS_ALL.OWNER_ID%type;
442: l_contract_type OKC_REP_CONTRACTS_ALL.CONTRACT_TYPE%type;
443: l_use_acl_flag OKC_REP_CONTRACTS_ALL.USE_ACL_FLAG%type;
444: l_result VARCHAR2(1);
445: l_user_id FND_USER.USER_ID%type;
446: l_user_name FND_USER.USER_NAME%type;

Line 443: l_use_acl_flag OKC_REP_CONTRACTS_ALL.USE_ACL_FLAG%type;

439: l_api_name VARCHAR2(30);
440: l_org_id OKC_REP_CONTRACTS_ALL.ORG_ID%type;
441: l_owner_id OKC_REP_CONTRACTS_ALL.OWNER_ID%type;
442: l_contract_type OKC_REP_CONTRACTS_ALL.CONTRACT_TYPE%type;
443: l_use_acl_flag OKC_REP_CONTRACTS_ALL.USE_ACL_FLAG%type;
444: l_result VARCHAR2(1);
445: l_user_id FND_USER.USER_ID%type;
446: l_user_name FND_USER.USER_NAME%type;
447: l_status_code OKC_REP_CONTRACTS_ALL.CONTRACT_STATUS_CODE%type;

Line 447: l_status_code OKC_REP_CONTRACTS_ALL.CONTRACT_STATUS_CODE%type;

443: l_use_acl_flag OKC_REP_CONTRACTS_ALL.USE_ACL_FLAG%type;
444: l_result VARCHAR2(1);
445: l_user_id FND_USER.USER_ID%type;
446: l_user_name FND_USER.USER_NAME%type;
447: l_status_code OKC_REP_CONTRACTS_ALL.CONTRACT_STATUS_CODE%type;
448: l_sign_type OKC_REP_CONTRACTS_ALL.ESIGNATURE_REQUIRED%type;
449: l_approversOut ame_util.approversTable2;
450: l_process_complete_yn varchar2(1);
451: l_item_indexes ame_util.idList;

Line 448: l_sign_type OKC_REP_CONTRACTS_ALL.ESIGNATURE_REQUIRED%type;

444: l_result VARCHAR2(1);
445: l_user_id FND_USER.USER_ID%type;
446: l_user_name FND_USER.USER_NAME%type;
447: l_status_code OKC_REP_CONTRACTS_ALL.CONTRACT_STATUS_CODE%type;
448: l_sign_type OKC_REP_CONTRACTS_ALL.ESIGNATURE_REQUIRED%type;
449: l_approversOut ame_util.approversTable2;
450: l_process_complete_yn varchar2(1);
451: l_item_indexes ame_util.idList;
452: l_item_classes ame_util.stringList;

Line 477: FROM okc_rep_contracts_all

473: use_acl_flag,
474: contract_type,
475: contract_status_code,
476: esignature_required
477: FROM okc_rep_contracts_all
478: WHERE contract_id = p_contract_id;
479:
480: CURSOR contract_signers_csr(p_contract_id in number) IS
481: SELECT usr.user_id

Line 1078: UPDATE okc_rep_contracts_all

1074: 'Before updating Contract Status');
1075: END IF;
1076:
1077: -- Update the contract status
1078: UPDATE okc_rep_contracts_all
1079: SET contract_status_code = p_status_code,
1080: contract_last_update_date = sysdate,
1081: contract_last_updated_by = FND_GLOBAL.user_id()
1082: WHERE contract_id = p_contract_id

Line 3939: SELECT OKC_REP_CONTRACTS_ALL_S1.NEXTVAL

3935: l_notify_contact_role_id NUMBER;
3936: l_con_num_hook NUMBER;
3937:
3938: CURSOR CONTRACT_ID_CSR IS
3939: SELECT OKC_REP_CONTRACTS_ALL_S1.NEXTVAL
3940: FROM DUAL;
3941:
3942: CURSOR CONTRACT_NUMBER_CSR IS
3943: SELECT OKC_REP_CONTRACTS_ALL_S2.NEXTVAL

Line 3943: SELECT OKC_REP_CONTRACTS_ALL_S2.NEXTVAL

3939: SELECT OKC_REP_CONTRACTS_ALL_S1.NEXTVAL
3940: FROM DUAL;
3941:
3942: CURSOR CONTRACT_NUMBER_CSR IS
3943: SELECT OKC_REP_CONTRACTS_ALL_S2.NEXTVAL
3944: FROM DUAL;
3945:
3946: CURSOR CONTRACT_NUMBER_CSR_3 IS
3947: SELECT OKC_REP_CONTRACTS_ALL_S3.NEXTVAL

Line 3947: SELECT OKC_REP_CONTRACTS_ALL_S3.NEXTVAL

3943: SELECT OKC_REP_CONTRACTS_ALL_S2.NEXTVAL
3944: FROM DUAL;
3945:
3946: CURSOR CONTRACT_NUMBER_CSR_3 IS
3947: SELECT OKC_REP_CONTRACTS_ALL_S3.NEXTVAL
3948: FROM DUAL;
3949:
3950: CURSOR CONTRACT_NUMBER_CSR_4 IS
3951: SELECT OKC_REP_CONTRACTS_ALL_S4.NEXTVAL

Line 3951: SELECT OKC_REP_CONTRACTS_ALL_S4.NEXTVAL

3947: SELECT OKC_REP_CONTRACTS_ALL_S3.NEXTVAL
3948: FROM DUAL;
3949:
3950: CURSOR CONTRACT_NUMBER_CSR_4 IS
3951: SELECT OKC_REP_CONTRACTS_ALL_S4.NEXTVAL
3952: FROM DUAL;
3953:
3954: CURSOR CONTRACT_NUMBER_CSR_5 IS
3955: SELECT OKC_REP_CONTRACTS_ALL_S5.NEXTVAL

Line 3955: SELECT OKC_REP_CONTRACTS_ALL_S5.NEXTVAL

3951: SELECT OKC_REP_CONTRACTS_ALL_S4.NEXTVAL
3952: FROM DUAL;
3953:
3954: CURSOR CONTRACT_NUMBER_CSR_5 IS
3955: SELECT OKC_REP_CONTRACTS_ALL_S5.NEXTVAL
3956: FROM DUAL;
3957:
3958: CURSOR CONTRACT_NUMBER_UNIQUE_CSR (p_contract_number VARCHAR2,p_contract_type VARCHAR2,p_org_id NUMBER ,p_contract_type_txt VARCHAR2,p_org_name VARCHAR2 , p_imp_contract_id NUMBER) IS
3959: SELECT CONTRACT_NUMBER

Line 3960: FROM OKC_REP_CONTRACTS_ALL

3956: FROM DUAL;
3957:
3958: CURSOR CONTRACT_NUMBER_UNIQUE_CSR (p_contract_number VARCHAR2,p_contract_type VARCHAR2,p_org_id NUMBER ,p_contract_type_txt VARCHAR2,p_org_name VARCHAR2 , p_imp_contract_id NUMBER) IS
3959: SELECT CONTRACT_NUMBER
3960: FROM OKC_REP_CONTRACTS_ALL
3961: WHERE UPPER(CONTRACT_NUMBER) = UPPER(p_contract_number)
3962: AND UPPER(CONTRACT_TYPE) = UPPER(p_contract_type)
3963: AND org_id= p_org_id
3964: UNION

Line 5590: -- to OKC_REP_CONTRACTS_ALL AND OKC_REP_CONTRACT_PARTIES

5586: --API name : insert_prod_data
5587: --Type : Private.
5588: --Function : Insert validated contracts and parties into production tables
5589: -- i.e., move from OKC_REP_IMP_CONTRACTS_T and OKC_REP_IMP_PARTIES_T
5590: -- to OKC_REP_CONTRACTS_ALL AND OKC_REP_CONTRACT_PARTIES
5591: -- It also insert a record into OKC_REP_CON_STATUS_HIST for every record
5592: -- inserted into OKC_REP_CONTRACTS_ALL.
5593: --Pre-reqs : Currently only called from repository import.
5594: -- Contracts should be saved to the OKC_REP_IMP_CONTRACTS_T table

Line 5592: -- inserted into OKC_REP_CONTRACTS_ALL.

5588: --Function : Insert validated contracts and parties into production tables
5589: -- i.e., move from OKC_REP_IMP_CONTRACTS_T and OKC_REP_IMP_PARTIES_T
5590: -- to OKC_REP_CONTRACTS_ALL AND OKC_REP_CONTRACT_PARTIES
5591: -- It also insert a record into OKC_REP_CON_STATUS_HIST for every record
5592: -- inserted into OKC_REP_CONTRACTS_ALL.
5593: --Pre-reqs : Currently only called from repository import.
5594: -- Contracts should be saved to the OKC_REP_IMP_CONTRACTS_T table
5595: -- Date should all be validated in OKC_REP_IMP_CONTRACTS_T,
5596: -- : OKC_REP_IMP_PARTIES_T, and OKC_REP_IMP_DOCUMENTS_T

Line 5635: FROM okc_rep_contracts_all

5631: l_insert_batch_size NUMBER;
5632:
5633: CURSOR number_inserted_csr IS
5634: SELECT COUNT(contract_id)
5635: FROM okc_rep_contracts_all
5636: WHERE run_id = p_run_id;
5637:
5638: CURSOR contract_id_cur IS
5639: SELECT

Line 5708: INSERT INTO okc_rep_contracts_all

5704:
5705: FND_FILE.PUT_LINE(FND_FILE.LOG, '***** SAVEPOINT before_insert_contracts *****');
5706:
5707: --Bulk insert contracts
5708: INSERT INTO okc_rep_contracts_all
5709: (contract_id,
5710: contract_version_num,
5711: contract_name,
5712: contract_number,

Line 5839: FND_FILE.PUT_LINE(FND_FILE.LOG, '* INSERT INTO okc_rep_contracts_all *');

5835: AND valid_flag = 'Y'
5836: AND contract_id >= l_start_contract_id
5837: AND contract_id < l_start_contract_id + l_insert_batch_size;
5838:
5839: FND_FILE.PUT_LINE(FND_FILE.LOG, '***** INSERT INTO okc_rep_contracts_all *****');
5840:
5841: --insert into contract parties
5842: INSERT INTO okc_rep_contract_parties
5843: (

Line 5960: FROM okc_rep_contracts_all

5956: creation_date,
5957: last_updated_by,
5958: last_update_date,
5959: last_update_login
5960: FROM okc_rep_contracts_all
5961: WHERE run_id = p_run_id
5962: AND created_by = FND_GLOBAL.USER_ID
5963: AND contract_id >= l_start_contract_id
5964: AND contract_id < l_start_contract_id + l_insert_batch_size;

Line 6209: -- okc_rep_contracts_all and okc_rep_contract_parties

6205: --API name : validate_and_insert_contracts
6206: --Type : Private.
6207: --Function : Validates contracts in the interface tables, and then insert
6208: -- the valid ones into production tables:
6209: -- okc_rep_contracts_all and okc_rep_contract_parties
6210: -- Note that contract documents are inserted in the Java layer after this
6211: --Pre-reqs : Currently only called from repository import.
6212: -- : Contracts should be saved to the OKC_REP_IMP_CONTRACTS_T table
6213: --Parameters :

Line 7508: FROM okc_rep_contracts_all

7504:
7505:
7506: CURSOR l_contract_exist_csr IS
7507: SELECT contract_id
7508: FROM okc_rep_contracts_all
7509: WHERE contract_id=p_doc_id;
7510:
7511: CURSOR l_contract_updatable_csr IS
7512: SELECT contract_id

Line 7513: FROM okc_rep_contracts_all

7509: WHERE contract_id=p_doc_id;
7510:
7511: CURSOR l_contract_updatable_csr IS
7512: SELECT contract_id
7513: FROM okc_rep_contracts_all
7514: WHERE contract_id=p_doc_id
7515: AND contract_status_code in (G_STATUS_REJECTED, G_STATUS_DRAFT);
7516:
7517:

Line 7562: -- UPDATE okc_rep_contracts_all

7558: CLOSE l_contract_exist_csr;
7559: ELSE
7560: -- Update the CONTRACT_LAST_UPDATE_DATE and CONTRACT_LAST_UPDATE_BY columns
7561: -- No need to updated these columns. These are updated upon View Contract.
7562: -- UPDATE okc_rep_contracts_all
7563: -- SET CONTRACT_LAST_UPDATE_DATE = sysdate,
7564: -- CONTRACT_LAST_UPDATED_BY = FND_GLOBAL.user_id()
7565: -- WHERE contract_id = p_doc_id;
7566: l_ok_to_commit := FND_API.G_TRUE;

Line 7582: -- UPDATE okc_rep_contracts_all

7578: CLOSE l_contract_updatable_csr;
7579: ELSE
7580: -- Update the CONTRACT_LAST_UPDATE_DATE and CONTRACT_LAST_UPDATE_BY columns
7581: -- No need to updated these columns. These are updated upon View Contract.
7582: -- UPDATE okc_rep_contracts_all
7583: -- SET CONTRACT_LAST_UPDATE_DATE = sysdate,
7584: -- CONTRACT_LAST_UPDATED_BY = FND_GLOBAL.user_id()
7585: -- WHERE contract_id = p_doc_id;
7586: l_ok_to_commit := FND_API.G_TRUE;

Line 7836: l_org_id okc_rep_contracts_all.org_id%TYPE;

7832: l_rel_party_id NUMBER;
7833: l_rel_id NUMBER;
7834: l_org_contact_id NUMBER;
7835: l_party_site_id NUMBER;
7836: l_org_id okc_rep_contracts_all.org_id%TYPE;
7837:
7838: CURSOR contract_org_csr IS
7839: SELECT org_id
7840: FROM okc_rep_contracts_all

Line 7840: FROM okc_rep_contracts_all

7836: l_org_id okc_rep_contracts_all.org_id%TYPE;
7837:
7838: CURSOR contract_org_csr IS
7839: SELECT org_id
7840: FROM okc_rep_contracts_all
7841: WHERE contract_id = p_contract_id;
7842:
7843: /* Bug 8721411 */
7844: CURSOR get_party_id( okc_contract_id OKC_REP_CONTRACT_PARTIES.contract_id%TYPE ,

Line 7981: l_desc okc_rep_contracts_all.contract_desc%TYPE;

7977: IS
7978: l_api_name VARCHAR2(32);
7979: l_api_version NUMBER;
7980:
7981: l_desc okc_rep_contracts_all.contract_desc%TYPE;
7982: l_use_acl_flag okc_rep_contracts_all.use_acl_flag%TYPE;
7983: l_expire_ntf_flag okc_rep_contracts_all.expire_ntf_flag%TYPE;
7984: l_expire_ntf_period okc_rep_contracts_all.expire_ntf_period%TYPE;
7985: l_ntf_contact_role_id okc_rep_contracts_all.notify_contact_role_id%TYPE;

Line 7982: l_use_acl_flag okc_rep_contracts_all.use_acl_flag%TYPE;

7978: l_api_name VARCHAR2(32);
7979: l_api_version NUMBER;
7980:
7981: l_desc okc_rep_contracts_all.contract_desc%TYPE;
7982: l_use_acl_flag okc_rep_contracts_all.use_acl_flag%TYPE;
7983: l_expire_ntf_flag okc_rep_contracts_all.expire_ntf_flag%TYPE;
7984: l_expire_ntf_period okc_rep_contracts_all.expire_ntf_period%TYPE;
7985: l_ntf_contact_role_id okc_rep_contracts_all.notify_contact_role_id%TYPE;
7986:

Line 7983: l_expire_ntf_flag okc_rep_contracts_all.expire_ntf_flag%TYPE;

7979: l_api_version NUMBER;
7980:
7981: l_desc okc_rep_contracts_all.contract_desc%TYPE;
7982: l_use_acl_flag okc_rep_contracts_all.use_acl_flag%TYPE;
7983: l_expire_ntf_flag okc_rep_contracts_all.expire_ntf_flag%TYPE;
7984: l_expire_ntf_period okc_rep_contracts_all.expire_ntf_period%TYPE;
7985: l_ntf_contact_role_id okc_rep_contracts_all.notify_contact_role_id%TYPE;
7986:
7987: CURSOR contract_attribs_csr IS

Line 7984: l_expire_ntf_period okc_rep_contracts_all.expire_ntf_period%TYPE;

7980:
7981: l_desc okc_rep_contracts_all.contract_desc%TYPE;
7982: l_use_acl_flag okc_rep_contracts_all.use_acl_flag%TYPE;
7983: l_expire_ntf_flag okc_rep_contracts_all.expire_ntf_flag%TYPE;
7984: l_expire_ntf_period okc_rep_contracts_all.expire_ntf_period%TYPE;
7985: l_ntf_contact_role_id okc_rep_contracts_all.notify_contact_role_id%TYPE;
7986:
7987: CURSOR contract_attribs_csr IS
7988: SELECT contract_desc,

Line 7985: l_ntf_contact_role_id okc_rep_contracts_all.notify_contact_role_id%TYPE;

7981: l_desc okc_rep_contracts_all.contract_desc%TYPE;
7982: l_use_acl_flag okc_rep_contracts_all.use_acl_flag%TYPE;
7983: l_expire_ntf_flag okc_rep_contracts_all.expire_ntf_flag%TYPE;
7984: l_expire_ntf_period okc_rep_contracts_all.expire_ntf_period%TYPE;
7985: l_ntf_contact_role_id okc_rep_contracts_all.notify_contact_role_id%TYPE;
7986:
7987: CURSOR contract_attribs_csr IS
7988: SELECT contract_desc,
7989: use_acl_flag,

Line 7993: FROM okc_rep_contracts_all

7989: use_acl_flag,
7990: expire_ntf_flag,
7991: expire_ntf_period,
7992: notify_contact_role_id
7993: FROM okc_rep_contracts_all
7994: WHERE contract_id = p_contract_id;
7995:
7996: BEGIN
7997: l_api_name := 'sync_con_header_attributes';

Line 8112: l_status_code OKC_REP_CONTRACTS_ALL.CONTRACT_STATUS_CODE%TYPE;

8108: x_msg_count OUT NOCOPY NUMBER,
8109: x_return_status OUT NOCOPY VARCHAR2)
8110: IS
8111:
8112: l_status_code OKC_REP_CONTRACTS_ALL.CONTRACT_STATUS_CODE%TYPE;
8113: l_archived_yn OKC_REP_DOC_VERSIONS_V.ARCHIVED_YN%TYPE;
8114:
8115: BEGIN
8116:

Line 8383: SELECT Nvl((SELECT 'Y' FROM okc_rep_contracts_all WHERE contract_type = p_contract_type AND ROWNUM =1),'N') INTO x_disable_subentities_yn FROM dual;

8379:
8380: END IF;
8381:
8382:
8383: SELECT Nvl((SELECT 'Y' FROM okc_rep_contracts_all WHERE contract_type = p_contract_type AND ROWNUM =1),'N') INTO x_disable_subentities_yn FROM dual;
8384:
8385: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
8386: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
8387: 'OKC_REP_UTIL_PVT.DocTyp_subent_disabled_yn returns x_disable_subentities_yn as : '