APPS.HZ_CREDIT_USAGES_PKG dependencies on HZ_CREDIT_USAGES

Line 1: PACKAGE BODY HZ_CREDIT_USAGES_PKG AS

1: PACKAGE BODY HZ_CREDIT_USAGES_PKG AS
2: /* $Header: ARHUSAGB.pls 115.10 2004/02/03 22:47:44 bsarkar ship $ */
3:
4:
5: ----------Globals

Line 56: -- COMMENT : Procedure inserts record into the table HZ_CREDIT_USAGES

52: -- a record
53: -- p_last_update_login login of the person,who inserted
54: -- a record
55:
56: -- COMMENT : Procedure inserts record into the table HZ_CREDIT_USAGES
57: --========================================================================
58: PROCEDURE Insert_row
59: ( p_row_id OUT NOCOPY VARCHAR2
60: , p_credit_usage_rule_set_id NUMBER

Line 93: HZ_CREDIT_USAGES

89: CURSOR usages_csr IS
90: SELECT
91: rowid
92: FROM
93: HZ_CREDIT_USAGES
94: WHERE credit_usage_id=p_credit_usage_id;
95:
96: BEGIN
97:

Line 98: INSERT INTO hz_credit_usages

94: WHERE credit_usage_id=p_credit_usage_id;
95:
96: BEGIN
97:
98: INSERT INTO hz_credit_usages
99: ( credit_usage_id
100: , credit_profile_amt_id
101: , cust_acct_profile_amt_id
102: , profile_class_amount_id

Line 186: -- table HZ_CREDIT_USAGES.

182: --========================================================================
183: -- PROCEDURE : Delete_row PUBLIC
184: -- PARAMETERS: p_row_id ROWID of the current record
185: -- COMMENT : Procedure deletes record with ROWID=p_row_id from the
186: -- table HZ_CREDIT_USAGES.
187: --========================================================================
188: PROCEDURE Delete_row
189: ( p_row_id VARCHAR2
190: )

Line 194: FROM HZ_CREDIT_USAGES

190: )
191: IS
192: BEGIN
193: DELETE
194: FROM HZ_CREDIT_USAGES
195: WHERE ROWID=p_row_id;
196:
197: IF (SQL%NOTFOUND)
198: THEN

Line 220: -- COMMENT : Procedure locks current record in the table HZ_CREDIT_USAGES.

216: -- p_credit_profile_amt_id
217: -- p_profile_class_amount_id
218: -- p_cust_acct_profile_amt_id
219: --
220: -- COMMENT : Procedure locks current record in the table HZ_CREDIT_USAGES.
221: --========================================================================
222: PROCEDURE Lock_row
223: ( p_row_id VARCHAR2
224: , p_credit_usage_rule_set_id NUMBER

Line 233: FROM hz_credit_usages

229: IS
230: CURSOR usage_csr
231: IS
232: SELECT *
233: FROM hz_credit_usages
234: WHERE rowid=CHARTOROWID(p_row_id)
235: FOR UPDATE OF cust_acct_profile_amt_id NOWAIT;
236:
237: recinfo usage_csr%ROWTYPE;

Line 289: , x_usage_curr_tbl OUT NOCOPY HZ_CREDIT_USAGES_PKG.curr_tbl_type

285: , x_overall_limit OUT NOCOPY NUMBER
286: , x_cust_acct_profile_amt_id OUT NOCOPY NUMBER
287: , x_global_exposure_flag OUT NOCOPY VARCHAR2
288: , x_include_all_flag OUT NOCOPY VARCHAR2
289: , x_usage_curr_tbl OUT NOCOPY HZ_CREDIT_USAGES_PKG.curr_tbl_type
290: , x_excl_curr_list OUT NOCOPY VARCHAR2
291: ) IS
292:
293:

Line 306: , hz_credit_usages cu

302: , cp.credit_checking
303: , cu.credit_usage_rule_set_id
304: FROM hz_customer_profiles cp
305: , hz_cust_profile_amts cpa
306: , hz_credit_usages cu
307: , hz_credit_usage_rules cur
308: WHERE cp.cust_account_id = p_entity_id
309: AND cp.site_use_id IS NULL
310: AND cp.cust_account_profile_id = cpa.cust_account_profile_id

Line 335: , hz_credit_usages cu

331: , cp.credit_checking
332: , cu.credit_usage_rule_set_id
333: FROM hz_customer_profiles cp
334: , hz_cust_profile_amts cpa
335: , hz_credit_usages cu
336: , hz_credit_usage_rules cur
337: WHERE cp.cust_account_id = p_entity_id
338: AND cp.site_use_id IS NULL
339: AND cp.cust_account_profile_id = cpa.cust_account_profile_id

Line 371: , hz_credit_usages cu

367: , cp.credit_checking
368: , cu.credit_usage_rule_set_id
369: FROM hz_customer_profiles cp
370: , hz_cust_profile_amts cpa
371: , hz_credit_usages cu
372: , hz_credit_usage_rules cur
373: WHERE cp.site_use_id = p_entity_id
374: AND cp.cust_account_profile_id = cpa.cust_account_profile_id
375: AND cpa.cust_acct_profile_amt_id = cu.cust_acct_profile_amt_id

Line 398: , hz_credit_usages cu

394: , cp.credit_checking
395: , cu.credit_usage_rule_set_id
396: FROM hz_customer_profiles cp
397: , hz_cust_profile_amts cpa
398: , hz_credit_usages cu
399: , hz_credit_usage_rules cur
400: WHERE cp.site_use_id = p_entity_id
401: AND cp.cust_account_profile_id = cpa.cust_account_profile_id
402: AND cpa.cust_acct_profile_amt_id = cu.cust_acct_profile_amt_id

Line 431: , hz_credit_usages cu

427: , cp.credit_checking
428: , cu.credit_usage_rule_set_id
429: FROM hz_customer_profiles cp
430: , hz_cust_profile_amts cpa
431: , hz_credit_usages cu
432: , hz_credit_usage_rules cur
433: WHERE cp.cust_account_id = -1
434: AND cp.site_use_id IS NULL
435: AND cp.party_id = p_entity_id

Line 461: , hz_credit_usages cu

457: , cp.credit_checking
458: , cu.credit_usage_rule_set_id
459: FROM hz_customer_profiles cp
460: , hz_cust_profile_amts cpa
461: , hz_credit_usages cu
462: , hz_credit_usage_rules cur
463: WHERE cp.cust_account_id = -1
464: AND cp.site_use_id IS NULL
465: AND cp.party_id = p_entity_id

Line 648: , x_usage_curr_tbl OUT NOCOPY HZ_CREDIT_USAGES_PKG.curr_tbl_type

644: p_cust_acct_profile_amt_id IN NUMBER
645: ,p_limit_curr_code IN VARCHAR2
646: , x_global_exposure_flag OUT NOCOPY VARCHAR2
647: , x_include_all_flag OUT NOCOPY VARCHAR2
648: , x_usage_curr_tbl OUT NOCOPY HZ_CREDIT_USAGES_PKG.curr_tbl_type
649: , x_excl_curr_list OUT NOCOPY VARCHAR2
650: )
651: IS
652:

Line 659: FROM hz_credit_usages usg

655: --------------------------------------------------------
656: CURSOR usage_rule_set_csr IS
657: SELECT rset.credit_usage_rule_set_id ,
658: rset.global_exposure_flag
659: FROM hz_credit_usages usg
660: , hz_credit_usage_rule_sets_b rset
661: WHERE usg.cust_acct_profile_amt_id = p_cust_acct_profile_amt_id
662: AND rset.credit_usage_rule_set_id = usg.credit_usage_rule_set_id ;
663:

Line 865: END HZ_CREDIT_USAGES_PKG;

861: END get_usage_rules ;
862:
863:
864:
865: END HZ_CREDIT_USAGES_PKG;