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.IGI_STP_TABLE_HANDLER_PKG dependencies on IGI_RA_CUSTOMERS

Line 1196: CURSOR C2 IS SELECT customer_id FROM igi_ra_customers

1192: CURSOR C IS SELECT party_id FROM hz_parties
1193: WHERE party_id = X_party_id;
1194: CURSOR C1 IS SELECT rowid FROM hz_cust_accounts
1195: WHERE cust_account_id = X_customer_id;
1196: CURSOR C2 IS SELECT customer_id FROM igi_ra_customers
1197: WHERE customer_id = X_customer_id;
1198:
1199: CURSOR c_gen_cust_num IS
1200: SELECT generate_customer_number

Line 1306: INSERT INTO igi_ra_customers(

1302: CLOSE C1;
1303:
1304:
1305:
1306: INSERT INTO igi_ra_customers(
1307: customer_id,
1308: stp_enforce_threshold,
1309: stp_type,
1310: creation_date,

Line 1453: UPDATE igi_ra_customers irc

1449: x_msg_count => l_msg_count,
1450: x_msg_data => l_msg_data
1451: );
1452:
1453: UPDATE igi_ra_customers irc
1454: SET stp_enforce_threshold = X_stp_enforce_threshold,
1455: stp_type = X_stp_type,
1456: last_update_login = X_last_update_login,
1457: last_update_date = X_last_update_date,

Line 1491: FROM igi_ra_customers irc

1487: RecCust C%ROWTYPE;
1488:
1489: CURSOR C1 IS
1490: SELECT *
1491: FROM igi_ra_customers irc
1492: WHERE irc.customer_id = (select a.cust_account_id from hz_cust_accounts a,hz_parties p -- Bug 3902175
1493: where a.party_id = p.party_id and a.rowid = X_rowid)
1494: FOR UPDATE OF irc.customer_id NOWAIT;
1495: