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.

[Home] [Help]

APPS.ARW_SEARCH_CUSTOMERS dependencies on AR_IREC_USER_ACCT_SITES_ALL

Line 936: delete from ar_irec_user_acct_sites_all where (session_id=p_session_id

932:
933: pragma autonomous_transaction ;
934:
935: BEGIN
936: delete from ar_irec_user_acct_sites_all where (session_id=p_session_id
937: or trunc(CREATION_DATE)<=trunc(sysdate-2));
938:
939: IF (p_user_id = 6) THEN
940: mo_global.init('AR');

Line 969: INSERT INTO ar_irec_user_acct_sites_all

965: IF ( p_site_use_id is null and p_customer_id is not null) THEN
966:
967: /* the following insert statement is added for bug 7678038 to show receipts created with out location */
968:
969: INSERT INTO ar_irec_user_acct_sites_all
970: (SESSION_ID,CUSTOMER_ID,CUSTOMER_SITE_USE_ID,USER_ID,CURRENT_DATE,ORG_ID, CREATION_DATE)
971: VALUES(p_session_id,p_customer_id,'-1',p_user_id,trunc(sysdate),p_org_id, trunc(sysdate));
972:
973: FOR account_assigned_site IN (

Line 981: INSERT INTO ar_irec_user_acct_sites_all

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; */
985: END LOOP;

Line 992: /*INSERT INTO ar_irec_user_acct_sites_all

988:
989: -- Bug 14486763 - To insert multiple bill to site use ids of a CUST_ACCT_SITE_ID
990: 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_site_use_id => p_site_use_id);
991:
992: /*INSERT INTO ar_irec_user_acct_sites_all
993: (SESSION_ID,CUSTOMER_ID,CUSTOMER_SITE_USE_ID,USER_ID,CURRENT_DATE,ORG_ID, CREATION_DATE)
994: VALUES(p_session_id,p_customer_id,p_site_use_id,p_user_id,trunc(sysdate),l_org_id, trunc(sysdate)); */
995: END IF;
996: ELSE

Line 1010: INSERT INTO ar_irec_user_acct_sites_all

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));
1013: END IF; */
1014: END LOOP;

Line 1029: INSERT INTO ar_irec_user_acct_sites_all

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; */
1033: END LOOP;

Line 1037: INSERT INTO ar_irec_user_acct_sites_all

1033: END LOOP;
1034:
1035: /* the following insert statement is added for bug 7678038 to show receipts created with out location */
1036:
1037: INSERT INTO ar_irec_user_acct_sites_all
1038: (SESSION_ID,CUSTOMER_ID,CUSTOMER_SITE_USE_ID,USER_ID,CURRENT_DATE,ORG_ID, CREATION_DATE)
1039: VALUES(p_session_id,customer_assigned_record.cust_account_id,'-1',p_user_id,trunc(sysdate),p_org_id, trunc(sysdate));
1040:
1041: END LOOP;

Line 1047: /* INSERT INTO ar_irec_user_acct_sites_all

1043: ELSIF (( p_site_use_id is not null ) and (p_customer_id is not null)) THEN
1044:
1045: -- Bug 14486763 - To insert multiple bill to site use ids of a CUST_ACCT_SITE_ID
1046: 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_site_use_id => p_site_use_id);
1047: /* INSERT INTO ar_irec_user_acct_sites_all
1048: (SESSION_ID,CUSTOMER_ID,CUSTOMER_SITE_USE_ID,USER_ID,CURRENT_DATE,ORG_ID, CREATION_DATE)
1049: VALUES(p_session_id,p_customer_id,p_site_use_id,p_user_id,trunc(sysdate),l_org_id, trunc(sysdate)); */
1050:
1051: END IF;

Line 1060: DELETE FROM ar_irec_user_acct_sites_all A WHERE ROWID > (

1056:
1057: END LOOP;
1058:
1059: /* REMOVE DUPLICATE ROWS IF ANY */
1060: DELETE FROM ar_irec_user_acct_sites_all A WHERE ROWID > (
1061: SELECT min(rowid) FROM ar_irec_user_acct_sites_all B
1062: WHERE A.org_id = B.org_id
1063: AND A.SESSION_ID=B.SESSION_ID
1064: AND A.USER_ID=B.USER_ID

Line 1061: SELECT min(rowid) FROM ar_irec_user_acct_sites_all B

1057: END LOOP;
1058:
1059: /* REMOVE DUPLICATE ROWS IF ANY */
1060: DELETE FROM ar_irec_user_acct_sites_all A WHERE ROWID > (
1061: SELECT min(rowid) FROM ar_irec_user_acct_sites_all B
1062: WHERE A.org_id = B.org_id
1063: AND A.SESSION_ID=B.SESSION_ID
1064: AND A.USER_ID=B.USER_ID
1065: AND A.CUSTOMER_ID=B.CUSTOMER_ID

Line 1096: INSERT INTO ar_irec_user_acct_sites_all

1092: end if;
1093: FOR account_assigned_site IN (
1094: SELECT SITE_USE_ID FROM hz_cust_site_uses WHERE cust_acct_site_id = l_cust_acct_site_id and SITE_USE_CODE = 'BILL_TO'
1095: )LOOP
1096: INSERT INTO ar_irec_user_acct_sites_all
1097: (SESSION_ID,CUSTOMER_ID,CUSTOMER_SITE_USE_ID,USER_ID,CURRENT_DATE,ORG_ID, CREATION_DATE)
1098: VALUES(p_session_id,p_customer_id,account_assigned_site.SITE_USE_ID,p_user_id,trunc(sysdate),p_org_id, trunc(sysdate));
1099: END LOOP;
1100:

Line 1136: delete from ar_irec_user_acct_sites_all where (session_id=p_session_id

1132:
1133: pragma autonomous_transaction ;
1134:
1135: BEGIN
1136: delete from ar_irec_user_acct_sites_all where (session_id=p_session_id
1137: or trunc(CREATION_DATE)<=trunc(sysdate-2));
1138:
1139: mo_global.init('AR');
1140: mo_global.set_policy_context('M',-1);

Line 1158: INSERT INTO ar_irec_user_acct_sites_all

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;*/
1162: END LOOP;

Line 1169: /* INSERT INTO ar_irec_user_acct_sites_all

1165:
1166: -- Bug 14486763 - To insert multiple bill to site use ids of a CUST_ACCT_SITE_ID
1167: 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_site_use_id => p_site_use_id);
1168:
1169: /* INSERT INTO ar_irec_user_acct_sites_all
1170: (SESSION_ID,CUSTOMER_ID,CUSTOMER_SITE_USE_ID,USER_ID,CURRENT_DATE,ORG_ID, CREATION_DATE)
1171: VALUES(p_session_id,p_customer_id,p_site_use_id,p_user_id,trunc(sysdate),l_org_id, trunc(sysdate));*/
1172:
1173: END IF;

Line 1187: INSERT INTO ar_irec_user_acct_sites_all

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));
1190: END IF;*/
1191: END LOOP;

Line 1205: INSERT INTO ar_irec_user_acct_sites_all

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;*/
1209: END LOOP;

Line 1215: /* INSERT INTO ar_irec_user_acct_sites_all

1211:
1212: ELSIF (( p_site_use_id is not null ) and (p_customer_id is not null)) THEN
1213: -- Bug 14486763 - To insert multiple bill to site use ids of a CUST_ACCT_SITE_ID
1214: 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_site_use_id => p_site_use_id);
1215: /* INSERT INTO ar_irec_user_acct_sites_all
1216: (SESSION_ID,CUSTOMER_ID,CUSTOMER_SITE_USE_ID,USER_ID,CURRENT_DATE,ORG_ID, CREATION_DATE)
1217: VALUES(p_session_id,p_customer_id,p_site_use_id,p_user_id,trunc(sysdate),l_org_id, trunc(sysdate));*/
1218:
1219: END IF;

Line 1225: DELETE FROM ar_irec_user_acct_sites_all A WHERE ROWID > (

1221: ------------------------------------------------
1222:
1223:
1224: /* REMOVE DUPLICATE ROWS IF ANY */
1225: DELETE FROM ar_irec_user_acct_sites_all A WHERE ROWID > (
1226: SELECT min(rowid) FROM ar_irec_user_acct_sites_all B
1227: WHERE A.org_id = B.org_id
1228: AND A.SESSION_ID=B.SESSION_ID
1229: AND A.USER_ID=B.USER_ID

Line 1226: SELECT min(rowid) FROM ar_irec_user_acct_sites_all B

1222:
1223:
1224: /* REMOVE DUPLICATE ROWS IF ANY */
1225: DELETE FROM ar_irec_user_acct_sites_all A WHERE ROWID > (
1226: SELECT min(rowid) FROM ar_irec_user_acct_sites_all B
1227: WHERE A.org_id = B.org_id
1228: AND A.SESSION_ID=B.SESSION_ID
1229: AND A.USER_ID=B.USER_ID
1230: AND A.CUSTOMER_ID=B.CUSTOMER_ID

Line 1270: delete from ar_irec_user_acct_sites_all where session_id=p_session_id AND RELATED_CUSTOMER_FLAG = 'Y';

1266:
1267: pragma autonomous_transaction ;
1268:
1269: BEGIN
1270: delete from ar_irec_user_acct_sites_all where session_id=p_session_id AND RELATED_CUSTOMER_FLAG = 'Y';
1271:
1272: select person_party_id into p_party_id from fnd_user where user_id = p_user_id;
1273:
1274: IF (p_is_internal_user='Y') THEN

Line 1278: INSERT INTO ar_irec_user_acct_sites_all

1274: IF (p_is_internal_user='Y') THEN
1275:
1276: /* the following insert statement is added for bug 7678038 to show receipts created with out location */
1277:
1278: INSERT INTO ar_irec_user_acct_sites_all
1279: (SESSION_ID,CUSTOMER_ID,CUSTOMER_SITE_USE_ID,USER_ID,CURRENT_DATE,ORG_ID, CREATION_DATE,RELATED_CUSTOMER_FLAG)
1280: VALUES(p_session_id,p_customer_id,'-1',p_user_id,trunc(sysdate),p_org_id, trunc(sysdate),'Y');
1281:
1282: FOR account_assigned_site IN (

Line 1286: INSERT INTO ar_irec_user_acct_sites_all

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;
1290: END LOOP;

Line 1298: INSERT INTO ar_irec_user_acct_sites_all

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');
1301: END IF;
1302: END LOOP;

Line 1309: INSERT INTO ar_irec_user_acct_sites_all

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;
1313: END LOOP;

Line 1316: INSERT INTO ar_irec_user_acct_sites_all

1312: END IF;
1313: END LOOP;
1314: /* the following insert statement is added for bug 7678038 to show receipts created with out location */
1315:
1316: INSERT INTO ar_irec_user_acct_sites_all
1317: (SESSION_ID,CUSTOMER_ID,CUSTOMER_SITE_USE_ID,USER_ID,CURRENT_DATE,ORG_ID, CREATION_DATE,RELATED_CUSTOMER_FLAG)
1318: VALUES(p_session_id,p_customer_id,'-1',p_user_id,trunc(sysdate),p_org_id, trunc(sysdate),'Y');
1319:
1320: END IF;

Line 1324: DELETE FROM ar_irec_user_acct_sites_all A WHERE ROWID > (

1320: END IF;
1321:
1322:
1323: /* REMOVE DUPLICATE ROWS IF ANY */
1324: DELETE FROM ar_irec_user_acct_sites_all A WHERE ROWID > (
1325: SELECT min(rowid) FROM ar_irec_user_acct_sites_all B
1326: WHERE A.org_id = B.org_id
1327: AND A.SESSION_ID=B.SESSION_ID
1328: AND A.USER_ID=B.USER_ID

Line 1325: SELECT min(rowid) FROM ar_irec_user_acct_sites_all B

1321:
1322:
1323: /* REMOVE DUPLICATE ROWS IF ANY */
1324: DELETE FROM ar_irec_user_acct_sites_all A WHERE ROWID > (
1325: SELECT min(rowid) FROM ar_irec_user_acct_sites_all B
1326: WHERE A.org_id = B.org_id
1327: AND A.SESSION_ID=B.SESSION_ID
1328: AND A.USER_ID=B.USER_ID
1329: AND A.CUSTOMER_ID=B.CUSTOMER_ID