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_UTILS2 dependencies on PA_IMPLEMENTATIONS_ALL

Line 1136: l_cwk_lab_to_gl pa_implementations_all.XFACE_CWK_LABOR_TO_GL_FLAG%type;

1132: p_USER_ID CONSTANT NUMBER := FND_GLOBAL.user_id;
1133: l_err_code NUMBER ;
1134: l_err_stage VARCHAR2(2000);
1135: l_err_stack VARCHAR2(255) ;
1136: l_cwk_lab_to_gl pa_implementations_all.XFACE_CWK_LABOR_TO_GL_FLAG%type;
1137: l_labor_to_gl pa_implementations_all.interface_labor_to_gl_flag%type;
1138: l_usage_to_gl pa_implementations_all.interface_usage_to_gl_flag%type;
1139: l_interface_to_gl PA_PLSQL_DATATYPES.Char1TabTyp;
1140:

Line 1137: l_labor_to_gl pa_implementations_all.interface_labor_to_gl_flag%type;

1133: l_err_code NUMBER ;
1134: l_err_stage VARCHAR2(2000);
1135: l_err_stack VARCHAR2(255) ;
1136: l_cwk_lab_to_gl pa_implementations_all.XFACE_CWK_LABOR_TO_GL_FLAG%type;
1137: l_labor_to_gl pa_implementations_all.interface_labor_to_gl_flag%type;
1138: l_usage_to_gl pa_implementations_all.interface_usage_to_gl_flag%type;
1139: l_interface_to_gl PA_PLSQL_DATATYPES.Char1TabTyp;
1140:
1141: -- Bug 4374769 : The following variables are introduced as part of this bug.

Line 1138: l_usage_to_gl pa_implementations_all.interface_usage_to_gl_flag%type;

1134: l_err_stage VARCHAR2(2000);
1135: l_err_stack VARCHAR2(255) ;
1136: l_cwk_lab_to_gl pa_implementations_all.XFACE_CWK_LABOR_TO_GL_FLAG%type;
1137: l_labor_to_gl pa_implementations_all.interface_labor_to_gl_flag%type;
1138: l_usage_to_gl pa_implementations_all.interface_usage_to_gl_flag%type;
1139: l_interface_to_gl PA_PLSQL_DATATYPES.Char1TabTyp;
1140:
1141: -- Bug 4374769 : The following variables are introduced as part of this bug.
1142: v_gl_per_end_dt DATE;

Line 2442: ,p_prvdr_sob_id IN pa_implementations_all.set_of_books_id%TYPE

2438: ,p_prvdr_raw_gl_date IN pa_cost_distribution_lines_all.gl_date%TYPE
2439: ,p_recvr_raw_gl_date IN pa_cost_distribution_lines_all.gl_date%TYPE
2440: ,p_prvdr_org_id IN pa_expenditure_items_all.org_id%TYPE
2441: ,p_recvr_org_id IN pa_expenditure_items_all.org_id%TYPE
2442: ,p_prvdr_sob_id IN pa_implementations_all.set_of_books_id%TYPE
2443: ,p_recvr_sob_id IN pa_implementations_all.set_of_books_id%TYPE
2444: ,p_calling_module IN VARCHAR2
2445: ,p_ou_context IN VARCHAR2
2446: ,x_prvdr_pa_date OUT NOCOPY pa_cost_distribution_lines_all.pa_date%TYPE

Line 2443: ,p_recvr_sob_id IN pa_implementations_all.set_of_books_id%TYPE

2439: ,p_recvr_raw_gl_date IN pa_cost_distribution_lines_all.gl_date%TYPE
2440: ,p_prvdr_org_id IN pa_expenditure_items_all.org_id%TYPE
2441: ,p_recvr_org_id IN pa_expenditure_items_all.org_id%TYPE
2442: ,p_prvdr_sob_id IN pa_implementations_all.set_of_books_id%TYPE
2443: ,p_recvr_sob_id IN pa_implementations_all.set_of_books_id%TYPE
2444: ,p_calling_module IN VARCHAR2
2445: ,p_ou_context IN VARCHAR2
2446: ,x_prvdr_pa_date OUT NOCOPY pa_cost_distribution_lines_all.pa_date%TYPE
2447: ,x_prvdr_pa_period_name OUT NOCOPY pa_cost_distribution_lines_all.pa_period_name%TYPE

Line 2997: l_org_id pa_implementations_all.org_id%TYPE;

2993: ,x_error_code OUT NOCOPY VARCHAR2
2994: ,x_error_stage OUT NOCOPY NUMBER
2995: )
2996: IS
2997: l_org_id pa_implementations_all.org_id%TYPE;
2998: l_sob_id pa_implementations_all.set_of_books_id%TYPE;
2999:
3000: l_pa_date pa_cost_distribution_lines_all.pa_date%TYPE := NULL;
3001: l_pa_period_name pa_cost_distribution_lines_all.pa_period_name%TYPE := NULL;

Line 2998: l_sob_id pa_implementations_all.set_of_books_id%TYPE;

2994: ,x_error_stage OUT NOCOPY NUMBER
2995: )
2996: IS
2997: l_org_id pa_implementations_all.org_id%TYPE;
2998: l_sob_id pa_implementations_all.set_of_books_id%TYPE;
2999:
3000: l_pa_date pa_cost_distribution_lines_all.pa_date%TYPE := NULL;
3001: l_pa_period_name pa_cost_distribution_lines_all.pa_period_name%TYPE := NULL;
3002: l_gl_date pa_cost_distribution_lines_all.pa_date%TYPE := NULL;

Line 3122: ,pa_implementations_all imp

3118: ,l_gl_period_start_date
3119: ,l_gl_period_end_date
3120: FROM gl_periods glp
3121: ,gl_sets_of_books glsob
3122: ,pa_implementations_all imp
3123: WHERE glsob.period_set_name = glp.period_set_name
3124: AND glp.period_type = glsob.accounted_period_type
3125: AND glp.adjustment_period_flag <> 'Y'
3126: AND glsob.set_of_books_id = imp.set_of_books_id

Line 3147: FUNCTION get_set_of_books_id (p_org_id IN pa_implementations_all.org_id%TYPE)

3143: l_gl_period_name := NULL ;
3144: RAISE;
3145: END get_gl_period_name ;
3146: ---------------------------------------------------------------
3147: FUNCTION get_set_of_books_id (p_org_id IN pa_implementations_all.org_id%TYPE)
3148: RETURN NUMBER IS
3149: l_set_of_books_id pa_implementations_all.set_of_books_id%TYPE;
3150: BEGIN
3151:

Line 3149: l_set_of_books_id pa_implementations_all.set_of_books_id%TYPE;

3145: END get_gl_period_name ;
3146: ---------------------------------------------------------------
3147: FUNCTION get_set_of_books_id (p_org_id IN pa_implementations_all.org_id%TYPE)
3148: RETURN NUMBER IS
3149: l_set_of_books_id pa_implementations_all.set_of_books_id%TYPE;
3150: BEGIN
3151:
3152: SELECT imp.set_of_books_id
3153: INTO l_set_of_books_id

Line 3154: FROM pa_implementations_all imp

3150: BEGIN
3151:
3152: SELECT imp.set_of_books_id
3153: INTO l_set_of_books_id
3154: FROM pa_implementations_all imp
3155: WHERE NVL(imp.org_id,-99) = NVL(p_org_id, -99);
3156:
3157: RETURN l_set_of_books_id;
3158: EXCEPTION

Line 4016: ,p_prvdr_sob_id IN pa_implementations_all.set_of_books_id%TYPE

4012: ,x_prvdr_accrual_date IN OUT NOCOPY pa_cost_distribution_lines_all.gl_date%TYPE
4013: ,x_recvr_accrual_date IN OUT NOCOPY pa_cost_distribution_lines_all.gl_date%TYPE
4014: ,p_prvdr_org_id IN pa_expenditure_items_all.org_id%TYPE
4015: ,p_recvr_org_id IN pa_expenditure_items_all.org_id%TYPE
4016: ,p_prvdr_sob_id IN pa_implementations_all.set_of_books_id%TYPE
4017: ,p_recvr_sob_id IN pa_implementations_all.set_of_books_id%TYPE
4018: ,p_calling_module IN VARCHAR2
4019: ,x_prvdr_pa_date OUT NOCOPY pa_cost_distribution_lines_all.pa_date%TYPE
4020: ,x_prvdr_pa_period_name OUT NOCOPY pa_cost_distribution_lines_all.pa_period_name%TYPE

Line 4017: ,p_recvr_sob_id IN pa_implementations_all.set_of_books_id%TYPE

4013: ,x_recvr_accrual_date IN OUT NOCOPY pa_cost_distribution_lines_all.gl_date%TYPE
4014: ,p_prvdr_org_id IN pa_expenditure_items_all.org_id%TYPE
4015: ,p_recvr_org_id IN pa_expenditure_items_all.org_id%TYPE
4016: ,p_prvdr_sob_id IN pa_implementations_all.set_of_books_id%TYPE
4017: ,p_recvr_sob_id IN pa_implementations_all.set_of_books_id%TYPE
4018: ,p_calling_module IN VARCHAR2
4019: ,x_prvdr_pa_date OUT NOCOPY pa_cost_distribution_lines_all.pa_date%TYPE
4020: ,x_prvdr_pa_period_name OUT NOCOPY pa_cost_distribution_lines_all.pa_period_name%TYPE
4021: ,x_prvdr_gl_date IN OUT NOCOPY pa_cost_distribution_lines_all.gl_date%TYPE

Line 4736: ,p_org_id IN pa_implementations_all.org_id%TYPE

4732: RAISE ;
4733: END get_accrual_period_information ;
4734: -----------------------------------------------------------------------
4735: FUNCTION get_pa_period_name( p_txn_date IN pa_expenditure_items_all.expenditure_item_date%TYPE
4736: ,p_org_id IN pa_implementations_all.org_id%TYPE
4737: )
4738: RETURN pa_periods.period_name%TYPE
4739: IS
4740: l_pa_period_name pa_periods.period_name%TYPE;

Line 5021: l_set_of_books_id pa_implementations_all.set_of_books_id%TYPE;

5017: l_gl_period_st_dt pa_draft_revenues_all.gl_date%TYPE := NULL;
5018: l_gl_period_end_dt pa_draft_revenues_all.gl_date%TYPE := NULL;
5019: l_period_status gl_period_statuses.closing_status%TYPE := NULL;
5020:
5021: l_set_of_books_id pa_implementations_all.set_of_books_id%TYPE;
5022:
5023: l_gl_app_id NUMBER := 101;
5024: l_epp_flag VARCHAR2(1) := 'N';
5025: l_application_id NUMBER := NULL ;