APPS.PA_COSTING dependencies on PA_EXPENDITURE_ITEMS

Line 485: from pa_expenditure_items_all

481: /* bug 2891527 */
482: If p_mode = 'VIADJUST' Then
483: select cost_ind_compiled_set_id
484: into p_ind_compiled_set_id
485: from pa_expenditure_items_all
486: where expenditure_item_id = X_expenditure_item_id;
487: end if;
488: /* bug 2891527 */
489:

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

638: /* bug 3149022 */
639: l_ei_date DATE := NULL;
640: l_exp_id NUMBER := NULL;
641: l_sys_link_function VARCHAR2(3) := NULL;
642: l_org_id pa_expenditure_items.org_id%type := NULL;
643: l_recvr_org_id pa_expenditure_items.org_id%type := NULL;
644: l_sob_id NUMBER := NULL;
645: l_recvr_sob_id NUMBER := NULL;
646: l_pa_date DATE := NULL;

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

639: l_ei_date DATE := NULL;
640: l_exp_id NUMBER := NULL;
641: l_sys_link_function VARCHAR2(3) := NULL;
642: l_org_id pa_expenditure_items.org_id%type := NULL;
643: l_recvr_org_id pa_expenditure_items.org_id%type := NULL;
644: l_sob_id NUMBER := NULL;
645: l_recvr_sob_id NUMBER := NULL;
646: l_pa_date DATE := NULL;
647: l_pa_period_name VARCHAR2(15) := NULL;

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

671: ,l_org_id
672: ,l_recvr_org_id
673: ,l_sys_link_function
674: ,l_exp_id
675: -- FROM pa_expenditure_items ITEMS -- 12i MOAC changes
676: FROM pa_expenditure_items_All ITEMS
677: WHERE ITEMS.expenditure_item_id = X_expenditure_item_id;
678:
679: SELECT imp1.set_of_books_id, imp2.set_of_books_id

Line 676: FROM pa_expenditure_items_All ITEMS

672: ,l_recvr_org_id
673: ,l_sys_link_function
674: ,l_exp_id
675: -- FROM pa_expenditure_items ITEMS -- 12i MOAC changes
676: FROM pa_expenditure_items_All ITEMS
677: WHERE ITEMS.expenditure_item_id = X_expenditure_item_id;
678:
679: SELECT imp1.set_of_books_id, imp2.set_of_books_id
680: INTO l_sob_id, l_recvr_sob_id

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

750: Into l_gl_date,
751: l_gl_period_name,
752: l_recvr_gl_date,
753: l_recvr_gl_period_name
754: -- From PA_Expenditure_items EI, -- 12i MOAC changes
755: From PA_Expenditure_items_All EI /* Bug 5353670 / PQE Bug 5248665
756: PA_Implementations_All IMP */
757: Where EI.expenditure_item_id = X_expenditure_item_id;
758: /* AND NVL(EI.recvr_org_id,EI.ORG_ID) = IMP.org_id; Bug 5353670 / PQE Bug 5248665 */

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

751: l_gl_period_name,
752: l_recvr_gl_date,
753: l_recvr_gl_period_name
754: -- From PA_Expenditure_items EI, -- 12i MOAC changes
755: From PA_Expenditure_items_All EI /* Bug 5353670 / PQE Bug 5248665
756: PA_Implementations_All IMP */
757: Where EI.expenditure_item_id = X_expenditure_item_id;
758: /* AND NVL(EI.recvr_org_id,EI.ORG_ID) = IMP.org_id; Bug 5353670 / PQE Bug 5248665 */
759:

Line 1145: p_parent_adjusted_id pa_expenditure_items.adjusted_expenditure_item_id%TYPE;

1141: p_project_rate_type pa_cost_distribution_lines.project_rate_type%TYPE;
1142: p_project_exchange_rate pa_cost_distribution_lines.project_exchange_rate%TYPE;
1143: p_project_id pa_cost_distribution_lines.project_id%TYPE;
1144: p_task_id pa_cost_distribution_lines.task_id%TYPE;
1145: p_parent_adjusted_id pa_expenditure_items.adjusted_expenditure_item_id%TYPE;
1146: p_parent_transferred_id pa_expenditure_items.transferred_from_exp_item_id%TYPE;
1147: p_gl_accounted_flag pa_transaction_sources.gl_accounted_flag%TYPE;
1148: p_transaction_source pa_transaction_sources.transaction_source%TYPE;
1149:

Line 1146: p_parent_transferred_id pa_expenditure_items.transferred_from_exp_item_id%TYPE;

1142: p_project_exchange_rate pa_cost_distribution_lines.project_exchange_rate%TYPE;
1143: p_project_id pa_cost_distribution_lines.project_id%TYPE;
1144: p_task_id pa_cost_distribution_lines.task_id%TYPE;
1145: p_parent_adjusted_id pa_expenditure_items.adjusted_expenditure_item_id%TYPE;
1146: p_parent_transferred_id pa_expenditure_items.transferred_from_exp_item_id%TYPE;
1147: p_gl_accounted_flag pa_transaction_sources.gl_accounted_flag%TYPE;
1148: p_transaction_source pa_transaction_sources.transaction_source%TYPE;
1149:
1150: l_si_assets_addition_flag pa_cost_distribution_lines.si_assets_addition_flag%TYPE ;

Line 1181: l_org_id pa_expenditure_items.org_id%type;

1177: /* bug#2361495 */
1178: l_pa_date DATE ;
1179: l_recvr_pa_date DATE ;
1180: l_ei_date DATE ;
1181: l_org_id pa_expenditure_items.org_id%type;
1182: /* bug#2361495 */
1183: /* bug2378505 */
1184: actual_cdl_line_num pa_cost_distribution_lines.line_num%TYPE;
1185: /* bug2378505 */

Line 1187: l_recvr_org_id pa_expenditure_items.org_id%type;

1183: /* bug2378505 */
1184: actual_cdl_line_num pa_cost_distribution_lines.line_num%TYPE;
1185: /* bug2378505 */
1186: /* bug 2661921*/
1187: l_recvr_org_id pa_expenditure_items.org_id%type;
1188: l_gl_date DATE;
1189: l_recvr_gl_date DATE;
1190: l_exp_id NUMBER;
1191: l_sob_id NUMBER;

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

1220: ,l_recvr_org_id
1221: ,l_sys_link_function
1222: ,l_exp_id
1223: /* bug 2661921*/
1224: -- FROM pa_expenditure_items ITEMS, -- 12i MOAC changes
1225: FROM pa_expenditure_items_All ITEMS,
1226: pa_transaction_sources TRN
1227: WHERE ITEMS.transaction_source = TRN.transaction_source
1228: AND ITEMS.expenditure_item_id = X_exp_item_id;

Line 1225: FROM pa_expenditure_items_All ITEMS,

1221: ,l_sys_link_function
1222: ,l_exp_id
1223: /* bug 2661921*/
1224: -- FROM pa_expenditure_items ITEMS, -- 12i MOAC changes
1225: FROM pa_expenditure_items_All ITEMS,
1226: pa_transaction_sources TRN
1227: WHERE ITEMS.transaction_source = TRN.transaction_source
1228: AND ITEMS.expenditure_item_id = X_exp_item_id;
1229:

Line 1495: UPDATE pa_expenditure_items

1491: IF p_err_code IS NOT NULL THEN
1492: raise e_cdl_error;
1493: END IF;
1494:
1495: UPDATE pa_expenditure_items
1496: SET cost_distributed_flag = 'Y'
1497: WHERE expenditure_item_id = X_backout_id;
1498:
1499: END IF;