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.PAAPIMP_PKG dependencies on PA_PJC_CWK_UTILS

Line 6258: IF PA_PJC_CWK_UTILS.Is_rate_based_line(null, l_po_dist_id_tbl(i)) = 'Y'

6254: /* If the PO Receipt is for Contingent Worker labor type and the CWK timecard is to be processed
6255: as Labor cost in the Project operating unit, then only the non recoverable tax receipt lines
6256: should be pulled from PO, otherwise the entire receipt with tax should be processed from PO */
6257:
6258: IF PA_PJC_CWK_UTILS.Is_rate_based_line(null, l_po_dist_id_tbl(i)) = 'Y'
6259: AND PA_PJC_CWK_UTILS.Is_CWK_TC_Xface_Allowed(l_project_id_tbl(i)) = 'Y' THEN
6260: l_insert_flag_tbl(i) := 'N';
6261:
6262: write_log(LOG, 'Receipt is for CWK timecard PO - Only NRTAX will be processed');

Line 6259: AND PA_PJC_CWK_UTILS.Is_CWK_TC_Xface_Allowed(l_project_id_tbl(i)) = 'Y' THEN

6255: as Labor cost in the Project operating unit, then only the non recoverable tax receipt lines
6256: should be pulled from PO, otherwise the entire receipt with tax should be processed from PO */
6257:
6258: IF PA_PJC_CWK_UTILS.Is_rate_based_line(null, l_po_dist_id_tbl(i)) = 'Y'
6259: AND PA_PJC_CWK_UTILS.Is_CWK_TC_Xface_Allowed(l_project_id_tbl(i)) = 'Y' THEN
6260: l_insert_flag_tbl(i) := 'N';
6261:
6262: write_log(LOG, 'Receipt is for CWK timecard PO - Only NRTAX will be processed');
6263:

Line 7567: AND PA_PJC_CWK_UTILS.Is_cwk_tc_xface_allowed(nvl(dist.project_ID, 0))= 'Y'

7563: WHERE inv.invoice_id = dist.invoice_id
7564: AND po.po_distribution_id = dist.po_distribution_id
7565: AND nvl(po.distribution_type,'XXX') <> 'PREPAYMENT' -- bug 7192304, added nvl
7566: AND NVL(po.destination_type_code, 'EXPENSE') = 'EXPENSE'
7567: AND PA_PJC_CWK_UTILS.Is_cwk_tc_xface_allowed(nvl(dist.project_ID, 0))= 'Y'
7568: AND PA_PJC_CWK_UTILS.Is_rate_based_line(null,nvl(dist.po_distribution_id,0))= 'Y'
7569: AND dist.line_type_lookup_code in ( 'ITEM','ACCRUAL') --added accrual for historical data
7570: AND dist.pa_addition_flag = 'N'
7571: AND inv.invoice_type_lookup_code <> 'EXPENSE REPORT'

Line 7568: AND PA_PJC_CWK_UTILS.Is_rate_based_line(null,nvl(dist.po_distribution_id,0))= 'Y'

7564: AND po.po_distribution_id = dist.po_distribution_id
7565: AND nvl(po.distribution_type,'XXX') <> 'PREPAYMENT' -- bug 7192304, added nvl
7566: AND NVL(po.destination_type_code, 'EXPENSE') = 'EXPENSE'
7567: AND PA_PJC_CWK_UTILS.Is_cwk_tc_xface_allowed(nvl(dist.project_ID, 0))= 'Y'
7568: AND PA_PJC_CWK_UTILS.Is_rate_based_line(null,nvl(dist.po_distribution_id,0))= 'Y'
7569: AND dist.line_type_lookup_code in ( 'ITEM','ACCRUAL') --added accrual for historical data
7570: AND dist.pa_addition_flag = 'N'
7571: AND inv.invoice_type_lookup_code <> 'EXPENSE REPORT'
7572: AND nvl(INV.source, 'xx' ) NOT IN

Line 7696: AND PA_PJC_CWK_UTILS.Is_cwk_tc_xface_allowed(nvl(dist.project_ID, 0))= 'Y'

7692: WHERE inv.invoice_id = dist.invoice_id
7693: AND po.po_distribution_id = dist.po_distribution_id
7694: AND NVL(po.destination_type_code, 'EXPENSE') = 'EXPENSE'
7695: AND nvl(po.distribution_type,'XXX') <> 'PREPAYMENT' -- bug 7192304, added nvl
7696: AND PA_PJC_CWK_UTILS.Is_cwk_tc_xface_allowed(nvl(dist.project_ID, 0))= 'Y'
7697: AND PA_PJC_CWK_UTILS.Is_rate_based_line(null,nvl(dist.po_distribution_id,0))= 'Y'
7698: AND dist.line_type_lookup_code in ( 'ITEM','ACCRUAL') --added accrual for historical data
7699: AND dist.pa_addition_flag = 'N'
7700: AND inv.invoice_type_lookup_code <> 'EXPENSE REPORT'

Line 7697: AND PA_PJC_CWK_UTILS.Is_rate_based_line(null,nvl(dist.po_distribution_id,0))= 'Y'

7693: AND po.po_distribution_id = dist.po_distribution_id
7694: AND NVL(po.destination_type_code, 'EXPENSE') = 'EXPENSE'
7695: AND nvl(po.distribution_type,'XXX') <> 'PREPAYMENT' -- bug 7192304, added nvl
7696: AND PA_PJC_CWK_UTILS.Is_cwk_tc_xface_allowed(nvl(dist.project_ID, 0))= 'Y'
7697: AND PA_PJC_CWK_UTILS.Is_rate_based_line(null,nvl(dist.po_distribution_id,0))= 'Y'
7698: AND dist.line_type_lookup_code in ( 'ITEM','ACCRUAL') --added accrual for historical data
7699: AND dist.pa_addition_flag = 'N'
7700: AND inv.invoice_type_lookup_code <> 'EXPENSE REPORT'
7701: AND nvl(INV.source, 'xx' ) NOT IN

Line 9130: PA_PJC_CWK_UTILS.Is_cwk_tc_xface_allowed(nvl(aid.project_ID, 0))= 'N'

9126: AND nvl(INV.source, 'xx' ) NOT IN ('Oracle Project Accounting', 'PA_IC_INVOICES')
9127: AND aid.project_id = G_PROJECT_ID
9128: AND aid.line_type_lookup_code <> 'REC_TAX'
9129: AND (((
9130: PA_PJC_CWK_UTILS.Is_cwk_tc_xface_allowed(nvl(aid.project_ID, 0))= 'N'
9131: OR
9132: PA_PJC_CWK_UTILS.Is_rate_based_line(null,nvl(aid.po_distribution_id,0))= 'N' )
9133: AND aid.line_type_lookup_code IN ('ITEM','ACCRUAL')) OR
9134: (aid.line_type_lookup_code NOT IN ('ITEM','ACCRUAL')))

Line 9132: PA_PJC_CWK_UTILS.Is_rate_based_line(null,nvl(aid.po_distribution_id,0))= 'N' )

9128: AND aid.line_type_lookup_code <> 'REC_TAX'
9129: AND (((
9130: PA_PJC_CWK_UTILS.Is_cwk_tc_xface_allowed(nvl(aid.project_ID, 0))= 'N'
9131: OR
9132: PA_PJC_CWK_UTILS.Is_rate_based_line(null,nvl(aid.po_distribution_id,0))= 'N' )
9133: AND aid.line_type_lookup_code IN ('ITEM','ACCRUAL')) OR
9134: (aid.line_type_lookup_code NOT IN ('ITEM','ACCRUAL')))
9135: AND trunc(aip.Accounting_Date) <= trunc(nvl(G_GL_DATE,aip.Accounting_Date))
9136: AND trunc(aid.expenditure_item_date) <= trunc(nvl(G_TRANSACTION_DATE,aid.expenditure_item_date)));

Line 9178: PA_PJC_CWK_UTILS.Is_cwk_tc_xface_allowed(nvl(aid.project_ID, 0))= 'N'

9174: AND inv.invoice_type_lookup_code <> 'EXPENSE REPORT'
9175: AND nvl(INV.source, 'xx' ) NOT IN ('Oracle Project Accounting', 'PA_IC_INVOICES')
9176: AND aid.project_id = G_PROJECT_ID
9177: AND (((
9178: PA_PJC_CWK_UTILS.Is_cwk_tc_xface_allowed(nvl(aid.project_ID, 0))= 'N'
9179: OR
9180: PA_PJC_CWK_UTILS.Is_rate_based_line(null,nvl(aid.po_distribution_id,0))= 'N' )
9181: AND aid.line_type_lookup_code IN ('ITEM','ACCRUAL')) OR
9182: (aid.line_type_lookup_code NOT IN ('ITEM','ACCRUAL')))

Line 9180: PA_PJC_CWK_UTILS.Is_rate_based_line(null,nvl(aid.po_distribution_id,0))= 'N' )

9176: AND aid.project_id = G_PROJECT_ID
9177: AND (((
9178: PA_PJC_CWK_UTILS.Is_cwk_tc_xface_allowed(nvl(aid.project_ID, 0))= 'N'
9179: OR
9180: PA_PJC_CWK_UTILS.Is_rate_based_line(null,nvl(aid.po_distribution_id,0))= 'N' )
9181: AND aid.line_type_lookup_code IN ('ITEM','ACCRUAL')) OR
9182: (aid.line_type_lookup_code NOT IN ('ITEM','ACCRUAL')))
9183: AND trunc(aid2.Accounting_Date) <= trunc(nvl(G_GL_DATE,aid2.Accounting_Date))
9184: AND trunc(aid.expenditure_item_date) <= trunc(nvl(G_TRANSACTION_DATE,aid.expenditure_item_date)));

Line 9232: PA_PJC_CWK_UTILS.Is_cwk_tc_xface_allowed(nvl(aid.project_ID, 0))= 'N'

9228: AND nvl(INV.source, 'xx' ) NOT IN ('Oracle Project Accounting', 'PA_IC_INVOICES')
9229: AND aid.project_id > 0
9230: AND aid.line_type_lookup_code <> 'REC_TAX'
9231: AND (((
9232: PA_PJC_CWK_UTILS.Is_cwk_tc_xface_allowed(nvl(aid.project_ID, 0))= 'N'
9233: OR
9234: PA_PJC_CWK_UTILS.Is_rate_based_line(null,nvl(aid.po_distribution_id,0))= 'N' )
9235: AND aid.line_type_lookup_code IN ('ITEM','ACCRUAL')) OR
9236: (aid.line_type_lookup_code NOT IN ('ITEM','ACCRUAL')))

Line 9234: PA_PJC_CWK_UTILS.Is_rate_based_line(null,nvl(aid.po_distribution_id,0))= 'N' )

9230: AND aid.line_type_lookup_code <> 'REC_TAX'
9231: AND (((
9232: PA_PJC_CWK_UTILS.Is_cwk_tc_xface_allowed(nvl(aid.project_ID, 0))= 'N'
9233: OR
9234: PA_PJC_CWK_UTILS.Is_rate_based_line(null,nvl(aid.po_distribution_id,0))= 'N' )
9235: AND aid.line_type_lookup_code IN ('ITEM','ACCRUAL')) OR
9236: (aid.line_type_lookup_code NOT IN ('ITEM','ACCRUAL')))
9237: AND trunc(aip.Accounting_Date) <= trunc(nvl(G_GL_DATE,aip.Accounting_Date))
9238: AND trunc(aid.expenditure_item_date) <= trunc(nvl(G_TRANSACTION_DATE,aid.expenditure_item_date)));

Line 9280: PA_PJC_CWK_UTILS.Is_cwk_tc_xface_allowed(nvl(aid.project_ID, 0))= 'N'

9276: AND inv.invoice_type_lookup_code <> 'EXPENSE REPORT'
9277: AND nvl(INV.source, 'xx' ) NOT IN ('Oracle Project Accounting', 'PA_IC_INVOICES')
9278: AND aid.project_id> 0
9279: AND (((
9280: PA_PJC_CWK_UTILS.Is_cwk_tc_xface_allowed(nvl(aid.project_ID, 0))= 'N'
9281: OR
9282: PA_PJC_CWK_UTILS.Is_rate_based_line(null,nvl(aid.po_distribution_id,0))= 'N' )
9283: AND aid.line_type_lookup_code IN ('ITEM','ACCRUAL')) OR
9284: (aid.line_type_lookup_code NOT IN ('ITEM','ACCRUAL')))

Line 9282: PA_PJC_CWK_UTILS.Is_rate_based_line(null,nvl(aid.po_distribution_id,0))= 'N' )

9278: AND aid.project_id> 0
9279: AND (((
9280: PA_PJC_CWK_UTILS.Is_cwk_tc_xface_allowed(nvl(aid.project_ID, 0))= 'N'
9281: OR
9282: PA_PJC_CWK_UTILS.Is_rate_based_line(null,nvl(aid.po_distribution_id,0))= 'N' )
9283: AND aid.line_type_lookup_code IN ('ITEM','ACCRUAL')) OR
9284: (aid.line_type_lookup_code NOT IN ('ITEM','ACCRUAL')))
9285: AND trunc(aid2.Accounting_Date) <= trunc(nvl(G_GL_DATE,aid2.Accounting_Date))
9286: AND trunc(aid.expenditure_item_date) <= trunc(nvl(G_TRANSACTION_DATE,aid.expenditure_item_date)));