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.HZ_MGD_MASS_UPDATE_MEDIATOR dependencies on HZ_CREDIT_USAGES

Line 223: , hz_credit_usages cu

219: , substrb(cur.user_code,1,5) curr
220: , cpa.currency_code prof_curr
221: FROM hz_customer_profiles cp
222: , hz_cust_profile_amts cpa
223: , hz_credit_usages cu
224: , hz_credit_usage_rules cur
225: WHERE cp.party_id = p_entity_id
226: AND cp.site_use_id IS NULL
227: AND cp.cust_account_id =-1

Line 254: , hz_credit_usages cu

250: SELECT cpa.currency_code profile_curr
251: , cu.credit_usage_id
252: FROM hz_customer_profiles cp
253: , hz_cust_profile_amts cpa
254: , hz_credit_usages cu
255: , hz_credit_usage_rules cur
256: WHERE cp.party_id = p_entity_id
257: AND cp.cust_account_id =-1
258: AND cp.site_use_id IS NULL

Line 285: , hz_credit_usages cu

281: , substrb(cur.user_code,1,5) curr
282: , cpa.currency_code prof_curr
283: FROM hz_customer_profiles cp
284: , hz_cust_profile_amts cpa
285: , hz_credit_usages cu
286: , hz_credit_usage_rules cur
287: WHERE cp.party_id = p_entity_id
288: AND cp.cust_account_id =-1
289: AND cp.site_use_id IS NULL

Line 317: , hz_credit_usages cu

313: SELECT cpa.currency_code profile_curr
314: , cu.credit_usage_id
315: FROM hz_customer_profiles cp
316: , hz_cust_profile_amts cpa
317: , hz_credit_usages cu
318: , hz_credit_usage_rules cur
319: WHERE cp.party_id = p_entity_id
320: AND cp.cust_account_id =-1
321: AND cp.site_use_id IS NULL

Line 344: , hz_credit_usages cu

340: , substrb(cur.user_code,1,5) curr
341: , cpa.currency_code prof_curr
342: FROM hz_customer_profiles cp
343: , hz_cust_profile_amts cpa
344: , hz_credit_usages cu
345: , hz_credit_usage_rules cur
346: WHERE cp.cust_account_id = p_cust_account_id
347: AND cp.site_use_id = p_entity_id
348: AND cp.cust_account_profile_id = cpa.cust_account_profile_id

Line 374: , hz_credit_usages cu

370: SELECT cpa.currency_code profile_curr
371: , cu.credit_usage_id
372: FROM hz_customer_profiles cp
373: , hz_cust_profile_amts cpa
374: , hz_credit_usages cu
375: , hz_credit_usage_rules cur
376: WHERE cp.cust_account_id = p_cust_account_id
377: AND cp.site_use_id = p_entity_id
378: AND cp.cust_account_profile_id = cpa.cust_account_profile_id

Line 403: , hz_credit_usages cu

399: , substrb(cur.user_code,1,5) curr
400: , cpa.currency_code prof_curr
401: FROM hz_customer_profiles cp
402: , hz_cust_profile_amts cpa
403: , hz_credit_usages cu
404: , hz_credit_usage_rules cur
405: WHERE cp.cust_account_id = p_cust_account_id
406: AND cp.site_use_id = p_entity_id
407: AND cp.cust_account_profile_id = cpa.cust_account_profile_id

Line 433: , hz_credit_usages cu

429: SELECT cpa.currency_code profile_curr
430: , cu.credit_usage_id
431: FROM hz_customer_profiles cp
432: , hz_cust_profile_amts cpa
433: , hz_credit_usages cu
434: , hz_credit_usage_rules cur
435: WHERE cp.cust_account_id = p_cust_account_id
436: AND cp.site_use_id = p_entity_id
437: AND cp.cust_account_profile_id = cpa.cust_account_profile_id

Line 463: , hz_credit_usages cu

459: , substrb(cur.user_code,1,5) curr
460: , cpa.currency_code prof_curr
461: FROM hz_customer_profiles cp
462: , hz_cust_profile_amts cpa
463: , hz_credit_usages cu
464: , hz_credit_usage_rules cur
465: WHERE cp.cust_account_id = p_entity_id
466: AND cp.site_use_id IS NULL
467: AND cp.cust_account_profile_id = cpa.cust_account_profile_id

Line 493: , hz_credit_usages cu

489: SELECT cpa.currency_code profile_curr
490: , cu.credit_usage_id
491: FROM hz_customer_profiles cp
492: , hz_cust_profile_amts cpa
493: , hz_credit_usages cu
494: , hz_credit_usage_rules cur
495: WHERE cp.cust_account_id = p_entity_id
496: AND cp.site_use_id IS NULL
497: AND cp.cust_account_profile_id = cpa.cust_account_profile_id

Line 523: , hz_credit_usages cu

519: , substrb(cur.user_code,1,5) curr
520: , cpa.currency_code prof_curr
521: FROM hz_customer_profiles cp
522: , hz_cust_profile_amts cpa
523: , hz_credit_usages cu
524: , hz_credit_usage_rules cur
525: WHERE cp.cust_account_id = p_entity_id
526: AND cp.site_use_id IS NULL
527: AND cp.cust_account_profile_id = cpa.cust_account_profile_id

Line 554: , hz_credit_usages cu

550: SELECT cpa.currency_code profile_curr
551: , cu.credit_usage_id
552: FROM hz_customer_profiles cp
553: , hz_cust_profile_amts cpa
554: , hz_credit_usages cu
555: , hz_credit_usage_rules cur
556: WHERE cp.cust_account_id = p_entity_id
557: AND cp.site_use_id IS NULL
558: AND cp.cust_account_profile_id = cpa.cust_account_profile_id

Line 997: usages table HZ_CREDIT_USAGES for this ID

993: PROCEDURE: delete_credit_usages
994: COMMENTS: This procedure will accept the
995: cust_acct_profile_amt_id as input and
996: remove records from the multi currency credit checking
997: usages table HZ_CREDIT_USAGES for this ID
998: -----------------------------------------------------------------*/
999: PROCEDURE delete_credit_usages
1000: ( p_cust_acct_profile_amt_id IN NUMBER
1001: , X_return_status OUT NOCOPY VARCHAR2

Line 1017: HZ_CREDIT_USAGES

1013:
1014: X_return_status := 'S' ;
1015:
1016: DELETE FROM
1017: HZ_CREDIT_USAGES
1018: WHERE CUST_ACCT_PROFILE_AMT_ID
1019: = p_cust_acct_profile_amt_id ;
1020:
1021: HZ_MGD_MASS_UPDATE_REP_GEN.log

Line 1068: FROM HZ_CREDIT_USAGES

1064:
1065: CURSOR rule_set_csr IS
1066: SELECT
1067: credit_usage_rule_set_id
1068: FROM HZ_CREDIT_USAGES
1069: WHERE profile_class_amount_id = p_profile_class_amt_id;
1070:
1071: RULE_SET_CSR_REC rule_set_csr%ROWTYPE;
1072:

Line 1087: -- HZ_credit_usages table

1083: -- made with the profile class limit currency with
1084: -- profile amt currency being created when the
1085: -- profile class amt currency ic used as reference
1086: -- The information is currently stores in the
1087: -- HZ_credit_usages table
1088:
1089: -- The logic is to replicate the exact image of the rule sets
1090: -- assignments made with the profile class amount currency
1091: -- so the exiting rule sets assigned with the

Line 1284: INSERT INTO HZ_CREDIT_USAGES

1280: AND l_duplicate <> 'Y'
1281: THEN
1282: ---DBMS_OUTPUT.PUT_LINE('Delete SUCCESS, call INSERT ');
1283:
1284: INSERT INTO HZ_CREDIT_USAGES
1285: ( CREDIT_USAGE_ID
1286: , CREDIT_PROFILE_AMT_ID
1287: , CUST_ACCT_PROFILE_AMT_ID
1288: , PROFILE_CLASS_AMOUNT_ID

Line 1316: HZ_CREDIT_USAGES_S.NEXTVAL

1312: , ATTRIBUTE13
1313: , ATTRIBUTE14
1314: , ATTRIBUTE15
1315: ) SELECT
1316: HZ_CREDIT_USAGES_S.NEXTVAL
1317: , NULL
1318: , p_cust_acct_profile_amt_id
1319: , NULL
1320: , cu.CREDIT_USAGE_RULE_SET_ID

Line 1347: HZ_CREDIT_USAGES cu

1343: , cu.ATTRIBUTE13
1344: , cu.ATTRIBUTE14
1345: , cu.ATTRIBUTE15
1346: FROM
1347: HZ_CREDIT_USAGES cu
1348: WHERE cu.PROFILE_CLASS_AMOUNT_ID = p_profile_class_amt_id ;
1349:
1350: END IF;
1351:

Line 1427: , p_msg => ' HZ_CREDIT_USAGES_CASCADE_PKG.Cascade_credit_usage_rules for

1423: , p_currency_code => p_currency_code)
1424: LOOP
1425: HZ_MGD_MASS_UPDATE_REP_GEN.log
1426: ( p_priority => HZ_MGD_MASS_UPDATE_REP_GEN.G_LOG_STATEMENT
1427: , p_msg => ' HZ_CREDIT_USAGES_CASCADE_PKG.Cascade_credit_usage_rules for
1428: p_cust_acct_profile_amt_id='||TO_CHAR(cust_prof_csr_rec.cust_acct_profile_amt_id)
1429: ||' p_profile_class_amt_id='||TO_CHAR(p_profile_class_amount_id)
1430: );
1431:

Line 1438: FROM HZ_CREDIT_USAGES

1434: SELECT
1435: COUNT(*)
1436: INTO
1437: l_count
1438: FROM HZ_CREDIT_USAGES
1439: WHERE profile_class_amount_id = p_profile_class_amount_id;
1440:
1441: IF l_count=0
1442: THEN