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_CREDIT_USAGES_CASCADE_PKG dependencies on HZ_CREDIT_USAGES

Line 1: PACKAGE BODY HZ_CREDIT_USAGES_CASCADE_PKG AS

1: PACKAGE BODY HZ_CREDIT_USAGES_CASCADE_PKG AS
2: /* $Header: ARHCRCCB.pls 115.15 2003/03/15 03:51:18 vto noship $ */
3: --======================================================================
4: --CONSTANTS
5: --======================================================================

Line 6: G_PKG_NAME CONSTANT VARCHAR2(30) := 'HZ_CREDIT_USAGES_CASCADE_PKG' ;

2: /* $Header: ARHCRCCB.pls 115.15 2003/03/15 03:51:18 vto noship $ */
3: --======================================================================
4: --CONSTANTS
5: --======================================================================
6: G_PKG_NAME CONSTANT VARCHAR2(30) := 'HZ_CREDIT_USAGES_CASCADE_PKG' ;
7:
8: G_request_id NUMBER
9: := FND_GLOBAL.CONC_Request_id ;
10: G_program_id NUMBER

Line 59: FROM HZ_CREDIT_USAGES cu

55: CURSOR rule_set_csr IS
56: SELECT
57: cu.credit_usage_rule_set_id
58: , cr.global_exposure_flag
59: FROM HZ_CREDIT_USAGES cu
60: , hz_credit_usage_rule_sets_b cr
61: WHERE cu.profile_class_amount_id = p_profile_class_amt_id
62: AND cu.credit_usage_rule_set_id = cr.credit_usage_rule_set_id ;
63:

Line 75: -- HZ_credit_usages table

71: -- made with the profile class limit currency with
72: -- profile amt currency being created when the
73: -- profile class amt currency ic used as reference
74: -- The information is currently stores in the
75: -- HZ_credit_usages table
76:
77: -- The logic is to replicate the exact image of the rule sets
78: -- assignments made with the profile class amount currency
79: -- so the exiting rule sets assigned with the

Line 207: HZ_CREDIT_USAGES_CASCADE_PKG.Check_Duplicate_all

