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

Line 9: current_project_id pa_projects_all.project_id%type;

5: l_tbl_eiid typ_tbl_eiid;
6: l_tbl_cdlln typ_tbl_cdlln;
7: --End Of Mods(EOM) Bug # 5743708
8:
9: current_project_id pa_projects_all.project_id%type;
10: -- Project id of the project being processed.
11: current_run_id pa_cost_distribution_lines_all.burden_sum_source_run_id%TYPE; /*Bug# 2255068*/
12: -- Run id of the batch being processed.
13: -- 3699045

Line 62: PROCEDURE create_burden_expenditure_item (p_start_project_number in pa_projects_all.segment1%TYPE,/2255068/

58: return current_run_id;
59: END get_current_run_id;
60: /*End of changes for bug# 2255068*/
61:
62: PROCEDURE create_burden_expenditure_item (p_start_project_number in pa_projects_all.segment1%TYPE,/*2255068*/
63: p_end_project_number in pa_projects_all.segment1%TYPE,/*2255068*/
64: x_request_id in number, /*2255068*/
65: x_end_date in varchar2,
66: status in out NOCOPY number,

Line 63: p_end_project_number in pa_projects_all.segment1%TYPE,/2255068/

59: END get_current_run_id;
60: /*End of changes for bug# 2255068*/
61:
62: PROCEDURE create_burden_expenditure_item (p_start_project_number in pa_projects_all.segment1%TYPE,/*2255068*/
63: p_end_project_number in pa_projects_all.segment1%TYPE,/*2255068*/
64: x_request_id in number, /*2255068*/
65: x_end_date in varchar2,
66: status in out NOCOPY number,
67: stage in out NOCOPY number,

Line 92: over_project_id pa_projects_all.project_id%type;

88: x_exp_id pa_expenditures_all.expenditure_id%type;
89: exp_item_id pa_expenditure_items_all.expenditure_item_id%type;
90: exp_org_id pa_expenditure_items_all.organization_id%type;
91: -- expenditure organization/override organization
92: over_project_id pa_projects_all.project_id%type;
93: -- project id of the source cdl or the project type level override
94: over_task_id pa_tasks.task_id%type;
95: -- task id of the source cdl or the project type level override
96: prev_bcc_rec pa_cdl_burden_summary_v%rowtype;

Line 98: l_attribute1 pa_projects_all.attribute1%type;

94: over_task_id pa_tasks.task_id%type;
95: -- task id of the source cdl or the project type level override
96: prev_bcc_rec pa_cdl_burden_summary_v%rowtype;
97: -- Record to hold previous record from bcc_cur Cursor
98: l_attribute1 pa_projects_all.attribute1%type;
99: -- local variable to hold attribute1 from project for locking
100: l_burden_cost pa_expenditure_items_all.burden_cost%type;
101: -- Running total of burden cost (project functional currency)for an summarization group
102: /*

Line 207: project_id pa_projects_all.project_id%TYPE,

203:
204: /* S.N. Bug 3618193 Added Record Type to fetch different cursors */
205:
206: TYPE proj_rec_type IS RECORD (
207: project_id pa_projects_all.project_id%TYPE,
208: segment1 pa_projects_all.segment1%TYPE,
209: org_id pa_projects_all.org_id%TYPE,
210: burden_account_flag pa_project_types.burden_account_flag%TYPE,
211: dest_project_id pa_projects_all.project_id%TYPE,

Line 208: segment1 pa_projects_all.segment1%TYPE,

204: /* S.N. Bug 3618193 Added Record Type to fetch different cursors */
205:
206: TYPE proj_rec_type IS RECORD (
207: project_id pa_projects_all.project_id%TYPE,
208: segment1 pa_projects_all.segment1%TYPE,
209: org_id pa_projects_all.org_id%TYPE,
210: burden_account_flag pa_project_types.burden_account_flag%TYPE,
211: dest_project_id pa_projects_all.project_id%TYPE,
212: dest_task_id pa_tasks.task_id%TYPE,

Line 209: org_id pa_projects_all.org_id%TYPE,

205:
206: TYPE proj_rec_type IS RECORD (
207: project_id pa_projects_all.project_id%TYPE,
208: segment1 pa_projects_all.segment1%TYPE,
209: org_id pa_projects_all.org_id%TYPE,
210: burden_account_flag pa_project_types.burden_account_flag%TYPE,
211: dest_project_id pa_projects_all.project_id%TYPE,
212: dest_task_id pa_tasks.task_id%TYPE,
213: burden_amt_display_method pa_project_types.burden_amt_display_method%TYPE

Line 211: dest_project_id pa_projects_all.project_id%TYPE,

207: project_id pa_projects_all.project_id%TYPE,
208: segment1 pa_projects_all.segment1%TYPE,
209: org_id pa_projects_all.org_id%TYPE,
210: burden_account_flag pa_project_types.burden_account_flag%TYPE,
211: dest_project_id pa_projects_all.project_id%TYPE,
212: dest_task_id pa_tasks.task_id%TYPE,
213: burden_amt_display_method pa_project_types.burden_amt_display_method%TYPE
214: );
215:

Line 221: TYPE Typ_project_id IS TABLE OF pa_projects_all.project_id%TYPE INDEX BY BINARY_INTEGER;

217:
218:
219: /* SOM Bug# 5743708 */
220:
221: TYPE Typ_project_id IS TABLE OF pa_projects_all.project_id%TYPE INDEX BY BINARY_INTEGER;
222: TYPE Typ_segment1 IS TABLE OF pa_projects_all.segment1%TYPE INDEX BY BINARY_INTEGER;
223: TYPE Typ_org_id IS TABLE OF pa_projects_all.org_id%TYPE INDEX BY BINARY_INTEGER;
224: TYPE Typ_burden_account_flag IS TABLE OF pa_project_types.burden_account_flag%TYPE INDEX BY BINARY_INTEGER;
225: TYPE Typ_dest_project_id IS TABLE OF pa_projects_all.project_id%TYPE INDEX BY BINARY_INTEGER;

Line 222: TYPE Typ_segment1 IS TABLE OF pa_projects_all.segment1%TYPE INDEX BY BINARY_INTEGER;

218:
219: /* SOM Bug# 5743708 */
220:
221: TYPE Typ_project_id IS TABLE OF pa_projects_all.project_id%TYPE INDEX BY BINARY_INTEGER;
222: TYPE Typ_segment1 IS TABLE OF pa_projects_all.segment1%TYPE INDEX BY BINARY_INTEGER;
223: TYPE Typ_org_id IS TABLE OF pa_projects_all.org_id%TYPE INDEX BY BINARY_INTEGER;
224: TYPE Typ_burden_account_flag IS TABLE OF pa_project_types.burden_account_flag%TYPE INDEX BY BINARY_INTEGER;
225: TYPE Typ_dest_project_id IS TABLE OF pa_projects_all.project_id%TYPE INDEX BY BINARY_INTEGER;
226: TYPE Typ_dest_task_id IS TABLE OF pa_tasks.task_id%TYPE INDEX BY BINARY_INTEGER;

Line 223: TYPE Typ_org_id IS TABLE OF pa_projects_all.org_id%TYPE INDEX BY BINARY_INTEGER;

219: /* SOM Bug# 5743708 */
220:
221: TYPE Typ_project_id IS TABLE OF pa_projects_all.project_id%TYPE INDEX BY BINARY_INTEGER;
222: TYPE Typ_segment1 IS TABLE OF pa_projects_all.segment1%TYPE INDEX BY BINARY_INTEGER;
223: TYPE Typ_org_id IS TABLE OF pa_projects_all.org_id%TYPE INDEX BY BINARY_INTEGER;
224: TYPE Typ_burden_account_flag IS TABLE OF pa_project_types.burden_account_flag%TYPE INDEX BY BINARY_INTEGER;
225: TYPE Typ_dest_project_id IS TABLE OF pa_projects_all.project_id%TYPE INDEX BY BINARY_INTEGER;
226: TYPE Typ_dest_task_id IS TABLE OF pa_tasks.task_id%TYPE INDEX BY BINARY_INTEGER;
227: TYPE Typ_burden_amt_display_method IS TABLE OF pa_project_types.burden_amt_display_method%TYPE INDEX BY BINARY_INTEGER;

Line 225: TYPE Typ_dest_project_id IS TABLE OF pa_projects_all.project_id%TYPE INDEX BY BINARY_INTEGER;

221: TYPE Typ_project_id IS TABLE OF pa_projects_all.project_id%TYPE INDEX BY BINARY_INTEGER;
222: TYPE Typ_segment1 IS TABLE OF pa_projects_all.segment1%TYPE INDEX BY BINARY_INTEGER;
223: TYPE Typ_org_id IS TABLE OF pa_projects_all.org_id%TYPE INDEX BY BINARY_INTEGER;
224: TYPE Typ_burden_account_flag IS TABLE OF pa_project_types.burden_account_flag%TYPE INDEX BY BINARY_INTEGER;
225: TYPE Typ_dest_project_id IS TABLE OF pa_projects_all.project_id%TYPE INDEX BY BINARY_INTEGER;
226: TYPE Typ_dest_task_id IS TABLE OF pa_tasks.task_id%TYPE INDEX BY BINARY_INTEGER;
227: TYPE Typ_burden_amt_display_method IS TABLE OF pa_project_types.burden_amt_display_method%TYPE INDEX BY BINARY_INTEGER;
228:
229: l_tbl_project_id Typ_project_id;

Line 256: from pa_projects_all p, -- pa_projects_all changed to pa_projects for Bug# 5743708 /pa_projects is changed to pa_projects_all for the bug 6610145/

252: , upper(nvl(pt.burden_account_flag,'N')) burden_account_flag
253: , pt.burden_sum_dest_project_id dest_project_id
254: , pt.burden_sum_dest_task_id dest_task_id
255: , upper(pt.burden_amt_display_method) burden_amt_display_method
256: from pa_projects_all p, -- pa_projects_all changed to pa_projects for Bug# 5743708 /*pa_projects is changed to pa_projects_all for the bug 6610145*/
257: pa_project_types_all pt -- pa_project_types_all changed to pa_project_types for Bug# 5743708 /*pa_project_types is changed to pa_project_types_all for the bug 6610145*/
258: where pt.project_type = p.project_type
259: and p.segment1 between p_start_project_number and p_end_project_number /*2255068*/
260: and ( pt.burden_amt_display_method in ('D','d') or

Line 305: from pa_projects_all p, -- Bug # 5743708 changing pa_projects_all to pa_projects /changed pa_projects to pa_projects_all for the bug 6610145 /

301: , upper(nvl(pt.burden_account_flag,'N')) burden_account_flag
302: , pt.burden_sum_dest_project_id dest_project_id
303: , pt.burden_sum_dest_task_id dest_task_id
304: , upper(pt.burden_amt_display_method) burden_amt_display_method
305: from pa_projects_all p, -- Bug # 5743708 changing pa_projects_all to pa_projects /*changed pa_projects to pa_projects_all for the bug 6610145 */
306: pa_project_types_all pt -- Bug # 5743708 changing pa_project_typees_all to pa_project_types /*changed pa_project_types to pa_project_types_all for the bug 6610145 */
307: where pt.project_type = p.project_type
308: and p.segment1 between p_start_project_number and p_end_project_number /*2255068*/
309: and ( pt.burden_amt_display_method in ('D','d') or

Line 777: from pa_projects_all

773: pa_cc_utils.log_message('create_burden_expenditure_item: ' || '600:Lock the current Project');
774: END IF;
775: select attribute1
776: into l_attribute1
777: from pa_projects_all
778: where project_id = proj_rec.project_id
779: for update of attribute1 nowait;
780: exception /*2255068*/
781: when resource_busy then

Line 2617: l_attribute1 pa_projects_all.attribute1%type;

2613: init_cmt_run_id number := -9999;
2614: message_string varchar2(200);
2615:
2616: prev_bcc_rec pa_cmt_burden_summary_v%rowtype;
2617: l_attribute1 pa_projects_all.attribute1%type;
2618: l_cmt_line_id pa_commitment_txns.cmt_line_id%type;
2619: l_burden_cost pa_expenditure_items_all.burden_cost%type;
2620: l_txn_ref1 pa_commitment_txns.original_txn_reference1%type;
2621: apps_id number(3) := 275; -- For PA

Line 2648: * Bug 4914022 : Changed projects cursor to join to pa_projects_all

2644: -- Bug 2556167: Added hint for using hash join
2645: -- Bug 2838499: Used pa_projects Org view instead of table.
2646: -- added org_id join between pt and p.
2647: /*
2648: * Bug 4914022 : Changed projects cursor to join to pa_projects_all
2649: * pa_project_types_all instead of pa_projects, pa_project_types.
2650: */
2651: Cursor projects is
2652: select /*+ use_hash(pt p) */

Line 2656: from pa_projects_all p,

2652: select /*+ use_hash(pt p) */
2653: p.project_id , p.segment1
2654: , upper(nvl(pt.burden_account_flag,'N')) burden_account_flag
2655: , upper(pt.burden_amt_display_method) burden_amt_display_method
2656: from pa_projects_all p,
2657: pa_project_types_all pt
2658: where pt.project_type = p.project_type
2659: and pt.org_id = p.org_id /*5368274*/
2660: and pt.burden_amt_display_method in ('D','d')

Line 2778: from pa_projects_all

2774: begin
2775: stage := 210; -- locking project record
2776: select attribute1
2777: into l_attribute1
2778: from pa_projects_all
2779: where project_id = proj_rec.project_id
2780: for update of attribute1 nowait;
2781:
2782: update pa_commitment_txns