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.OKL_PARTY_MERGE_PUB dependencies on OKC_RULES_B

Line 6144: -- Description : Updating the table: OKC_RULES_B for column: OBJECT1_ID1

6140:
6141: ----------------------------------------------------------------------------------------------------------
6142: -- Start of comments
6143: -- Procedure Name : RUL_PARTY_SITE_MERGE
6144: -- Description : Updating the table: OKC_RULES_B for column: OBJECT1_ID1
6145: -- Business Rules : performing PARTY MERGE for table: OKC_RULES_B and col: OBJECT1_ID1
6146: -- for the records created by Lease Management for Party Site
6147: -- Parameters :
6148: -- Version : 1.0

Line 6145: -- Business Rules : performing PARTY MERGE for table: OKC_RULES_B and col: OBJECT1_ID1

6141: ----------------------------------------------------------------------------------------------------------
6142: -- Start of comments
6143: -- Procedure Name : RUL_PARTY_SITE_MERGE
6144: -- Description : Updating the table: OKC_RULES_B for column: OBJECT1_ID1
6145: -- Business Rules : performing PARTY MERGE for table: OKC_RULES_B and col: OBJECT1_ID1
6146: -- for the records created by Lease Management for Party Site
6147: -- Parameters :
6148: -- Version : 1.0
6149: -- End of comments

Line 6210: arp_message.set_token('TABLE_NAME','OKC_RULES_B',FALSE);

6206: if p_from_fk_id <> p_to_fk_id
6207: then
6208: begin
6209: arp_message.set_name('AR','AR_UPDATING_TABLE');
6210: arp_message.set_token('TABLE_NAME','OKC_RULES_B',FALSE);
6211:
6212: IF p_parent_entity_name = 'HZ_PARTY_SITES'
6213: THEN
6214: --updating the OKC_RULES_B table for column references OBJECT1_ID1

Line 6214: --updating the OKC_RULES_B table for column references OBJECT1_ID1

6210: arp_message.set_token('TABLE_NAME','OKC_RULES_B',FALSE);
6211:
6212: IF p_parent_entity_name = 'HZ_PARTY_SITES'
6213: THEN
6214: --updating the OKC_RULES_B table for column references OBJECT1_ID1
6215: --and JTOT_OBJECT1_CODE = 'OKL_PARTYSITE'
6216: UPDATE OKC_RULES_B TAB
6217: SET TAB.OBJECT1_ID1 = p_to_fk_id
6218: , TAB.object_version_number = TAB.object_version_number + 1

Line 6216: UPDATE OKC_RULES_B TAB

6212: IF p_parent_entity_name = 'HZ_PARTY_SITES'
6213: THEN
6214: --updating the OKC_RULES_B table for column references OBJECT1_ID1
6215: --and JTOT_OBJECT1_CODE = 'OKL_PARTYSITE'
6216: UPDATE OKC_RULES_B TAB
6217: SET TAB.OBJECT1_ID1 = p_to_fk_id
6218: , TAB.object_version_number = TAB.object_version_number + 1
6219: , TAB.last_update_date = SYSDATE
6220: , TAB.last_updated_by = arp_standard.profile.user_id

Line 6234: 'OKC_RULES_B for = '|| p_from_id));

6230: when others
6231: then
6232: arp_message.set_line(G_PKG_NAME || '.' || l_api_name || ': ' || sqlerrm);
6233: fnd_file.put_line(fnd_file.log,(G_PKG_NAME || '.' || l_api_name ||
6234: 'OKC_RULES_B for = '|| p_from_id));
6235: fnd_file.put_line(fnd_file.log, G_PKG_NAME||'.'||l_api_name||':'||sqlerrm);
6236: x_return_status := FND_API.G_RET_STS_ERROR;
6237: END;
6238: END IF;

Line 6245: | Account merge procedure for the table, OKC_RULES_B for OKL

6241: /*-------------------------------------------------------------
6242: | PROCEDURE
6243: | RUL_ACCOUNT_MERGE
6244: | DESCRIPTION :
6245: | Account merge procedure for the table, OKC_RULES_B for OKL
6246: | specific usage of rules architecture. OKL uses rules
6247: | architecture for storing vendor billing information where
6248: | billing party is stored in rules tables for the vendor account
6249: | This API will be called prior to the OKC hook of account merge.

Line 6261: TYPE ID_LIST_TYPE IS TABLE OF OKC_RULES_B.ID%TYPE

6257: RA_CUSTOMER_MERGE_HEADERS.CUSTOMER_MERGE_HEADER_ID%TYPE
6258: INDEX BY BINARY_INTEGER;
6259: MERGE_HEADER_ID_LIST MERGE_HEADER_ID_LIST_TYPE;
6260:
6261: TYPE ID_LIST_TYPE IS TABLE OF OKC_RULES_B.ID%TYPE
6262: INDEX BY BINARY_INTEGER;
6263: PRIMARY_KEY_ID_LIST ID_LIST_TYPE;
6264:
6265: TYPE CUST_ACCT_ID_LIST_TYPE IS TABLE OF OKC_K_PARTY_ROLES_B.CUST_ACCT_ID%TYPE

Line 6271: OKC_RULES_B.OBJECT1_ID1%TYPE

6267: NUM_COL1_ORIG_LIST CUST_ACCT_ID_LIST_TYPE;
6268: NUM_COL1_NEW_LIST CUST_ACCT_ID_LIST_TYPE;
6269:
6270: TYPE RUL_OBJ1_ID_LIST_TYPE IS TABLE OF
6271: OKC_RULES_B.OBJECT1_ID1%TYPE
6272: INDEX BY BINARY_INTEGER;
6273: NUM_RUL_OBJ1_ORIG_LIST RUL_OBJ1_ID_LIST_TYPE;
6274: NUM_RUL_OBJ1_NEW_LIST RUL_OBJ1_ID_LIST_TYPE;
6275:

Line 6282: FROM OKC_RULES_B rul

6278: SELECT distinct m.CUSTOMER_MERGE_HEADER_ID
6279: , rul.ID
6280: , yt.CUST_ACCT_ID
6281: , rul.object1_id1
6282: FROM OKC_RULES_B rul
6283: , OKC_RG_PARTY_ROLES rgpr
6284: , OKC_RULE_GROUPS_B rgp
6285: , OKC_K_PARTY_ROLES_B yt
6286: , RA_CUSTOMER_MERGES m

Line 6313: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','OKC_RULES_B',FALSE);

6309: IF process_mode='LOCK' THEN
6310: NULL;
6311: ELSE
6312: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
6313: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','OKC_RULES_B',FALSE);
6314: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
6315: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
6316:
6317: OPEN merged_records;

Line 6359: 'OKC_RULES_B',

6355: LAST_UPDATE_DATE,
6356: LAST_UPDATED_BY)
6357: VALUES
6358: (HZ_CUSTOMER_MERGE_LOG_s.nextval,
6359: 'OKC_RULES_B',
6360: MERGE_HEADER_ID_LIST(I),
6361: PRIMARY_KEY_ID_LIST(I),
6362: NUM_RUL_OBJ1_ORIG_LIST(I),
6363: NUM_RUL_OBJ1_NEW_LIST(I),

Line 6374: UPDATE OKC_RULES_B yt SET

6370: hz_utility_pub.LAST_UPDATED_BY);
6371: END IF;
6372:
6373: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
6374: UPDATE OKC_RULES_B yt SET
6375: OBJECT1_ID1=NUM_RUL_OBJ1_NEW_LIST(I)
6376: , LAST_UPDATE_DATE=SYSDATE
6377: , last_updated_by=arp_standard.profile.user_id
6378: , last_update_login=arp_standard.profile.last_update_login