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_IMPLEMENTATIONS_ALL

Line 39: l_start_org_id pa_implementations_all.start_organization_id%TYPE := pa_rep_util_glob.G_implementation_details.G_start_organization_id;

35:
36: /*
37: * Org ids locally cached at the package level.
38: */
39: l_start_org_id pa_implementations_all.start_organization_id%TYPE := pa_rep_util_glob.G_implementation_details.G_start_organization_id;
40: l_org_id pa_implementations_all.org_id%TYPE := pa_rep_util_glob.G_implementation_details.G_org_id;
41: l_org_structure_version_id pa_implementations_all.org_id%TYPE := pa_rep_util_glob.G_implementation_details.G_org_structure_version_id;
42:
43: /*

Line 40: l_org_id pa_implementations_all.org_id%TYPE := pa_rep_util_glob.G_implementation_details.G_org_id;

36: /*
37: * Org ids locally cached at the package level.
38: */
39: l_start_org_id pa_implementations_all.start_organization_id%TYPE := pa_rep_util_glob.G_implementation_details.G_start_organization_id;
40: l_org_id pa_implementations_all.org_id%TYPE := pa_rep_util_glob.G_implementation_details.G_org_id;
41: l_org_structure_version_id pa_implementations_all.org_id%TYPE := pa_rep_util_glob.G_implementation_details.G_org_structure_version_id;
42:
43: /*
44: * Period Set Name locally cached at the package level.

Line 41: l_org_structure_version_id pa_implementations_all.org_id%TYPE := pa_rep_util_glob.G_implementation_details.G_org_structure_version_id;

37: * Org ids locally cached at the package level.
38: */
39: l_start_org_id pa_implementations_all.start_organization_id%TYPE := pa_rep_util_glob.G_implementation_details.G_start_organization_id;
40: l_org_id pa_implementations_all.org_id%TYPE := pa_rep_util_glob.G_implementation_details.G_org_id;
41: l_org_structure_version_id pa_implementations_all.org_id%TYPE := pa_rep_util_glob.G_implementation_details.G_org_structure_version_id;
42:
43: /*
44: * Period Set Name locally cached at the package level.
45: * Changed for bug 3434019

Line 91: l_pa_period_type pa_implementations_all.pa_period_type%TYPE := pa_rep_util_glob.G_implementation_details.G_pa_period_type;

87:
88: /*
89: * pa and gl period types.
90: */
91: l_pa_period_type pa_implementations_all.pa_period_type%TYPE := pa_rep_util_glob.G_implementation_details.G_pa_period_type;
92: l_gl_period_type gl_sets_of_books.accounted_period_type%TYPE := pa_rep_util_glob.G_implementation_details.G_gl_period_type;
93:
94: /*
95: * Constants for 'PA' and 'GL'.

Line 465: CURSOR cur_org_dir_balances_pagl( p_start_org_id IN pa_implementations_all.start_organization_id%TYPE

461: /*
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

Line 470: ,p_org_id IN pa_implementations_all.org_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
471: )
472: IS SELECT bal.object_id
473: ,bal.object_type_code
474: ,bal.period_name

Line 524: ,p_org_id IN pa_implementations_all.org_id%TYPE

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: )
526: IS SELECT MAX(obj1.object_id)
527: ,obj.object_type_code
528: ,bal.period_name

Line 1058: CURSOR cur_org_dir_balances_ge( p_start_org_id IN pa_implementations_all.start_organization_id%TYPE

1054: /*
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

Line 1064: ,p_org_id IN pa_implementations_all.org_id%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
1064: ,p_org_id IN pa_implementations_all.org_id%TYPE
1065: )
1066: IS SELECT bal.object_id
1067: ,bal.object_type_code
1068: ,bal.period_name

Line 1117: ,p_org_id IN pa_implementations_all.org_id%TYPE

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
1118: )
1119: IS SELECT MAX(obj1.object_id)
1120: ,obj.object_type_code
1121: ,bal.period_name