APPS.PA_GL_TIEBACK_PKG dependencies on PA_GL_INTERFACE

Line 29: SELECT gi.RowId Row_Id from Pa_Gl_Interface gi

25: AND exe.executable_name = L_Interface_Process;
26:
27:
28: Cursor Corruption_Labor is
29: SELECT gi.RowId Row_Id from Pa_Gl_Interface gi
30: WHERE Status = 'NEW'
31: AND not exists (Select 0 from gl_Interface_control gc where gc.group_id = gi.group_id)
32: AND user_je_category_name in ( select user_je_category_name
33: from gl_je_Categories where je_category_name='Labor Cost');

Line 36: SELECT gi.RowId Row_Id from Pa_Gl_Interface gi

32: AND user_je_category_name in ( select user_je_category_name
33: from gl_je_Categories where je_category_name='Labor Cost');
34:
35: Cursor Corruption_Usage is
36: SELECT gi.RowId Row_Id from Pa_Gl_Interface gi
37: WHERE Status = 'NEW'
38: AND not exists (Select 0 from gl_Interface_control gc where gc.group_id = gi.group_id)
39: AND user_je_category_name in ( select user_je_category_name
40: from gl_je_Categories where je_category_name

Line 45: SELECT gi.RowId Row_Id from Pa_Gl_Interface gi

41: in ('Budget','Usage Cost'));
42:
43:
44: Cursor Corruption_Burden is
45: SELECT gi.RowId Row_Id from Pa_Gl_Interface gi
46: WHERE Status = 'NEW'
47: AND not exists (Select 0 from gl_Interface_control gc where gc.group_id = gi.group_id)
48: AND user_je_category_name in ( select user_je_category_name
49: from gl_je_Categories where je_category_name='Total Burdened Cost');

Line 53: SELECT gi.RowId Row_Id from Pa_Gl_Interface gi

49: from gl_je_Categories where je_category_name='Total Burdened Cost');
50:
51:
52: Cursor Corruption_Revenue is
53: SELECT gi.RowId Row_Id from Pa_Gl_Interface gi
54: WHERE Status = 'NEW'
55: AND not exists (Select 0 from gl_Interface_control gc where gc.group_id = gi.group_id)
56: AND user_je_category_name in ( select user_je_category_name
57: from gl_je_Categories where je_category_name='Revenue');

Line 62: SELECT gi.RowId Row_Id from Pa_Gl_Interface gi

58:
59:
60:
61: Cursor Corruption_CrossCharge is
62: SELECT gi.RowId Row_Id from Pa_Gl_Interface gi
63: WHERE Status = 'NEW'
64: AND not exists (Select 0 from gl_Interface_control gc where gc.group_id = gi.group_id)
65: AND user_je_category_name in ( select user_je_category_name
66: from gl_je_Categories where je_category_name

Line 103: Update PA_GL_Interface

99:
100: IF P_Module = 'LABOR' Then
101: For Rec In Corruption_labor Loop
102:
103: Update PA_GL_Interface
104: Set Status = 'PREV_GL_INTERFACE_UNSUCCESSFUL'
105: Where RowId = Rec.Row_Id;
106:
107: L_Count := L_Count + Sql%rowcount;

Line 115: Update PA_GL_Interface

111:
112: IF P_Module = 'USAGE' Then
113: For Rec In Corruption_usage Loop
114:
115: Update PA_GL_Interface
116: Set Status = 'PREV_GL_INTERFACE_UNSUCCESSFUL'
117: Where RowId = Rec.Row_Id;
118:
119: L_Count := L_Count + Sql%rowcount;

Line 127: Update PA_GL_Interface

123:
124: IF P_Module = 'BURDEN' Then
125: For Rec In Corruption_burden Loop
126:
127: Update PA_GL_Interface
128: Set Status = 'PREV_GL_INTERFACE_UNSUCCESSFUL'
129: Where RowId = Rec.Row_Id;
130:
131: L_Count := L_Count + Sql%rowcount;

Line 139: Update PA_GL_Interface

135:
136: IF P_Module = 'REVENUE' Then
137: For Rec In Corruption_revenue Loop
138:
139: Update PA_GL_Interface
140: Set Status = 'PREV_GL_INTERFACE_UNSUCCESSFUL'
141: Where RowId = Rec.Row_Id;
142:
143: L_Count := L_Count + Sql%rowcount;

Line 151: Update PA_GL_Interface

147:
148: IF P_Module = 'BORRLENT' Then
149: For Rec In Corruption_CrossCharge Loop
150:
151: Update PA_GL_Interface
152: Set Status = 'PREV_GL_INTERFACE_UNSUCCESSFUL'
153: Where RowId = Rec.Row_Id;
154:
155: L_Count := L_Count + Sql%rowcount;