APPS.XNB_BILL_SUMMARIES_PKG dependencies on XNB_BILL_SUMMARIES

Line 1: PACKAGE BODY XNB_BILL_SUMMARIES_PKG as

1: PACKAGE BODY XNB_BILL_SUMMARIES_PKG as
2: /* $Header: XNBTBSB.pls 120.0 2005/05/30 13:45:26 appldev noship $ */
3:
4: -- Start of Comments
5: -- Package name : XNB_BILL_SUMMARIES_PKG

Line 5: -- Package name : XNB_BILL_SUMMARIES_PKG

1: PACKAGE BODY XNB_BILL_SUMMARIES_PKG as
2: /* $Header: XNBTBSB.pls 120.0 2005/05/30 13:45:26 appldev noship $ */
3:
4: -- Start of Comments
5: -- Package name : XNB_BILL_SUMMARIES_PKG
6: -- Purpose : Defines public APIs to insert/update records into XNB BILL SUMMARIES schema
7: -- NOTE :
8: -- History :
9: -- DATE AUTHOR COMMENTS

Line 6: -- Purpose : Defines public APIs to insert/update records into XNB BILL SUMMARIES schema

2: /* $Header: XNBTBSB.pls 120.0 2005/05/30 13:45:26 appldev noship $ */
3:
4: -- Start of Comments
5: -- Package name : XNB_BILL_SUMMARIES_PKG
6: -- Purpose : Defines public APIs to insert/update records into XNB BILL SUMMARIES schema
7: -- NOTE :
8: -- History :
9: -- DATE AUTHOR COMMENTS
10: -- 24-Aug-2004 dbhagat Create table handler

Line 15: G_PKG_NAME CONSTANT VARCHAR2(30):= 'XNB_BILL_SUMMARIES_PKG';

11: -- 04-Feb-2005 DPUTHIYE Added p_api_version parameter to APIs. (Fixed bug 4159395).
12: -- 14-Apr-2005 dbhagat Removed Bill Cycle End Date a mandatory for update. (Fixed bug 4300093).
13: -- End of Comments
14:
15: G_PKG_NAME CONSTANT VARCHAR2(30):= 'XNB_BILL_SUMMARIES_PKG';
16: G_FILE_NAME CONSTANT VARCHAR2(12) := 'xnbtbsb.pls';
17:
18:
19: -- Start of comments

Line 24: -- . XNB_BILL_SUMMARIES

20: -- API name : Insert_Row_Batch
21: -- Type : Public
22: -- Pre-reqs : None.
23: -- Function : Inserts the given bill summary rows into the XNB table
24: -- . XNB_BILL_SUMMARIES
25: -- Assumptions :
26: -- All records whose
27: -- 1. Account Number must exit in eBusiness suite database schema
28: -- HZ_CUST_ACCOUNTS.ACCOUNT_NUMBER.

Line 129: from XNB_BILL_SUMMARIES

125: where ACCOUNT_NUMBER = tmp_acc_num;
126:
127: Cursor c_check_uniq_constrain is
128: select 1
129: from XNB_BILL_SUMMARIES
130: where ACCOUNT_NUMBER = t_acc_num
131: and BILL_NUMBER = t_bill_num
132: and BILLING_VENDOR_NAME = t_bill_vendor;
133:

Line 389: INSERT INTO XNB_BILL_SUMMARIES(

385: END LOOP; -- End For loop
386:
387: -- batch insert all valid records in database
388: FORALL i IN 1..l_bs_valid_rec_count
389: INSERT INTO XNB_BILL_SUMMARIES(
390: BILL_SUMMARY_ID,
391: ACCOUNT_NUMBER,
392: TOTAL_AMOUNT_DUE,
393: ADJUSTMENTS,

Line 429: XNB_BILL_SUMMARIES_S.nextval,

425: ATTRIBUTE13,
426: ATTRIBUTE14,
427: ATTRIBUTE15
428: ) VALUES (
429: XNB_BILL_SUMMARIES_S.nextval,
430: l_account_number(i),
431: l_total_amount_due(i),
432: l_adjustments(i),
433: l_unresolved_disputes(i),

Line 515: -- . XNB_BILL_SUMMARIES.

511: -- API name : Update_Row_Batch
512: -- Type : Public
513: -- Pre-reqs : None.
514: -- Function : Updates the given bill summary rows in the XNB table
515: -- . XNB_BILL_SUMMARIES.
516: -- Assumptions :
517: -- All records whose
518: -- 1. Account Number must exit in eBusiness suite database schema
519: -- HZ_CUST_ACCOUNTS.ACCOUNT_NUMBER.

Line 641: from XNB_BILL_SUMMARIES

637: ATTRIBUTE12,
638: ATTRIBUTE13,
639: ATTRIBUTE14,
640: ATTRIBUTE15
641: from XNB_BILL_SUMMARIES
642: where ACCOUNT_NUMBER = t_acc_num
643: and BILL_NUMBER = t_bill_num
644: and BILLING_VENDOR_NAME = t_bill_vendor;
645:

Line 936: Update XNB_BILL_SUMMARIES

932: END LOOP; -- End For loop
933:
934: -- batch update all valid records in database
935: FORALL i IN 1..l_bs_valid_rec_count
936: Update XNB_BILL_SUMMARIES
937: SET
938: TOTAL_AMOUNT_DUE = l_total_amount_due(i),
939: ADJUSTMENTS = l_adjustments(i),
940: UNRESOLVED_DISPUTES = l_unresolved_disputes(i),

Line 1019: End XNB_BILL_SUMMARIES_PKG;

1015:
1016: End Update_Row_Batch;
1017:
1018:
1019: End XNB_BILL_SUMMARIES_PKG;