DBA Data[Home] [Help]

APPS.PA_CI_SUPPLIER_PKG dependencies on PA_RESOURCE_ASSIGNMENTS_S

Line 81: select pa_resource_assignments_s.nextval

77: from pa_control_items
78: where ci_id = p_ci_id;
79:
80: cursor get_res_asgn_id is
81: select pa_resource_assignments_s.nextval
82: from sys.dual;
83:
84: cursor get_burdened_cost(ci_trans_id number) is
85: select final_cost from pa_ci_supplier_details

Line 962: select pa_resource_assignments_s.nextval

958: from pa_ci_supplier_details
959: where ci_transaction_id = p_ci_transaction_id;
960:
961: cursor get_res_asgn_id is
962: select pa_resource_assignments_s.nextval
963: from sys.dual;
964:
965: CURSOR cur_row is
966: SELECT CI_TYPE_ID

Line 1365: update PA_RESOURCE_ASSIGNMENTS SET

1361: --nag_test('UPDATE resource assignment id '||l_res_asgn_Id);
1362: If l_debug_mode = 'Y' Then
1363: print_msg('Updating the existing resource assignment');
1364: End If;
1365: update PA_RESOURCE_ASSIGNMENTS SET
1366: LAST_UPDATE_DATE = p_LAST_UPDATE_DATE
1367: ,LAST_UPDATED_BY = 1319
1368: ,LAST_UPDATE_LOGIN = p_LAST_UPDATE_LOGIN
1369: ,TOTAL_PLAN_REVENUE = l_revenue