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.ARW_SEARCH_CUSTOMERS dependencies on ARI_UTILITIES

Line 45: ari_utilities.get_site_uses(ACCT_SITE.CUST_ACCT_SITE_ID) SITE_USES,

41: ARP_ADDR_PKG.FORMAT_ADDRESS(LOC.ADDRESS_STYLE,LOC.ADDRESS1, LOC.ADDRESS2,LOC.ADDRESS3,LOC.ADDRESS4,LOC.CITY,LOC.COUNTY, LOC.STATE,LOC.PROVINCE,LOC.POSTAL_CODE, T.TERRITORY_SHORT_NAME ) CONCATENATED_ADDRESS,
42: TO_CHAR(NULL) CONTACT_NAME,
43: TO_CHAR(NULL) CONTACT_PHONE,
44: -1 BILL_TO_SITE_USE_ID,
45: ari_utilities.get_site_uses(ACCT_SITE.CUST_ACCT_SITE_ID) SITE_USES,
46: ACCT_SITE.org_id,
47: 'N' selected,
48: ari_utilities.get_site_use_location(ACCT_SITE.CUST_ACCT_SITE_ID) location
49: FROM HZ_CUST_ACCT_SITES ACCT_SITE ,

Line 48: ari_utilities.get_site_use_location(ACCT_SITE.CUST_ACCT_SITE_ID) location

44: -1 BILL_TO_SITE_USE_ID,
45: ari_utilities.get_site_uses(ACCT_SITE.CUST_ACCT_SITE_ID) SITE_USES,
46: ACCT_SITE.org_id,
47: 'N' selected,
48: ari_utilities.get_site_use_location(ACCT_SITE.CUST_ACCT_SITE_ID) location
49: FROM HZ_CUST_ACCT_SITES ACCT_SITE ,
50: HZ_PARTY_SITES PARTY_SITE ,
51: -- For Bug# 13688313
52: -- HZ_LOC_ASSIGNMENTS LOC_ASSIGN ,

Line 81: ari_utilities.get_contact(cus.cust_account_id, null, 'ALL') CONTACT_NAME,

77: cus.ACCOUNT_NUMBER customer_number,
78: substrb(party.party_name, 1, 50) CUSTOMER_NAME,
79: -1 address_id,
80: 'ALL_LOCATIONS' CONCATENATED_ADDRESS,
81: ari_utilities.get_contact(cus.cust_account_id, null, 'ALL') CONTACT_NAME,
82: ari_utilities.get_phone(cus.cust_account_id, null, 'ALL','GEN') CONTACT_PHONE,
83: -1 BILL_TO_SITE_USE_ID,
84: NULL SITE_USES,
85: cus.org_id,

Line 82: ari_utilities.get_phone(cus.cust_account_id, null, 'ALL','GEN') CONTACT_PHONE,

78: substrb(party.party_name, 1, 50) CUSTOMER_NAME,
79: -1 address_id,
80: 'ALL_LOCATIONS' CONCATENATED_ADDRESS,
81: ari_utilities.get_contact(cus.cust_account_id, null, 'ALL') CONTACT_NAME,
82: ari_utilities.get_phone(cus.cust_account_id, null, 'ALL','GEN') CONTACT_PHONE,
83: -1 BILL_TO_SITE_USE_ID,
84: NULL SITE_USES,
85: cus.org_id,
86: 'N' selected,

Line 150: ari_utilities.get_site_uses(ACCT_SITE.CUST_ACCT_SITE_ID) SITE_USES,

146: ARP_ADDR_PKG.FORMAT_ADDRESS(LOC.ADDRESS_STYLE,LOC.ADDRESS1, LOC.ADDRESS2,LOC.ADDRESS3,LOC.ADDRESS4,LOC.CITY,LOC.COUNTY, LOC.STATE,LOC.PROVINCE,LOC.POSTAL_CODE, T.TERRITORY_SHORT_NAME ) CONCATENATED_ADDRESS,
147: TO_CHAR(NULL) CONTACT_NAME,
148: TO_CHAR(NULL) CONTACT_PHONE,
149: -1 BILL_TO_SITE_USE_ID,
150: ari_utilities.get_site_uses(ACCT_SITE.CUST_ACCT_SITE_ID) SITE_USES,
151: ACCT_SITE.org_id,
152: 'N' selected,
153: ari_utilities.get_site_use_location(ACCT_SITE.CUST_ACCT_SITE_ID) location
154: FROM HZ_CUST_ACCT_SITES ACCT_SITE ,

Line 153: ari_utilities.get_site_use_location(ACCT_SITE.CUST_ACCT_SITE_ID) location

149: -1 BILL_TO_SITE_USE_ID,
150: ari_utilities.get_site_uses(ACCT_SITE.CUST_ACCT_SITE_ID) SITE_USES,
151: ACCT_SITE.org_id,
152: 'N' selected,
153: ari_utilities.get_site_use_location(ACCT_SITE.CUST_ACCT_SITE_ID) location
154: FROM HZ_CUST_ACCT_SITES ACCT_SITE ,
155: HZ_PARTY_SITES PARTY_SITE ,
156: -- HZ_LOC_ASSIGNMENTS LOC_ASSIGN ,
157: HZ_LOCATIONS LOC ,

Line 185: ari_utilities.get_site_uses(ACCT_SITE.CUST_ACCT_SITE_ID) SITE_USES,

181: ARP_ADDR_PKG.FORMAT_ADDRESS(LOC.ADDRESS_STYLE,LOC.ADDRESS1, LOC.ADDRESS2,LOC.ADDRESS3,LOC.ADDRESS4,LOC.CITY,LOC.COUNTY, LOC.STATE,LOC.PROVINCE,LOC.POSTAL_CODE, T.TERRITORY_SHORT_NAME ) CONCATENATED_ADDRESS,
182: TO_CHAR(NULL) CONTACT_NAME,
183: TO_CHAR(NULL) CONTACT_PHONE,
184: -1 BILL_TO_SITE_USE_ID,
185: ari_utilities.get_site_uses(ACCT_SITE.CUST_ACCT_SITE_ID) SITE_USES,
186: ACCT_SITE.org_id,
187: 'N' selected,
188: ari_utilities.get_site_use_location(ACCT_SITE.CUST_ACCT_SITE_ID) location
189: FROM HZ_CUST_ACCT_SITES ACCT_SITE ,

Line 188: ari_utilities.get_site_use_location(ACCT_SITE.CUST_ACCT_SITE_ID) location

184: -1 BILL_TO_SITE_USE_ID,
185: ari_utilities.get_site_uses(ACCT_SITE.CUST_ACCT_SITE_ID) SITE_USES,
186: ACCT_SITE.org_id,
187: 'N' selected,
188: ari_utilities.get_site_use_location(ACCT_SITE.CUST_ACCT_SITE_ID) location
189: FROM HZ_CUST_ACCT_SITES ACCT_SITE ,
190: HZ_PARTY_SITES PARTY_SITE ,
191: -- HZ_LOC_ASSIGNMENTS LOC_ASSIGN ,
192: HZ_LOCATIONS LOC ,

Line 795: l_contact_id := ari_utilities.get_contact_id(l_search_result_table(l_tab_idx).customer_id,l_search_result_table(l_tab_idx).address_id, 'SELF_SERVICE_USER');

791:
792: LOOP
793: -- Exit if there are no more records
794: EXIT WHEN l_tab_idx IS NULL;
795: l_contact_id := ari_utilities.get_contact_id(l_search_result_table(l_tab_idx).customer_id,l_search_result_table(l_tab_idx).address_id, 'SELF_SERVICE_USER');
796:
797: l_search_result_table(l_tab_idx).contact_name := ari_utilities.get_contact(l_contact_id);
798: l_search_result_table(l_tab_idx).contact_phone := ari_utilities.get_phone(l_contact_id, 'GEN');
799: l_search_result_table(l_tab_idx).site_uses := ari_utilities.get_site_uses(l_search_result_table(l_tab_idx).address_id);

Line 797: l_search_result_table(l_tab_idx).contact_name := ari_utilities.get_contact(l_contact_id);

793: -- Exit if there are no more records
794: EXIT WHEN l_tab_idx IS NULL;
795: l_contact_id := ari_utilities.get_contact_id(l_search_result_table(l_tab_idx).customer_id,l_search_result_table(l_tab_idx).address_id, 'SELF_SERVICE_USER');
796:
797: l_search_result_table(l_tab_idx).contact_name := ari_utilities.get_contact(l_contact_id);
798: l_search_result_table(l_tab_idx).contact_phone := ari_utilities.get_phone(l_contact_id, 'GEN');
799: l_search_result_table(l_tab_idx).site_uses := ari_utilities.get_site_uses(l_search_result_table(l_tab_idx).address_id);
800: l_tab_idx := l_search_result_table.NEXT(l_tab_idx);
801:

Line 798: l_search_result_table(l_tab_idx).contact_phone := ari_utilities.get_phone(l_contact_id, 'GEN');

794: EXIT WHEN l_tab_idx IS NULL;
795: l_contact_id := ari_utilities.get_contact_id(l_search_result_table(l_tab_idx).customer_id,l_search_result_table(l_tab_idx).address_id, 'SELF_SERVICE_USER');
796:
797: l_search_result_table(l_tab_idx).contact_name := ari_utilities.get_contact(l_contact_id);
798: l_search_result_table(l_tab_idx).contact_phone := ari_utilities.get_phone(l_contact_id, 'GEN');
799: l_search_result_table(l_tab_idx).site_uses := ari_utilities.get_site_uses(l_search_result_table(l_tab_idx).address_id);
800: l_tab_idx := l_search_result_table.NEXT(l_tab_idx);
801:
802: END LOOP;

Line 799: l_search_result_table(l_tab_idx).site_uses := ari_utilities.get_site_uses(l_search_result_table(l_tab_idx).address_id);

795: l_contact_id := ari_utilities.get_contact_id(l_search_result_table(l_tab_idx).customer_id,l_search_result_table(l_tab_idx).address_id, 'SELF_SERVICE_USER');
796:
797: l_search_result_table(l_tab_idx).contact_name := ari_utilities.get_contact(l_contact_id);
798: l_search_result_table(l_tab_idx).contact_phone := ari_utilities.get_phone(l_contact_id, 'GEN');
799: l_search_result_table(l_tab_idx).site_uses := ari_utilities.get_site_uses(l_search_result_table(l_tab_idx).address_id);
800: l_tab_idx := l_search_result_table.NEXT(l_tab_idx);
801:
802: END LOOP;
803:

Line 980: /*IF ari_utilities.get_bill_to_site_use_id( account_assigned_site.CUST_ACCT_SITE_ID )>0 THEN

976:
977: -- Bug 14486763 - To insert multiple bill to site use ids of a CUST_ACCT_SITE_ID
978: insert_acct_site_uses(p_session_id => p_session_id, p_user_id => p_user_id, p_org_id => account_assigned_site.org_id, p_customer_id => p_customer_id, p_cust_acct_site_id => account_assigned_site.CUST_ACCT_SITE_ID);
979:
980: /*IF ari_utilities.get_bill_to_site_use_id( account_assigned_site.CUST_ACCT_SITE_ID )>0 THEN
981: INSERT INTO ar_irec_user_acct_sites_all
982: (SESSION_ID,CUSTOMER_ID,CUSTOMER_SITE_USE_ID,USER_ID,CURRENT_DATE,ORG_ID, CREATION_DATE)
983: VALUES(p_session_id,p_customer_id,ari_utilities.get_bill_to_site_use_id( account_assigned_site.CUST_ACCT_SITE_ID ),p_user_id,trunc(sysdate),account_assigned_site.org_id, trunc(sysdate));
984: END IF; */

Line 983: VALUES(p_session_id,p_customer_id,ari_utilities.get_bill_to_site_use_id( account_assigned_site.CUST_ACCT_SITE_ID ),p_user_id,trunc(sysdate),account_assigned_site.org_id, trunc(sysdate));

979:
980: /*IF ari_utilities.get_bill_to_site_use_id( account_assigned_site.CUST_ACCT_SITE_ID )>0 THEN
981: INSERT INTO ar_irec_user_acct_sites_all
982: (SESSION_ID,CUSTOMER_ID,CUSTOMER_SITE_USE_ID,USER_ID,CURRENT_DATE,ORG_ID, CREATION_DATE)
983: VALUES(p_session_id,p_customer_id,ari_utilities.get_bill_to_site_use_id( account_assigned_site.CUST_ACCT_SITE_ID ),p_user_id,trunc(sysdate),account_assigned_site.org_id, trunc(sysdate));
984: END IF; */
985: END LOOP;
986:
987: ELSIF (( p_site_use_id is not null ) and (p_customer_id is not null)) THEN

Line 1008: AND ari_utilities.get_bill_to_site_use_id( FETCH_SITES_ID_CURSOR_RECORD.address_id ) > 0

1004: insert_acct_site_uses(p_session_id => p_session_id, p_user_id => p_user_id, p_org_id => FETCH_SITES_ID_CURSOR_RECORD.org_id, p_customer_id => FETCH_SITES_ID_CURSOR_RECORD.account_id, p_cust_acct_site_id => FETCH_SITES_ID_CURSOR_RECORD.address_id);
1005:
1006: /*IF
1007: FETCH_SITES_ID_CURSOR_RECORD.address_id IS NOT NULL
1008: AND ari_utilities.get_bill_to_site_use_id( FETCH_SITES_ID_CURSOR_RECORD.address_id ) > 0
1009: THEN
1010: INSERT INTO ar_irec_user_acct_sites_all
1011: (SESSION_ID,CUSTOMER_ID,CUSTOMER_SITE_USE_ID,USER_ID,CURRENT_DATE,ORG_ID, CREATION_DATE)
1012: VALUES(p_session_id,FETCH_SITES_ID_CURSOR_RECORD.account_id,ari_utilities.get_bill_to_site_use_id( FETCH_SITES_ID_CURSOR_RECORD.address_id ),p_user_id,trunc(sysdate),FETCH_SITES_ID_CURSOR_RECORD.org_id, trunc(sysdate));

Line 1012: VALUES(p_session_id,FETCH_SITES_ID_CURSOR_RECORD.account_id,ari_utilities.get_bill_to_site_use_id( FETCH_SITES_ID_CURSOR_RECORD.address_id ),p_user_id,trunc(sysdate),FETCH_SITES_ID_CURSOR_RECORD.org_id, trunc(sysdate));

1008: AND ari_utilities.get_bill_to_site_use_id( FETCH_SITES_ID_CURSOR_RECORD.address_id ) > 0
1009: THEN
1010: INSERT INTO ar_irec_user_acct_sites_all
1011: (SESSION_ID,CUSTOMER_ID,CUSTOMER_SITE_USE_ID,USER_ID,CURRENT_DATE,ORG_ID, CREATION_DATE)
1012: VALUES(p_session_id,FETCH_SITES_ID_CURSOR_RECORD.account_id,ari_utilities.get_bill_to_site_use_id( FETCH_SITES_ID_CURSOR_RECORD.address_id ),p_user_id,trunc(sysdate),FETCH_SITES_ID_CURSOR_RECORD.org_id, trunc(sysdate));
1013: END IF; */
1014: END LOOP;
1015:
1016: /* Check for account level access and insert all bill to sites */

Line 1028: /*IF ari_utilities.get_bill_to_site_use_id( account_assigned_site.CUST_ACCT_SITE_ID )>0 THEN

1024: )LOOP
1025: -- Bug 14486763 - To insert multiple bill to site use ids of a CUST_ACCT_SITE_ID
1026: insert_acct_site_uses(p_session_id => p_session_id, p_user_id => p_user_id, p_org_id => account_assigned_site.org_id, p_customer_id => customer_assigned_record.cust_account_id, p_cust_acct_site_id => account_assigned_site.CUST_ACCT_SITE_ID);
1027:
1028: /*IF ari_utilities.get_bill_to_site_use_id( account_assigned_site.CUST_ACCT_SITE_ID )>0 THEN
1029: INSERT INTO ar_irec_user_acct_sites_all
1030: (SESSION_ID,CUSTOMER_ID,CUSTOMER_SITE_USE_ID,USER_ID,CURRENT_DATE,ORG_ID, CREATION_DATE)
1031: VALUES(p_session_id,customer_assigned_record.cust_account_id,ari_utilities.get_bill_to_site_use_id( account_assigned_site.CUST_ACCT_SITE_ID ),p_user_id,trunc(sysdate),account_assigned_site.org_id, trunc(sysdate));
1032: END IF; */

