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_EXT_CONTACTS_PKG dependencies on CSI_DATASTRUCTURES_PUB

Line 49: X_party_tbl OUT NOCOPY csi_datastructures_pub.party_tbl) IS

45: P_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
46: P_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
47: P_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
48: P_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
49: X_party_tbl OUT NOCOPY csi_datastructures_pub.party_tbl) IS
50: CURSOR CONTACT_IP(P_INSTANCE_ID NUMBER ) IS
51: select instance_party_id
52: from csi_i_parties
53: where instance_id=P_INSTANCE_ID

Line 122: l_Party_Tbl CSI_DATASTRUCTURES_PUB.Party_Tbl;

118: x_msg_data OUT NOCOPY VARCHAR,
119: x_object_version_number OUT NOCOPY NUMBER
120: )
121: IS
122: l_Party_Tbl CSI_DATASTRUCTURES_PUB.Party_Tbl;
123: l_Party_Account_Tbl CSI_DATASTRUCTURES_PUB.Party_Account_Tbl;
124: l_Txn_Rec CSI_DATASTRUCTURES_PUB.Transaction_Rec;
125: l_Api_Version NUMBER DEFAULT 1;
126: l_api_name CONSTANT VARCHAR2(30) := 'Insert_Row';

Line 123: l_Party_Account_Tbl CSI_DATASTRUCTURES_PUB.Party_Account_Tbl;

119: x_object_version_number OUT NOCOPY NUMBER
120: )
121: IS
122: l_Party_Tbl CSI_DATASTRUCTURES_PUB.Party_Tbl;
123: l_Party_Account_Tbl CSI_DATASTRUCTURES_PUB.Party_Account_Tbl;
124: l_Txn_Rec CSI_DATASTRUCTURES_PUB.Transaction_Rec;
125: l_Api_Version NUMBER DEFAULT 1;
126: l_api_name CONSTANT VARCHAR2(30) := 'Insert_Row';
127: l_Commit VARCHAR2(1) := FND_API.G_FALSE;

Line 124: l_Txn_Rec CSI_DATASTRUCTURES_PUB.Transaction_Rec;

120: )
121: IS
122: l_Party_Tbl CSI_DATASTRUCTURES_PUB.Party_Tbl;
123: l_Party_Account_Tbl CSI_DATASTRUCTURES_PUB.Party_Account_Tbl;
124: l_Txn_Rec CSI_DATASTRUCTURES_PUB.Transaction_Rec;
125: l_Api_Version NUMBER DEFAULT 1;
126: l_api_name CONSTANT VARCHAR2(30) := 'Insert_Row';
127: l_Commit VARCHAR2(1) := FND_API.G_FALSE;
128: l_Init_Msg_List VARCHAR2(1) := FND_API.G_FALSE;

Line 134: l_chg_instance_rec csi_datastructures_pub.instance_rec;

130: l_Return_Status VARCHAR2(1);
131: l_Msg_Index NUMBER;
132:
133: -- added as part of fix for Bug 2733128
134: l_chg_instance_rec csi_datastructures_pub.instance_rec;
135: l_chg_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;
136: l_chg_ext_attrib_val_tbl csi_datastructures_pub.extend_attrib_values_tbl;
137: l_chg_org_units_tbl csi_datastructures_pub.organization_units_tbl;
138: l_chg_inst_asset_tbl csi_datastructures_pub.instance_asset_tbl;

Line 135: l_chg_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;

131: l_Msg_Index NUMBER;
132:
133: -- added as part of fix for Bug 2733128
134: l_chg_instance_rec csi_datastructures_pub.instance_rec;
135: l_chg_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;
136: l_chg_ext_attrib_val_tbl csi_datastructures_pub.extend_attrib_values_tbl;
137: l_chg_org_units_tbl csi_datastructures_pub.organization_units_tbl;
138: l_chg_inst_asset_tbl csi_datastructures_pub.instance_asset_tbl;
139: l_chg_inst_id_lst csi_datastructures_pub.id_tbl;

Line 136: l_chg_ext_attrib_val_tbl csi_datastructures_pub.extend_attrib_values_tbl;

132:
133: -- added as part of fix for Bug 2733128
134: l_chg_instance_rec csi_datastructures_pub.instance_rec;
135: l_chg_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;
136: l_chg_ext_attrib_val_tbl csi_datastructures_pub.extend_attrib_values_tbl;
137: l_chg_org_units_tbl csi_datastructures_pub.organization_units_tbl;
138: l_chg_inst_asset_tbl csi_datastructures_pub.instance_asset_tbl;
139: l_chg_inst_id_lst csi_datastructures_pub.id_tbl;
140:

Line 137: l_chg_org_units_tbl csi_datastructures_pub.organization_units_tbl;

133: -- added as part of fix for Bug 2733128
134: l_chg_instance_rec csi_datastructures_pub.instance_rec;
135: l_chg_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;
136: l_chg_ext_attrib_val_tbl csi_datastructures_pub.extend_attrib_values_tbl;
137: l_chg_org_units_tbl csi_datastructures_pub.organization_units_tbl;
138: l_chg_inst_asset_tbl csi_datastructures_pub.instance_asset_tbl;
139: l_chg_inst_id_lst csi_datastructures_pub.id_tbl;
140:
141: BEGIN

Line 138: l_chg_inst_asset_tbl csi_datastructures_pub.instance_asset_tbl;

134: l_chg_instance_rec csi_datastructures_pub.instance_rec;
135: l_chg_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;
136: l_chg_ext_attrib_val_tbl csi_datastructures_pub.extend_attrib_values_tbl;
137: l_chg_org_units_tbl csi_datastructures_pub.organization_units_tbl;
138: l_chg_inst_asset_tbl csi_datastructures_pub.instance_asset_tbl;
139: l_chg_inst_id_lst csi_datastructures_pub.id_tbl;
140:
141: BEGIN
142: Convert_Contact_Param_To_Rec(

Line 139: l_chg_inst_id_lst csi_datastructures_pub.id_tbl;

135: l_chg_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;
136: l_chg_ext_attrib_val_tbl csi_datastructures_pub.extend_attrib_values_tbl;
137: l_chg_org_units_tbl csi_datastructures_pub.organization_units_tbl;
138: l_chg_inst_asset_tbl csi_datastructures_pub.instance_asset_tbl;
139: l_chg_inst_id_lst csi_datastructures_pub.id_tbl;
140:
141: BEGIN
142: Convert_Contact_Param_To_Rec(
143: P_customer_product_id ,

Line 253: l_Party_Tbl CSI_DATASTRUCTURES_PUB.Party_Tbl;

249: x_msg_data OUT NOCOPY VARCHAR,
250: p_cs_contact_id IN NUMBER,
251: P_Object_Version_Number IN NUMBER)
252: IS
253: l_Party_Tbl CSI_DATASTRUCTURES_PUB.Party_Tbl;
254: l_Party_Account_Tbl CSI_DATASTRUCTURES_PUB.Party_Account_Tbl;
255: l_Txn_Rec CSI_DATASTRUCTURES_PUB.Transaction_Rec;
256: l_Api_Version NUMBER DEFAULT 1;
257: l_Api_Name VARCHAR2(30) := 'Delete_Row';

Line 254: l_Party_Account_Tbl CSI_DATASTRUCTURES_PUB.Party_Account_Tbl;

250: p_cs_contact_id IN NUMBER,
251: P_Object_Version_Number IN NUMBER)
252: IS
253: l_Party_Tbl CSI_DATASTRUCTURES_PUB.Party_Tbl;
254: l_Party_Account_Tbl CSI_DATASTRUCTURES_PUB.Party_Account_Tbl;
255: l_Txn_Rec CSI_DATASTRUCTURES_PUB.Transaction_Rec;
256: l_Api_Version NUMBER DEFAULT 1;
257: l_Api_Name VARCHAR2(30) := 'Delete_Row';
258: l_Commit VARCHAR2(1) := FND_API.G_FALSE;

Line 255: l_Txn_Rec CSI_DATASTRUCTURES_PUB.Transaction_Rec;

251: P_Object_Version_Number IN NUMBER)
252: IS
253: l_Party_Tbl CSI_DATASTRUCTURES_PUB.Party_Tbl;
254: l_Party_Account_Tbl CSI_DATASTRUCTURES_PUB.Party_Account_Tbl;
255: l_Txn_Rec CSI_DATASTRUCTURES_PUB.Transaction_Rec;
256: l_Api_Version NUMBER DEFAULT 1;
257: l_Api_Name VARCHAR2(30) := 'Delete_Row';
258: l_Commit VARCHAR2(1) := FND_API.G_FALSE;
259: l_Init_Msg_List VARCHAR2(1) := FND_API.G_FALSE;

Line 512: l_Party_Tbl csi_datastructures_pub.party_tbl;

508: l_Commit VARCHAR2(1) := FND_API.G_FALSE;
509: l_Init_Msg_List VARCHAR2(1) := FND_API.G_FALSE;
510: l_Validation_Level NUMBER := FND_API.G_VALID_LEVEL_FULL;
511: l_Msg_Index NUMBER;
512: l_Party_Tbl csi_datastructures_pub.party_tbl;
513: l_Account_Tbl csi_datastructures_pub.party_account_tbl;
514: l_Txn_Rec csi_datastructures_pub.Transaction_Rec;
515:
516: -- added as part of fix for Bug 2733128

Line 513: l_Account_Tbl csi_datastructures_pub.party_account_tbl;

509: l_Init_Msg_List VARCHAR2(1) := FND_API.G_FALSE;
510: l_Validation_Level NUMBER := FND_API.G_VALID_LEVEL_FULL;
511: l_Msg_Index NUMBER;
512: l_Party_Tbl csi_datastructures_pub.party_tbl;
513: l_Account_Tbl csi_datastructures_pub.party_account_tbl;
514: l_Txn_Rec csi_datastructures_pub.Transaction_Rec;
515:
516: -- added as part of fix for Bug 2733128
517: l_chg_instance_rec csi_datastructures_pub.instance_rec;

Line 514: l_Txn_Rec csi_datastructures_pub.Transaction_Rec;

510: l_Validation_Level NUMBER := FND_API.G_VALID_LEVEL_FULL;
511: l_Msg_Index NUMBER;
512: l_Party_Tbl csi_datastructures_pub.party_tbl;
513: l_Account_Tbl csi_datastructures_pub.party_account_tbl;
514: l_Txn_Rec csi_datastructures_pub.Transaction_Rec;
515:
516: -- added as part of fix for Bug 2733128
517: l_chg_instance_rec csi_datastructures_pub.instance_rec;
518: l_chg_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;

Line 517: l_chg_instance_rec csi_datastructures_pub.instance_rec;

513: l_Account_Tbl csi_datastructures_pub.party_account_tbl;
514: l_Txn_Rec csi_datastructures_pub.Transaction_Rec;
515:
516: -- added as part of fix for Bug 2733128
517: l_chg_instance_rec csi_datastructures_pub.instance_rec;
518: l_chg_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;
519: l_chg_ext_attrib_val_tbl csi_datastructures_pub.extend_attrib_values_tbl;
520: l_chg_org_units_tbl csi_datastructures_pub.organization_units_tbl;
521: l_chg_inst_asset_tbl csi_datastructures_pub.instance_asset_tbl;

Line 518: l_chg_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;

514: l_Txn_Rec csi_datastructures_pub.Transaction_Rec;
515:
516: -- added as part of fix for Bug 2733128
517: l_chg_instance_rec csi_datastructures_pub.instance_rec;
518: l_chg_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;
519: l_chg_ext_attrib_val_tbl csi_datastructures_pub.extend_attrib_values_tbl;
520: l_chg_org_units_tbl csi_datastructures_pub.organization_units_tbl;
521: l_chg_inst_asset_tbl csi_datastructures_pub.instance_asset_tbl;
522: l_chg_inst_id_lst csi_datastructures_pub.id_tbl;

Line 519: l_chg_ext_attrib_val_tbl csi_datastructures_pub.extend_attrib_values_tbl;

515:
516: -- added as part of fix for Bug 2733128
517: l_chg_instance_rec csi_datastructures_pub.instance_rec;
518: l_chg_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;
519: l_chg_ext_attrib_val_tbl csi_datastructures_pub.extend_attrib_values_tbl;
520: l_chg_org_units_tbl csi_datastructures_pub.organization_units_tbl;
521: l_chg_inst_asset_tbl csi_datastructures_pub.instance_asset_tbl;
522: l_chg_inst_id_lst csi_datastructures_pub.id_tbl;
523: BEGIN

Line 520: l_chg_org_units_tbl csi_datastructures_pub.organization_units_tbl;

516: -- added as part of fix for Bug 2733128
517: l_chg_instance_rec csi_datastructures_pub.instance_rec;
518: l_chg_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;
519: l_chg_ext_attrib_val_tbl csi_datastructures_pub.extend_attrib_values_tbl;
520: l_chg_org_units_tbl csi_datastructures_pub.organization_units_tbl;
521: l_chg_inst_asset_tbl csi_datastructures_pub.instance_asset_tbl;
522: l_chg_inst_id_lst csi_datastructures_pub.id_tbl;
523: BEGIN
524: -- Converting Single Column Attributes to Record Type.

Line 521: l_chg_inst_asset_tbl csi_datastructures_pub.instance_asset_tbl;

517: l_chg_instance_rec csi_datastructures_pub.instance_rec;
518: l_chg_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;
519: l_chg_ext_attrib_val_tbl csi_datastructures_pub.extend_attrib_values_tbl;
520: l_chg_org_units_tbl csi_datastructures_pub.organization_units_tbl;
521: l_chg_inst_asset_tbl csi_datastructures_pub.instance_asset_tbl;
522: l_chg_inst_id_lst csi_datastructures_pub.id_tbl;
523: BEGIN
524: -- Converting Single Column Attributes to Record Type.
525: Convert_Contact_Param_To_Rec(

Line 522: l_chg_inst_id_lst csi_datastructures_pub.id_tbl;

518: l_chg_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;
519: l_chg_ext_attrib_val_tbl csi_datastructures_pub.extend_attrib_values_tbl;
520: l_chg_org_units_tbl csi_datastructures_pub.organization_units_tbl;
521: l_chg_inst_asset_tbl csi_datastructures_pub.instance_asset_tbl;
522: l_chg_inst_id_lst csi_datastructures_pub.id_tbl;
523: BEGIN
524: -- Converting Single Column Attributes to Record Type.
525: Convert_Contact_Param_To_Rec(
526: P_cs_Contact_id => p_cs_contact_id,