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

Line 1152: l_cwk_lab_to_gl pa_implementations_all.XFACE_CWK_LABOR_TO_GL_FLAG%type;

1148: p_USER_ID CONSTANT NUMBER := FND_GLOBAL.user_id;
1149: l_err_code NUMBER ;
1150: l_err_stage VARCHAR2(2000);
1151: l_err_stack VARCHAR2(255) ;
1152: l_cwk_lab_to_gl pa_implementations_all.XFACE_CWK_LABOR_TO_GL_FLAG%type;
1153: l_labor_to_gl pa_implementations_all.interface_labor_to_gl_flag%type;
1154: l_usage_to_gl pa_implementations_all.interface_usage_to_gl_flag%type;
1155: l_interface_to_gl PA_PLSQL_DATATYPES.Char1TabTyp;
1156:

Line 1153: l_labor_to_gl pa_implementations_all.interface_labor_to_gl_flag%type;

1149: l_err_code NUMBER ;
1150: l_err_stage VARCHAR2(2000);
1151: l_err_stack VARCHAR2(255) ;
1152: l_cwk_lab_to_gl pa_implementations_all.XFACE_CWK_LABOR_TO_GL_FLAG%type;
1153: l_labor_to_gl pa_implementations_all.interface_labor_to_gl_flag%type;
1154: l_usage_to_gl pa_implementations_all.interface_usage_to_gl_flag%type;
1155: l_interface_to_gl PA_PLSQL_DATATYPES.Char1TabTyp;
1156:
1157: -- Bug 4374769 : The following variables are introduced as part of this bug.

Line 1154: l_usage_to_gl pa_implementations_all.interface_usage_to_gl_flag%type;

1150: l_err_stage VARCHAR2(2000);
1151: l_err_stack VARCHAR2(255) ;
1152: l_cwk_lab_to_gl pa_implementations_all.XFACE_CWK_LABOR_TO_GL_FLAG%type;
1153: l_labor_to_gl pa_implementations_all.interface_labor_to_gl_flag%type;
1154: l_usage_to_gl pa_implementations_all.interface_usage_to_gl_flag%type;
1155: l_interface_to_gl PA_PLSQL_DATATYPES.Char1TabTyp;
1156:
1157: -- Bug 4374769 : The following variables are introduced as part of this bug.
1158: v_gl_per_end_dt DATE;

Line 1181: l_sob_id pa_implementations.set_of_books_id%type;

1177: l_projfunc_cost_rate_date pa_expenditure_items_all.projfunc_cost_rate_date%type;
1178: l_projfunc_cost_rate_type pa_expenditure_items_all.projfunc_cost_rate_type%type;
1179: l_projfunc_cost_exchange_rate pa_expenditure_items_all.projfunc_cost_exchange_rate%type;
1180: l_work_type_id pa_expenditure_items_all.work_type_id%type;
1181: l_sob_id pa_implementations.set_of_books_id%type;
1182:
1183:
1184: -- Cursor to pick up all CDLs with intermediate status 'Y' for creation of
1185: -- reversing and new CDLs .

Line 1229: from pa_implementations;

1225:
1226:
1227: select interface_labor_to_gl_flag , interface_usage_to_gl_flag , XFACE_CWK_LABOR_TO_GL_FLAG , set_of_books_id
1228: Into l_labor_to_gl , l_usage_to_gl , l_cwk_lab_to_gl , l_sob_id
1229: from pa_implementations;
1230:
1231: /* Bug 4374769 : If the populate_gl_dates procedure is called for miscellaneous transactions for which the "Reverse Expenditure in a future period"
1232: is checked then the "PRC: Interface Usage and Miscellaneous costs to General Ledger" calls this procedure with the
1233: p_sys_linkage_type parameter as 'PJ' for the CDLs of reversing EI. */

Line 1477: from pa_implementations; */

1473:
1474: -- Commented for Bug 4374769
1475: /* select interface_labor_to_gl_flag , interface_usage_to_gl_flag , XFACE_CWK_LABOR_TO_GL_FLAG
1476: Into l_labor_to_gl , l_usage_to_gl , l_cwk_lab_to_gl
1477: from pa_implementations; */
1478:
1479: --Get the GL Info into PLSQL table for all the CDL_row_Ids passed to this procedure .
1480: FOR i IN 1..p_local_set_size
1481: LOOP

Line 2459: ,p_prvdr_sob_id IN pa_implementations_all.set_of_books_id%TYPE

2455: ,p_prvdr_raw_gl_date IN pa_cost_distribution_lines_all.gl_date%TYPE
2456: ,p_recvr_raw_gl_date IN pa_cost_distribution_lines_all.gl_date%TYPE
2457: ,p_prvdr_org_id IN pa_expenditure_items_all.org_id%TYPE
2458: ,p_recvr_org_id IN pa_expenditure_items_all.org_id%TYPE
2459: ,p_prvdr_sob_id IN pa_implementations_all.set_of_books_id%TYPE
2460: ,p_recvr_sob_id IN pa_implementations_all.set_of_books_id%TYPE
2461: ,p_calling_module IN VARCHAR2
2462: ,p_ou_context IN VARCHAR2
2463: ,x_prvdr_pa_date OUT NOCOPY pa_cost_distribution_lines_all.pa_date%TYPE

Line 2460: ,p_recvr_sob_id IN pa_implementations_all.set_of_books_id%TYPE

2456: ,p_recvr_raw_gl_date IN pa_cost_distribution_lines_all.gl_date%TYPE
2457: ,p_prvdr_org_id IN pa_expenditure_items_all.org_id%TYPE
2458: ,p_recvr_org_id IN pa_expenditure_items_all.org_id%TYPE
2459: ,p_prvdr_sob_id IN pa_implementations_all.set_of_books_id%TYPE
2460: ,p_recvr_sob_id IN pa_implementations_all.set_of_books_id%TYPE
2461: ,p_calling_module IN VARCHAR2
2462: ,p_ou_context IN VARCHAR2
2463: ,x_prvdr_pa_date OUT NOCOPY pa_cost_distribution_lines_all.pa_date%TYPE
2464: ,x_prvdr_pa_period_name OUT NOCOPY pa_cost_distribution_lines_all.pa_period_name%TYPE

Line 3035: l_org_id pa_implementations_all.org_id%TYPE;

3031: ,x_error_code OUT NOCOPY VARCHAR2
3032: ,x_error_stage OUT NOCOPY NUMBER
3033: )
3034: IS
3035: l_org_id pa_implementations_all.org_id%TYPE;
3036: l_sob_id pa_implementations_all.set_of_books_id%TYPE;
3037:
3038: l_pa_date pa_cost_distribution_lines_all.pa_date%TYPE := NULL;
3039: l_pa_period_name pa_cost_distribution_lines_all.pa_period_name%TYPE := NULL;

Line 3036: l_sob_id pa_implementations_all.set_of_books_id%TYPE;

3032: ,x_error_stage OUT NOCOPY NUMBER
3033: )
3034: IS
3035: l_org_id pa_implementations_all.org_id%TYPE;
3036: l_sob_id pa_implementations_all.set_of_books_id%TYPE;
3037:
3038: l_pa_date pa_cost_distribution_lines_all.pa_date%TYPE := NULL;
3039: l_pa_period_name pa_cost_distribution_lines_all.pa_period_name%TYPE := NULL;
3040: l_gl_date pa_cost_distribution_lines_all.pa_date%TYPE := NULL;

Line 3073: FROM pa_implementations imp;

3069: SELECT NVL(imp.org_id, -99)
3070: ,imp.set_of_books_id
3071: INTO l_org_id
3072: ,l_sob_id
3073: FROM pa_implementations imp;
3074:
3075: l_stage := 200 ;
3076: IF ( l_debug_mode = 'Y' )
3077: THEN

Line 3160: ,pa_implementations_all imp

3156: ,l_gl_period_start_date
3157: ,l_gl_period_end_date
3158: FROM gl_periods glp
3159: ,gl_sets_of_books glsob
3160: ,pa_implementations_all imp
3161: WHERE glsob.period_set_name = glp.period_set_name
3162: AND glp.period_type = glsob.accounted_period_type
3163: AND glp.adjustment_period_flag <> 'Y'
3164: AND glsob.set_of_books_id = imp.set_of_books_id

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

3181: l_gl_period_name := NULL ;
3182: RAISE;
3183: END get_gl_period_name ;
3184: ---------------------------------------------------------------
3185: FUNCTION get_set_of_books_id (p_org_id IN pa_implementations_all.org_id%TYPE)
3186: RETURN NUMBER IS
3187: l_set_of_books_id pa_implementations_all.set_of_books_id%TYPE;
3188: BEGIN
3189:

Line 3187: l_set_of_books_id pa_implementations_all.set_of_books_id%TYPE;

3183: END get_gl_period_name ;
3184: ---------------------------------------------------------------
3185: FUNCTION get_set_of_books_id (p_org_id IN pa_implementations_all.org_id%TYPE)
3186: RETURN NUMBER IS
3187: l_set_of_books_id pa_implementations_all.set_of_books_id%TYPE;
3188: BEGIN
3189:
3190: SELECT imp.set_of_books_id
3191: INTO l_set_of_books_id

Line 3192: FROM pa_implementations_all imp

3188: BEGIN
3189:
3190: SELECT imp.set_of_books_id
3191: INTO l_set_of_books_id
3192: FROM pa_implementations_all imp
3193: WHERE NVL(imp.org_id,-99) = NVL(p_org_id, -99);
3194:
3195: RETURN l_set_of_books_id;
3196: EXCEPTION

Line 4054: ,p_prvdr_sob_id IN pa_implementations_all.set_of_books_id%TYPE

4050: ,x_prvdr_accrual_date IN OUT NOCOPY pa_cost_distribution_lines_all.gl_date%TYPE
4051: ,x_recvr_accrual_date IN OUT NOCOPY pa_cost_distribution_lines_all.gl_date%TYPE
4052: ,p_prvdr_org_id IN pa_expenditure_items_all.org_id%TYPE
4053: ,p_recvr_org_id IN pa_expenditure_items_all.org_id%TYPE
4054: ,p_prvdr_sob_id IN pa_implementations_all.set_of_books_id%TYPE
4055: ,p_recvr_sob_id IN pa_implementations_all.set_of_books_id%TYPE
4056: ,p_calling_module IN VARCHAR2
4057: ,x_prvdr_pa_date OUT NOCOPY pa_cost_distribution_lines_all.pa_date%TYPE
4058: ,x_prvdr_pa_period_name OUT NOCOPY pa_cost_distribution_lines_all.pa_period_name%TYPE

Line 4055: ,p_recvr_sob_id IN pa_implementations_all.set_of_books_id%TYPE

4051: ,x_recvr_accrual_date IN OUT NOCOPY pa_cost_distribution_lines_all.gl_date%TYPE
4052: ,p_prvdr_org_id IN pa_expenditure_items_all.org_id%TYPE
4053: ,p_recvr_org_id IN pa_expenditure_items_all.org_id%TYPE
4054: ,p_prvdr_sob_id IN pa_implementations_all.set_of_books_id%TYPE
4055: ,p_recvr_sob_id IN pa_implementations_all.set_of_books_id%TYPE
4056: ,p_calling_module IN VARCHAR2
4057: ,x_prvdr_pa_date OUT NOCOPY pa_cost_distribution_lines_all.pa_date%TYPE
4058: ,x_prvdr_pa_period_name OUT NOCOPY pa_cost_distribution_lines_all.pa_period_name%TYPE
4059: ,x_prvdr_gl_date IN OUT NOCOPY pa_cost_distribution_lines_all.gl_date%TYPE

Line 4774: ,p_org_id IN pa_implementations_all.org_id%TYPE

4770: RAISE ;
4771: END get_accrual_period_information ;
4772: -----------------------------------------------------------------------
4773: FUNCTION get_pa_period_name( p_txn_date IN pa_expenditure_items_all.expenditure_item_date%TYPE
4774: ,p_org_id IN pa_implementations_all.org_id%TYPE
4775: )
4776: RETURN pa_periods.period_name%TYPE
4777: IS
4778: l_pa_period_name pa_periods.period_name%TYPE;

Line 5059: l_set_of_books_id pa_implementations_all.set_of_books_id%TYPE;

5055: l_gl_period_st_dt pa_draft_revenues_all.gl_date%TYPE := NULL;
5056: l_gl_period_end_dt pa_draft_revenues_all.gl_date%TYPE := NULL;
5057: l_period_status gl_period_statuses.closing_status%TYPE := NULL;
5058:
5059: l_set_of_books_id pa_implementations_all.set_of_books_id%TYPE;
5060:
5061: l_gl_app_id NUMBER := 101;
5062: l_epp_flag VARCHAR2(1) := 'N';
5063: l_application_id NUMBER := NULL ;

Line 5078: FROM pa_implementations imp;

5074: l_application_id := l_gl_app_id ;
5075:
5076: SELECT imp.set_of_books_id
5077: INTO l_set_of_books_id
5078: FROM pa_implementations imp;
5079:
5080: pa_debug.write_file('PA_UTILS2.GET_GL_PERIOD: Using (appl_id, sob_id): (' || to_char(l_application_id) || ', ' || to_char(l_set_of_books_id) || ')' );
5081:
5082: ---Initialize the out variables.

Line 5331: FROM pa_implementations;

5327: l_Cross_BG_Profile:= pa_utils.IsCrossBGProfile_WNPS;
5328:
5329: SELECT business_group_id
5330: INTO l_business_group_id
5331: FROM pa_implementations;
5332:
5333: pa_debug.write_file('PA_UTILS2.populate_person_type: l_Cross_BG_Profile = ' || l_Cross_BG_Profile);
5334: pa_debug.write_file('PA_UTILS2.populate_person_type: l_business_group_id = ' || l_business_group_id);
5335: