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_UTILS dependencies on PA_IMPLEMENTATIONS

Line 287: pa_implementations i

283: INTO
284: X_org_id
285: FROM
286: hr_organization_units o,
287: pa_implementations i
288: WHERE name = X_org_name
289: AND ((pa_utils.IsCrossBGProfile_WNPS = 'N'
290: AND o.business_group_id = i.business_group_id)
291: OR (pa_utils.IsCrossBGProfile_WNPS = 'Y'));

Line 322: pa_implementations i

318: INTO
319: X_orgn_id
320: FROM
321: hr_organization_units o,
322: pa_implementations i
323: WHERE name = X_org_name
324: AND ((pa_utils.IsCrossBGProfile_WNPS = 'N'
325: AND o.business_group_id = i.business_group_id
326: AND o.business_group_id = X_bg_id)

Line 336: pa_implementations i

332: INTO
333: X_orgn_id
334: FROM
335: hr_organization_units o,
336: pa_implementations i
337: WHERE name = X_org_name
338: AND ((pa_utils.IsCrossBGProfile_WNPS = 'N'
339: AND o.business_group_id = i.business_group_id)
340: OR (pa_utils.IsCrossBGProfile_WNPS = 'Y' ));

Line 370: pa_implementations i

366: INTO
367: X_org_name
368: FROM
369: hr_organization_units o,
370: pa_implementations i
371: WHERE
372: organization_id = X_org_id
373: AND ((pa_utils.IsCrossBGProfile_WNPS = 'N'
374: AND o.business_group_id = i.business_group_id)

Line 400: FROM pa_implementations;

396: BEGIN
397:
398: SELECT decode( exp_cycle_start_day_code, 1, 8, exp_cycle_start_day_code )-1
399: into X_week_ending_day_index
400: FROM pa_implementations;
401:
402: select to_char(to_date('01-01-1950','DD-MM-YYYY') +X_week_ending_day_index-1, 'Day')
403: into X_week_ending_day from dual;
404:

Line 514: FROM pa_implementations;

510: X_Cross_BG_Profile:= pa_utils.IsCrossBGProfile_WNPS; --Moved the function call from inside where clause to here
511:
512: SELECT business_group_id --Moved selection of BG id from inside where clause to here
513: INTO X_business_group_id
514: FROM pa_implementations;
515:
516: BEGIN --added in bug 11741116
517: SELECT
518: max(a.organization_id)

Line 786: FROM pa_implementations;

782: X_Cross_BG_Profile:= pa_utils.IsCrossBGProfile_WNPS; --Moved the function call from inside where clause to here
783:
784: SELECT business_group_id --Moved selection of BG id from inside where clause to here
785: INTO X_business_group_id
786: FROM pa_implementations;
787:
788: If x_po_header_id is not null then --Bug 4044057
789:
790: hr_po_info.get_po_for_primary_asg(X_person_id, X_date,l_po_header_id,l_po_line_id);

Line 1167: FROM pa_implementations;

1163: X_business_group_id NUMBER(15);
1164: BEGIN
1165: SELECT DISTINCT business_group_id /*Distinct added for Bug 6043451*/
1166: INTO X_business_group_id
1167: FROM pa_implementations;
1168:
1169: RETURN(X_business_group_id);
1170:
1171: END business_group_id;

Line 1291: FROM pa_implementations_all

1287: INTO x_dummy
1288: FROM sys.dual
1289: WHERE EXISTS (
1290: SELECT NULL
1291: FROM pa_implementations_all
1292: WHERE org_id IS NOT NULL );
1293:
1294: IF ( x_dummy = 'Y' ) THEN
1295: RETURN( 'Y' );

Line 1485: with this procedure like no_data_found in pa_implementations.

1481: -- = FUNCTION Get_Org_Window_Title
1482: -- ==========================================================================
1483: /* These comments are added for bug 1812275.
1484: Please have a look at the solution provided in this bug if you face any issue
1485: with this procedure like no_data_found in pa_implementations.
1486: We are not suppressing any exceptions because and exception should be raised
1487: if there are no records found in pa_implementations
1488: */
1489:

Line 1487: if there are no records found in pa_implementations

1483: /* These comments are added for bug 1812275.
1484: Please have a look at the solution provided in this bug if you face any issue
1485: with this procedure like no_data_found in pa_implementations.
1486: We are not suppressing any exceptions because and exception should be raised
1487: if there are no records found in pa_implementations
1488: */
1489:
1490:
1491: FUNCTION Get_Org_Window_Title RETURN VARCHAR2

Line 1550: , pa_implementations c

1546: decode(l_multi_cur, 'N', NULL,
1547: ': ' || g.currency_code))
1548: into l_wnd_context
1549: from gl_sets_of_books g
1550: , pa_implementations c
1551: where c.set_of_books_id = g.set_of_books_id;
1552:
1553: /*
1554: ***

Line 1587: , pa_implementations c

1583: decode(l_multi_cur, 'N', NULL,
1584: ': ' || g.currency_code))
1585: into l_wnd_context
1586: from gl_sets_of_books g
1587: , pa_implementations c
1588: , hr_operating_units h
1589: where h.organization_id = to_number(l_id)
1590: and c.set_of_books_id = g.set_of_books_id;
1591:

Line 1857: , pa_implementations i

1853: X_Emp_Org_Id
1854: FROM
1855: per_assignment_status_types s
1856: , per_all_assignments_f a -- modified for Bug 4699231
1857: , pa_implementations i
1858: WHERE
1859: a.job_id IS NOT NULL
1860: AND a.primary_flag = 'Y'
1861: AND trunc(X_date) BETWEEN trunc( a.effective_start_date )

Line 1885: , pa_implementations i

1881: X_Emp_Org_Id
1882: FROM
1883: per_assignment_status_types s
1884: , per_all_assignments_f a -- modified for Bug 4699231
1885: , pa_implementations i
1886: WHERE
1887: a.job_id IS NOT NULL
1888: AND a.primary_flag = 'Y'
1889: AND trunc(X_date) BETWEEN trunc( a.effective_start_date )

Line 1934: select exp_cycle_start_day_code into x_week_start from pa_implementations; /Bug 7601460 /

1930: BEGIN
1931:
1932: Begin
1933:
1934: select exp_cycle_start_day_code into x_week_start from pa_implementations; /*Bug 7601460 */
1935:
1936: -- Check if there are any records in the pl/sql table.
1937: If G_WeekEndDateTab.COUNT > 0 Then
1938:

Line 1969: FROM pa_implementations;

1965: End If;
1966:
1967: SELECT decode( exp_cycle_start_day_code, 1, 8, exp_cycle_start_day_code )-1
1968: into X_week_ending_day_index
1969: FROM pa_implementations;
1970:
1971: select to_char(to_date('01-01-1950','DD-MM-YYYY') +X_week_ending_day_index-1, 'Day')
1972: into X_week_ending_day
1973: from dual;

Line 2248: l_org_id pa_implementations_all.org_id%TYPE;

2244: l_costing_rule pa_compensation_rule_sets.compensation_rule_set%TYPE;
2245:
2246: l_debug_mode varchar2(1);
2247:
2248: l_org_id pa_implementations_all.org_id%TYPE;
2249: l_organization_id pa_expenditures_all.incurred_by_organization_id%TYPE;
2250: l_person_id pa_expenditures_all.incurred_by_person_id%TYPE;
2251: l_job_id pa_expenditure_items_all.job_id%TYPE;
2252: l_txn_date pa_expenditure_items_all.expenditure_item_date%TYPE;

Line 2264: lx_acct_rate_date_code pa_implementations_all.acct_rate_date_code%TYPE;

2260: lx_base_hours pa_org_labor_sch_rule.base_hours%TYPE;
2261: lx_rbc_elem_type_id pa_org_labor_sch_rule.rbc_element_type_id%TYPE;
2262: lx_cost_rate_curr_code pa_expenditure_items_all.denom_currency_code%TYPE;
2263: lx_acct_rate_type pa_expenditure_items_all.acct_rate_type%TYPE;
2264: lx_acct_rate_date_code pa_implementations_all.acct_rate_date_code%TYPE;
2265: lx_acct_exch_rate pa_compensation_details_all.acct_exchange_rate%TYPE;
2266: lx_err_stage number;
2267: lx_err_code varchar2(150);
2268:

Line 2379: l_org_id pa_implementations_all.org_id%TYPE;

2375: l_costing_rule pa_compensation_rule_sets.compensation_rule_set%TYPE;
2376:
2377: l_debug_mode varchar2(1);
2378:
2379: l_org_id pa_implementations_all.org_id%TYPE;
2380: l_organization_id pa_expenditures_all.incurred_by_organization_id%TYPE;
2381: l_person_id pa_expenditures_all.incurred_by_person_id%TYPE;
2382: l_job_id pa_expenditure_items_all.job_id%TYPE;
2383: l_txn_date pa_expenditure_items_all.expenditure_item_date%TYPE;

Line 2395: lx_acct_rate_date_code pa_implementations_all.acct_rate_date_code%TYPE;

2391: lx_base_hours pa_org_labor_sch_rule.base_hours%TYPE;
2392: lx_rbc_elem_type_id pa_org_labor_sch_rule.rbc_element_type_id%TYPE;
2393: lx_cost_rate_curr_code pa_expenditure_items_all.denom_currency_code%TYPE;
2394: lx_acct_rate_type pa_expenditure_items_all.acct_rate_type%TYPE;
2395: lx_acct_rate_date_code pa_implementations_all.acct_rate_date_code%TYPE;
2396: lx_acct_exch_rate pa_compensation_details_all.acct_exchange_rate%TYPE;
2397: lx_err_stage number;
2398: lx_err_code varchar2(150);
2399: