DBA Data[Home] [Help]

APPS.PA_COSTING dependencies on PA_TRANSACTION_SOURCES

Line 1128: accounted_flag PA_TRANSACTION_SOURCES.Gl_Accounted_Flag%TYPE;

1124:
1125: FUNCTION Is_Accounted(X_Transaction_Source IN VARCHAR2)
1126: RETURN VARCHAR2
1127: IS
1128: accounted_flag PA_TRANSACTION_SOURCES.Gl_Accounted_Flag%TYPE;
1129: BEGIN
1130: IF X_Transaction_Source IS NOT NULL THEN
1131: SELECT TS.Gl_Accounted_Flag
1132: INTO accounted_flag

Line 1133: FROM PA_TRANSACTION_SOURCES TS

1129: BEGIN
1130: IF X_Transaction_Source IS NOT NULL THEN
1131: SELECT TS.Gl_Accounted_Flag
1132: INTO accounted_flag
1133: FROM PA_TRANSACTION_SOURCES TS
1134: WHERE TS.Transaction_Source = X_Transaction_source;
1135: ELSE
1136: accounted_flag := 'N';
1137: END IF;

Line 1194: p_gl_accounted_flag pa_transaction_sources.gl_accounted_flag%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 ;
1198: p_err_code NUMBER;

Line 1195: p_transaction_source pa_transaction_sources.transaction_source%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 ;
1198: p_err_code NUMBER;
1199: p_err_stage VARCHAR2(1000);

Line 1278: pa_transaction_sources TRN

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:
1282: /* selecting set of books id for bug 2661921*/