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 25: ari_utilities.get_site_uses(cus.ADDRESS_ID) SITE_USES,

21: cus.CONCATENATED_ADDRESS,
22: cus.CONTACT_NAME,
23: cus.CONTACT_PHONE,
24: cus.BILL_TO_SITE_USE_ID,
25: ari_utilities.get_site_uses(cus.ADDRESS_ID) SITE_USES,
26: cus.ORG_ID,
27: 'N' selected,
28: ari_utilities.get_site_use_location(cus.ADDRESS_ID) location
29: FROM

Line 28: ari_utilities.get_site_use_location(cus.ADDRESS_ID) location

24: cus.BILL_TO_SITE_USE_ID,
25: ari_utilities.get_site_uses(cus.ADDRESS_ID) SITE_USES,
26: cus.ORG_ID,
27: 'N' selected,
28: ari_utilities.get_site_use_location(cus.ADDRESS_ID) location
29: FROM
30: ari_customer_search_v cus
31: WHERE
32: cus.customer_id = p_customer_id

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

40: cus.ACCOUNT_NUMBER customer_number,
41: substrb(party.party_name, 1, 50) CUSTOMER_NAME,
42: -1 address_id,
43: 'ALL_LOCATIONS' CONCATENATED_ADDRESS,
44: ari_utilities.get_contact(cus.cust_account_id, null, 'ALL') CONTACT_NAME,
45: ari_utilities.get_phone(cus.cust_account_id, null, 'ALL','GEN') CONTACT_PHONE,
46: -1 BILL_TO_SITE_USE_ID,
47: NULL SITE_USES,
48: cus.org_id,

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

41: substrb(party.party_name, 1, 50) CUSTOMER_NAME,
42: -1 address_id,
43: 'ALL_LOCATIONS' CONCATENATED_ADDRESS,
44: ari_utilities.get_contact(cus.cust_account_id, null, 'ALL') CONTACT_NAME,
45: ari_utilities.get_phone(cus.cust_account_id, null, 'ALL','GEN') CONTACT_PHONE,
46: -1 BILL_TO_SITE_USE_ID,
47: NULL SITE_USES,
48: cus.org_id,
49: 'N' selected,

Line 72: ari_utilities.get_site_uses(cus.ADDRESS_ID) SITE_USES,

68: cus.CONCATENATED_ADDRESS,
69: cus.CONTACT_NAME,
70: cus.CONTACT_PHONE,
71: cus.BILL_TO_SITE_USE_ID,
72: ari_utilities.get_site_uses(cus.ADDRESS_ID) SITE_USES,
73: cus.ORG_ID,
74: 'N' selected,
75: ari_utilities.get_site_use_location(cus.ADDRESS_ID) location
76: FROM

Line 75: ari_utilities.get_site_use_location(cus.ADDRESS_ID) location

71: cus.BILL_TO_SITE_USE_ID,
72: ari_utilities.get_site_uses(cus.ADDRESS_ID) SITE_USES,
73: cus.ORG_ID,
74: 'N' selected,
75: ari_utilities.get_site_use_location(cus.ADDRESS_ID) location
76: FROM
77: ari_customer_search_v cus
78: WHERE
79: cus.CUSTOMER_NUMBER like p_customer_name_number

Line 91: ari_utilities.get_site_uses(cus.ADDRESS_ID) SITE_USES,

87: cus.CONCATENATED_ADDRESS,
88: cus.CONTACT_NAME,
89: cus.CONTACT_PHONE,
90: cus.BILL_TO_SITE_USE_ID,
91: ari_utilities.get_site_uses(cus.ADDRESS_ID) SITE_USES,
92: cus.ORG_ID,
93: 'N' selected,
94: ari_utilities.get_site_use_location(cus.ADDRESS_ID) location
95: FROM

Line 94: ari_utilities.get_site_use_location(cus.ADDRESS_ID) location

90: cus.BILL_TO_SITE_USE_ID,
91: ari_utilities.get_site_uses(cus.ADDRESS_ID) SITE_USES,
92: cus.ORG_ID,
93: 'N' selected,
94: ari_utilities.get_site_use_location(cus.ADDRESS_ID) location
95: FROM
96: ari_customer_search_v cus
97: WHERE
98: cus.customer_name like p_customer_name_number

Line 662: 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');

658: LOOP
659: -- Exit if there are no more records
660: EXIT WHEN l_tab_idx IS NULL;
661:
662: 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');
663:
664: l_search_result_table(l_tab_idx).contact_name := ari_utilities.get_contact(l_contact_id);
665: l_search_result_table(l_tab_idx).contact_phone := ari_utilities.get_phone(l_contact_id, 'GEN');
666: l_search_result_table(l_tab_idx).site_uses := ari_utilities.get_site_uses(l_search_result_table(l_tab_idx).address_id);

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

660: EXIT WHEN l_tab_idx IS NULL;
661:
662: 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');
663:
664: l_search_result_table(l_tab_idx).contact_name := ari_utilities.get_contact(l_contact_id);
665: l_search_result_table(l_tab_idx).contact_phone := ari_utilities.get_phone(l_contact_id, 'GEN');
666: l_search_result_table(l_tab_idx).site_uses := ari_utilities.get_site_uses(l_search_result_table(l_tab_idx).address_id);
667: l_tab_idx := l_search_result_table.NEXT(l_tab_idx);
668:

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

661:
662: 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');
663:
664: l_search_result_table(l_tab_idx).contact_name := ari_utilities.get_contact(l_contact_id);
665: l_search_result_table(l_tab_idx).contact_phone := ari_utilities.get_phone(l_contact_id, 'GEN');
666: l_search_result_table(l_tab_idx).site_uses := ari_utilities.get_site_uses(l_search_result_table(l_tab_idx).address_id);
667: l_tab_idx := l_search_result_table.NEXT(l_tab_idx);
668:
669: END LOOP;

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

662: 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');
663:
664: l_search_result_table(l_tab_idx).contact_name := ari_utilities.get_contact(l_contact_id);
665: l_search_result_table(l_tab_idx).contact_phone := ari_utilities.get_phone(l_contact_id, 'GEN');
666: l_search_result_table(l_tab_idx).site_uses := ari_utilities.get_site_uses(l_search_result_table(l_tab_idx).address_id);
667: l_tab_idx := l_search_result_table.NEXT(l_tab_idx);
668:
669: END LOOP;
670: --------------------------------------------------------------------------

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

818: FOR account_assigned_site IN (
819: select CUST_ACCT_SITE_ID from hz_cust_acct_sites where CUST_ACCOUNT_ID = p_customer_id
820: )LOOP
821:
822: IF ari_utilities.get_bill_to_site_use_id( account_assigned_site.CUST_ACCT_SITE_ID )>0 THEN
823: INSERT INTO ar_irec_user_acct_sites_all
824: (SESSION_ID,CUSTOMER_ID,CUSTOMER_SITE_USE_ID,USER_ID,CURRENT_DATE,ORG_ID, CREATION_DATE)
825: 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));
826: END IF;

Line 825: 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));

821:
822: IF ari_utilities.get_bill_to_site_use_id( account_assigned_site.CUST_ACCT_SITE_ID )>0 THEN
823: INSERT INTO ar_irec_user_acct_sites_all
824: (SESSION_ID,CUSTOMER_ID,CUSTOMER_SITE_USE_ID,USER_ID,CURRENT_DATE,ORG_ID, CREATION_DATE)
825: 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));
826: END IF;
827: END LOOP;
828:
829: ELSIF (( p_site_use_id is not null ) and (p_customer_id is not null)) THEN

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

839:
840: FOR FETCH_SITES_ID_CURSOR_RECORD IN FETCH_SITES_ID_CURSOR loop
841: IF
842: FETCH_SITES_ID_CURSOR_RECORD.address_id IS NOT NULL
843: AND ari_utilities.get_bill_to_site_use_id( FETCH_SITES_ID_CURSOR_RECORD.address_id ) > 0
844: THEN
845: INSERT INTO ar_irec_user_acct_sites_all
846: (SESSION_ID,CUSTOMER_ID,CUSTOMER_SITE_USE_ID,USER_ID,CURRENT_DATE,ORG_ID, CREATION_DATE)
847: 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));

Line 847: 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));

843: AND ari_utilities.get_bill_to_site_use_id( FETCH_SITES_ID_CURSOR_RECORD.address_id ) > 0
844: THEN
845: INSERT INTO ar_irec_user_acct_sites_all
846: (SESSION_ID,CUSTOMER_ID,CUSTOMER_SITE_USE_ID,USER_ID,CURRENT_DATE,ORG_ID, CREATION_DATE)
847: 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));
848: END IF;
849: END LOOP;
850:
851: /* Check for account level access and insert all bill to sites */

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

