APPS.POR_RCV_TRANSACTION_SV dependencies on RCV_TRANSACTIONS_INTERFACE

Line 25: PROCEDURE insert_interface_errors ( rcv_trx IN OUT NOCOPY rcv_transactions_interface%ROWTYPE,

21: p_employee_id in number,
22: p_Comments in varchar2,
23: x_parent_interface_txn_id IN OUT NOCOPY number);
24:
25: PROCEDURE insert_interface_errors ( rcv_trx IN OUT NOCOPY rcv_transactions_interface%ROWTYPE,
26: X_column_name IN VARCHAR2,
27: X_err_message IN VARCHAR2);
28:
29: function get_rtv_id(p_transaction_id in number) return number;

Line 350: FROM rcv_transactions_interface

346: return number is
347:
348: CURSOR rcv_get_interface_rows IS
349: SELECT *
350: FROM rcv_transactions_interface
351: WHERE group_id = p_group_id OR group_id = p_group_id2
352: ORDER BY interface_transaction_id;
353:
354: rcv_trx rcv_transactions_interface%ROWTYPE;

Line 354: rcv_trx rcv_transactions_interface%ROWTYPE;

350: FROM rcv_transactions_interface
351: WHERE group_id = p_group_id OR group_id = p_group_id2
352: ORDER BY interface_transaction_id;
353:
354: rcv_trx rcv_transactions_interface%ROWTYPE;
355: x_return number;
356: valid_wip_info NUMBER :=0;
357: X_column_name VARCHAR2(30);
358: X_err_message VARCHAR2(240);

Line 670: Select RCV_TRANSACTIONS_INTERFACE_S.NEXTVAL

666: where rt.transaction_id = p_parent_transaction_id;
667: end if;
668:
669: -- Setting validation flag to Y for ROI
670: Select RCV_TRANSACTIONS_INTERFACE_S.NEXTVAL
671: INTO x_interface_id
672: FROM DUAL;
673:
674: insert into RCV_TRANSACTIONS_INTERFACE

Line 674: insert into RCV_TRANSACTIONS_INTERFACE

670: Select RCV_TRANSACTIONS_INTERFACE_S.NEXTVAL
671: INTO x_interface_id
672: FROM DUAL;
673:
674: insert into RCV_TRANSACTIONS_INTERFACE
675: ( receipt_source_code,
676: interface_transaction_id,
677: group_id,
678: org_id,

Line 1000: PROCEDURE insert_interface_errors ( rcv_trx IN OUT NOCOPY rcv_transactions_interface%ROWTYPE,

996: ** Insert into PO_INTERFACE_ERRORS table
997: */
998:
999:
1000: PROCEDURE insert_interface_errors ( rcv_trx IN OUT NOCOPY rcv_transactions_interface%ROWTYPE,
1001: X_column_name IN VARCHAR2,
1002: X_err_message IN VARCHAR2) as
1003:
1004: X_progress VARCHAR2(3) := '000';