Line 1031: VALUES(p_session_id,customer_assigned_record.cust_account_id,ari_utilities.get_bill_to_site_use_id( account_assigned_site.CUST_ACCT_SITE_ID ),p_user_id,trunc(sysdate),account_assigned_site.org_id, trunc(sysdate));

1027:
1028: /*IF ari_utilities.get_bill_to_site_use_id( account_assigned_site.CUST_ACCT_SITE_ID )>0 THEN
1029: INSERT INTO ar_irec_user_acct_sites_all
1030: (SESSION_ID,CUSTOMER_ID,CUSTOMER_SITE_USE_ID,USER_ID,CURRENT_DATE,ORG_ID, CREATION_DATE)
1031: VALUES(p_session_id,customer_assigned_record.cust_account_id,ari_utilities.get_bill_to_site_use_id( account_assigned_site.CUST_ACCT_SITE_ID ),p_user_id,trunc(sysdate),account_assigned_site.org_id, trunc(sysdate));
1032: END IF; */
1033: END LOOP;
1034:
1035: /* the following insert statement is added for bug 7678038 to show receipts created with out location */

Line 1157: /*IF ari_utilities.get_bill_to_site_use_id( account_assigned_site.CUST_ACCT_SITE_ID )>0 THEN

1153: )LOOP
1154:
1155: -- Bug 14486763 - To insert multiple bill to site use ids of a CUST_ACCT_SITE_ID
1156: insert_acct_site_uses(p_session_id => p_session_id, p_user_id => p_user_id, p_org_id => l_org_id, p_customer_id => p_customer_id, p_cust_acct_site_id => account_assigned_site.CUST_ACCT_SITE_ID);
1157: /*IF ari_utilities.get_bill_to_site_use_id( account_assigned_site.CUST_ACCT_SITE_ID )>0 THEN
1158: INSERT INTO ar_irec_user_acct_sites_all
1159: (SESSION_ID,CUSTOMER_ID,CUSTOMER_SITE_USE_ID,USER_ID,CURRENT_DATE,ORG_ID, CREATION_DATE)
1160: VALUES(p_session_id,p_customer_id,ari_utilities.get_bill_to_site_use_id( account_assigned_site.CUST_ACCT_SITE_ID ),p_user_id,trunc(sysdate),l_org_id, trunc(sysdate));
1161: END IF;*/

Line 1160: VALUES(p_session_id,p_customer_id,ari_utilities.get_bill_to_site_use_id( account_assigned_site.CUST_ACCT_SITE_ID ),p_user_id,trunc(sysdate),l_org_id, trunc(sysdate));

1156: insert_acct_site_uses(p_session_id => p_session_id, p_user_id => p_user_id, p_org_id => l_org_id, p_customer_id => p_customer_id, p_cust_acct_site_id => account_assigned_site.CUST_ACCT_SITE_ID);
1157: /*IF ari_utilities.get_bill_to_site_use_id( account_assigned_site.CUST_ACCT_SITE_ID )>0 THEN
1158: INSERT INTO ar_irec_user_acct_sites_all
1159: (SESSION_ID,CUSTOMER_ID,CUSTOMER_SITE_USE_ID,USER_ID,CURRENT_DATE,ORG_ID, CREATION_DATE)
1160: VALUES(p_session_id,p_customer_id,ari_utilities.get_bill_to_site_use_id( account_assigned_site.CUST_ACCT_SITE_ID ),p_user_id,trunc(sysdate),l_org_id, trunc(sysdate));
1161: END IF;*/
1162: END LOOP;
1163:
1164: ELSIF (( p_site_use_id is not null ) and (p_customer_id is not null)) THEN

