DBA Data[Home] [Help]

APPS.CSI_PROCESS_TXN_PVT dependencies on CSI_PROCESS_TXN_GRP

Line 74: p_dest_location_rec IN OUT NOCOPY csi_process_txn_grp.dest_location_rec,

70: END get_dfl_inv_location;
71:
72: PROCEDURE validate_dest_location_rec(
73: p_in_out_flag IN varchar2,
74: p_dest_location_rec IN OUT NOCOPY csi_process_txn_grp.dest_location_rec,
75: x_return_status OUT NOCOPY varchar2)
76: IS
77: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
78: BEGIN

Line 87: p_api_name => 'csi_process_txn_grp.process_transaction');

83:
84: csi_t_vldn_routines_pvt.check_reqd_param(
85: p_value => p_dest_location_rec.inv_organization_id,
86: p_param_name => 'p_dest_location_rec.inv_organization_id',
87: p_api_name => 'csi_process_txn_grp.process_transaction');
88:
89: IF p_dest_location_rec.location_type_code = 'INVENTORY' THEN
90:
91: get_dfl_inv_location(

Line 160: p_txn_instances_tbl IN csi_process_txn_grp.txn_instances_tbl,

156: /* --------------------------------------------------------------- */
157:
158: PROCEDURE validate_reference(
159: p_reference_type IN varchar2,
160: p_txn_instances_tbl IN csi_process_txn_grp.txn_instances_tbl,
161: x_return_status OUT NOCOPY varchar2)
162: IS
163: l_reference_found boolean;
164: l_reference_code varchar2(30);

Line 214: p_txn_instances_tbl IN csi_process_txn_grp.txn_instances_tbl,

210:
211: PROCEDURE validate_owner_reference(
212: p_reference_type IN varchar2,
213: p_change_owner_to_code IN varchar2,
214: p_txn_instances_tbl IN csi_process_txn_grp.txn_instances_tbl,
215: p_txn_i_parties_tbl IN csi_process_txn_grp.txn_i_parties_tbl,
216: x_return_status OUT NOCOPY varchar2)
217: IS
218:

Line 215: p_txn_i_parties_tbl IN csi_process_txn_grp.txn_i_parties_tbl,

211: PROCEDURE validate_owner_reference(
212: p_reference_type IN varchar2,
213: p_change_owner_to_code IN varchar2,
214: p_txn_instances_tbl IN csi_process_txn_grp.txn_instances_tbl,
215: p_txn_i_parties_tbl IN csi_process_txn_grp.txn_i_parties_tbl,
216: x_return_status OUT NOCOPY varchar2)
217: IS
218:
219: l_owner_found boolean;

Line 300: p_txn_instances_tbl IN csi_process_txn_grp.txn_instances_tbl,

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
304: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;

Line 301: p_txn_i_parties_tbl IN csi_process_txn_grp.txn_i_parties_tbl,

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
304: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
305: BEGIN

Line 527: p_instance_rec IN csi_process_txn_grp.txn_instance_rec,

523: /* instance from the installed base */
524: /* -------------------------------------------------------------------- */
525:
526: PROCEDURE validate_instance_rec(
527: p_instance_rec IN csi_process_txn_grp.txn_instance_rec,
528: p_item_attr_rec IN csi_process_txn_pvt.item_attr_rec,
529: x_return_status OUT NOCOPY varchar2)
530: IS
531: BEGIN

Line 609: p_instance_rec IN csi_process_txn_grp.txn_instance_rec,

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,
613: x_return_status OUT NOCOPY varchar2)

Line 610: p_dest_location_rec IN csi_process_txn_grp.dest_location_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,
613: x_return_status OUT NOCOPY varchar2)
614: IS

Line 722: p_instance_rec in csi_process_txn_grp.txn_instance_rec,

718: x_return_status := fnd_api.g_ret_sts_error;
719: END get_negative_code;
720:
721: PROCEDURE create_zero_qty_instance(
722: p_instance_rec in csi_process_txn_grp.txn_instance_rec,
723: p_txn_rec in OUT NOCOPY csi_datastructures_pub.transaction_rec,
724: x_instance_id OUT NOCOPY number,
725: x_return_status OUT NOCOPY varchar2)
726: IS

Line 874: p_instance_rec IN csi_process_txn_grp.txn_instance_rec,

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,
878: x_instance_id OUT NOCOPY number,

Line 875: p_dest_location_rec IN csi_process_txn_grp.dest_location_rec,

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,
878: x_instance_id OUT NOCOPY number,
879: x_return_status OUT NOCOPY varchar2)

Line 1140: p_instance_rec IN csi_process_txn_grp.txn_instance_rec,

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,
1144: x_return_status OUT NOCOPY varchar2)

Line 1141: p_dest_location_rec IN csi_process_txn_grp.dest_location_rec,

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,
1144: x_return_status OUT NOCOPY varchar2)
1145:

Line 1254: p_instance_rec IN csi_process_txn_grp.txn_instance_rec,

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,
1257: x_process_mode OUT NOCOPY varchar2,
1258: x_return_status OUT NOCOPY varchar2)

Line 1255: p_dest_location_rec IN csi_process_txn_grp.dest_location_rec,

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,
1257: x_process_mode OUT NOCOPY varchar2,
1258: x_return_status OUT NOCOPY varchar2)
1259: IS

Line 1384: p_i_parties_tbl IN csi_process_txn_grp.txn_i_parties_tbl,

1380: /* --------------------------------------------------------------------- */
1381:
1382: PROCEDURE build_parties_for_index(
1383: p_instance_index IN binary_integer,
1384: p_i_parties_tbl IN csi_process_txn_grp.txn_i_parties_tbl,
1385: p_ip_accounts_tbl IN csi_process_txn_grp.txn_ip_accounts_tbl,
1386: x_parties_tbl OUT NOCOPY csi_datastructures_pub.party_tbl,
1387: x_pty_accts_tbl OUT NOCOPY csi_datastructures_pub.party_account_tbl,
1388: x_return_status OUT NOCOPY varchar2)

Line 1385: p_ip_accounts_tbl IN csi_process_txn_grp.txn_ip_accounts_tbl,

1381:
1382: PROCEDURE build_parties_for_index(
1383: p_instance_index IN binary_integer,
1384: p_i_parties_tbl IN csi_process_txn_grp.txn_i_parties_tbl,
1385: p_ip_accounts_tbl IN csi_process_txn_grp.txn_ip_accounts_tbl,
1386: x_parties_tbl OUT NOCOPY csi_datastructures_pub.party_tbl,
1387: x_pty_accts_tbl OUT NOCOPY csi_datastructures_pub.party_account_tbl,
1388: x_return_status OUT NOCOPY varchar2)
1389: IS

Line 1505: p_ext_attrib_vals_tbl IN csi_process_txn_grp.txn_ext_attrib_values_tbl,

1501: /* --------------------------------------------------------------------- */
1502:
1503: PROCEDURE build_ext_vals_for_index(
1504: p_instance_index IN binary_integer,
1505: p_ext_attrib_vals_tbl IN csi_process_txn_grp.txn_ext_attrib_values_tbl,
1506: x_ea_values_tbl OUT NOCOPY csi_datastructures_pub.extend_attrib_values_tbl,
1507: x_return_status OUT NOCOPY varchar2)
1508: IS
1509: l_eav_tbl csi_datastructures_pub.extend_attrib_values_tbl;

Line 1566: p_pricing_attribs_tbl IN csi_process_txn_grp.txn_pricing_attribs_tbl,

1562: /* --------------------------------------------------------------------- */
1563:
1564: PROCEDURE build_price_tbl_for_index(
1565: p_instance_index IN binary_integer,
1566: p_pricing_attribs_tbl IN csi_process_txn_grp.txn_pricing_attribs_tbl,
1567: x_pricing_tbl OUT NOCOPY csi_datastructures_pub.pricing_attribs_tbl,
1568: x_return_status OUT NOCOPY varchar2)
1569: IS
1570: l_price_tbl csi_datastructures_pub.pricing_attribs_tbl;

Line 1725: p_org_units_tbl IN csi_process_txn_grp.txn_org_units_tbl,

1721: /* --------------------------------------------------------------------- */
1722:
1723: PROCEDURE build_org_units_for_index(
1724: p_instance_index IN binary_integer,
1725: p_org_units_tbl IN csi_process_txn_grp.txn_org_units_tbl,
1726: x_org_units_tbl OUT NOCOPY csi_datastructures_pub.organization_units_tbl,
1727: x_return_status OUT NOCOPY varchar2)
1728: IS
1729: c_ind binary_integer;

Line 1786: p_instance_asset_tbl IN csi_process_txn_grp.txn_instance_asset_tbl,

1782: /* --------------------------------------------------------------------- */
1783:
1784: PROCEDURE build_assets_for_index(
1785: p_instance_index IN binary_integer,
1786: p_instance_asset_tbl IN csi_process_txn_grp.txn_instance_asset_tbl,
1787: x_assets_tbl OUT NOCOPY csi_datastructures_pub.instance_asset_tbl,
1788: x_return_status OUT NOCOPY varchar2)
1789: IS
1790: c_ind binary_integer;

Line 2295: p_dest_location_rec IN csi_process_txn_grp.dest_location_rec,

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,
2297: p_i_parties_tbl IN OUT NOCOPY csi_process_txn_grp.txn_i_parties_tbl,
2298: p_ip_accounts_tbl IN OUT NOCOPY csi_process_txn_grp.txn_ip_accounts_tbl,
2299: p_ext_attrib_vals_tbl IN OUT NOCOPY csi_process_txn_grp.txn_ext_attrib_values_tbl,

Line 2296: p_instance_rec IN OUT NOCOPY csi_process_txn_grp.txn_instance_rec,

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,
2297: p_i_parties_tbl IN OUT NOCOPY csi_process_txn_grp.txn_i_parties_tbl,
2298: p_ip_accounts_tbl IN OUT NOCOPY csi_process_txn_grp.txn_ip_accounts_tbl,
2299: p_ext_attrib_vals_tbl IN OUT NOCOPY csi_process_txn_grp.txn_ext_attrib_values_tbl,
2300: p_pricing_attribs_tbl IN OUT NOCOPY csi_process_txn_grp.txn_pricing_attribs_tbl,

Line 2297: p_i_parties_tbl IN OUT NOCOPY csi_process_txn_grp.txn_i_parties_tbl,

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,
2297: p_i_parties_tbl IN OUT NOCOPY csi_process_txn_grp.txn_i_parties_tbl,
2298: p_ip_accounts_tbl IN OUT NOCOPY csi_process_txn_grp.txn_ip_accounts_tbl,
2299: p_ext_attrib_vals_tbl IN OUT NOCOPY csi_process_txn_grp.txn_ext_attrib_values_tbl,
2300: p_pricing_attribs_tbl IN OUT NOCOPY csi_process_txn_grp.txn_pricing_attribs_tbl,
2301: p_org_units_tbl IN OUT NOCOPY csi_process_txn_grp.txn_org_units_tbl,

Line 2298: p_ip_accounts_tbl IN OUT NOCOPY csi_process_txn_grp.txn_ip_accounts_tbl,

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,
2297: p_i_parties_tbl IN OUT NOCOPY csi_process_txn_grp.txn_i_parties_tbl,
2298: p_ip_accounts_tbl IN OUT NOCOPY csi_process_txn_grp.txn_ip_accounts_tbl,
2299: p_ext_attrib_vals_tbl IN OUT NOCOPY csi_process_txn_grp.txn_ext_attrib_values_tbl,
2300: p_pricing_attribs_tbl IN OUT NOCOPY csi_process_txn_grp.txn_pricing_attribs_tbl,
2301: p_org_units_tbl IN OUT NOCOPY csi_process_txn_grp.txn_org_units_tbl,
2302: p_instance_asset_tbl IN OUT NOCOPY csi_process_txn_grp.txn_instance_asset_tbl,

Line 2299: p_ext_attrib_vals_tbl IN OUT NOCOPY csi_process_txn_grp.txn_ext_attrib_values_tbl,

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,
2297: p_i_parties_tbl IN OUT NOCOPY csi_process_txn_grp.txn_i_parties_tbl,
2298: p_ip_accounts_tbl IN OUT NOCOPY csi_process_txn_grp.txn_ip_accounts_tbl,
2299: p_ext_attrib_vals_tbl IN OUT NOCOPY csi_process_txn_grp.txn_ext_attrib_values_tbl,
2300: p_pricing_attribs_tbl IN OUT NOCOPY csi_process_txn_grp.txn_pricing_attribs_tbl,
2301: p_org_units_tbl IN OUT NOCOPY csi_process_txn_grp.txn_org_units_tbl,
2302: p_instance_asset_tbl IN OUT NOCOPY csi_process_txn_grp.txn_instance_asset_tbl,
2303: p_transaction_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec,

Line 2300: p_pricing_attribs_tbl IN OUT NOCOPY csi_process_txn_grp.txn_pricing_attribs_tbl,

2296: p_instance_rec IN OUT NOCOPY csi_process_txn_grp.txn_instance_rec,
2297: p_i_parties_tbl IN OUT NOCOPY csi_process_txn_grp.txn_i_parties_tbl,
2298: p_ip_accounts_tbl IN OUT NOCOPY csi_process_txn_grp.txn_ip_accounts_tbl,
2299: p_ext_attrib_vals_tbl IN OUT NOCOPY csi_process_txn_grp.txn_ext_attrib_values_tbl,
2300: p_pricing_attribs_tbl IN OUT NOCOPY csi_process_txn_grp.txn_pricing_attribs_tbl,
2301: p_org_units_tbl IN OUT NOCOPY csi_process_txn_grp.txn_org_units_tbl,
2302: p_instance_asset_tbl IN OUT NOCOPY csi_process_txn_grp.txn_instance_asset_tbl,
2303: p_transaction_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec,
2304: px_txn_error_rec IN OUT NOCOPY csi_datastructures_pub.transaction_error_rec,

Line 2301: p_org_units_tbl IN OUT NOCOPY csi_process_txn_grp.txn_org_units_tbl,

2297: p_i_parties_tbl IN OUT NOCOPY csi_process_txn_grp.txn_i_parties_tbl,
2298: p_ip_accounts_tbl IN OUT NOCOPY csi_process_txn_grp.txn_ip_accounts_tbl,
2299: p_ext_attrib_vals_tbl IN OUT NOCOPY csi_process_txn_grp.txn_ext_attrib_values_tbl,
2300: p_pricing_attribs_tbl IN OUT NOCOPY csi_process_txn_grp.txn_pricing_attribs_tbl,
2301: p_org_units_tbl IN OUT NOCOPY csi_process_txn_grp.txn_org_units_tbl,
2302: p_instance_asset_tbl IN OUT NOCOPY csi_process_txn_grp.txn_instance_asset_tbl,
2303: p_transaction_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec,
2304: px_txn_error_rec IN OUT NOCOPY csi_datastructures_pub.transaction_error_rec,
2305: x_return_status OUT NOCOPY varchar2)

Line 2302: p_instance_asset_tbl IN OUT NOCOPY csi_process_txn_grp.txn_instance_asset_tbl,

2298: p_ip_accounts_tbl IN OUT NOCOPY csi_process_txn_grp.txn_ip_accounts_tbl,
2299: p_ext_attrib_vals_tbl IN OUT NOCOPY csi_process_txn_grp.txn_ext_attrib_values_tbl,
2300: p_pricing_attribs_tbl IN OUT NOCOPY csi_process_txn_grp.txn_pricing_attribs_tbl,
2301: p_org_units_tbl IN OUT NOCOPY csi_process_txn_grp.txn_org_units_tbl,
2302: p_instance_asset_tbl IN OUT NOCOPY csi_process_txn_grp.txn_instance_asset_tbl,
2303: p_transaction_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec,
2304: px_txn_error_rec IN OUT NOCOPY csi_datastructures_pub.transaction_error_rec,
2305: x_return_status OUT NOCOPY varchar2)
2306:

Line 3837: p_txn_ii_rltns_rec IN csi_process_txn_grp.txn_ii_relationship_rec,

3833: /* output can be passed to create relationships */
3834: /* ----------------------------------------------------------------------- */
3835:
3836: PROCEDURE build_ii_rltns_rec(
3837: p_txn_ii_rltns_rec IN csi_process_txn_grp.txn_ii_relationship_rec,
3838: p_instances_tbl IN csi_process_txn_grp.txn_instances_tbl,
3839: x_ii_rltns_rec OUT NOCOPY csi_datastructures_pub.ii_relationship_rec,
3840: x_return_status OUT NOCOPY varchar2)
3841: IS

Line 3838: p_instances_tbl IN csi_process_txn_grp.txn_instances_tbl,

3834: /* ----------------------------------------------------------------------- */
3835:
3836: PROCEDURE build_ii_rltns_rec(
3837: p_txn_ii_rltns_rec IN csi_process_txn_grp.txn_ii_relationship_rec,
3838: p_instances_tbl IN csi_process_txn_grp.txn_instances_tbl,
3839: x_ii_rltns_rec OUT NOCOPY csi_datastructures_pub.ii_relationship_rec,
3840: x_return_status OUT NOCOPY varchar2)
3841: IS
3842:

Line 3919: p_instances_tbl IN csi_process_txn_grp.txn_instances_tbl,

3915: /* the realtion in the the Installed Base */
3916: /* -------------------------------------------------------------------- */
3917:
3918: PROCEDURE process_relation(
3919: p_instances_tbl IN csi_process_txn_grp.txn_instances_tbl,
3920: p_ii_relationships_tbl IN csi_process_txn_grp.txn_ii_relationships_tbl,
3921: p_transaction_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec,
3922: x_return_status OUT NOCOPY varchar2)
3923: IS

Line 3920: p_ii_relationships_tbl IN csi_process_txn_grp.txn_ii_relationships_tbl,

3916: /* -------------------------------------------------------------------- */
3917:
3918: PROCEDURE process_relation(
3919: p_instances_tbl IN csi_process_txn_grp.txn_instances_tbl,
3920: p_ii_relationships_tbl IN csi_process_txn_grp.txn_ii_relationships_tbl,
3921: p_transaction_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec,
3922: x_return_status OUT NOCOPY varchar2)
3923: IS
3924: