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 309: from pa_projects_all p, /changed pa_projects to pa_projects_all for the bug 13109368 /

305: , upper(nvl(pt.burden_account_flag,'N')) burden_account_flag
306: , pt.burden_sum_dest_project_id dest_project_id
307: , pt.burden_sum_dest_task_id dest_task_id
308: , upper(pt.burden_amt_display_method) burden_amt_display_method
309: from pa_projects_all p, /*changed pa_projects to pa_projects_all for the bug 13109368 */
310: pa_project_types_all pt /*changed pa_project_types to pa_project_types_all for the bug 13109368 */
311: where pt.project_type = p.project_type
312: and p.segment1 between p_start_project_number and p_end_project_number
313: and ( pt.burden_amt_display_method in ('D','d') or

Line 773: from pa_projects_all

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

Line 2761: l_attribute1 pa_projects_all.attribute1%type;

2757: init_cmt_run_id number := -9999;
2758: message_string varchar2(200);
2759:
2760: prev_bcc_rec pa_cmt_burden_summary_v%rowtype;
2761: l_attribute1 pa_projects_all.attribute1%type;
2762: l_cmt_line_id pa_commitment_txns.cmt_line_id%type;
2763: l_burden_cost pa_expenditure_items_all.burden_cost%type;
2764: l_txn_ref1 pa_commitment_txns.original_txn_reference1%type;
2765: apps_id number(3) := 275; -- For PA

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

2788: -- Bug 2556167: Added hint for using hash join
2789: -- Bug 2838499: Used pa_projects Org view instead of table.
2790: -- added org_id join between pt and p.
2791: /*
2792: * Bug 4914022 : Changed projects cursor to join to pa_projects_all
2793: * pa_project_types_all instead of pa_projects, pa_project_types.
2794: */
2795: Cursor projects is
2796: select /*+ use_hash(pt p) */

Line 2800: from pa_projects_all p,

2796: select /*+ use_hash(pt p) */
2797: p.project_id , p.segment1
2798: , upper(nvl(pt.burden_account_flag,'N')) burden_account_flag
2799: , upper(pt.burden_amt_display_method) burden_amt_display_method
2800: from pa_projects_all p,
2801: pa_project_types_all pt
2802: where pt.project_type = p.project_type
2803: and pt.org_id = p.org_id /*5368274*/
2804: and pt.burden_amt_display_method in ('D','d')

Line 2922: from pa_projects_all

2918: begin
2919: stage := 210; -- locking project record
2920: select attribute1
2921: into l_attribute1
2922: from pa_projects_all
2923: where project_id = proj_rec.project_id
2924: for update of attribute1 nowait;
2925:
2926: update pa_commitment_txns