DBA Data[Home] [Help]

APPS.PA_COSTING dependencies on PA_TRANSACTION_SOURCES

Line 1081: accounted_flag PA_TRANSACTION_SOURCES.Gl_Accounted_Flag%TYPE;

1077:
1078: FUNCTION Is_Accounted(X_Transaction_Source IN VARCHAR2)
1079: RETURN VARCHAR2
1080: IS
1081: accounted_flag PA_TRANSACTION_SOURCES.Gl_Accounted_Flag%TYPE;
1082: BEGIN
1083: IF X_Transaction_Source IS NOT NULL THEN
1084: SELECT TS.Gl_Accounted_Flag
1085: INTO accounted_flag

Line 1086: FROM PA_TRANSACTION_SOURCES TS

1082: BEGIN
1083: IF X_Transaction_Source IS NOT NULL THEN
1084: SELECT TS.Gl_Accounted_Flag
1085: INTO accounted_flag
1086: FROM PA_TRANSACTION_SOURCES TS
1087: WHERE TS.Transaction_Source = X_Transaction_source;
1088: ELSE
1089: accounted_flag := 'N';
1090: END IF;

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

Line 1148: p_transaction_source pa_transaction_sources.transaction_source%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 ;
1151: p_err_code NUMBER;
1152: p_err_stage VARCHAR2(1000);

Line 1226: pa_transaction_sources TRN

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