23:
24:
25: PROCEDURE sub_type_validations(
26: p_sub_type_rec IN csi_txn_sub_types%rowtype,
27: p_txn_instances_tbl IN csi_process_txn_grp.txn_instances_tbl,
28: p_txn_i_parties_tbl IN csi_process_txn_grp.txn_i_parties_tbl,
29: x_return_status OUT NOCOPY varchar2);
30:
31:
24:
25: PROCEDURE sub_type_validations(
26: p_sub_type_rec IN csi_txn_sub_types%rowtype,
27: p_txn_instances_tbl IN csi_process_txn_grp.txn_instances_tbl,
28: p_txn_i_parties_tbl IN csi_process_txn_grp.txn_i_parties_tbl,
29: x_return_status OUT NOCOPY varchar2);
30:
31:
32: PROCEDURE validate_dest_location_rec(
30:
31:
32: PROCEDURE validate_dest_location_rec(
33: p_in_out_flag IN varchar2,
34: p_dest_location_rec IN OUT NOCOPY csi_process_txn_grp.dest_location_rec,
35: x_return_status OUT NOCOPY varchar2);
36:
37:
38: PROCEDURE get_item_attributes(
46:
47: PROCEDURE get_src_instance_id(
48: p_in_out_flag IN varchar2,
49: p_sub_type_rec IN csi_txn_sub_types%rowtype,
50: p_instance_rec IN csi_process_txn_grp.txn_instance_rec,
51: p_dest_location_rec IN csi_process_txn_grp.dest_location_rec,
52: p_item_attr_rec IN csi_process_txn_pvt.item_attr_rec,
53: p_transaction_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec,
54: x_instance_id OUT NOCOPY number,
47: PROCEDURE get_src_instance_id(
48: p_in_out_flag IN varchar2,
49: p_sub_type_rec IN csi_txn_sub_types%rowtype,
50: p_instance_rec IN csi_process_txn_grp.txn_instance_rec,
51: p_dest_location_rec IN csi_process_txn_grp.dest_location_rec,
52: p_item_attr_rec IN csi_process_txn_pvt.item_attr_rec,
53: p_transaction_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec,
54: x_instance_id OUT NOCOPY number,
55: x_return_status OUT NOCOPY varchar2);
56:
57: PROCEDURE get_dest_instance_id(
58: p_in_out_flag IN varchar2,
59: p_sub_type_rec IN csi_txn_sub_types%rowtype,
60: p_instance_rec IN csi_process_txn_grp.txn_instance_rec,
61: p_dest_location_rec IN csi_process_txn_grp.dest_location_rec,
62: p_item_attr_rec IN csi_process_txn_pvt.item_attr_rec,
63: x_instance_id OUT NOCOPY number,
64: x_return_status OUT NOCOPY varchar2);
57: PROCEDURE get_dest_instance_id(
58: p_in_out_flag IN varchar2,
59: p_sub_type_rec IN csi_txn_sub_types%rowtype,
60: p_instance_rec IN csi_process_txn_grp.txn_instance_rec,
61: p_dest_location_rec IN csi_process_txn_grp.dest_location_rec,
62: p_item_attr_rec IN csi_process_txn_pvt.item_attr_rec,
63: x_instance_id OUT NOCOPY number,
64: x_return_status OUT NOCOPY varchar2);
65:
67: p_in_out_flag IN varchar2,
68: p_sub_type_rec IN csi_txn_sub_types%rowtype,
69: p_item_attr_rec IN csi_process_txn_pvt.item_attr_rec,
70: p_instance_index IN binary_integer,
71: p_dest_location_rec IN csi_process_txn_grp.dest_location_rec,
72: p_instance_rec IN OUT NOCOPY csi_process_txn_grp.txn_instance_rec,
73: p_i_parties_tbl IN OUT NOCOPY csi_process_txn_grp.txn_i_parties_tbl,
74: p_ip_accounts_tbl IN OUT NOCOPY csi_process_txn_grp.txn_ip_accounts_tbl,
75: p_ext_attrib_vals_tbl IN OUT NOCOPY csi_process_txn_grp.txn_ext_attrib_values_tbl,
68: p_sub_type_rec IN csi_txn_sub_types%rowtype,
69: p_item_attr_rec IN csi_process_txn_pvt.item_attr_rec,
70: p_instance_index IN binary_integer,
71: p_dest_location_rec IN csi_process_txn_grp.dest_location_rec,
72: p_instance_rec IN OUT NOCOPY csi_process_txn_grp.txn_instance_rec,
73: p_i_parties_tbl IN OUT NOCOPY csi_process_txn_grp.txn_i_parties_tbl,
74: p_ip_accounts_tbl IN OUT NOCOPY csi_process_txn_grp.txn_ip_accounts_tbl,
75: p_ext_attrib_vals_tbl IN OUT NOCOPY csi_process_txn_grp.txn_ext_attrib_values_tbl,
76: p_pricing_attribs_tbl IN OUT NOCOPY csi_process_txn_grp.txn_pricing_attribs_tbl,
69: p_item_attr_rec IN csi_process_txn_pvt.item_attr_rec,
70: p_instance_index IN binary_integer,
71: p_dest_location_rec IN csi_process_txn_grp.dest_location_rec,
72: p_instance_rec IN OUT NOCOPY csi_process_txn_grp.txn_instance_rec,
73: p_i_parties_tbl IN OUT NOCOPY csi_process_txn_grp.txn_i_parties_tbl,
74: p_ip_accounts_tbl IN OUT NOCOPY csi_process_txn_grp.txn_ip_accounts_tbl,
75: p_ext_attrib_vals_tbl IN OUT NOCOPY csi_process_txn_grp.txn_ext_attrib_values_tbl,
76: p_pricing_attribs_tbl IN OUT NOCOPY csi_process_txn_grp.txn_pricing_attribs_tbl,
77: p_org_units_tbl IN OUT NOCOPY csi_process_txn_grp.txn_org_units_tbl,
70: p_instance_index IN binary_integer,
71: p_dest_location_rec IN csi_process_txn_grp.dest_location_rec,
72: p_instance_rec IN OUT NOCOPY csi_process_txn_grp.txn_instance_rec,
73: p_i_parties_tbl IN OUT NOCOPY csi_process_txn_grp.txn_i_parties_tbl,
74: p_ip_accounts_tbl IN OUT NOCOPY csi_process_txn_grp.txn_ip_accounts_tbl,
75: p_ext_attrib_vals_tbl IN OUT NOCOPY csi_process_txn_grp.txn_ext_attrib_values_tbl,
76: p_pricing_attribs_tbl IN OUT NOCOPY csi_process_txn_grp.txn_pricing_attribs_tbl,
77: p_org_units_tbl IN OUT NOCOPY csi_process_txn_grp.txn_org_units_tbl,
78: p_instance_asset_tbl IN OUT NOCOPY csi_process_txn_grp.txn_instance_asset_tbl,
71: p_dest_location_rec IN csi_process_txn_grp.dest_location_rec,
72: p_instance_rec IN OUT NOCOPY csi_process_txn_grp.txn_instance_rec,
73: p_i_parties_tbl IN OUT NOCOPY csi_process_txn_grp.txn_i_parties_tbl,
74: p_ip_accounts_tbl IN OUT NOCOPY csi_process_txn_grp.txn_ip_accounts_tbl,
75: p_ext_attrib_vals_tbl IN OUT NOCOPY csi_process_txn_grp.txn_ext_attrib_values_tbl,
76: p_pricing_attribs_tbl IN OUT NOCOPY csi_process_txn_grp.txn_pricing_attribs_tbl,
77: p_org_units_tbl IN OUT NOCOPY csi_process_txn_grp.txn_org_units_tbl,
78: p_instance_asset_tbl IN OUT NOCOPY csi_process_txn_grp.txn_instance_asset_tbl,
79: p_transaction_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec,
72: p_instance_rec IN OUT NOCOPY csi_process_txn_grp.txn_instance_rec,
73: p_i_parties_tbl IN OUT NOCOPY csi_process_txn_grp.txn_i_parties_tbl,
74: p_ip_accounts_tbl IN OUT NOCOPY csi_process_txn_grp.txn_ip_accounts_tbl,
75: p_ext_attrib_vals_tbl IN OUT NOCOPY csi_process_txn_grp.txn_ext_attrib_values_tbl,
76: p_pricing_attribs_tbl IN OUT NOCOPY csi_process_txn_grp.txn_pricing_attribs_tbl,
77: p_org_units_tbl IN OUT NOCOPY csi_process_txn_grp.txn_org_units_tbl,
78: p_instance_asset_tbl IN OUT NOCOPY csi_process_txn_grp.txn_instance_asset_tbl,
79: p_transaction_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec,
80: px_txn_error_rec IN OUT NOCOPY csi_datastructures_pub.transaction_error_rec,
73: p_i_parties_tbl IN OUT NOCOPY csi_process_txn_grp.txn_i_parties_tbl,
74: p_ip_accounts_tbl IN OUT NOCOPY csi_process_txn_grp.txn_ip_accounts_tbl,
75: p_ext_attrib_vals_tbl IN OUT NOCOPY csi_process_txn_grp.txn_ext_attrib_values_tbl,
76: p_pricing_attribs_tbl IN OUT NOCOPY csi_process_txn_grp.txn_pricing_attribs_tbl,
77: p_org_units_tbl IN OUT NOCOPY csi_process_txn_grp.txn_org_units_tbl,
78: p_instance_asset_tbl IN OUT NOCOPY csi_process_txn_grp.txn_instance_asset_tbl,
79: p_transaction_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec,
80: px_txn_error_rec IN OUT NOCOPY csi_datastructures_pub.transaction_error_rec,
81: x_return_status OUT NOCOPY varchar2);
74: p_ip_accounts_tbl IN OUT NOCOPY csi_process_txn_grp.txn_ip_accounts_tbl,
75: p_ext_attrib_vals_tbl IN OUT NOCOPY csi_process_txn_grp.txn_ext_attrib_values_tbl,
76: p_pricing_attribs_tbl IN OUT NOCOPY csi_process_txn_grp.txn_pricing_attribs_tbl,
77: p_org_units_tbl IN OUT NOCOPY csi_process_txn_grp.txn_org_units_tbl,
78: p_instance_asset_tbl IN OUT NOCOPY csi_process_txn_grp.txn_instance_asset_tbl,
79: p_transaction_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec,
80: px_txn_error_rec IN OUT NOCOPY csi_datastructures_pub.transaction_error_rec,
81: x_return_status OUT NOCOPY varchar2);
82:
81: x_return_status OUT NOCOPY varchar2);
82:
83:
84: PROCEDURE process_relation(
85: p_instances_tbl IN csi_process_txn_grp.txn_instances_tbl,
86: p_ii_relationships_tbl IN csi_process_txn_grp.txn_ii_relationships_tbl,
87: p_transaction_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec,
88: x_return_status OUT NOCOPY varchar2);
89:
82:
83:
84: PROCEDURE process_relation(
85: p_instances_tbl IN csi_process_txn_grp.txn_instances_tbl,
86: p_ii_relationships_tbl IN csi_process_txn_grp.txn_ii_relationships_tbl,
87: p_transaction_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec,
88: x_return_status OUT NOCOPY varchar2);
89:
90: -- Moved the check and break routine from rma receipt pub to avoid circular dependancy introduced in that routine for bug 2373109 and also to not load rma receipt for Non RMA txns . shegde. Bug 2443204