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_COSTING dependencies on PA_EXPENDITURE_ITEMS

Line 501: from pa_expenditure_items_all

497: /* bug 2891527 */
498: If p_mode = 'VIADJUST' Then
499: select cost_ind_compiled_set_id
500: into p_ind_compiled_set_id
501: from pa_expenditure_items_all
502: where expenditure_item_id = X_expenditure_item_id;
503: end if;
504: /* bug 2891527 */
505:

Line 672: l_org_id pa_expenditure_items.org_id%type := NULL;

668: /* bug 3149022 */
669: l_ei_date DATE := NULL;
670: l_exp_id NUMBER := NULL;
671: l_sys_link_function VARCHAR2(3) := NULL;
672: l_org_id pa_expenditure_items.org_id%type := NULL;
673: l_recvr_org_id pa_expenditure_items.org_id%type := NULL;
674: l_sob_id NUMBER := NULL;
675: l_recvr_sob_id NUMBER := NULL;
676: l_pa_date DATE := NULL;

Line 673: l_recvr_org_id pa_expenditure_items.org_id%type := NULL;

669: l_ei_date DATE := NULL;
670: l_exp_id NUMBER := NULL;
671: l_sys_link_function VARCHAR2(3) := NULL;
672: l_org_id pa_expenditure_items.org_id%type := NULL;
673: l_recvr_org_id pa_expenditure_items.org_id%type := NULL;
674: l_sob_id NUMBER := NULL;
675: l_recvr_sob_id NUMBER := NULL;
676: l_pa_date DATE := NULL;
677: l_pa_period_name VARCHAR2(15) := NULL;

Line 705: -- FROM pa_expenditure_items ITEMS -- 12i MOAC changes

701: ,l_org_id
702: ,l_recvr_org_id
703: ,l_sys_link_function
704: ,l_exp_id
705: -- FROM pa_expenditure_items ITEMS -- 12i MOAC changes
706: FROM pa_expenditure_items_All ITEMS
707: WHERE ITEMS.expenditure_item_id = X_expenditure_item_id;
708:
709: SELECT imp1.set_of_books_id, imp2.set_of_books_id

Line 706: FROM pa_expenditure_items_All ITEMS

702: ,l_recvr_org_id
703: ,l_sys_link_function
704: ,l_exp_id
705: -- FROM pa_expenditure_items ITEMS -- 12i MOAC changes
706: FROM pa_expenditure_items_All ITEMS
707: WHERE ITEMS.expenditure_item_id = X_expenditure_item_id;
708:
709: SELECT imp1.set_of_books_id, imp2.set_of_books_id
710: INTO l_sob_id, l_recvr_sob_id

Line 784: -- From PA_Expenditure_items EI, -- 12i MOAC changes

780: Into l_gl_date,
781: l_gl_period_name,
782: l_recvr_gl_date,
783: l_recvr_gl_period_name
784: -- From PA_Expenditure_items EI, -- 12i MOAC changes
785: From PA_Expenditure_items_All EI /* Bug 5353670 / PQE Bug 5248665
786: PA_Implementations_All IMP */
787: Where EI.expenditure_item_id = X_expenditure_item_id;
788: /* AND NVL(EI.recvr_org_id,EI.ORG_ID) = IMP.org_id; Bug 5353670 / PQE Bug 5248665 */

Line 785: From PA_Expenditure_items_All EI /* Bug 5353670 / PQE Bug 5248665

781: l_gl_period_name,
782: l_recvr_gl_date,
783: l_recvr_gl_period_name
784: -- From PA_Expenditure_items EI, -- 12i MOAC changes
785: From PA_Expenditure_items_All EI /* Bug 5353670 / PQE Bug 5248665
786: PA_Implementations_All IMP */
787: Where EI.expenditure_item_id = X_expenditure_item_id;
788: /* AND NVL(EI.recvr_org_id,EI.ORG_ID) = IMP.org_id; Bug 5353670 / PQE Bug 5248665 */
789:

Line 1192: p_parent_adjusted_id pa_expenditure_items.adjusted_expenditure_item_id%TYPE;

1188: p_project_rate_type pa_cost_distribution_lines.project_rate_type%TYPE;
1189: p_project_exchange_rate pa_cost_distribution_lines.project_exchange_rate%TYPE;
1190: p_project_id pa_cost_distribution_lines.project_id%TYPE;
1191: p_task_id pa_cost_distribution_lines.task_id%TYPE;
1192: p_parent_adjusted_id pa_expenditure_items.adjusted_expenditure_item_id%TYPE;
1193: p_parent_transferred_id pa_expenditure_items.transferred_from_exp_item_id%TYPE;
1194: p_gl_accounted_flag pa_transaction_sources.gl_accounted_flag%TYPE;
1195: p_transaction_source pa_transaction_sources.transaction_source%TYPE;
1196:

Line 1193: p_parent_transferred_id pa_expenditure_items.transferred_from_exp_item_id%TYPE;

1189: p_project_exchange_rate pa_cost_distribution_lines.project_exchange_rate%TYPE;
1190: p_project_id pa_cost_distribution_lines.project_id%TYPE;
1191: p_task_id pa_cost_distribution_lines.task_id%TYPE;
1192: p_parent_adjusted_id pa_expenditure_items.adjusted_expenditure_item_id%TYPE;
1193: p_parent_transferred_id pa_expenditure_items.transferred_from_exp_item_id%TYPE;
1194: p_gl_accounted_flag pa_transaction_sources.gl_accounted_flag%TYPE;
1195: p_transaction_source pa_transaction_sources.transaction_source%TYPE;
1196:
1197: l_si_assets_addition_flag pa_cost_distribution_lines.si_assets_addition_flag%TYPE ;

Line 1228: l_org_id pa_expenditure_items.org_id%type;

1224: /* bug#2361495 */
1225: l_pa_date DATE ;
1226: l_recvr_pa_date DATE ;
1227: l_ei_date DATE ;
1228: l_org_id pa_expenditure_items.org_id%type;
1229: /* bug#2361495 */
1230: /* bug2378505 */
1231: actual_cdl_line_num pa_cost_distribution_lines.line_num%TYPE;
1232: /* bug2378505 */

Line 1234: l_recvr_org_id pa_expenditure_items.org_id%type;

1230: /* bug2378505 */
1231: actual_cdl_line_num pa_cost_distribution_lines.line_num%TYPE;
1232: /* bug2378505 */
1233: /* bug 2661921*/
1234: l_recvr_org_id pa_expenditure_items.org_id%type;
1235: l_gl_date DATE;
1236: l_recvr_gl_date DATE;
1237: l_exp_id NUMBER;
1238: l_sob_id NUMBER;

Line 1276: -- FROM pa_expenditure_items ITEMS, -- 12i MOAC changes

1272: ,l_recvr_org_id
1273: ,l_sys_link_function
1274: ,l_exp_id
1275: /* bug 2661921*/
1276: -- FROM pa_expenditure_items ITEMS, -- 12i MOAC changes
1277: FROM pa_expenditure_items_All ITEMS,
1278: pa_transaction_sources TRN
1279: WHERE ITEMS.transaction_source = TRN.transaction_source
1280: AND ITEMS.expenditure_item_id = X_exp_item_id;

Line 1277: FROM pa_expenditure_items_All ITEMS,

1273: ,l_sys_link_function
1274: ,l_exp_id
1275: /* bug 2661921*/
1276: -- FROM pa_expenditure_items ITEMS, -- 12i MOAC changes
1277: FROM pa_expenditure_items_All ITEMS,
1278: pa_transaction_sources TRN
1279: WHERE ITEMS.transaction_source = TRN.transaction_source
1280: AND ITEMS.expenditure_item_id = X_exp_item_id;
1281:

Line 1563: UPDATE pa_expenditure_items

1559: IF p_err_code IS NOT NULL THEN
1560: raise e_cdl_error;
1561: END IF;
1562:
1563: UPDATE pa_expenditure_items
1564: SET cost_distributed_flag = 'Y'
1565: WHERE expenditure_item_id = X_backout_id;
1566:
1567: END IF;