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 3601: p_sub_type_rec IN csi_txn_sub_types%rowtype,

3597: END build_instance_set;
3598:
3599: PROCEDURE sub_type_specific_vldns(
3600: p_source_flag IN varchar2,
3601: p_sub_type_rec IN csi_txn_sub_types%rowtype,
3602: p_instance_rec IN csi_datastructures_pub.instance_rec,
3603: p_party_tbl IN csi_datastructures_pub.party_tbl,
3604: p_party_acct_tbl IN csi_datastructures_pub.party_account_tbl,
3605: p_org_units_tbl IN csi_datastructures_pub.organization_units_tbl,

Line 4121: l_sub_type_rec csi_txn_sub_types%rowtype;

4117: l_eav_tbl csi_datastructures_pub.extend_attrib_values_tbl;
4118: l_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;
4119: l_org_units_tbl csi_datastructures_pub.organization_units_tbl;
4120:
4121: l_sub_type_rec csi_txn_sub_types%rowtype;
4122: l_item_attrib_rec item_attributes_rec;
4123:
4124: l_csi_txn_rec csi_datastructures_pub.transaction_rec;
4125:

Line 4286: FROM csi_txn_sub_types

4282: -- get sub_type rec
4283: BEGIN
4284: SELECT *
4285: INTO l_sub_type_rec
4286: FROM csi_txn_sub_types
4287: WHERE transaction_type_id = px_txn_line_rec.source_transaction_type_id
4288: AND sub_type_id = px_txn_line_dtl_tbl(l_td_ind).sub_type_id;
4289: EXCEPTION
4290: WHEN no_data_found THEN