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.6.12000000.2 2007/07/24 11:36:25 jjgeorge 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 41: pa_retention_util.write_log('Entering pa_retention_pkg.Get_NetZero_Line');

37: NetZero_line_num NUMBER;
38: BEGIN
39:
40: IF g1_debug_mode = 'Y' THEN
41: pa_retention_util.write_log('Entering pa_retention_pkg.Get_NetZero_Line');
42: END IF;
43:
44: SELECT line_num
45: INTO NetZero_line_num

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

69:
70: -- Function Get_Proj_Inv_Retn_Format
71: -- Purpose Function to return the project invoice retention line format
72:
73: Function Get_Proj_Inv_Retn_Format(p_project_id NUMBER) RETURN pa_retention_pkg.TabInvRetnLineFormat IS
74:
75: CURSOR cur_inv_group_columns IS SELECT grp.column_code column_code,
76: fmtdet.text text,
77: fmtdet.start_position start_position,

Line 94: TmpRetnLineFmt pa_retention_pkg.TabInvRetnLineFormat;

90: Cnt NUMBER :=0;
91:
92: InvGroupColumnsRec cur_Inv_Group_columns%ROWTYPE;
93:
94: TmpRetnLineFmt pa_retention_pkg.TabInvRetnLineFormat;
95:
96: BEGIN
97: IF g1_debug_mode = 'Y' THEN
98: pa_retention_util.write_log('Entering pa_retention_pkg.Get_Proj_Inv_Retn_Format');

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

94: TmpRetnLineFmt pa_retention_pkg.TabInvRetnLineFormat;
95:
96: BEGIN
97: IF g1_debug_mode = 'Y' THEN
98: pa_retention_util.write_log('Entering pa_retention_pkg.Get_Proj_Inv_Retn_Format');
99: END IF;
100:
101: OPEN cur_inv_group_columns;
102: LOOP

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

117: END LOOP;
118: CLOSE cur_inv_group_columns;
119:
120: IF g1_debug_mode = 'Y' THEN
121: pa_retention_util.write_log('Leaving pa_retention_pkg.Get_Proj_Inv_Retn_Format');
122: END IF;
123:
124: RETURN TmpRetnLineFmt;
125:

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

161: spr_found EXCEPTION;
162:
163: BEGIN
164: IF g1_debug_mode = 'Y' THEN
165: pa_retention_util.write_log('Entering pa_retention_pkg.Update_Retention_Balances');
166: END IF;
167:
168: IF p_change_type = 'RETAINED' THEN
169:

Line 578: InvRetnLineFmt Pa_Retention_Pkg.TabInvRetnLineFormat;

574: InvProcCurrency VARCHAR2(15);
575: InvProcCurrType VARCHAR2(30); --Added for Bug3604143
576: BillTransCurrency VARCHAR2(15);
577:
578: InvRetnLineFmt Pa_Retention_Pkg.TabInvRetnLineFormat;
579:
580: TmpCnt BINARY_INTEGER:=0;
581: UpdateRDL BOOLEAN := FALSE;
582: UpdateERDL BOOLEAN := FALSE;

Line 3764: END pa_retention_pkg;

3760: RAISE;
3761:
3762: END Delete_Unused_Retention_Lines;
3763:
3764: END pa_retention_pkg;