APPS.PA_RETENTION_PKG dependencies on PA_RETENTION_PKG

Line 1: PACKAGE BODY pa_retention_pkg AS

1: PACKAGE BODY pa_retention_pkg AS
2: /* $Header: PAXIRTNB.pls 120.8 2010/05/28 07:58:46 rmandali ship $ */
3:
4:
5: -- Function Get_Invoice_Max_Line

Line 16: pa_retention_util.write_log('Entering pa_retention_pkg.Get_Invoice_Max_Line');

12: last_line_num NUMBER;
13: BEGIN
14:
15: IF g1_debug_mode = 'Y' THEN
16: pa_retention_util.write_log('Entering pa_retention_pkg.Get_Invoice_Max_Line');
17: END IF;
18:
19: SELECT NVL(MAX(line_num),0) +1
20: INTO last_line_num

Line 27: pa_retention_util.write_log('Leaving pa_retention_pkg.Get_Invoice_Max_Line');

23: AND draft_invoice_num = p_draft_invoice_num;
24:
25: IF g1_debug_mode = 'Y' THEN
26: pa_retention_util.write_log('Get_Invoice_Max_Line : ' || last_line_num);
27: pa_retention_util.write_log('Leaving pa_retention_pkg.Get_Invoice_Max_Line');
28: END IF;
29: RETURN (last_line_num);
30:
31: END Get_Invoice_Max_Line;

Line 51: pa_retention_util.write_log('Entering pa_retention_pkg.Get_NetZero_Line');

47:
48: BEGIN
49:
50: IF g1_debug_mode = 'Y' THEN
51: pa_retention_util.write_log('Entering pa_retention_pkg.Get_NetZero_Line');
52: END IF;
53:
54: /* Commented the code for Bug 9690548 Start
55: SELECT line_num

Line 91: Function Get_Proj_Inv_Retn_Format(p_project_id NUMBER) RETURN pa_retention_pkg.TabInvRetnLineFormat IS

87:
88: -- Function Get_Proj_Inv_Retn_Format
89: -- Purpose Function to return the project invoice retention line format
90:
91: Function Get_Proj_Inv_Retn_Format(p_project_id NUMBER) RETURN pa_retention_pkg.TabInvRetnLineFormat IS
92:
93: CURSOR cur_inv_group_columns IS SELECT grp.column_code column_code,
94: fmtdet.text text,
95: fmtdet.start_position start_position,

Line 112: TmpRetnLineFmt pa_retention_pkg.TabInvRetnLineFormat;

108: Cnt NUMBER :=0;
109:
110: InvGroupColumnsRec cur_Inv_Group_columns%ROWTYPE;
111:
112: TmpRetnLineFmt pa_retention_pkg.TabInvRetnLineFormat;
113:
114: BEGIN
115: IF g1_debug_mode = 'Y' THEN
116: pa_retention_util.write_log('Entering pa_retention_pkg.Get_Proj_Inv_Retn_Format');

Line 116: pa_retention_util.write_log('Entering pa_retention_pkg.Get_Proj_Inv_Retn_Format');

112: TmpRetnLineFmt pa_retention_pkg.TabInvRetnLineFormat;
113:
114: BEGIN
115: IF g1_debug_mode = 'Y' THEN
116: pa_retention_util.write_log('Entering pa_retention_pkg.Get_Proj_Inv_Retn_Format');
117: END IF;
118:
119: OPEN cur_inv_group_columns;
120: LOOP

Line 139: pa_retention_util.write_log('Leaving pa_retention_pkg.Get_Proj_Inv_Retn_Format');

135: END LOOP;
136: CLOSE cur_inv_group_columns;
137:
138: IF g1_debug_mode = 'Y' THEN
139: pa_retention_util.write_log('Leaving pa_retention_pkg.Get_Proj_Inv_Retn_Format');
140: END IF;
141:
142: RETURN TmpRetnLineFmt;
143:

Line 183: pa_retention_util.write_log('Entering pa_retention_pkg.Update_Retention_Balances');

179: spr_found EXCEPTION;
180:
181: BEGIN
182: IF g1_debug_mode = 'Y' THEN
183: pa_retention_util.write_log('Entering pa_retention_pkg.Update_Retention_Balances');
184: END IF;
185:
186: IF p_change_type = 'RETAINED' THEN
187:

Line 596: InvRetnLineFmt Pa_Retention_Pkg.TabInvRetnLineFormat;

592: InvProcCurrency VARCHAR2(15);
593: InvProcCurrType VARCHAR2(30); --Added for Bug3604143
594: BillTransCurrency VARCHAR2(15);
595:
596: InvRetnLineFmt Pa_Retention_Pkg.TabInvRetnLineFormat;
597:
598: TmpCnt BINARY_INTEGER:=0;
599: UpdateRDL BOOLEAN := FALSE;
600: UpdateERDL BOOLEAN := FALSE;

Line 3801: END pa_retention_pkg;

3797: RAISE;
3798:
3799: END Delete_Unused_Retention_Lines;
3800:
3801: END pa_retention_pkg;