Line 1185: AND ari_utilities.get_bill_to_site_use_id( FETCH_SITES_ID_CURSOR_RECORD.address_id ) > 0

1181: -- Bug 14486763 - To insert multiple bill to site use ids of a CUST_ACCT_SITE_ID
1182: insert_acct_site_uses(p_session_id => p_session_id, p_user_id => p_user_id, p_org_id => l_org_id, p_customer_id => FETCH_SITES_ID_CURSOR_RECORD.account_id, p_cust_acct_site_id => FETCH_SITES_ID_CURSOR_RECORD.address_id);
1183: /*IF
1184: FETCH_SITES_ID_CURSOR_RECORD.address_id IS NOT NULL
1185: AND ari_utilities.get_bill_to_site_use_id( FETCH_SITES_ID_CURSOR_RECORD.address_id ) > 0
1186: THEN
1187: INSERT INTO ar_irec_user_acct_sites_all
1188: (SESSION_ID,CUSTOMER_ID,CUSTOMER_SITE_USE_ID,USER_ID,CURRENT_DATE,ORG_ID, CREATION_DATE)
1189: VALUES(p_session_id,FETCH_SITES_ID_CURSOR_RECORD.account_id,ari_utilities.get_bill_to_site_use_id( FETCH_SITES_ID_CURSOR_RECORD.address_id ),p_user_id,trunc(sysdate),l_org_id, trunc(sysdate));

Line 1189: VALUES(p_session_id,FETCH_SITES_ID_CURSOR_RECORD.account_id,ari_utilities.get_bill_to_site_use_id( FETCH_SITES_ID_CURSOR_RECORD.address_id ),p_user_id,trunc(sysdate),l_org_id, trunc(sysdate));

1185: AND ari_utilities.get_bill_to_site_use_id( FETCH_SITES_ID_CURSOR_RECORD.address_id ) > 0
1186: THEN
1187: INSERT INTO ar_irec_user_acct_sites_all
1188: (SESSION_ID,CUSTOMER_ID,CUSTOMER_SITE_USE_ID,USER_ID,CURRENT_DATE,ORG_ID, CREATION_DATE)
1189: VALUES(p_session_id,FETCH_SITES_ID_CURSOR_RECORD.account_id,ari_utilities.get_bill_to_site_use_id( FETCH_SITES_ID_CURSOR_RECORD.address_id ),p_user_id,trunc(sysdate),l_org_id, trunc(sysdate));
1190: END IF;*/
1191: END LOOP;
1192:
1193: /* Check for account level access and insert all bill to sites */

Line 1204: /*IF ari_utilities.get_bill_to_site_use_id( account_assigned_site.CUST_ACCT_SITE_ID )>0 THEN

1200: select CUST_ACCT_SITE_ID from hz_cust_acct_sites where CUST_ACCOUNT_ID=customer_assigned_record.cust_account_id
1201: )LOOP
1202: -- Bug 14486763 - To insert multiple bill to site use ids of a CUST_ACCT_SITE_ID
1203: insert_acct_site_uses(p_session_id => p_session_id, p_user_id => p_user_id, p_org_id => l_org_id, p_customer_id => customer_assigned_record.cust_account_id, p_cust_acct_site_id => account_assigned_site.CUST_ACCT_SITE_ID);
1204: /*IF ari_utilities.get_bill_to_site_use_id( account_assigned_site.CUST_ACCT_SITE_ID )>0 THEN
1205: INSERT INTO ar_irec_user_acct_sites_all
1206: (SESSION_ID,CUSTOMER_ID,CUSTOMER_SITE_USE_ID,USER_ID,CURRENT_DATE,ORG_ID, CREATION_DATE)
1207: VALUES(p_session_id,customer_assigned_record.cust_account_id,ari_utilities.get_bill_to_site_use_id( account_assigned_site.CUST_ACCT_SITE_ID ),p_user_id,trunc(sysdate),l_org_id, trunc(sysdate));
1208: END IF;*/

