APPS.PA_CI_SUPPLIER_PKG dependencies on PA_CI_SUPPLIER_DETAILS_S

Line 41: select pa_ci_supplier_details_s.nextval

37: from pa_ci_supplier_details
38: where ci_transaction_id = x_ci_transaction_id;
39:
40: cursor get_itemid is
41: select pa_ci_supplier_details_s.nextval
42: from sys.dual;
43:
44: l_return_status varchar2(100) := 'S';
45: l_error_msg_code varchar2(100) := NULL;

Line 211: UPDATE pa_ci_supplier_details SET

207: Nvl(recinfo.change_description,'X') <> nvl(p_change_description,'X') THEN
208: If l_debug_mode = 'Y' Then
209: print_msg('firing update query');
210: End If;
211: UPDATE pa_ci_supplier_details SET
212: VENDOR_ID = p_vendor_id
213: ,PO_HEADER_ID = p_po_header_id
214: ,PO_LINE_ID = p_po_line_id
215: ,ADJUSTED_CI_TRANSACTION_ID = p_adjusted_transaction_id