DBA Data[Home] [Help]

APPS.CSI_PROCESS_TXN_PVT dependencies on CSI_TXN_SUB_TYPES

Line 114: x_sub_type_rec OUT NOCOPY csi_txn_sub_types%rowtype,

110:
111: PROCEDURE get_sub_type_rec(
112: p_txn_type_id IN number,
113: p_sub_type_id IN number,
114: x_sub_type_rec OUT NOCOPY csi_txn_sub_types%rowtype,
115: x_return_status OUT NOCOPY varchar2)
116: IS
117:
118: l_sub_type_rec csi_txn_sub_types%rowtype;

Line 118: l_sub_type_rec csi_txn_sub_types%rowtype;

114: x_sub_type_rec OUT NOCOPY csi_txn_sub_types%rowtype,
115: x_return_status OUT NOCOPY varchar2)
116: IS
117:
118: l_sub_type_rec csi_txn_sub_types%rowtype;
119:
120: BEGIN
121:
122: x_return_status := fnd_api.g_ret_sts_success;

Line 126: FROM csi_txn_sub_types

122: x_return_status := fnd_api.g_ret_sts_success;
123:
124: SELECT *
125: INTO l_sub_type_rec
126: FROM csi_txn_sub_types
127: WHERE transaction_type_id = p_txn_type_id
128: AND sub_type_id = p_sub_type_id;
129:
130: IF l_sub_type_rec.src_status_id is null THEN

Line 299: p_sub_type_rec IN csi_txn_sub_types%rowtype,

295: /* all the sub type specific validations handled in this routine */
296: /* --------------------------------------------------------------- */
297:
298: PROCEDURE sub_type_validations(
299: p_sub_type_rec IN csi_txn_sub_types%rowtype,
300: p_txn_instances_tbl IN csi_process_txn_grp.txn_instances_tbl,
301: p_txn_i_parties_tbl IN csi_process_txn_grp.txn_i_parties_tbl,
302: x_return_status OUT NOCOPY varchar2)
303: IS

Line 397: p_sub_type_rec IN csi_txn_sub_types%rowtype,

393: /* -------------------------------------------------------------------- */
394:
395: PROCEDURE get_item_attributes(
396: p_in_out_flag IN varchar2,
397: p_sub_type_rec IN csi_txn_sub_types%rowtype,
398: p_inventory_item_id IN number,
399: p_organization_id IN number,
400: x_item_attr_rec OUT NOCOPY csi_process_txn_pvt.item_attr_rec,
401: x_return_status OUT NOCOPY varchar2)

Line 608: p_sub_type_rec IN csi_txn_sub_types%rowtype,

604:
605: PROCEDURE build_instance_query_rec(
606: p_query_criteria IN varchar2,
607: p_in_out_flag IN varchar2,
608: p_sub_type_rec IN csi_txn_sub_types%rowtype,
609: p_instance_rec IN csi_process_txn_grp.txn_instance_rec,
610: p_dest_location_rec IN csi_process_txn_grp.dest_location_rec,
611: p_item_attr_rec IN csi_process_txn_pvt.item_attr_rec,
612: x_instance_query_rec OUT NOCOPY csi_datastructures_pub.instance_query_rec,

Line 873: p_sub_type_rec IN csi_txn_sub_types%rowtype,

869: /* ---------------------------------------------------------------------- */
870:
871: PROCEDURE get_src_instance_id(
872: p_in_out_flag IN varchar2,
873: p_sub_type_rec IN csi_txn_sub_types%rowtype,
874: p_instance_rec IN csi_process_txn_grp.txn_instance_rec,
875: p_dest_location_rec IN csi_process_txn_grp.dest_location_rec,
876: p_item_attr_rec IN csi_process_txn_pvt.item_attr_rec,
877: p_transaction_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec,

Line 1139: p_sub_type_rec IN csi_txn_sub_types%rowtype,

1135:
1136:
1137: PROCEDURE get_dest_instance_id(
1138: p_in_out_flag IN varchar2,
1139: p_sub_type_rec IN csi_txn_sub_types%rowtype,
1140: p_instance_rec IN csi_process_txn_grp.txn_instance_rec,
1141: p_dest_location_rec IN csi_process_txn_grp.dest_location_rec,
1142: p_item_attr_rec IN csi_process_txn_pvt.item_attr_rec,
1143: x_instance_id OUT NOCOPY number,

Line 1252: p_sub_type_rec IN csi_txn_sub_types%rowtype,

1248: /* for an update based on the availability on the instance record */
1249: /* ---------------------------------------------------------------------*/
1250:
1251: PROCEDURE build_instance_rec(
1252: p_sub_type_rec IN csi_txn_sub_types%rowtype,
1253: p_item_attr_rec IN csi_process_txn_pvt.item_attr_rec,
1254: p_instance_rec IN csi_process_txn_grp.txn_instance_rec,
1255: p_dest_location_rec IN csi_process_txn_grp.dest_location_rec,
1256: x_instance_rec OUT NOCOPY csi_datastructures_pub.instance_rec,

Line 1826: p_sub_type_rec IN csi_txn_sub_types%rowtype,

1822: END build_assets_for_index;
1823:
1824: PROCEDURE get_ids_for_instance(
1825: p_in_out_flag IN varchar2,
1826: p_sub_type_rec IN csi_txn_sub_types%rowtype,
1827: p_instance_rec IN OUT NOCOPY csi_datastructures_pub.instance_rec,
1828: p_parties_tbl IN OUT NOCOPY csi_datastructures_pub.party_tbl,
1829: p_pty_accts_tbl IN OUT NOCOPY csi_datastructures_pub.party_account_tbl,
1830: p_org_units_tbl IN OUT NOCOPY csi_datastructures_pub.organization_units_tbl,

Line 2292: p_sub_type_rec IN csi_txn_sub_types%rowtype,

2288: /* -------------------------------------------------------------------- */
2289:
2290: PROCEDURE process_ib(
2291: p_in_out_flag IN varchar2,
2292: p_sub_type_rec IN csi_txn_sub_types%rowtype,
2293: p_item_attr_rec IN csi_process_txn_pvt.item_attr_rec,
2294: p_instance_index IN binary_integer,
2295: p_dest_location_rec IN csi_process_txn_grp.dest_location_rec,
2296: p_instance_rec IN OUT NOCOPY csi_process_txn_grp.txn_instance_rec,