eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CSI_ML_INTERFACE_TXN_PVT dependencies on CSI_DATASTRUCTURES_PUB

Line 81: x_relation_rec OUT NOCOPY csi_datastructures_pub.ii_relationship_rec) IS

77:
78: PROCEDURE check_rel_exists(p_subect_id IN NUMBER,
79: p_object_id IN NUMBER,
80: x_exists OUT NOCOPY BOOLEAN,
81: x_relation_rec OUT NOCOPY csi_datastructures_pub.ii_relationship_rec) IS
82: CURSOR rel_cur(p_sub_id IN NUMBER,
83: p_ob_id IN NUMBER) IS
84: SELECT *
85: FROM csi_ii_relationships

Line 128: c_instance_tbl csi_datastructures_pub.instance_tbl;

124: l_msg_data VARCHAR2(2000);
125: l_error_message VARCHAR2(2000);
126: l_instance_id NUMBER;
127: l_def_usage_code VARCHAR2(30) := 'OUT_OF_ENTERPRISE';
128: c_instance_tbl csi_datastructures_pub.instance_tbl;
129: c_ext_attrib_tbl csi_datastructures_pub.extend_attrib_values_tbl;
130: c_party_tbl csi_datastructures_pub.party_tbl;
131: c_party_contact_tbl csi_ml_util_pvt.party_contact_tbl_type;
132: c_account_tbl csi_datastructures_pub.party_account_tbl;

Line 129: c_ext_attrib_tbl csi_datastructures_pub.extend_attrib_values_tbl;

125: l_error_message VARCHAR2(2000);
126: l_instance_id NUMBER;
127: l_def_usage_code VARCHAR2(30) := 'OUT_OF_ENTERPRISE';
128: c_instance_tbl csi_datastructures_pub.instance_tbl;
129: c_ext_attrib_tbl csi_datastructures_pub.extend_attrib_values_tbl;
130: c_party_tbl csi_datastructures_pub.party_tbl;
131: c_party_contact_tbl csi_ml_util_pvt.party_contact_tbl_type;
132: c_account_tbl csi_datastructures_pub.party_account_tbl;
133: c_price_tbl csi_datastructures_pub.pricing_attribs_tbl;

Line 130: c_party_tbl csi_datastructures_pub.party_tbl;

126: l_instance_id NUMBER;
127: l_def_usage_code VARCHAR2(30) := 'OUT_OF_ENTERPRISE';
128: c_instance_tbl csi_datastructures_pub.instance_tbl;
129: c_ext_attrib_tbl csi_datastructures_pub.extend_attrib_values_tbl;
130: c_party_tbl csi_datastructures_pub.party_tbl;
131: c_party_contact_tbl csi_ml_util_pvt.party_contact_tbl_type;
132: c_account_tbl csi_datastructures_pub.party_account_tbl;
133: c_price_tbl csi_datastructures_pub.pricing_attribs_tbl;
134: c_org_assign_tbl csi_datastructures_pub.organization_units_tbl;

Line 132: c_account_tbl csi_datastructures_pub.party_account_tbl;

128: c_instance_tbl csi_datastructures_pub.instance_tbl;
129: c_ext_attrib_tbl csi_datastructures_pub.extend_attrib_values_tbl;
130: c_party_tbl csi_datastructures_pub.party_tbl;
131: c_party_contact_tbl csi_ml_util_pvt.party_contact_tbl_type;
132: c_account_tbl csi_datastructures_pub.party_account_tbl;
133: c_price_tbl csi_datastructures_pub.pricing_attribs_tbl;
134: c_org_assign_tbl csi_datastructures_pub.organization_units_tbl;
135: c_asset_assignment_tbl csi_datastructures_pub.instance_asset_tbl;
136: c_txn_tbl csi_datastructures_pub.transaction_tbl;

Line 133: c_price_tbl csi_datastructures_pub.pricing_attribs_tbl;

129: c_ext_attrib_tbl csi_datastructures_pub.extend_attrib_values_tbl;
130: c_party_tbl csi_datastructures_pub.party_tbl;
131: c_party_contact_tbl csi_ml_util_pvt.party_contact_tbl_type;
132: c_account_tbl csi_datastructures_pub.party_account_tbl;
133: c_price_tbl csi_datastructures_pub.pricing_attribs_tbl;
134: c_org_assign_tbl csi_datastructures_pub.organization_units_tbl;
135: c_asset_assignment_tbl csi_datastructures_pub.instance_asset_tbl;
136: c_txn_tbl csi_datastructures_pub.transaction_tbl;
137: c_rel_txn_rec csi_datastructures_pub.transaction_rec;

Line 134: c_org_assign_tbl csi_datastructures_pub.organization_units_tbl;

130: c_party_tbl csi_datastructures_pub.party_tbl;
131: c_party_contact_tbl csi_ml_util_pvt.party_contact_tbl_type;
132: c_account_tbl csi_datastructures_pub.party_account_tbl;
133: c_price_tbl csi_datastructures_pub.pricing_attribs_tbl;
134: c_org_assign_tbl csi_datastructures_pub.organization_units_tbl;
135: c_asset_assignment_tbl csi_datastructures_pub.instance_asset_tbl;
136: c_txn_tbl csi_datastructures_pub.transaction_tbl;
137: c_rel_txn_rec csi_datastructures_pub.transaction_rec;
138: c_grp_error_tbl csi_datastructures_pub.grp_error_tbl;

Line 135: c_asset_assignment_tbl csi_datastructures_pub.instance_asset_tbl;

131: c_party_contact_tbl csi_ml_util_pvt.party_contact_tbl_type;
132: c_account_tbl csi_datastructures_pub.party_account_tbl;
133: c_price_tbl csi_datastructures_pub.pricing_attribs_tbl;
134: c_org_assign_tbl csi_datastructures_pub.organization_units_tbl;
135: c_asset_assignment_tbl csi_datastructures_pub.instance_asset_tbl;
136: c_txn_tbl csi_datastructures_pub.transaction_tbl;
137: c_rel_txn_rec csi_datastructures_pub.transaction_rec;
138: c_grp_error_tbl csi_datastructures_pub.grp_error_tbl;
139:

Line 136: c_txn_tbl csi_datastructures_pub.transaction_tbl;

132: c_account_tbl csi_datastructures_pub.party_account_tbl;
133: c_price_tbl csi_datastructures_pub.pricing_attribs_tbl;
134: c_org_assign_tbl csi_datastructures_pub.organization_units_tbl;
135: c_asset_assignment_tbl csi_datastructures_pub.instance_asset_tbl;
136: c_txn_tbl csi_datastructures_pub.transaction_tbl;
137: c_rel_txn_rec csi_datastructures_pub.transaction_rec;
138: c_grp_error_tbl csi_datastructures_pub.grp_error_tbl;
139:
140: u_instance_tbl csi_datastructures_pub.instance_tbl;

Line 137: c_rel_txn_rec csi_datastructures_pub.transaction_rec;

133: c_price_tbl csi_datastructures_pub.pricing_attribs_tbl;
134: c_org_assign_tbl csi_datastructures_pub.organization_units_tbl;
135: c_asset_assignment_tbl csi_datastructures_pub.instance_asset_tbl;
136: c_txn_tbl csi_datastructures_pub.transaction_tbl;
137: c_rel_txn_rec csi_datastructures_pub.transaction_rec;
138: c_grp_error_tbl csi_datastructures_pub.grp_error_tbl;
139:
140: u_instance_tbl csi_datastructures_pub.instance_tbl;
141: u_ext_attrib_tbl csi_datastructures_pub.extend_attrib_values_tbl;

Line 138: c_grp_error_tbl csi_datastructures_pub.grp_error_tbl;

134: c_org_assign_tbl csi_datastructures_pub.organization_units_tbl;
135: c_asset_assignment_tbl csi_datastructures_pub.instance_asset_tbl;
136: c_txn_tbl csi_datastructures_pub.transaction_tbl;
137: c_rel_txn_rec csi_datastructures_pub.transaction_rec;
138: c_grp_error_tbl csi_datastructures_pub.grp_error_tbl;
139:
140: u_instance_tbl csi_datastructures_pub.instance_tbl;
141: u_ext_attrib_tbl csi_datastructures_pub.extend_attrib_values_tbl;
142: u_party_tbl csi_datastructures_pub.party_tbl;

