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_MULTI_CURRENCY_TXN dependencies on PA_PROJECTS_ALL

Line 7: prev_project_id pa_projects_all.project_id%type := NULL

3:
4: /** This is a global Record structure used as a cache for FI calls **/
5:
6: TYPE FI_REC_ATTRB_TYPE IS RECORD (
7: prev_project_id pa_projects_all.project_id%type := NULL
8: ,prev_exp_org_id number := NULL
9: ,prev_ei_date date := null
10: ,prev_attribute varchar2(200) := null
11: ,project_rate_type varchar2(100) := null

Line 101: FROM pa_projects_all proj

97: NVL( proj.projfunc_cost_rate_type,imp_recvr.default_rate_type)) PROJFUNC_COST_RATE_TYPE
98: ,NVL(proj.projfunc_cost_rate_date, DECODE(imp_prvdr.default_rate_date_code,
99: 'E', P_EI_date, 'P'
100: ,pa_utils2.get_pa_date(P_EI_date,sysdate, imp_prvdr.org_id))) PROJFUNC_COST_RATE_DATE
101: FROM pa_projects_all proj
102: ,pa_implementations_all imp_prvdr
103: ,pa_implementations_all imp_recvr /* bug fix :2322364 */
104: WHERE proj.project_id = P_project_id
105: AND imp_prvdr.org_id = P_exp_org_id

Line 229: P_project_id IN pa_projects_all.project_id%TYPE DEFAULT NULL,

225:
226:
227: PROCEDURE get_projfunc_cost_rate_type (
228: P_task_id IN NUMBER ,
229: P_project_id IN pa_projects_all.project_id%TYPE DEFAULT NULL,
230: P_calling_module IN VARCHAR2 ,
231: p_structure_version_id IN NUMBER DEFAULT NULL,
232: P_projfunc_currency_code IN OUT NOCOPY VARCHAR2 ,
233: P_projfunc_cost_rate_type IN OUT NOCOPY VARCHAR2 )

Line 257: FROM pa_projects_all proj,

253: NVL(P_projfunc_cost_rate_type, NVL(NVL(task.taskfunc_cost_rate_type,
254: proj.projfunc_cost_rate_type), imp.default_rate_type))
255: INTO P_projfunc_currency_code,
256: P_projfunc_cost_rate_type
257: FROM pa_projects_all proj,
258: pa_tasks task,
259: pa_implementations_all imp
260: WHERE proj.project_id = task.project_id
261: AND task.task_id = P_task_id

Line 270: FROM pa_projects_all proj,

266: NVL(P_projfunc_cost_rate_type, NVL(NVL(task.taskfunc_cost_rate_type,
267: proj.projfunc_cost_rate_type), imp.default_rate_type))
268: INTO P_projfunc_currency_code,
269: P_projfunc_cost_rate_type
270: FROM pa_projects_all proj,
271: pa_tasks task,
272: pa_map_wp_to_fin_tasks_v map_wp_fin,
273: pa_implementations_all imp
274: WHERE proj.project_id = map_wp_fin.project_id

Line 285: FROM pa_projects_all proj,

281: NVL(P_projfunc_cost_rate_type, NVL(NVL(task.taskfunc_cost_rate_type,
282: proj.projfunc_cost_rate_type), imp.default_rate_type))
283: INTO P_projfunc_currency_code,
284: P_projfunc_cost_rate_type
285: FROM pa_projects_all proj,
286: pa_tasks task,
287: pa_map_wp_to_fin_tasks_v map_wp_fin,
288: pa_implementations_all imp
289: WHERE proj.project_id = p_project_id

Line 302: FROM pa_projects_all proj,

298: NVL(P_projfunc_cost_rate_type, NVL(proj.projfunc_cost_rate_type
299: , imp.default_rate_type))
300: INTO P_projfunc_currency_code,
301: P_projfunc_cost_rate_type
302: FROM pa_projects_all proj,
303: pa_implementations_all imp
304: WHERE proj.project_id = p_project_id
305: AND NVL(proj.org_id, -99) = NVL(imp.org_id, -99);
306: END; -- anonymous

Line 347: FROM pa_projects_all proj,