857: FOR account_assigned_site IN (
858: select CUST_ACCT_SITE_ID from hz_cust_acct_sites where CUST_ACCOUNT_ID=customer_assigned_record.cust_account_id
859: )LOOP
860:
861: IF ari_utilities.get_bill_to_site_use_id( account_assigned_site.CUST_ACCT_SITE_ID )>0 THEN
862: INSERT INTO ar_irec_user_acct_sites_all
863: (SESSION_ID,CUSTOMER_ID,CUSTOMER_SITE_USE_ID,USER_ID,CURRENT_DATE,ORG_ID, CREATION_DATE)
864: 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),p_org_id, trunc(sysdate));
865: END IF;

Line 864: 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),p_org_id, trunc(sysdate));

860:
861: IF ari_utilities.get_bill_to_site_use_id( account_assigned_site.CUST_ACCT_SITE_ID )>0 THEN
862: INSERT INTO ar_irec_user_acct_sites_all
863: (SESSION_ID,CUSTOMER_ID,CUSTOMER_SITE_USE_ID,USER_ID,CURRENT_DATE,ORG_ID, CREATION_DATE)
864: 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),p_org_id, trunc(sysdate));
865: END IF;
866: END LOOP;
867: END LOOP;
868:

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

945: FOR account_assigned_site IN (
946: select CUST_ACCT_SITE_ID from hz_cust_acct_sites where CUST_ACCOUNT_ID = p_customer_id
947: )LOOP
948:
949: IF ari_utilities.get_bill_to_site_use_id( account_assigned_site.CUST_ACCT_SITE_ID )>0 THEN
950: INSERT INTO ar_irec_user_acct_sites_all
951: (SESSION_ID,CUSTOMER_ID,CUSTOMER_SITE_USE_ID,USER_ID,CURRENT_DATE,ORG_ID, CREATION_DATE)
952: 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));
953: END IF;

Line 952: 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));

948:
949: IF ari_utilities.get_bill_to_site_use_id( account_assigned_site.CUST_ACCT_SITE_ID )>0 THEN
950: INSERT INTO ar_irec_user_acct_sites_all
951: (SESSION_ID,CUSTOMER_ID,CUSTOMER_SITE_USE_ID,USER_ID,CURRENT_DATE,ORG_ID, CREATION_DATE)
952: 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));
953: END IF;
954: END LOOP;
955:
956: ELSIF (( p_site_use_id is not null ) and (p_customer_id is not null)) THEN

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

966:
967: FOR FETCH_SITES_ID_CURSOR_RECORD IN FETCH_SITES_ID_CURSOR loop
968: IF
969: FETCH_SITES_ID_CURSOR_RECORD.address_id IS NOT NULL
970: AND ari_utilities.get_bill_to_site_use_id( FETCH_SITES_ID_CURSOR_RECORD.address_id ) > 0
971: THEN
972: INSERT INTO ar_irec_user_acct_sites_all
973: (SESSION_ID,CUSTOMER_ID,CUSTOMER_SITE_USE_ID,USER_ID,CURRENT_DATE,ORG_ID, CREATION_DATE)
974: 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 974: 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));

970: AND ari_utilities.get_bill_to_site_use_id( FETCH_SITES_ID_CURSOR_RECORD.address_id ) > 0
971: THEN
972: INSERT INTO ar_irec_user_acct_sites_all
973: (SESSION_ID,CUSTOMER_ID,CUSTOMER_SITE_USE_ID,USER_ID,CURRENT_DATE,ORG_ID, CREATION_DATE)
974: 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));
975: END IF;
976: END LOOP;
977:
978: /* Check for account level access and insert all bill to sites */

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

984: FOR account_assigned_site IN (
985: select CUST_ACCT_SITE_ID from hz_cust_acct_sites where CUST_ACCOUNT_ID=customer_assigned_record.cust_account_id
986: )LOOP
987:
988: IF ari_utilities.get_bill_to_site_use_id( account_assigned_site.CUST_ACCT_SITE_ID )>0 THEN
989: INSERT INTO ar_irec_user_acct_sites_all
990: (SESSION_ID,CUSTOMER_ID,CUSTOMER_SITE_USE_ID,USER_ID,CURRENT_DATE,ORG_ID, CREATION_DATE)
991: 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));
992: END IF;

Line 991: 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));

