eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PA_TRX_IMPORT dependencies on PA_COST_DISTRIBUTION_LINES_ALL

Line 140: G_PaDate pa_cost_distribution_lines_all.pa_date%TYPE;

136: current_etype_classcode VARCHAR2(100) DEFAULT NULL;
137:
138: -- Oct 2001 Enhanced Period Processing
139: -- Start EPP Changes
140: G_PaDate pa_cost_distribution_lines_all.pa_date%TYPE;
141: G_PaPeriodName pa_cost_distribution_lines_all.pa_period_name%TYPE;
142: G_RecvrPaDate pa_cost_distribution_lines_all.recvr_pa_date%TYPE;
143: G_RecvrPaPeriodName pa_cost_distribution_lines_all.recvr_pa_period_name%TYPE;
144: G_GlPeriodName pa_cost_distribution_lines_all.gl_period_name%TYPE;

Line 141: G_PaPeriodName pa_cost_distribution_lines_all.pa_period_name%TYPE;

137:
138: -- Oct 2001 Enhanced Period Processing
139: -- Start EPP Changes
140: G_PaDate pa_cost_distribution_lines_all.pa_date%TYPE;
141: G_PaPeriodName pa_cost_distribution_lines_all.pa_period_name%TYPE;
142: G_RecvrPaDate pa_cost_distribution_lines_all.recvr_pa_date%TYPE;
143: G_RecvrPaPeriodName pa_cost_distribution_lines_all.recvr_pa_period_name%TYPE;
144: G_GlPeriodName pa_cost_distribution_lines_all.gl_period_name%TYPE;
145: G_RecvrGlDate pa_cost_distribution_lines_all.recvr_gl_date%TYPE;

Line 142: G_RecvrPaDate pa_cost_distribution_lines_all.recvr_pa_date%TYPE;

138: -- Oct 2001 Enhanced Period Processing
139: -- Start EPP Changes
140: G_PaDate pa_cost_distribution_lines_all.pa_date%TYPE;
141: G_PaPeriodName pa_cost_distribution_lines_all.pa_period_name%TYPE;
142: G_RecvrPaDate pa_cost_distribution_lines_all.recvr_pa_date%TYPE;
143: G_RecvrPaPeriodName pa_cost_distribution_lines_all.recvr_pa_period_name%TYPE;
144: G_GlPeriodName pa_cost_distribution_lines_all.gl_period_name%TYPE;
145: G_RecvrGlDate pa_cost_distribution_lines_all.recvr_gl_date%TYPE;
146: G_RecvrGlPeriodName pa_cost_distribution_lines_all.recvr_gl_period_name%TYPE;

Line 143: G_RecvrPaPeriodName pa_cost_distribution_lines_all.recvr_pa_period_name%TYPE;

139: -- Start EPP Changes
140: G_PaDate pa_cost_distribution_lines_all.pa_date%TYPE;
141: G_PaPeriodName pa_cost_distribution_lines_all.pa_period_name%TYPE;
142: G_RecvrPaDate pa_cost_distribution_lines_all.recvr_pa_date%TYPE;
143: G_RecvrPaPeriodName pa_cost_distribution_lines_all.recvr_pa_period_name%TYPE;
144: G_GlPeriodName pa_cost_distribution_lines_all.gl_period_name%TYPE;
145: G_RecvrGlDate pa_cost_distribution_lines_all.recvr_gl_date%TYPE;
146: G_RecvrGlPeriodName pa_cost_distribution_lines_all.recvr_gl_period_name%TYPE;
147: G_SobId pa_implementations_all.set_of_books_id%TYPE;

Line 144: G_GlPeriodName pa_cost_distribution_lines_all.gl_period_name%TYPE;

140: G_PaDate pa_cost_distribution_lines_all.pa_date%TYPE;
141: G_PaPeriodName pa_cost_distribution_lines_all.pa_period_name%TYPE;
142: G_RecvrPaDate pa_cost_distribution_lines_all.recvr_pa_date%TYPE;
143: G_RecvrPaPeriodName pa_cost_distribution_lines_all.recvr_pa_period_name%TYPE;
144: G_GlPeriodName pa_cost_distribution_lines_all.gl_period_name%TYPE;
145: G_RecvrGlDate pa_cost_distribution_lines_all.recvr_gl_date%TYPE;
146: G_RecvrGlPeriodName pa_cost_distribution_lines_all.recvr_gl_period_name%TYPE;
147: G_SobId pa_implementations_all.set_of_books_id%TYPE;
148: G_RecvrSobId pa_implementations_all.set_of_books_id%TYPE;

Line 145: G_RecvrGlDate pa_cost_distribution_lines_all.recvr_gl_date%TYPE;

141: G_PaPeriodName pa_cost_distribution_lines_all.pa_period_name%TYPE;
142: G_RecvrPaDate pa_cost_distribution_lines_all.recvr_pa_date%TYPE;
143: G_RecvrPaPeriodName pa_cost_distribution_lines_all.recvr_pa_period_name%TYPE;
144: G_GlPeriodName pa_cost_distribution_lines_all.gl_period_name%TYPE;
145: G_RecvrGlDate pa_cost_distribution_lines_all.recvr_gl_date%TYPE;
146: G_RecvrGlPeriodName pa_cost_distribution_lines_all.recvr_gl_period_name%TYPE;
147: G_SobId pa_implementations_all.set_of_books_id%TYPE;
148: G_RecvrSobId pa_implementations_all.set_of_books_id%TYPE;
149: -- G_FSIO_ENABLED varchar2(1); --FSIO Changes

Line 146: G_RecvrGlPeriodName pa_cost_distribution_lines_all.recvr_gl_period_name%TYPE;

142: G_RecvrPaDate pa_cost_distribution_lines_all.recvr_pa_date%TYPE;
143: G_RecvrPaPeriodName pa_cost_distribution_lines_all.recvr_pa_period_name%TYPE;
144: G_GlPeriodName pa_cost_distribution_lines_all.gl_period_name%TYPE;
145: G_RecvrGlDate pa_cost_distribution_lines_all.recvr_gl_date%TYPE;
146: G_RecvrGlPeriodName pa_cost_distribution_lines_all.recvr_gl_period_name%TYPE;
147: G_SobId pa_implementations_all.set_of_books_id%TYPE;
148: G_RecvrSobId pa_implementations_all.set_of_books_id%TYPE;
149: -- G_FSIO_ENABLED varchar2(1); --FSIO Changes
150:

Line 170: G_RevPaDate pa_cost_distribution_lines_all.pa_date%TYPE;

166: G_AccDate DATE;
167: G_RecvrAccDate DATE;
168: G_RevAccDate DATE;
169: G_RevRecvrAccDate DATE;
170: G_RevPaDate pa_cost_distribution_lines_all.pa_date%TYPE;
171: G_RevPaPeriodName pa_cost_distribution_lines_all.pa_period_name%TYPE;
172: G_RevGlDate pa_cost_distribution_lines_all.gl_date%TYPE;
173: G_RevGlPeriodName pa_cost_distribution_lines_all.gl_period_name%TYPE;
174: G_RevRecvrPaDate pa_cost_distribution_lines_all.recvr_pa_date%TYPE;

Line 171: G_RevPaPeriodName pa_cost_distribution_lines_all.pa_period_name%TYPE;

167: G_RecvrAccDate DATE;
168: G_RevAccDate DATE;
169: G_RevRecvrAccDate DATE;
170: G_RevPaDate pa_cost_distribution_lines_all.pa_date%TYPE;
171: G_RevPaPeriodName pa_cost_distribution_lines_all.pa_period_name%TYPE;
172: G_RevGlDate pa_cost_distribution_lines_all.gl_date%TYPE;
173: G_RevGlPeriodName pa_cost_distribution_lines_all.gl_period_name%TYPE;
174: G_RevRecvrPaDate pa_cost_distribution_lines_all.recvr_pa_date%TYPE;
175: G_RevRecvrPaPdName pa_cost_distribution_lines_all.recvr_pa_period_name%TYPE;

Line 172: G_RevGlDate pa_cost_distribution_lines_all.gl_date%TYPE;

168: G_RevAccDate DATE;
169: G_RevRecvrAccDate DATE;
170: G_RevPaDate pa_cost_distribution_lines_all.pa_date%TYPE;
171: G_RevPaPeriodName pa_cost_distribution_lines_all.pa_period_name%TYPE;
172: G_RevGlDate pa_cost_distribution_lines_all.gl_date%TYPE;
173: G_RevGlPeriodName pa_cost_distribution_lines_all.gl_period_name%TYPE;
174: G_RevRecvrPaDate pa_cost_distribution_lines_all.recvr_pa_date%TYPE;
175: G_RevRecvrPaPdName pa_cost_distribution_lines_all.recvr_pa_period_name%TYPE;
176: G_RevRecvrGlDate pa_cost_distribution_lines_all.recvr_gl_date%TYPE;

Line 173: G_RevGlPeriodName pa_cost_distribution_lines_all.gl_period_name%TYPE;

169: G_RevRecvrAccDate DATE;
170: G_RevPaDate pa_cost_distribution_lines_all.pa_date%TYPE;
171: G_RevPaPeriodName pa_cost_distribution_lines_all.pa_period_name%TYPE;
172: G_RevGlDate pa_cost_distribution_lines_all.gl_date%TYPE;
173: G_RevGlPeriodName pa_cost_distribution_lines_all.gl_period_name%TYPE;
174: G_RevRecvrPaDate pa_cost_distribution_lines_all.recvr_pa_date%TYPE;
175: G_RevRecvrPaPdName pa_cost_distribution_lines_all.recvr_pa_period_name%TYPE;
176: G_RevRecvrGlDate pa_cost_distribution_lines_all.recvr_gl_date%TYPE;
177: G_RevRecvrGlPdName pa_cost_distribution_lines_all.recvr_gl_period_name%TYPE;

Line 174: G_RevRecvrPaDate pa_cost_distribution_lines_all.recvr_pa_date%TYPE;

170: G_RevPaDate pa_cost_distribution_lines_all.pa_date%TYPE;
171: G_RevPaPeriodName pa_cost_distribution_lines_all.pa_period_name%TYPE;
172: G_RevGlDate pa_cost_distribution_lines_all.gl_date%TYPE;
173: G_RevGlPeriodName pa_cost_distribution_lines_all.gl_period_name%TYPE;
174: G_RevRecvrPaDate pa_cost_distribution_lines_all.recvr_pa_date%TYPE;
175: G_RevRecvrPaPdName pa_cost_distribution_lines_all.recvr_pa_period_name%TYPE;
176: G_RevRecvrGlDate pa_cost_distribution_lines_all.recvr_gl_date%TYPE;
177: G_RevRecvrGlPdName pa_cost_distribution_lines_all.recvr_gl_period_name%TYPE;
178: --End PA-J Period-End Accrual Changes

Line 175: G_RevRecvrPaPdName pa_cost_distribution_lines_all.recvr_pa_period_name%TYPE;

171: G_RevPaPeriodName pa_cost_distribution_lines_all.pa_period_name%TYPE;
172: G_RevGlDate pa_cost_distribution_lines_all.gl_date%TYPE;
173: G_RevGlPeriodName pa_cost_distribution_lines_all.gl_period_name%TYPE;
174: G_RevRecvrPaDate pa_cost_distribution_lines_all.recvr_pa_date%TYPE;
175: G_RevRecvrPaPdName pa_cost_distribution_lines_all.recvr_pa_period_name%TYPE;
176: G_RevRecvrGlDate pa_cost_distribution_lines_all.recvr_gl_date%TYPE;
177: G_RevRecvrGlPdName pa_cost_distribution_lines_all.recvr_gl_period_name%TYPE;
178: --End PA-J Period-End Accrual Changes
179:

Line 176: G_RevRecvrGlDate pa_cost_distribution_lines_all.recvr_gl_date%TYPE;

172: G_RevGlDate pa_cost_distribution_lines_all.gl_date%TYPE;
173: G_RevGlPeriodName pa_cost_distribution_lines_all.gl_period_name%TYPE;
174: G_RevRecvrPaDate pa_cost_distribution_lines_all.recvr_pa_date%TYPE;
175: G_RevRecvrPaPdName pa_cost_distribution_lines_all.recvr_pa_period_name%TYPE;
176: G_RevRecvrGlDate pa_cost_distribution_lines_all.recvr_gl_date%TYPE;
177: G_RevRecvrGlPdName pa_cost_distribution_lines_all.recvr_gl_period_name%TYPE;
178: --End PA-J Period-End Accrual Changes
179:
180: --Start PA-K Changes

Line 177: G_RevRecvrGlPdName pa_cost_distribution_lines_all.recvr_gl_period_name%TYPE;

173: G_RevGlPeriodName pa_cost_distribution_lines_all.gl_period_name%TYPE;
174: G_RevRecvrPaDate pa_cost_distribution_lines_all.recvr_pa_date%TYPE;
175: G_RevRecvrPaPdName pa_cost_distribution_lines_all.recvr_pa_period_name%TYPE;
176: G_RevRecvrGlDate pa_cost_distribution_lines_all.recvr_gl_date%TYPE;
177: G_RevRecvrGlPdName pa_cost_distribution_lines_all.recvr_gl_period_name%TYPE;
178: --End PA-J Period-End Accrual Changes
179:
180: --Start PA-K Changes
181: G_Process_Funds_Flag VARCHAR2(1);

Line 9861: update pa_cost_distribution_lines_all cdl

9857:
9858: IF l_ExpItemId_temp_Tab.COUNT > 0 THEN
9859:
9860: FORALL j in l_ExpItemId_temp_Tab.first..l_ExpItemId_temp_Tab.last
9861: update pa_cost_distribution_lines_all cdl
9862: set cdl.Budget_CCID = l_budget_ccid ,
9863: cdl.encumbrance_type_id = pa_funds_control_utils.get_encum_type_id(cdl.project_id,'STD'),
9864: cdl.budget_line_id = DECODE(cdl.budget_line_id,NULL,l_budget_line_id,cdl.budget_line_id),
9865: cdl.budget_version_id = DECODE(cdl.budget_version_id,NULL,l_budget_version_id,cdl.budget_version_id)

Line 9956: update pa_cost_distribution_lines_all cdl

9952:
9953: IF l_ExpItemId_temp_Tab.COUNT > 0 THEN
9954:
9955: FORALL j in l_ExpItemId_temp_Tab.first..l_ExpItemId_temp_Tab.last
9956: update pa_cost_distribution_lines_all cdl
9957: set cdl.Budget_CCID = l_budget_ccid ,
9958: -- R12 Funds Management Uptake : Modified and added below columns logic
9959: cdl.encumbrance_type_id = pa_funds_control_utils.get_encum_type_id(cdl.project_id,'STD'),
9960: cdl.budget_line_id = DECODE(cdl.budget_line_id,NULL,l_budget_line_id,cdl.budget_line_id),

Line 10055: update pa_cost_distribution_lines_all cdl

10051: and ei.document_payment_id = to_number(l_sys_ref4);
10052:
10053: IF l_ExpItemId_temp_Tab.COUNT > 0 THEN
10054: FORALL j in l_ExpItemId_temp_Tab.first..l_ExpItemId_temp_Tab.last
10055: update pa_cost_distribution_lines_all cdl
10056: set cdl.Budget_CCID = l_budget_ccid ,
10057: cdl.encumbrance_type_id = pa_funds_control_utils.get_encum_type_id(cdl.project_id,'STD'),
10058: -- R12 Funds Management Uptake
10059: cdl.budget_line_id = DECODE(cdl.budget_line_id,NULL,l_budget_line_id,cdl.budget_line_id),