DBA Data[Home] [Help]

APPS.CSI_INTERFACE_PKG dependencies on CSI_TXN_SUB_TYPES

Line 66: FROM csi_txn_sub_types

62:
63: BEGIN
64: SELECT sub_type_id
65: INTO x_sub_type_id
66: FROM csi_txn_sub_types
67: WHERE transaction_type_id = p_transaction_type_id
68: AND default_flag = 'Y';
69: EXCEPTION
70: WHEN no_data_found THEN

Line 3693: p_sub_type_rec IN csi_txn_sub_types%rowtype,

3689: END build_instance_set;
3690:
3691: PROCEDURE sub_type_specific_vldns(
3692: p_source_flag IN varchar2,
3693: p_sub_type_rec IN csi_txn_sub_types%rowtype,
3694: p_instance_rec IN csi_datastructures_pub.instance_rec,
3695: p_party_tbl IN csi_datastructures_pub.party_tbl,
3696: p_party_acct_tbl IN csi_datastructures_pub.party_account_tbl,
3697: p_org_units_tbl IN csi_datastructures_pub.organization_units_tbl,

Line 4213: l_sub_type_rec csi_txn_sub_types%rowtype;

4209: l_eav_tbl csi_datastructures_pub.extend_attrib_values_tbl;
4210: l_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;
4211: l_org_units_tbl csi_datastructures_pub.organization_units_tbl;
4212:
4213: l_sub_type_rec csi_txn_sub_types%rowtype;
4214: l_item_attrib_rec item_attributes_rec;
4215:
4216: l_csi_txn_rec csi_datastructures_pub.transaction_rec;
4217:

Line 4392: FROM csi_txn_sub_types

4388: -- get sub_type rec
4389: BEGIN
4390: SELECT *
4391: INTO l_sub_type_rec
4392: FROM csi_txn_sub_types
4393: WHERE transaction_type_id = px_txn_line_rec.source_transaction_type_id
4394: AND sub_type_id = px_txn_line_dtl_tbl(l_td_ind).sub_type_id;
4395: EXCEPTION
4396: WHEN no_data_found THEN