987:
988: IF ari_utilities.get_bill_to_site_use_id( account_assigned_site.CUST_ACCT_SITE_ID )>0 THEN
989: INSERT INTO ar_irec_user_acct_sites_all
990: (SESSION_ID,CUSTOMER_ID,CUSTOMER_SITE_USE_ID,USER_ID,CURRENT_DATE,ORG_ID, CREATION_DATE)
991: 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));
992: END IF;
993: END LOOP;
994: END LOOP;
995:

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

1059: IF (p_is_internal_user='Y') THEN
1060: FOR account_assigned_site IN (
1061: select CUST_ACCT_SITE_ID from hz_cust_acct_sites where CUST_ACCOUNT_ID = p_customer_id
1062: )LOOP
1063: IF ari_utilities.get_bill_to_site_use_id( account_assigned_site.CUST_ACCT_SITE_ID )>0 THEN
1064: INSERT INTO ar_irec_user_acct_sites_all
1065: (SESSION_ID,CUSTOMER_ID,CUSTOMER_SITE_USE_ID,USER_ID,CURRENT_DATE,ORG_ID, CREATION_DATE, RELATED_CUSTOMER_FLAG)
1066: 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');
1067: END IF;

Line 1066: 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');

1062: )LOOP
1063: IF ari_utilities.get_bill_to_site_use_id( account_assigned_site.CUST_ACCT_SITE_ID )>0 THEN
1064: INSERT INTO ar_irec_user_acct_sites_all
1065: (SESSION_ID,CUSTOMER_ID,CUSTOMER_SITE_USE_ID,USER_ID,CURRENT_DATE,ORG_ID, CREATION_DATE, RELATED_CUSTOMER_FLAG)
1066: 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');
1067: END IF;
1068: END LOOP;
1069:
1070: ELSE

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

1070: ELSE
1071: /* insert all the sites this party is having direct access */
1072: FOR FETCH_SITES_ID_CURSOR_RECORD IN FETCH_SITES_ID_CURSOR loop
1073: IF FETCH_SITES_ID_CURSOR_RECORD.address_id IS NOT NULL
1074: AND ari_utilities.get_bill_to_site_use_id( FETCH_SITES_ID_CURSOR_RECORD.address_id ) > 0
1075: THEN
1076: INSERT INTO ar_irec_user_acct_sites_all
1077: (SESSION_ID,CUSTOMER_ID,CUSTOMER_SITE_USE_ID,USER_ID,CURRENT_DATE,ORG_ID, CREATION_DATE, RELATED_CUSTOMER_FLAG )
1078: 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 1078: 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');

1074: AND ari_utilities.get_bill_to_site_use_id( FETCH_SITES_ID_CURSOR_RECORD.address_id ) > 0
1075: THEN
1076: INSERT INTO ar_irec_user_acct_sites_all
1077: (SESSION_ID,CUSTOMER_ID,CUSTOMER_SITE_USE_ID,USER_ID,CURRENT_DATE,ORG_ID, CREATION_DATE, RELATED_CUSTOMER_FLAG )
1078: 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');
1079: END IF;
1080: END LOOP;
1081: /* Check for account level access and insert all bill to sites */
1082: FOR account_assigned_site IN (

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

1082: FOR account_assigned_site IN (
1083: select CUST_ACCT_SITE_ID from hz_cust_acct_sites where CUST_ACCOUNT_ID=p_customer_id
1084: )LOOP
1085:
1086: IF ari_utilities.get_bill_to_site_use_id( account_assigned_site.CUST_ACCT_SITE_ID )>0 THEN
1087: INSERT INTO ar_irec_user_acct_sites_all
1088: (SESSION_ID,CUSTOMER_ID, CUSTOMER_SITE_USE_ID,USER_ID,CURRENT_DATE,ORG_ID, CREATION_DATE, RELATED_CUSTOMER_FLAG)
1089: 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');
1090: END IF;

Line 1089: 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');

1085:
1086: IF ari_utilities.get_bill_to_site_use_id( account_assigned_site.CUST_ACCT_SITE_ID )>0 THEN
1087: INSERT INTO ar_irec_user_acct_sites_all
1088: (SESSION_ID,CUSTOMER_ID, CUSTOMER_SITE_USE_ID,USER_ID,CURRENT_DATE,ORG_ID, CREATION_DATE, RELATED_CUSTOMER_FLAG)
1089: 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');
1090: END IF;
1091: END LOOP;
1092:
1093: END IF;