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_SUMMARIZE_ORG_ROLLUP_PVT dependencies on PA_OBJECTS

Line 101: l_balance_type_code pa_objects.balance_type_code%TYPE;

97: l_period_type_pa VARCHAR2(3) := pa_rep_util_glob.G_PERIOD_TYPE_C.G_PA_C;
98: l_period_type_gl VARCHAR2(3) := pa_rep_util_glob.G_PERIOD_TYPE_C.G_GL_C;
99: l_period_type_ge VARCHAR2(3) := pa_rep_util_glob.G_PERIOD_TYPE_C.G_GE_C;
100:
101: l_balance_type_code pa_objects.balance_type_code%TYPE;
102: l_eff_start_pa_period_num PLS_INTEGER;
103: l_eff_start_gl_period_num PLS_INTEGER;
104: l_start_date DATE;
105: l_end_date DATE;

Line 156: * Create Missing objects pa_objects for organizations.

152: PA_DEBUG.log_message('refresh_org_hierarchy_rollup: ' || PA_DEBUG.g_err_stage);
153: END IF;
154:
155: /*
156: * Create Missing objects pa_objects for organizations.
157: */
158: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
159: PA_DEBUG.g_err_stage := '150:Before Calling create_missing_parent_objects';
160: PA_DEBUG.log_message('refresh_org_hierarchy_rollup: ' || PA_DEBUG.g_err_stage);

Line 261: l_object_type_code pa_objects.object_type_code%TYPE;

257:
258: PROCEDURE create_missing_parent_objects(p_balance_type_code IN VARCHAR2)
259: IS
260:
261: l_object_type_code pa_objects.object_type_code%TYPE;
262: l_org_util_category_id pa_objects.org_util_category_id%TYPE;
263: l_work_type_id pa_objects.work_type_id%TYPE;
264: l_parent_organization_id pa_objects.expenditure_organization_id%TYPE;
265:

Line 262: l_org_util_category_id pa_objects.org_util_category_id%TYPE;

258: PROCEDURE create_missing_parent_objects(p_balance_type_code IN VARCHAR2)
259: IS
260:
261: l_object_type_code pa_objects.object_type_code%TYPE;
262: l_org_util_category_id pa_objects.org_util_category_id%TYPE;
263: l_work_type_id pa_objects.work_type_id%TYPE;
264: l_parent_organization_id pa_objects.expenditure_organization_id%TYPE;
265:
266: l_dummy VARCHAR2(1);

Line 263: l_work_type_id pa_objects.work_type_id%TYPE;

259: IS
260:
261: l_object_type_code pa_objects.object_type_code%TYPE;
262: l_org_util_category_id pa_objects.org_util_category_id%TYPE;
263: l_work_type_id pa_objects.work_type_id%TYPE;
264: l_parent_organization_id pa_objects.expenditure_organization_id%TYPE;
265:
266: l_dummy VARCHAR2(1);
267:

Line 264: l_parent_organization_id pa_objects.expenditure_organization_id%TYPE;

260:
261: l_object_type_code pa_objects.object_type_code%TYPE;
262: l_org_util_category_id pa_objects.org_util_category_id%TYPE;
263: l_work_type_id pa_objects.work_type_id%TYPE;
264: l_parent_organization_id pa_objects.expenditure_organization_id%TYPE;
265:
266: l_dummy VARCHAR2(1);
267:
268: /*

Line 274: ,p_balance_type_code IN pa_objects.balance_type_code%TYPE

270: * should have based on the objects its child organizations have.
271: */
272:
273: CURSOR cur_unique_objects_per_parent( p_level IN PLS_INTEGER
274: ,p_balance_type_code IN pa_objects.balance_type_code%TYPE
275: )
276: IS
277: SELECT obj.object_type_code
278: ,obj.org_util_category_id

Line 281: FROM pa_objects obj

277: SELECT obj.object_type_code
278: ,obj.org_util_category_id
279: ,obj.work_type_id
280: ,hier.parent_organization_id
281: FROM pa_objects obj
282: ,pa_org_hierarchy_denorm hier
283: WHERE hier.child_organization_id = obj.expenditure_organization_id
284: AND hier.pa_org_use_type = 'REPORTING'
285: AND hier.ORG_HIERARCHY_VERSION_ID = l_org_structure_version_id

Line 370: FROM pa_objects obj

366: * If it exists, do nothing. Else insert.
367: */
368: SELECT 'X'
369: INTO l_dummy
370: FROM pa_objects obj
371: WHERE obj.object_type_code = l_object_type_code
372: AND obj.balance_type_code = p_balance_type_code
373: AND obj.work_type_id = l_work_type_id
374: AND obj.org_util_category_id = l_org_util_category_id

Line 385: INTO pa_objects( object_id

381: * If control comes here, object doesnt exists. Insert.
382: */
383:
384: INSERT
385: INTO pa_objects( object_id
386: ,object_type_code
387: ,balance_type_code
388: ,project_org_id
389: ,project_organization_id

Line 411: VALUES( pa_objects_s.nextval

407: ,program_application_id
408: ,program_id
409: ,program_update_date
410: )
411: VALUES( pa_objects_s.nextval
412: ,l_object_type_code
413: ,p_balance_type_code
414: ,-1
415: ,-1

Line 466: ,p_balance_type_code IN pa_objects.balance_type_code%TYPE

462: * Cursor to insert tot_num records same as that of
463: * dir_num records.
464: */
465: CURSOR cur_org_dir_balances_pagl( p_start_org_id IN pa_implementations_all.start_organization_id%TYPE
466: ,p_balance_type_code IN pa_objects.balance_type_code%TYPE
467: ,p_maximum_level IN PLS_INTEGER
468: ,p_period_type IN VARCHAR2
469: ,p_effective_start_period_num IN PLS_INTEGER
470: ,p_org_id IN pa_implementations_all.org_id%TYPE

Line 482: ,pa_objects obj

478: ,bal.period_num
479: ,bal.period_balance
480: FROM pa_org_hierarchy_denorm hier
481: ,pa_summ_balances bal
482: ,pa_objects obj
483: WHERE hier.parent_organization_id = p_start_org_id
484: AND hier.parent_level = p_maximum_level
485: AND NVL(hier.org_id,-99) = p_org_id
486: AND hier.pa_org_use_type = 'REPORTING'

Line 521: ,p_balance_type_code IN pa_objects.balance_type_code%TYPE

517: /*
518: * Cursor for getting the level-wise sub-org numbers.
519: */
520: CURSOR cur_org_sub_balances_pagl( p_level_number IN PLS_INTEGER
521: ,p_balance_type_code IN pa_objects.balance_type_code%TYPE
522: ,p_period_type IN VARCHAR2
523: ,p_effective_start_period_num IN PLS_INTEGER
524: ,p_org_id IN pa_implementations_all.org_id%TYPE
525: )

Line 535: ,pa_objects obj

531: ,bal.amount_type_id
532: ,MAX(bal.period_num)
533: ,SUM(bal.period_balance)
534: FROM pa_summ_balances bal
535: ,pa_objects obj
536: ,pa_objects obj1
537: ,pa_org_hierarchy_denorm hier
538: WHERE obj1.object_type_code = obj.object_type_code
539: AND obj1.balance_type_code = obj.balance_type_code

Line 536: ,pa_objects obj1

532: ,MAX(bal.period_num)
533: ,SUM(bal.period_balance)
534: FROM pa_summ_balances bal
535: ,pa_objects obj
536: ,pa_objects obj1
537: ,pa_org_hierarchy_denorm hier
538: WHERE obj1.object_type_code = obj.object_type_code
539: AND obj1.balance_type_code = obj.balance_type_code
540: AND obj1.project_org_id = obj.project_org_id

Line 650: FROM pa_objects obj

646: AND bal.period_num >= p_effective_start_period_num
647: AND period_type = p_period_type
648: AND ROWNUM <= l_fetch_size
649: AND EXISTS ( SELECT NULL
650: FROM pa_objects obj
651: WHERE obj.balance_type_code = p_balance_type_code
652: AND obj.object_id = bal.object_id
653: AND obj.expenditure_org_id = l_org_id
654: );

Line 1059: ,p_balance_type_code IN pa_objects.balance_type_code%TYPE

1055: * Cursor to insert tot_num records same as that of
1056: * dir_num records.
1057: */
1058: CURSOR cur_org_dir_balances_ge( p_start_org_id IN pa_implementations_all.start_organization_id%TYPE
1059: ,p_balance_type_code IN pa_objects.balance_type_code%TYPE
1060: ,p_maximum_level IN PLS_INTEGER
1061: ,p_period_type IN VARCHAR2
1062: ,p_start_date IN DATE
1063: ,p_end_date IN DATE

Line 1076: ,pa_objects obj

1072: ,bal.amount_type_id
1073: ,bal.period_balance
1074: FROM pa_org_hierarchy_denorm hier
1075: ,pa_summ_balances bal
1076: ,pa_objects obj
1077: WHERE hier.parent_organization_id = p_start_org_id
1078: AND hier.parent_level = p_maximum_level
1079: AND NVL(hier.org_id,-99) = p_org_id
1080: AND hier.pa_org_use_type = 'REPORTING'

Line 1113: ,p_balance_type_code IN pa_objects.balance_type_code%TYPE

1109: /*
1110: * Cursor for getting the level-wise sub-org numbers.
1111: */
1112: CURSOR cur_org_sub_balances_ge( p_level_number IN PLS_INTEGER
1113: ,p_balance_type_code IN pa_objects.balance_type_code%TYPE
1114: ,p_period_type IN VARCHAR2
1115: ,p_start_date IN DATE
1116: ,p_end_date IN DATE
1117: ,p_org_id IN pa_implementations_all.org_id%TYPE

Line 1128: ,pa_objects obj

1124: ,MAX(bal.quarter_or_month_number)
1125: ,bal.amount_type_id
1126: ,SUM(bal.period_balance)
1127: FROM pa_summ_balances bal
1128: ,pa_objects obj
1129: ,pa_objects obj1
1130: ,pa_org_hierarchy_denorm hier
1131: WHERE obj1.object_type_code = obj.object_type_code
1132: AND obj1.balance_type_code = obj.balance_type_code

Line 1129: ,pa_objects obj1

1125: ,bal.amount_type_id
1126: ,SUM(bal.period_balance)
1127: FROM pa_summ_balances bal
1128: ,pa_objects obj
1129: ,pa_objects obj1
1130: ,pa_org_hierarchy_denorm hier
1131: WHERE obj1.object_type_code = obj.object_type_code
1132: AND obj1.balance_type_code = obj.balance_type_code
1133: AND obj1.project_org_id = obj.project_org_id

Line 1238: FROM pa_objects obj

1234: AND bal.global_exp_period_end_date >= p_start_date
1235: AND bal.period_type = p_period_type
1236: AND ROWNUM <= l_fetch_size
1237: AND EXISTS ( SELECT NULL
1238: FROM pa_objects obj
1239: WHERE obj.balance_type_code = p_balance_type_code
1240: AND obj.object_id = bal.object_id
1241: AND obj.expenditure_org_id = l_org_id
1242: );