Line 1207: VALUES(p_session_id,customer_assigned_record.cust_account_id,ari_utilities.get_bill_to_site_use_id( account_assigned_site.CUST_ACCT_SITE_ID ),p_user_id,trunc(sysdate),l_org_id, trunc(sysdate));

1203: insert_acct_site_uses(p_session_id => p_session_id, p_user_id => p_user_id, p_org_id => l_org_id, p_customer_id => customer_assigned_record.cust_account_id, p_cust_acct_site_id => account_assigned_site.CUST_ACCT_SITE_ID);
1204: /*IF ari_utilities.get_bill_to_site_use_id( account_assigned_site.CUST_ACCT_SITE_ID )>0 THEN
1205: INSERT INTO ar_irec_user_acct_sites_all
1206: (SESSION_ID,CUSTOMER_ID,CUSTOMER_SITE_USE_ID,USER_ID,CURRENT_DATE,ORG_ID, CREATION_DATE)
1207: VALUES(p_session_id,customer_assigned_record.cust_account_id,ari_utilities.get_bill_to_site_use_id( account_assigned_site.CUST_ACCT_SITE_ID ),p_user_id,trunc(sysdate),l_org_id, trunc(sysdate));
1208: END IF;*/
1209: END LOOP;
1210: END LOOP;
1211:

Line 1285: IF ari_utilities.get_bill_to_site_use_id( account_assigned_site.CUST_ACCT_SITE_ID )>0 THEN

1281:
1282: FOR account_assigned_site IN (
1283: select CUST_ACCT_SITE_ID from hz_cust_acct_sites where CUST_ACCOUNT_ID = p_customer_id
1284: )LOOP
1285: IF ari_utilities.get_bill_to_site_use_id( account_assigned_site.CUST_ACCT_SITE_ID )>0 THEN
1286: INSERT INTO ar_irec_user_acct_sites_all
1287: (SESSION_ID,CUSTOMER_ID,CUSTOMER_SITE_USE_ID,USER_ID,CURRENT_DATE,ORG_ID, CREATION_DATE, RELATED_CUSTOMER_FLAG)
1288: VALUES(p_session_id,p_customer_id,ari_utilities.get_bill_to_site_use_id( account_assigned_site.CUST_ACCT_SITE_ID ),p_user_id,trunc(sysdate),p_org_id, trunc(sysdate), 'Y');
1289: END IF;

Line 1288: VALUES(p_session_id,p_customer_id,ari_utilities.get_bill_to_site_use_id( account_assigned_site.CUST_ACCT_SITE_ID ),p_user_id,trunc(sysdate),p_org_id, trunc(sysdate), 'Y');

1284: )LOOP
1285: IF ari_utilities.get_bill_to_site_use_id( account_assigned_site.CUST_ACCT_SITE_ID )>0 THEN
1286: INSERT INTO ar_irec_user_acct_sites_all
1287: (SESSION_ID,CUSTOMER_ID,CUSTOMER_SITE_USE_ID,USER_ID,CURRENT_DATE,ORG_ID, CREATION_DATE, RELATED_CUSTOMER_FLAG)
1288: VALUES(p_session_id,p_customer_id,ari_utilities.get_bill_to_site_use_id( account_assigned_site.CUST_ACCT_SITE_ID ),p_user_id,trunc(sysdate),p_org_id, trunc(sysdate), 'Y');
1289: END IF;
1290: END LOOP;
1291:
1292: ELSE

Line 1296: AND ari_utilities.get_bill_to_site_use_id( FETCH_SITES_ID_CURSOR_RECORD.address_id ) > 0

1292: ELSE
1293: /* insert all the sites this party is having direct access */
1294: FOR FETCH_SITES_ID_CURSOR_RECORD IN FETCH_SITES_ID_CURSOR loop
1295: IF FETCH_SITES_ID_CURSOR_RECORD.address_id IS NOT NULL
1296: AND ari_utilities.get_bill_to_site_use_id( FETCH_SITES_ID_CURSOR_RECORD.address_id ) > 0
1297: THEN
1298: INSERT INTO ar_irec_user_acct_sites_all
1299: (SESSION_ID,CUSTOMER_ID,CUSTOMER_SITE_USE_ID,USER_ID,CURRENT_DATE,ORG_ID, CREATION_DATE, RELATED_CUSTOMER_FLAG )
1300: VALUES(p_session_id,FETCH_SITES_ID_CURSOR_RECORD.account_id,ari_utilities.get_bill_to_site_use_id( FETCH_SITES_ID_CURSOR_RECORD.address_id ),p_user_id,trunc(sysdate),p_org_id, trunc(sysdate), 'Y');

Line 1300: VALUES(p_session_id,FETCH_SITES_ID_CURSOR_RECORD.account_id,ari_utilities.get_bill_to_site_use_id( FETCH_SITES_ID_CURSOR_RECORD.address_id ),p_user_id,trunc(sysdate),p_org_id, trunc(sysdate), 'Y');

1296: AND ari_utilities.get_bill_to_site_use_id( FETCH_SITES_ID_CURSOR_RECORD.address_id ) > 0
1297: THEN
1298: INSERT INTO ar_irec_user_acct_sites_all
1299: (SESSION_ID,CUSTOMER_ID,CUSTOMER_SITE_USE_ID,USER_ID,CURRENT_DATE,ORG_ID, CREATION_DATE, RELATED_CUSTOMER_FLAG )
1300: VALUES(p_session_id,FETCH_SITES_ID_CURSOR_RECORD.account_id,ari_utilities.get_bill_to_site_use_id( FETCH_SITES_ID_CURSOR_RECORD.address_id ),p_user_id,trunc(sysdate),p_org_id, trunc(sysdate), 'Y');
1301: END IF;
1302: END LOOP;
1303: /* Check for account level access and insert all bill to sites */
1304: FOR account_assigned_site IN (

Line 1308: IF ari_utilities.get_bill_to_site_use_id( account_assigned_site.CUST_ACCT_SITE_ID )>0 THEN

1304: FOR account_assigned_site IN (
1305: select CUST_ACCT_SITE_ID from hz_cust_acct_sites where CUST_ACCOUNT_ID=p_customer_id
1306: )LOOP
1307:
1308: IF ari_utilities.get_bill_to_site_use_id( account_assigned_site.CUST_ACCT_SITE_ID )>0 THEN
1309: INSERT INTO ar_irec_user_acct_sites_all
1310: (SESSION_ID,CUSTOMER_ID, CUSTOMER_SITE_USE_ID,USER_ID,CURRENT_DATE,ORG_ID, CREATION_DATE, RELATED_CUSTOMER_FLAG)
1311: VALUES(p_session_id,p_customer_id,ari_utilities.get_bill_to_site_use_id( account_assigned_site.CUST_ACCT_SITE_ID ),p_user_id,trunc(sysdate),p_org_id, trunc(sysdate), 'Y');
1312: END IF;

Line 1311: VALUES(p_session_id,p_customer_id,ari_utilities.get_bill_to_site_use_id( account_assigned_site.CUST_ACCT_SITE_ID ),p_user_id,trunc(sysdate),p_org_id, trunc(sysdate), 'Y');

1307:
1308: IF ari_utilities.get_bill_to_site_use_id( account_assigned_site.CUST_ACCT_SITE_ID )>0 THEN
1309: INSERT INTO ar_irec_user_acct_sites_all
1310: (SESSION_ID,CUSTOMER_ID, CUSTOMER_SITE_USE_ID,USER_ID,CURRENT_DATE,ORG_ID, CREATION_DATE, RELATED_CUSTOMER_FLAG)
1311: VALUES(p_session_id,p_customer_id,ari_utilities.get_bill_to_site_use_id( account_assigned_site.CUST_ACCT_SITE_ID ),p_user_id,trunc(sysdate),p_org_id, trunc(sysdate), 'Y');
1312: END IF;
1313: END LOOP;
1314: /* the following insert statement is added for bug 7678038 to show receipts created with out location */
1315: