DBA Data[Home] [Help]

APPS.CSI_PROCESS_TXN_PVT dependencies on CSI_TXN_SUB_TYPES

Line 173: x_sub_type_rec OUT NOCOPY csi_txn_sub_types%rowtype,

169:
170: PROCEDURE get_sub_type_rec(
171: p_txn_type_id IN number,
172: p_sub_type_id IN number,
173: x_sub_type_rec OUT NOCOPY csi_txn_sub_types%rowtype,
174: x_return_status OUT NOCOPY varchar2)
175: IS
176:
177: l_sub_type_rec csi_txn_sub_types%rowtype;

Line 177: l_sub_type_rec csi_txn_sub_types%rowtype;

173: x_sub_type_rec OUT NOCOPY csi_txn_sub_types%rowtype,
174: x_return_status OUT NOCOPY varchar2)
175: IS
176:
177: l_sub_type_rec csi_txn_sub_types%rowtype;
178:
179: BEGIN
180:
181: x_return_status := fnd_api.g_ret_sts_success;

Line 185: FROM csi_txn_sub_types

181: x_return_status := fnd_api.g_ret_sts_success;
182:
183: SELECT *
184: INTO l_sub_type_rec
185: FROM csi_txn_sub_types
186: WHERE transaction_type_id = p_txn_type_id
187: AND sub_type_id = p_sub_type_id;
188:
189: IF l_sub_type_rec.src_status_id is null THEN

Line 358: p_sub_type_rec IN csi_txn_sub_types%rowtype,

354: /* all the sub type specific validations handled in this routine */
355: /* --------------------------------------------------------------- */
356:
357: PROCEDURE sub_type_validations(
358: p_sub_type_rec IN csi_txn_sub_types%rowtype,
359: p_txn_instances_tbl IN csi_process_txn_grp.txn_instances_tbl,
360: p_txn_i_parties_tbl IN csi_process_txn_grp.txn_i_parties_tbl,
361: x_return_status OUT NOCOPY varchar2)
362: IS

Line 457: p_sub_type_rec IN csi_txn_sub_types%rowtype,

453:
454: PROCEDURE get_item_attributes(
455: p_transaction_id IN number, -- Added for bug#14835893
456: p_in_out_flag IN varchar2,
457: p_sub_type_rec IN csi_txn_sub_types%rowtype,
458: p_inventory_item_id IN number,
459: p_organization_id IN number,
460: p_mtl_transaction_id IN NUMBER,
461: x_item_attr_rec OUT NOCOPY csi_process_txn_pvt.item_attr_rec,

Line 708: p_sub_type_rec IN csi_txn_sub_types%rowtype,

704:
705: PROCEDURE build_instance_query_rec(
706: p_query_criteria IN varchar2,
707: p_in_out_flag IN varchar2,
708: p_sub_type_rec IN csi_txn_sub_types%rowtype,
709: p_instance_rec IN csi_process_txn_grp.txn_instance_rec,
710: p_dest_location_rec IN csi_process_txn_grp.dest_location_rec,
711: p_item_attr_rec IN csi_process_txn_pvt.item_attr_rec,
712: x_instance_query_rec OUT NOCOPY csi_datastructures_pub.instance_query_rec,

Line 1021: p_sub_type_rec IN csi_txn_sub_types%rowtype,

1017: /* ---------------------------------------------------------------------- */
1018:
1019: PROCEDURE get_src_instance_id(
1020: p_in_out_flag IN varchar2,
1021: p_sub_type_rec IN csi_txn_sub_types%rowtype,
1022: p_instance_rec IN csi_process_txn_grp.txn_instance_rec,
1023: p_dest_location_rec IN csi_process_txn_grp.dest_location_rec,
1024: p_item_attr_rec IN csi_process_txn_pvt.item_attr_rec,
1025: p_transaction_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec,

Line 1350: p_sub_type_rec IN csi_txn_sub_types%rowtype,

1346:
1347:
1348: PROCEDURE get_dest_instance_id(
1349: p_in_out_flag IN varchar2,
1350: p_sub_type_rec IN csi_txn_sub_types%rowtype,
1351: p_instance_rec IN csi_process_txn_grp.txn_instance_rec,
1352: p_dest_location_rec IN csi_process_txn_grp.dest_location_rec,
1353: p_item_attr_rec IN csi_process_txn_pvt.item_attr_rec,
1354: x_instance_id OUT NOCOPY number,

Line 1514: p_sub_type_rec IN csi_txn_sub_types%rowtype,

1510: /* for an update based on the availability on the instance record */
1511: /* ---------------------------------------------------------------------*/
1512:
1513: PROCEDURE build_instance_rec(
1514: p_sub_type_rec IN csi_txn_sub_types%rowtype,
1515: p_item_attr_rec IN csi_process_txn_pvt.item_attr_rec,
1516: p_instance_rec IN csi_process_txn_grp.txn_instance_rec,
1517: p_dest_location_rec IN csi_process_txn_grp.dest_location_rec,
1518: x_instance_rec OUT NOCOPY csi_datastructures_pub.instance_rec,

Line 2088: p_sub_type_rec IN csi_txn_sub_types%rowtype,

2084: END build_assets_for_index;
2085:
2086: PROCEDURE get_ids_for_instance(
2087: p_in_out_flag IN varchar2,
2088: p_sub_type_rec IN csi_txn_sub_types%rowtype,
2089: p_instance_rec IN OUT NOCOPY csi_datastructures_pub.instance_rec,
2090: p_parties_tbl IN OUT NOCOPY csi_datastructures_pub.party_tbl,
2091: p_pty_accts_tbl IN OUT NOCOPY csi_datastructures_pub.party_account_tbl,
2092: p_org_units_tbl IN OUT NOCOPY csi_datastructures_pub.organization_units_tbl,

Line 2554: p_sub_type_rec IN csi_txn_sub_types%rowtype,

2550: /* -------------------------------------------------------------------- */
2551:
2552: PROCEDURE process_ib(
2553: p_in_out_flag IN varchar2,
2554: p_sub_type_rec IN csi_txn_sub_types%rowtype,
2555: p_item_attr_rec IN csi_process_txn_pvt.item_attr_rec,
2556: p_instance_index IN binary_integer,
2557: p_dest_location_rec IN csi_process_txn_grp.dest_location_rec,
2558: p_instance_rec IN OUT NOCOPY csi_process_txn_grp.txn_instance_rec,