343: NVL(P_projfunc_cost_rate_type, NVL(NVL(task.taskfunc_cost_rate_type,
344: proj.projfunc_cost_rate_type), imp.default_rate_type))
345: INTO P_projfunc_currency_code,
346: P_projfunc_cost_rate_type
347: FROM pa_projects_all proj,
348: pa_tasks task,
349: pa_implementations_all imp -- bug 8265941 changed to pa_implementations_all
350: WHERE proj.project_id = task.project_id
351: AND task.task_id = P_task_id

Line 372: -- pa_projects_all table based on the project_id which is a

368: l_project_currency_code VARCHAR2(30) ;
369: BEGIN
370: --
371: -- This function returns the Project Currency Code from the
372: -- pa_projects_all table based on the project_id which is a
373: -- parameter for this function
374: -- Since, the Project Currency Code column is a NOT NULL column
375: -- in the pa_projects_all table, we need not handle the no_data_found
376: -- exception nor do we need to go to the Project owning OU to get the

Line 375: -- in the pa_projects_all table, we need not handle the no_data_found

371: -- This function returns the Project Currency Code from the
372: -- pa_projects_all table based on the project_id which is a
373: -- parameter for this function
374: -- Since, the Project Currency Code column is a NOT NULL column
375: -- in the pa_projects_all table, we need not handle the no_data_found
376: -- exception nor do we need to go to the Project owning OU to get the
377: -- currency Code from the Set of Books Id.
378:
379: SELECT project_currency_code

Line 381: FROM pa_projects_all

377: -- currency Code from the Set of Books Id.
378:
379: SELECT project_currency_code
380: INTO l_project_currency_code
381: FROM pa_projects_all
382: WHERE project_id = P_project_id ;
383:
384: RETURN l_project_currency_code ;
385:

Line 393: -- pa_projects_all instead of pa_projects

389:
390: END get_proj_curr_code_sql ;
391:
392: -- fix for bug # 910659. Changed from clause to select from
393: -- pa_projects_all instead of pa_projects
394:
395: PROCEDURE get_projfunc_cost_rate_date (
396: P_task_id IN NUMBER ,
397: P_project_id IN pa_projects_all.project_id%TYPE DEFAULT NULL ,

Line 397: P_project_id IN pa_projects_all.project_id%TYPE DEFAULT NULL ,

393: -- pa_projects_all instead of pa_projects
394:
395: PROCEDURE get_projfunc_cost_rate_date (
396: P_task_id IN NUMBER ,
397: P_project_id IN pa_projects_all.project_id%TYPE DEFAULT NULL ,
398: P_EI_date IN DATE ,
399: p_structure_version_id IN NUMBER DEFAULT NULL,
400: P_calling_module IN VARCHAR2 ,
401: P_projfunc_cost_rate_date IN OUT NOCOPY DATE )

Line 431: FROM pa_projects_all proj,

427: 'E', P_EI_date, 'P',
428: pa_utils2.get_pa_date(P_EI_date,
429: sysdate, imp.org_id))) /**CBGA**/
430: INTO P_projfunc_cost_rate_date
431: FROM pa_projects_all proj,
432: pa_tasks task,
433: pa_implementations_all imp -- bug 8265941 changed to pa_implementations_all
434: WHERE task.task_id = P_task_id
435: AND proj.project_id = task.project_id

Line 457: FROM pa_projects_all proj

453: 'E', P_EI_date, 'P',
454: pa_utils2.get_pa_date(P_EI_date,
455: sysdate, imp.org_id)))
456: INTO P_projfunc_cost_rate_date
457: FROM pa_projects_all proj
458: ,pa_implementations_all imp -- bug 8265941 changed to pa_implementations_all
459: WHERE proj.project_id = p_project_id
460: AND NVL(proj.org_id,-99) = NVL(imp.org_id,-99); -- bug 7579126
461: END IF;

Line 479: P_project_id IN pa_projects_all.project_id%TYPE DEFAULT NULL,

475:
476:
477: PROCEDURE get_def_projfunc_cst_rate_date (
478: P_task_id IN NUMBER ,
479: P_project_id IN pa_projects_all.project_id%TYPE DEFAULT NULL,
480: P_EI_date IN DATE ,
481: P_structure_version_id IN NUMBER DEFAULT NULL,
482: P_calling_module IN VARCHAR2 ,
483: P_projfunc_cost_rate_date IN OUT NOCOPY DATE )

Line 511: FROM pa_projects_all proj,

507: DECODE(imp.default_rate_date_code,
508: 'E', P_EI_date, 'P',
509: NULL))
510: INTO P_projfunc_cost_rate_date
511: FROM pa_projects_all proj,
512: pa_tasks task,
513: pa_implementations_all imp -- bug 8265941 changed to pa_implementations_all
514: WHERE task.task_id = P_task_id
515: AND proj.project_id = task.project_id

Line 525: FROM pa_projects_all proj,

521: DECODE(imp.default_rate_date_code,
522: 'E', P_EI_date, 'P',
523: NULL))
524: INTO P_projfunc_cost_rate_date
525: FROM pa_projects_all proj,
526: pa_tasks task,
527: pa_map_wp_to_fin_tasks_v map_wp_fin,
528: pa_implementations imp
529: WHERE proj.project_id = map_wp_fin.project_id

Line 553: FROM pa_projects_all proj

549: SELECT NVL(proj.projfunc_cost_rate_date,
550: DECODE(imp.default_rate_date_code,
551: 'E', P_EI_date, 'P', NULL))
552: INTO P_projfunc_cost_rate_date
553: FROM pa_projects_all proj
554: ,pa_implementations_all imp -- bug 8265941 changed to pa_implementations_all
555: WHERE proj.project_id = p_project_id
556: AND NVL(proj.org_id,-99) = NVL(imp.org_id,-99); -- bug 7579126
557: END IF;

Line 2134: ,p_project_id IN pa_projects_all.project_id%TYPE DEFAULT NULL

2130: END Perform_MC_and_IC_processing;
2131:
2132: /*---------------------------------------------------------------------*/
2133: PROCEDURE get_proj_rate_type ( P_task_id IN NUMBER
2134: ,p_project_id IN pa_projects_all.project_id%TYPE DEFAULT NULL
2135: ,p_structure_version_id IN NUMBER DEFAULT NULL
2136: ,p_calling_module IN VARCHAR2
2137: ,P_project_currency_code IN OUT NOCOPY VARCHAR2
2138: ,P_project_rate_type IN OUT NOCOPY VARCHAR2

Line 2163: FROM pa_projects_all proj,

2159: NVL(P_project_rate_type, NVL(NVL(task.project_rate_type,
2160: proj.project_rate_type), imp.default_rate_type))
2161: INTO P_project_currency_code,
2162: P_project_rate_type
2163: FROM pa_projects_all proj,
2164: pa_tasks task,
2165: pa_implementations_all imp
2166: WHERE proj.project_id = task.project_id
2167: AND task.task_id = P_task_id

Line 2179: FROM pa_projects_all proj,

2175: NVL(P_project_rate_type, NVL(NVL(task.project_rate_type,
2176: proj.project_rate_type), imp.default_rate_type))
2177: INTO P_project_currency_code,
2178: P_project_rate_type
2179: FROM pa_projects_all proj,
2180: pa_tasks task,
2181: pa_map_wp_to_fin_tasks_v map_wp_fin,
2182: pa_implementations_all imp
2183: WHERE proj.project_id = p_project_id

Line 2196: FROM pa_projects_all proj,

2192: NVL(NVL(P_project_rate_type, proj.project_rate_type)
2193: , imp.default_rate_type)
2194: INTO P_project_currency_code,
2195: P_project_rate_type
2196: FROM pa_projects_all proj,
2197: pa_implementations_all imp
2198: WHERE proj.project_id = p_project_id
2199: AND proj.org_id = imp.org_id;
2200: END ; -- anonymous

Line 2217: P_project_id IN pa_projects_all.project_id%TYPE DEFAULT NULL ,

2213: END get_proj_rate_type ;
2214:
2215: /*---------------------------------------------------------------------*/
2216: PROCEDURE get_proj_rate_date ( P_task_id IN NUMBER ,
2217: P_project_id IN pa_projects_all.project_id%TYPE DEFAULT NULL ,
2218: P_EI_date IN DATE ,
2219: p_structure_version_id IN NUMBER DEFAULT NULL,
2220: p_calling_module IN VARCHAR2,
2221: P_project_rate_date IN OUT NOCOPY DATE )

Line 2250: FROM pa_projects_all proj,

2246: 'E', P_EI_date, 'P',
2247: pa_utils2.get_pa_date(P_EI_date,
2248: sysdate, imp.org_id))) /**CBGA**/
2249: INTO P_project_rate_date
2250: FROM pa_projects_all proj,
2251: pa_tasks task,
2252: pa_implementations_all imp
2253: WHERE task.task_id = P_task_id
2254: AND proj.project_id = task.project_id

