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 1143: l_sub_type_rec csi_txn_sub_types%rowtype;

1139:
1140: --Hard Coded Values
1141: l_transaction_type_id number := 53;
1142: l_txn_sub_type_id number := 38;
1143: l_sub_type_rec csi_txn_sub_types%rowtype;
1144:
1145: l_internal_party_id number;
1146: l_master_organization_id number;
1147: l_instance_quantity number;

Line 1538: l_sub_type_rec csi_txn_sub_types%rowtype;

1534:
1535: --Hard Coded Values
1536: l_transaction_type_id number := 53;
1537: l_txn_sub_type_id number := 38;
1538: l_sub_type_rec csi_txn_sub_types%rowtype;
1539:
1540: l_internal_party_id number;
1541: l_master_organization_id number;
1542: l_rma_order_rec mtl_trx_type;

Line 2551: l_sub_type_rec csi_txn_sub_types%rowtype;

2547:
2548: -- added shegde
2549: l_src_order_rec source_order_rec;
2550: l_mtl_txn_rec mtl_txn_rec;
2551: l_sub_type_rec csi_txn_sub_types%rowtype;
2552: l_owner_pty_passed varchar2(1) := 'N';
2553: l_owner_act_passed varchar2(1) := 'N';
2554: i_p_ind binary_integer;
2555: i_pa_ind binary_integer;