DBA Data[Home] [Help]

APPS.PA_CI_SUPPLIER_PKG dependencies on PA_CI_SUPPLIER_DETAILS_S

Line 64: select pa_ci_supplier_details_s.nextval

60: from pa_ci_supplier_details
61: where ci_transaction_id = x_CI_TRANSACTION_ID;
62:
63: cursor get_itemid is
64: select pa_ci_supplier_details_s.nextval
65: from sys.dual;
66:
67: cursor get_budget_data(bvId number) is
68: select prac.total_projfunc_burdened_cost , prac.total_projfunc_revenue, prac.txn_average_bill_rate

Line 447: update pa_ci_supplier_details set CURRENT_AUDIT_FLAG = 'N' where ci_transaction_id = l_source_supp_id;

443: ,to_date(p_need_by_date)
444: -- gboomina modified for supplier cost 12.1.3 requirement - end
445: );
446: IF (l_audit_history_number > 1) then
447: update pa_ci_supplier_details set CURRENT_AUDIT_FLAG = 'N' where ci_transaction_id = l_source_supp_id;
448: end if;
449: /*
450: OPEN return_rowid;
451: FETCH return_rowid into x_rowid;

Line 1144: UPDATE pa_ci_supplier_details SET

1140: If l_debug_mode = 'Y' Then
1141: print_msg('firing update query');
1142: End If;
1143:
1144: UPDATE pa_ci_supplier_details SET
1145: VENDOR_ID = p_vendor_id
1146: ,PO_HEADER_ID = p_po_header_id
1147: ,PO_LINE_ID = p_po_line_id
1148: ,ADJUSTED_CI_TRANSACTION_ID = p_adjusted_transaction_id