Line 2277: FROM pa_projects_all proj

2273: 'E', P_EI_date, 'P',
2274: pa_utils2.get_pa_date(P_EI_date,
2275: sysdate, imp.org_id)))
2276: INTO P_project_rate_date
2277: FROM pa_projects_all proj
2278: ,pa_implementations_all imp
2279: WHERE proj.project_id = p_project_id
2280: AND nvl(proj.org_id, -99) = nvl(imp.org_id, -99);
2281: END IF;

Line 2298: * p_project_id IN pa_projects_all.project_id%type

2294: END get_proj_rate_date ;
2295:
2296:
2297: /** The following new parameters are added for the FI changes
2298: * p_project_id IN pa_projects_all.project_id%type
2299: * p_exp_org_id IN pa_projects_all.org_id%type
2300: **/
2301: PROCEDURE get_currency_attributes
2302: (P_project_id IN pa_projects_all.project_id%type default NULL,

Line 2299: * p_exp_org_id IN pa_projects_all.org_id%type

2295:
2296:
2297: /** The following new parameters are added for the FI changes
2298: * p_project_id IN pa_projects_all.project_id%type
2299: * p_exp_org_id IN pa_projects_all.org_id%type
2300: **/
2301: PROCEDURE get_currency_attributes
2302: (P_project_id IN pa_projects_all.project_id%type default NULL,
2303: P_exp_org_id IN pa_projects_all.org_id%type default NULL,

Line 2302: (P_project_id IN pa_projects_all.project_id%type default NULL,

2298: * p_project_id IN pa_projects_all.project_id%type
2299: * p_exp_org_id IN pa_projects_all.org_id%type
2300: **/
2301: PROCEDURE get_currency_attributes
2302: (P_project_id IN pa_projects_all.project_id%type default NULL,
2303: P_exp_org_id IN pa_projects_all.org_id%type default NULL,
2304: P_task_id IN pa_expenditure_items_all.task_id%TYPE,
2305: P_ei_date IN pa_expenditure_items_all.expenditure_item_date%TYPE,
2306: P_calling_module IN VARCHAR2,

Line 2303: P_exp_org_id IN pa_projects_all.org_id%type default NULL,

2299: * p_exp_org_id IN pa_projects_all.org_id%type
2300: **/
2301: PROCEDURE get_currency_attributes
2302: (P_project_id IN pa_projects_all.project_id%type default NULL,
2303: P_exp_org_id IN pa_projects_all.org_id%type default NULL,
2304: P_task_id IN pa_expenditure_items_all.task_id%TYPE,
2305: P_ei_date IN pa_expenditure_items_all.expenditure_item_date%TYPE,
2306: P_calling_module IN VARCHAR2,
2307: P_denom_curr_code IN pa_expenditure_items_all.denom_currency_code%TYPE,

Line 2355: ,P_project_id IN pa_projects_all.project_id%TYPE DEFAULT NULL

2351: --Forward bodies
2352:
2353: ----------------------------------------------------------------------
2354: Procedure derive_project_attributes( P_task_id IN pa_expenditure_items_all.task_id%TYPE
2355: ,P_project_id IN pa_projects_all.project_id%TYPE DEFAULT NULL
2356: ,P_ei_date IN pa_expenditure_items_all.expenditure_item_date%TYPE
2357: ,P_structure_version_id IN NUMBER DEFAULT NULL
2358: ,P_calling_module IN VARCHAR2
2359: ,x_project_rate_type IN OUT NOCOPY pa_expenditure_items_all.project_rate_type%TYPE

Line 2444: ,P_project_id IN pa_projects_all.project_id%TYPE

2440: procedure derive_projfunc_attributes
2441: ( P_calling_module IN VARCHAR2
2442: ,P_ei_date IN pa_expenditure_items_all.expenditure_item_date%TYPE
2443: ,P_task_id IN pa_expenditure_items_all.task_id%TYPE
2444: ,P_project_id IN pa_projects_all.project_id%TYPE
2445: ,P_attribute IN VARCHAR2
2446: ,P_structure_version_id IN NUMBER DEFAULT NULL
2447: ,x_projfunc_cost_rate_type IN OUT NOCOPY pa_expenditure_items_all.projfunc_cost_rate_type%TYPE
2448: ,x_projfunc_cost_rate_date IN OUT NOCOPY pa_expenditure_items_all.projfunc_cost_rate_date%TYPE