APPS.CSI_RMA_RECEIPT_PUB dependencies on CSI_TXN_SUB_TYPES

Line 113: x_sub_type_rec OUT NOCOPY csi_txn_sub_types%rowtype,

109: PROCEDURE get_instance_pa_dtls(
110: p_transaction_type_id IN number,
111: p_sub_type_id IN number,
112: px_inst_pa_rec IN OUT NOCOPY inst_pa_rec,
113: x_sub_type_rec OUT NOCOPY csi_txn_sub_types%rowtype,
114: x_return_status OUT NOCOPY varchar2)
115: IS
116: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
117: BEGIN

Line 227: x_sub_type_rec OUT NOCOPY csi_txn_sub_types%rowtype,

223:
224: PROCEDURE get_sub_type_rec(
225: p_transaction_type_id IN number,
226: p_sub_type_id IN number,
227: x_sub_type_rec OUT NOCOPY csi_txn_sub_types%rowtype,
228: x_return_status OUT NOCOPY varchar2)
229: IS
230: BEGIN
231:

Line 238: FROM csi_txn_sub_types

234: x_return_status := fnd_api.g_ret_sts_success;
235:
236: SELECT *
237: INTO x_sub_type_rec
238: FROM csi_txn_sub_types
239: WHERE transaction_type_id = p_transaction_type_id
240: AND sub_type_id = p_sub_type_id;
241:
242: debug(' transaction_type_id :'||x_sub_type_rec.transaction_type_id);

Line 1135: l_sub_type_rec csi_txn_sub_types%rowtype;

1131:
1132: --Hard Coded Values
1133: l_transaction_type_id number := 53;
1134: l_txn_sub_type_id number := 38;
1135: l_sub_type_rec csi_txn_sub_types%rowtype;
1136:
1137: l_internal_party_id number;
1138: l_master_organization_id number;
1139: l_instance_quantity number;

Line 1530: l_sub_type_rec csi_txn_sub_types%rowtype;

1526:
1527: --Hard Coded Values
1528: l_transaction_type_id number := 53;
1529: l_txn_sub_type_id number := 38;
1530: l_sub_type_rec csi_txn_sub_types%rowtype;
1531:
1532: l_internal_party_id number;
1533: l_master_organization_id number;
1534: l_rma_order_rec mtl_trx_type;

Line 2512: l_sub_type_rec csi_txn_sub_types%rowtype;

2508:
2509: -- added shegde
2510: l_src_order_rec source_order_rec;
2511: l_mtl_txn_rec mtl_txn_rec;
2512: l_sub_type_rec csi_txn_sub_types%rowtype;
2513: l_owner_pty_passed varchar2(1) := 'N';
2514: l_owner_act_passed varchar2(1) := 'N';
2515: i_p_ind binary_integer;
2516: i_pa_ind binary_integer;