203: THEN
204: l_duplicate := 'Y' ;
205: ELSE
206: l_duplicate := NULL ;
207: HZ_CREDIT_USAGES_CASCADE_PKG.Check_Duplicate_all
208: ( p_rule_set_id =>
209: rule_set_csr_rec.credit_usage_rule_set_id
210: , p_entity => l_entity
211: , p_entity_id => l_entity_id

Line 232: HZ_CREDIT_USAGES_CASCADE_PKG.delete_credit_usages

228: IF l_duplicate <> 'Y'
229: THEN
230: --DBMS_OUTPUT.PUT_LINE('Call delete_credit_usages ');
231:
232: HZ_CREDIT_USAGES_CASCADE_PKG.delete_credit_usages
233: ( p_cust_acct_profile_amt_id => p_cust_acct_profile_amt_id
234: , X_return_status => X_return_status
235: , X_msg_count => X_msg_count
236: , X_msg_data => X_msg_data

Line 245: INSERT INTO HZ_CREDIT_USAGES

241: AND l_duplicate <> 'Y'
242: THEN
243: --DBMS_OUTPUT.PUT_LINE('Delete SUCCESS, call INSERT ');
244:
245: INSERT INTO HZ_CREDIT_USAGES
246: ( CREDIT_USAGE_ID
247: , CREDIT_PROFILE_AMT_ID
248: , CUST_ACCT_PROFILE_AMT_ID
249: , PROFILE_CLASS_AMOUNT_ID

Line 278: HZ_CREDIT_USAGES_S.NEXTVAL

274: , ATTRIBUTE14
275: , ATTRIBUTE15
276: )
277: SELECT
278: HZ_CREDIT_USAGES_S.NEXTVAL
279: , NULL
280: , p_cust_acct_profile_amt_id
281: , NULL
282: , cu.CREDIT_USAGE_RULE_SET_ID

Line 309: HZ_CREDIT_USAGES cu

305: , cu.ATTRIBUTE13
306: , cu.ATTRIBUTE14
307: , cu.ATTRIBUTE15
308: FROM
309: HZ_CREDIT_USAGES cu
310: WHERE cu.PROFILE_CLASS_AMOUNT_ID = p_profile_class_amt_id ;
311:
312: END IF;
313:

Line 325: -- usages table HZ_CREDIT_USAGES for this ID

321: -- PROCEDURE: delete_credit_usages
322: -- COMMENTS: This procedure will accept the
323: -- cust_acct_profile_amt_id as input and
324: -- remove records from the multi currency credit checking
325: -- usages table HZ_CREDIT_USAGES for this ID
326: -----------------------------------------------------------------
327: PROCEDURE delete_credit_usages
328: ( p_cust_acct_profile_amt_id IN NUMBER
329: , X_return_status OUT NOCOPY VARCHAR2

Line 341: HZ_CREDIT_USAGES

337:
338: X_return_status := 'S' ;
339:
340: DELETE FROM
341: HZ_CREDIT_USAGES
342: WHERE CUST_ACCT_PROFILE_AMT_ID = p_cust_acct_profile_amt_id ;
343:
344: EXCEPTION
345: WHEN OTHERS THEN

Line 415: , hz_credit_usages cu

411: , substrb(cur.user_code,1,5) curr
412: , cpa.currency_code prof_curr
413: FROM hz_customer_profiles cp
414: , hz_cust_profile_amts cpa
415: , hz_credit_usages cu
416: , hz_credit_usage_rules cur
417: WHERE cp.cust_account_id = p_cust_account_id
418: AND cp.site_use_id = p_entity_id
419: AND cp.cust_account_profile_id = cpa.cust_account_profile_id

Line 445: , hz_credit_usages cu

441: SELECT cpa.currency_code profile_curr
442: , cu.credit_usage_id
443: FROM hz_customer_profiles cp
444: , hz_cust_profile_amts cpa
445: , hz_credit_usages cu
446: , hz_credit_usage_rules cur
447: WHERE cp.cust_account_id = p_cust_account_id
448: AND cp.site_use_id = p_entity_id
449: AND cp.cust_account_profile_id = cpa.cust_account_profile_id

Line 474: , hz_credit_usages cu

470: , substrb(cur.user_code,1,5) curr
471: , cpa.currency_code prof_curr
472: FROM hz_customer_profiles cp
473: , hz_cust_profile_amts cpa
474: , hz_credit_usages cu
475: , hz_credit_usage_rules cur
476: WHERE cp.cust_account_id = p_cust_account_id
477: AND cp.site_use_id = p_entity_id
478: AND cp.cust_account_profile_id = cpa.cust_account_profile_id

Line 504: , hz_credit_usages cu

500: SELECT cpa.currency_code profile_curr
501: , cu.credit_usage_id
502: FROM hz_customer_profiles cp
503: , hz_cust_profile_amts cpa
504: , hz_credit_usages cu
505: , hz_credit_usage_rules cur
506: WHERE cp.cust_account_id = p_cust_account_id
507: AND cp.site_use_id = p_entity_id
508: AND cp.cust_account_profile_id = cpa.cust_account_profile_id

Line 534: , hz_credit_usages cu

530: , substrb(cur.user_code,1,5) curr
531: , cpa.currency_code prof_curr
532: FROM hz_customer_profiles cp
533: , hz_cust_profile_amts cpa
534: , hz_credit_usages cu
535: , hz_credit_usage_rules cur
536: WHERE cp.cust_account_id = p_entity_id
537: AND cp.site_use_id IS NULL
538: AND cp.cust_account_profile_id = cpa.cust_account_profile_id

Line 564: , hz_credit_usages cu

560: SELECT cpa.currency_code profile_curr
561: , cu.credit_usage_id
562: FROM hz_customer_profiles cp
563: , hz_cust_profile_amts cpa
564: , hz_credit_usages cu
565: , hz_credit_usage_rules cur
566: WHERE cp.cust_account_id = p_entity_id
567: AND cp.site_use_id IS NULL
568: AND cp.cust_account_profile_id = cpa.cust_account_profile_id

Line 594: , hz_credit_usages cu

590: , substrb(cur.user_code,1,5) curr
591: , cpa.currency_code prof_curr
592: FROM hz_customer_profiles cp
593: , hz_cust_profile_amts cpa
594: , hz_credit_usages cu
595: , hz_credit_usage_rules cur
596: WHERE cp.cust_account_id = p_entity_id
597: AND cp.site_use_id IS NULL
598: AND cp.cust_account_profile_id = cpa.cust_account_profile_id

Line 625: , hz_credit_usages cu

621: SELECT cpa.currency_code profile_curr
622: , cu.credit_usage_id
623: FROM hz_customer_profiles cp
624: , hz_cust_profile_amts cpa
625: , hz_credit_usages cu
626: , hz_credit_usage_rules cur
627: WHERE cp.cust_account_id = p_entity_id
628: AND cp.site_use_id IS NULL
629: AND cp.cust_account_profile_id = cpa.cust_account_profile_id

Line 647: , hz_credit_usages cu

643: , substrb(cur.user_code,1,5) curr
644: , cpa.currency_code prof_curr
645: FROM hz_customer_profiles cp
646: , hz_cust_profile_amts cpa
647: , hz_credit_usages cu
648: , hz_credit_usage_rules cur
649: WHERE cp.cust_account_id = -1
650: AND cp.site_use_id IS NULL
651: AND cp.party_id = p_entity_id

Line 678: , hz_credit_usages cu

674: SELECT cpa.currency_code profile_curr
675: , cu.credit_usage_id
676: FROM hz_customer_profiles cp
677: , hz_cust_profile_amts cpa
678: , hz_credit_usages cu
679: , hz_credit_usage_rules cur
680: WHERE cp.cust_account_id = -1
681: AND cp.site_use_id IS NULL
682: AND cp.party_id = p_entity_id

Line 709: , hz_credit_usages cu

705: , substrb(cur.user_code,1,5) curr
706: , cpa.currency_code prof_curr
707: FROM hz_customer_profiles cp
708: , hz_cust_profile_amts cpa
709: , hz_credit_usages cu
710: , hz_credit_usage_rules cur
711: WHERE cp.cust_account_id = -1
712: AND cp.site_use_id IS NULL
713: AND cp.party_id = p_entity_id

Line 741: , hz_credit_usages cu

737: SELECT cpa.currency_code profile_curr
738: , cu.credit_usage_id
739: FROM hz_customer_profiles cp
740: , hz_cust_profile_amts cpa
741: , hz_credit_usages cu
742: , hz_credit_usage_rules cur
743: WHERE cp.cust_account_id = -1
744: AND cp.site_use_id IS NULL
745: AND cp.party_id = p_entity_id

Line 1178: END HZ_CREDIT_USAGES_CASCADE_PKG ;

1174:
1175:
1176:
1177:
1178: END HZ_CREDIT_USAGES_CASCADE_PKG ;