Line 140: u_instance_tbl csi_datastructures_pub.instance_tbl;

136: c_txn_tbl csi_datastructures_pub.transaction_tbl;
137: c_rel_txn_rec csi_datastructures_pub.transaction_rec;
138: c_grp_error_tbl csi_datastructures_pub.grp_error_tbl;
139:
140: u_instance_tbl csi_datastructures_pub.instance_tbl;
141: u_ext_attrib_tbl csi_datastructures_pub.extend_attrib_values_tbl;
142: u_party_tbl csi_datastructures_pub.party_tbl;
143: u_account_tbl csi_datastructures_pub.party_account_tbl;
144: u_price_tbl csi_datastructures_pub.pricing_attribs_tbl;

Line 141: u_ext_attrib_tbl csi_datastructures_pub.extend_attrib_values_tbl;

137: c_rel_txn_rec csi_datastructures_pub.transaction_rec;
138: c_grp_error_tbl csi_datastructures_pub.grp_error_tbl;
139:
140: u_instance_tbl csi_datastructures_pub.instance_tbl;
141: u_ext_attrib_tbl csi_datastructures_pub.extend_attrib_values_tbl;
142: u_party_tbl csi_datastructures_pub.party_tbl;
143: u_account_tbl csi_datastructures_pub.party_account_tbl;
144: u_price_tbl csi_datastructures_pub.pricing_attribs_tbl;
145: u_org_assignments_tbl csi_datastructures_pub.organization_units_tbl;

Line 142: u_party_tbl csi_datastructures_pub.party_tbl;

138: c_grp_error_tbl csi_datastructures_pub.grp_error_tbl;
139:
140: u_instance_tbl csi_datastructures_pub.instance_tbl;
141: u_ext_attrib_tbl csi_datastructures_pub.extend_attrib_values_tbl;
142: u_party_tbl csi_datastructures_pub.party_tbl;
143: u_account_tbl csi_datastructures_pub.party_account_tbl;
144: u_price_tbl csi_datastructures_pub.pricing_attribs_tbl;
145: u_org_assignments_tbl csi_datastructures_pub.organization_units_tbl;
146: u_asset_assignment_tbl csi_datastructures_pub.instance_asset_tbl;

Line 143: u_account_tbl csi_datastructures_pub.party_account_tbl;

139:
140: u_instance_tbl csi_datastructures_pub.instance_tbl;
141: u_ext_attrib_tbl csi_datastructures_pub.extend_attrib_values_tbl;
142: u_party_tbl csi_datastructures_pub.party_tbl;
143: u_account_tbl csi_datastructures_pub.party_account_tbl;
144: u_price_tbl csi_datastructures_pub.pricing_attribs_tbl;
145: u_org_assignments_tbl csi_datastructures_pub.organization_units_tbl;
146: u_asset_assignment_tbl csi_datastructures_pub.instance_asset_tbl;
147: u_txn_rec csi_datastructures_pub.transaction_rec;

Line 144: u_price_tbl csi_datastructures_pub.pricing_attribs_tbl;

140: u_instance_tbl csi_datastructures_pub.instance_tbl;
141: u_ext_attrib_tbl csi_datastructures_pub.extend_attrib_values_tbl;
142: u_party_tbl csi_datastructures_pub.party_tbl;
143: u_account_tbl csi_datastructures_pub.party_account_tbl;
144: u_price_tbl csi_datastructures_pub.pricing_attribs_tbl;
145: u_org_assignments_tbl csi_datastructures_pub.organization_units_tbl;
146: u_asset_assignment_tbl csi_datastructures_pub.instance_asset_tbl;
147: u_txn_rec csi_datastructures_pub.transaction_rec;
148: u_rel_txn_rec csi_datastructures_pub.transaction_rec;

Line 145: u_org_assignments_tbl csi_datastructures_pub.organization_units_tbl;

141: u_ext_attrib_tbl csi_datastructures_pub.extend_attrib_values_tbl;
142: u_party_tbl csi_datastructures_pub.party_tbl;
143: u_account_tbl csi_datastructures_pub.party_account_tbl;
144: u_price_tbl csi_datastructures_pub.pricing_attribs_tbl;
145: u_org_assignments_tbl csi_datastructures_pub.organization_units_tbl;
146: u_asset_assignment_tbl csi_datastructures_pub.instance_asset_tbl;
147: u_txn_rec csi_datastructures_pub.transaction_rec;
148: u_rel_txn_rec csi_datastructures_pub.transaction_rec;
149: u_grp_error_tbl csi_datastructures_pub.grp_upd_error_tbl;

Line 146: u_asset_assignment_tbl csi_datastructures_pub.instance_asset_tbl;

142: u_party_tbl csi_datastructures_pub.party_tbl;
143: u_account_tbl csi_datastructures_pub.party_account_tbl;
144: u_price_tbl csi_datastructures_pub.pricing_attribs_tbl;
145: u_org_assignments_tbl csi_datastructures_pub.organization_units_tbl;
146: u_asset_assignment_tbl csi_datastructures_pub.instance_asset_tbl;
147: u_txn_rec csi_datastructures_pub.transaction_rec;
148: u_rel_txn_rec csi_datastructures_pub.transaction_rec;
149: u_grp_error_tbl csi_datastructures_pub.grp_upd_error_tbl;
150: u_instance_id_lst csi_datastructures_pub.id_tbl;

Line 147: u_txn_rec csi_datastructures_pub.transaction_rec;

143: u_account_tbl csi_datastructures_pub.party_account_tbl;
144: u_price_tbl csi_datastructures_pub.pricing_attribs_tbl;
145: u_org_assignments_tbl csi_datastructures_pub.organization_units_tbl;
146: u_asset_assignment_tbl csi_datastructures_pub.instance_asset_tbl;
147: u_txn_rec csi_datastructures_pub.transaction_rec;
148: u_rel_txn_rec csi_datastructures_pub.transaction_rec;
149: u_grp_error_tbl csi_datastructures_pub.grp_upd_error_tbl;
150: u_instance_id_lst csi_datastructures_pub.id_tbl;
151:

Line 148: u_rel_txn_rec csi_datastructures_pub.transaction_rec;

144: u_price_tbl csi_datastructures_pub.pricing_attribs_tbl;
145: u_org_assignments_tbl csi_datastructures_pub.organization_units_tbl;
146: u_asset_assignment_tbl csi_datastructures_pub.instance_asset_tbl;
147: u_txn_rec csi_datastructures_pub.transaction_rec;
148: u_rel_txn_rec csi_datastructures_pub.transaction_rec;
149: u_grp_error_tbl csi_datastructures_pub.grp_upd_error_tbl;
150: u_instance_id_lst csi_datastructures_pub.id_tbl;
151:
152: g_exc_error EXCEPTION;

Line 149: u_grp_error_tbl csi_datastructures_pub.grp_upd_error_tbl;

145: u_org_assignments_tbl csi_datastructures_pub.organization_units_tbl;
146: u_asset_assignment_tbl csi_datastructures_pub.instance_asset_tbl;
147: u_txn_rec csi_datastructures_pub.transaction_rec;
148: u_rel_txn_rec csi_datastructures_pub.transaction_rec;
149: u_grp_error_tbl csi_datastructures_pub.grp_upd_error_tbl;
150: u_instance_id_lst csi_datastructures_pub.id_tbl;
151:
152: g_exc_error EXCEPTION;
153: g_inst_error EXCEPTION;

Line 150: u_instance_id_lst csi_datastructures_pub.id_tbl;

146: u_asset_assignment_tbl csi_datastructures_pub.instance_asset_tbl;
147: u_txn_rec csi_datastructures_pub.transaction_rec;
148: u_rel_txn_rec csi_datastructures_pub.transaction_rec;
149: u_grp_error_tbl csi_datastructures_pub.grp_upd_error_tbl;
150: u_instance_id_lst csi_datastructures_pub.id_tbl;
151:
152: g_exc_error EXCEPTION;
153: g_inst_error EXCEPTION;
154: g_upd_error EXCEPTION;

Line 162: c_relationship_tbl csi_datastructures_pub.ii_relationship_tbl;

158: l_rel_failure_count NUMBER:=0;
159: l_counter NUMBER:=0;
160:
161:
162: c_relationship_tbl csi_datastructures_pub.ii_relationship_tbl;
163: u_relationship_tbl csi_datastructures_pub.ii_relationship_tbl;
164: l_rel_rec csi_datastructures_pub.ii_relationship_rec;
165: l_exists BOOLEAN;
166: inst_idx PLS_INTEGER;

Line 163: u_relationship_tbl csi_datastructures_pub.ii_relationship_tbl;

159: l_counter NUMBER:=0;
160:
161:
162: c_relationship_tbl csi_datastructures_pub.ii_relationship_tbl;
163: u_relationship_tbl csi_datastructures_pub.ii_relationship_tbl;
164: l_rel_rec csi_datastructures_pub.ii_relationship_rec;
165: l_exists BOOLEAN;
166: inst_idx PLS_INTEGER;
167: prty_idx PLS_INTEGER;

Line 164: l_rel_rec csi_datastructures_pub.ii_relationship_rec;

160:
161:
162: c_relationship_tbl csi_datastructures_pub.ii_relationship_tbl;
163: u_relationship_tbl csi_datastructures_pub.ii_relationship_tbl;
164: l_rel_rec csi_datastructures_pub.ii_relationship_rec;
165: l_exists BOOLEAN;
166: inst_idx PLS_INTEGER;
167: prty_idx PLS_INTEGER;
168: ptyacc_idx PLS_INTEGER;

Line 323: (p_instance_tbl IN csi_datastructures_pub.instance_tbl

319: CURSOR internal_party_cur IS
320: SELECT internal_party_id FROM csi_install_parameters;
321:
322: PROCEDURE UPDATE_INTERFACE_TBL
323: (p_instance_tbl IN csi_datastructures_pub.instance_tbl
324: ,p_grp_error_tbl IN csi_datastructures_pub.grp_error_tbl)
325: IS
326: --
327: l_intf_id_array dbms_sql.Number_Table;

Line 324: ,p_grp_error_tbl IN csi_datastructures_pub.grp_error_tbl)

320: SELECT internal_party_id FROM csi_install_parameters;
321:
322: PROCEDURE UPDATE_INTERFACE_TBL
323: (p_instance_tbl IN csi_datastructures_pub.instance_tbl
324: ,p_grp_error_tbl IN csi_datastructures_pub.grp_error_tbl)
325: IS
326: --
327: l_intf_id_array dbms_sql.Number_Table;
328: l_error_array dbms_sql.Varchar2_Table;

Line 368: (p_instance_tbl IN csi_datastructures_pub.instance_tbl

364: END IF;
365: END UPDATE_INTERFACE_TBL;
366:
367: PROCEDURE UPDATE_INTERFACE_TBL
368: (p_instance_tbl IN csi_datastructures_pub.instance_tbl
369: ,p_grp_upd_error_tbl IN csi_datastructures_pub.grp_upd_error_tbl)
370: IS
371: --
372: l_intf_id_array dbms_sql.Number_Table;

Line 369: ,p_grp_upd_error_tbl IN csi_datastructures_pub.grp_upd_error_tbl)

365: END UPDATE_INTERFACE_TBL;
366:
367: PROCEDURE UPDATE_INTERFACE_TBL
368: (p_instance_tbl IN csi_datastructures_pub.instance_tbl
369: ,p_grp_upd_error_tbl IN csi_datastructures_pub.grp_upd_error_tbl)
370: IS
371: --
372: l_intf_id_array dbms_sql.Number_Table;
373: l_error_array dbms_sql.Varchar2_Table;