APPS.PA_CI_SUPPLIER_PKG dependencies on PA_CI_SUPPLIER_DETAILS

Line 37: from pa_ci_supplier_details

33: ,x_error_msg_code OUT NOCOPY VARCHAR2
34: )IS
35: cursor return_rowid is
36: select rowid
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

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 68: INSERT into pa_ci_supplier_details

64: IF l_debug_mode = 'Y' THEN
65: print_msg('Info transacton id ..'||x_ci_transaction_id);
66: End IF;
67:
68: INSERT into pa_ci_supplier_details
69: ( CI_TRANSACTION_ID
70: ,CI_TYPE_ID
71: ,CI_ID
72: ,CI_IMPACT_ID

Line 169: FROM pa_ci_supplier_details

165: ,CURRENCY_CODE
166: ,CHANGE_AMOUNT
167: ,CHANGE_TYPE
168: ,CHANGE_DESCRIPTION
169: FROM pa_ci_supplier_details
170: WHERE ci_transaction_id = p_ci_transaction_id
171: FOR UPDATE OF ci_transaction_id NOWAIT;
172:
173: recinfo cur_row%rowtype;

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

Line 259: DELETE FROM PA_CI_SUPPLIER_DETAILS

255: l_debug_mode := NVL(l_debug_mode, 'N');
256:
257: pa_debug.set_process('PLSQL','LOG',l_debug_mode);
258:
259: DELETE FROM PA_CI_SUPPLIER_DETAILS
260: WHERE CI_TRANSACTION_ID = P_CI_TRANSACTION_ID;
261: if sql%found then
262: If l_debug_mode = 'Y' Then
263: print_msg('Delete Success');

Line 277: from pa_ci_supplier_details

273: PROCEDURE delete_row (x_rowid in VARCHAR2)IS
274:
275: cursor get_itemid is
276: select ci_transaction_id
277: from pa_ci_supplier_details
278: where rowid = x_rowid;
279:
280: l_ci_transaction_id Number;
281: