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.CSE_UTIL_PKG dependencies on CSI_DATASTRUCTURES_PUB

Line 368: IF csi_datastructures_pub.g_install_param_rec.fetch_flag IS NULL

364: ret BOOLEAN;
365: l_flag VARCHAR2(1);
366:
367: BEGIN
368: IF csi_datastructures_pub.g_install_param_rec.fetch_flag IS NULL
369: THEN
370: csi_gen_utility_pvt.populate_install_param_rec;
371: END IF;
372: l_flag := NVL(csi_datastructures_pub.g_install_param_rec.sfm_queue_bypass_flag,'N');

Line 372: l_flag := NVL(csi_datastructures_pub.g_install_param_rec.sfm_queue_bypass_flag,'N');

368: IF csi_datastructures_pub.g_install_param_rec.fetch_flag IS NULL
369: THEN
370: csi_gen_utility_pvt.populate_install_param_rec;
371: END IF;
372: l_flag := NVL(csi_datastructures_pub.g_install_param_rec.sfm_queue_bypass_flag,'N');
373:
374: IF l_flag = 'Y'
375: THEN
376: ret := TRUE;

Line 407: P_Dest_Instance_tbl IN csi_datastructures_pub.instance_header_tbl,

403: RETURN l_neg_code ;
404: END get_neg_inv_code;
405:
406: PROCEDURE get_destination_instance(
407: P_Dest_Instance_tbl IN csi_datastructures_pub.instance_header_tbl,
408: X_Instance_Rec OUT NOCOPY csi_datastructures_pub.Instance_Rec,
409: X_Return_Status OUT NOCOPY VARCHAR2,
410: X_Error_Message OUT NOCOPY VARCHAR2) IS
411:

Line 408: X_Instance_Rec OUT NOCOPY csi_datastructures_pub.Instance_Rec,

404: END get_neg_inv_code;
405:
406: PROCEDURE get_destination_instance(
407: P_Dest_Instance_tbl IN csi_datastructures_pub.instance_header_tbl,
408: X_Instance_Rec OUT NOCOPY csi_datastructures_pub.Instance_Rec,
409: X_Return_Status OUT NOCOPY VARCHAR2,
410: X_Error_Message OUT NOCOPY VARCHAR2) IS
411:
412: l_Api_Name CONSTANT VARCHAR2(50) :='CSE_UTIL_PKG.GET_DESTINATION_INSTANCE';

Line 819: FUNCTION Init_Instance_Query_Rec RETURN CSI_DATASTRUCTURES_PUB.Instance_Query_Rec IS

815:
816: --This procedure tries to acquire a lock for infinite time for
817: --the given lockname.
818: --Also this procedure releases the lock on COMMIT ;
819: FUNCTION Init_Instance_Query_Rec RETURN CSI_DATASTRUCTURES_PUB.Instance_Query_Rec IS
820: l_Instance_Query_Rec CSI_DataStructures_Pub.Instance_Query_Rec;
821: BEGIN
822: RETURN l_Instance_Query_Rec;
823: END Init_Instance_Query_Rec;

Line 820: l_Instance_Query_Rec CSI_DataStructures_Pub.Instance_Query_Rec;

816: --This procedure tries to acquire a lock for infinite time for
817: --the given lockname.
818: --Also this procedure releases the lock on COMMIT ;
819: FUNCTION Init_Instance_Query_Rec RETURN CSI_DATASTRUCTURES_PUB.Instance_Query_Rec IS
820: l_Instance_Query_Rec CSI_DataStructures_Pub.Instance_Query_Rec;
821: BEGIN
822: RETURN l_Instance_Query_Rec;
823: END Init_Instance_Query_Rec;
824:

Line 825: FUNCTION Init_Instance_Create_Rec RETURN CSI_DATASTRUCTURES_PUB.Instance_Rec IS

821: BEGIN
822: RETURN l_Instance_Query_Rec;
823: END Init_Instance_Query_Rec;
824:
825: FUNCTION Init_Instance_Create_Rec RETURN CSI_DATASTRUCTURES_PUB.Instance_Rec IS
826: l_Instance_Rec CSI_DATASTRUCTURES_PUB.Instance_Rec;
827: BEGIN
828: l_instance_rec.version_label := 'AS-CREATED';
829: l_instance_rec.creation_complete_flag := NULL;

Line 826: l_Instance_Rec CSI_DATASTRUCTURES_PUB.Instance_Rec;

822: RETURN l_Instance_Query_Rec;
823: END Init_Instance_Query_Rec;
824:
825: FUNCTION Init_Instance_Create_Rec RETURN CSI_DATASTRUCTURES_PUB.Instance_Rec IS
826: l_Instance_Rec CSI_DATASTRUCTURES_PUB.Instance_Rec;
827: BEGIN
828: l_instance_rec.version_label := 'AS-CREATED';
829: l_instance_rec.creation_complete_flag := NULL;
830: RETURN l_Instance_Rec;

Line 833: FUNCTION Init_Instance_Update_Rec RETURN CSI_DATASTRUCTURES_PUB.Instance_Rec IS

829: l_instance_rec.creation_complete_flag := NULL;
830: RETURN l_Instance_Rec;
831: END Init_Instance_Create_Rec;
832:
833: FUNCTION Init_Instance_Update_Rec RETURN CSI_DATASTRUCTURES_PUB.Instance_Rec IS
834: l_Instance_Rec CSI_DATASTRUCTURES_PUB.Instance_Rec;
835: BEGIN
836: RETURN l_Instance_Rec;
837: END Init_Instance_Update_Rec;

Line 834: l_Instance_Rec CSI_DATASTRUCTURES_PUB.Instance_Rec;

830: RETURN l_Instance_Rec;
831: END Init_Instance_Create_Rec;
832:
833: FUNCTION Init_Instance_Update_Rec RETURN CSI_DATASTRUCTURES_PUB.Instance_Rec IS
834: l_Instance_Rec CSI_DATASTRUCTURES_PUB.Instance_Rec;
835: BEGIN
836: RETURN l_Instance_Rec;
837: END Init_Instance_Update_Rec;
838:

Line 841: FUNCTION Init_Party_Tbl RETURN CSI_DATASTRUCTURES_PUB.Party_Tbl IS

837: END Init_Instance_Update_Rec;
838:
839:
840:
841: FUNCTION Init_Party_Tbl RETURN CSI_DATASTRUCTURES_PUB.Party_Tbl IS
842: l_Party_Tbl CSI_DATASTRUCTURES_PUB.Party_Tbl;
843: l_Party_Id NUMBER;
844:
845: BEGIN

Line 842: l_Party_Tbl CSI_DATASTRUCTURES_PUB.Party_Tbl;

838:
839:
840:
841: FUNCTION Init_Party_Tbl RETURN CSI_DATASTRUCTURES_PUB.Party_Tbl IS
842: l_Party_Tbl CSI_DATASTRUCTURES_PUB.Party_Tbl;
843: l_Party_Id NUMBER;
844:
845: BEGIN
846:

Line 847: IF csi_datastructures_pub.g_install_param_rec.fetch_flag IS NULL

843: l_Party_Id NUMBER;
844:
845: BEGIN
846:
847: IF csi_datastructures_pub.g_install_param_rec.fetch_flag IS NULL
848: THEN
849: csi_gen_utility_pvt.populate_install_param_rec;
850: END IF;
851: l_Party_ID := csi_datastructures_pub.g_install_param_rec.Internal_Party_Id;

Line 851: l_Party_ID := csi_datastructures_pub.g_install_param_rec.Internal_Party_Id;

847: IF csi_datastructures_pub.g_install_param_rec.fetch_flag IS NULL
848: THEN
849: csi_gen_utility_pvt.populate_install_param_rec;
850: END IF;
851: l_Party_ID := csi_datastructures_pub.g_install_param_rec.Internal_Party_Id;
852:
853: l_Party_Tbl(1).party_source_table := 'HZ_PARTIES' ;
854: l_Party_Tbl(1).party_id := l_Party_Id;
855: l_Party_Tbl(1).relationship_type_code := 'OWNER';

Line 861: FUNCTION Init_Account_Tbl RETURN CSI_DATASTRUCTURES_PUB.Party_Account_Tbl IS

857:
858: RETURN l_Party_Tbl;
859: END Init_Party_Tbl;
860:
861: FUNCTION Init_Account_Tbl RETURN CSI_DATASTRUCTURES_PUB.Party_Account_Tbl IS
862: l_Account_Tbl CSI_DATASTRUCTURES_PUB.Party_Account_Tbl;
863: BEGIN
864: RETURN l_Account_Tbl;
865: END Init_Account_Tbl;

Line 862: l_Account_Tbl CSI_DATASTRUCTURES_PUB.Party_Account_Tbl;

858: RETURN l_Party_Tbl;
859: END Init_Party_Tbl;
860:
861: FUNCTION Init_Account_Tbl RETURN CSI_DATASTRUCTURES_PUB.Party_Account_Tbl IS
862: l_Account_Tbl CSI_DATASTRUCTURES_PUB.Party_Account_Tbl;
863: BEGIN
864: RETURN l_Account_Tbl;
865: END Init_Account_Tbl;
866:

Line 867: FUNCTION Init_ext_attrib_values_tbl RETURN CSI_DATASTRUCTURES_PUB.extend_attrib_values_tbl IS

863: BEGIN
864: RETURN l_Account_Tbl;
865: END Init_Account_Tbl;
866:
867: FUNCTION Init_ext_attrib_values_tbl RETURN CSI_DATASTRUCTURES_PUB.extend_attrib_values_tbl IS
868: l_extend_attrib_values_tbl CSI_DATASTRUCTURES_PUB.extend_attrib_values_tbl;
869: BEGIN
870: RETURN l_extend_attrib_values_tbl;
871: END Init_ext_attrib_values_tbl;

Line 868: l_extend_attrib_values_tbl CSI_DATASTRUCTURES_PUB.extend_attrib_values_tbl;

864: RETURN l_Account_Tbl;
865: END Init_Account_Tbl;
866:
867: FUNCTION Init_ext_attrib_values_tbl RETURN CSI_DATASTRUCTURES_PUB.extend_attrib_values_tbl IS
868: l_extend_attrib_values_tbl CSI_DATASTRUCTURES_PUB.extend_attrib_values_tbl;
869: BEGIN
870: RETURN l_extend_attrib_values_tbl;
871: END Init_ext_attrib_values_tbl;
872:

Line 873: FUNCTION Init_Pricing_Attribs_Tbl RETURN CSI_DATASTRUCTURES_PUB.pricing_attribs_tbl IS

869: BEGIN
870: RETURN l_extend_attrib_values_tbl;
871: END Init_ext_attrib_values_tbl;
872:
873: FUNCTION Init_Pricing_Attribs_Tbl RETURN CSI_DATASTRUCTURES_PUB.pricing_attribs_tbl IS
874: l_Pricing_Attribs_Tbl CSI_DATASTRUCTURES_PUB.pricing_attribs_tbl;
875: BEGIN
876: RETURN l_Pricing_Attribs_Tbl;
877: END Init_Pricing_Attribs_Tbl;

Line 874: l_Pricing_Attribs_Tbl CSI_DATASTRUCTURES_PUB.pricing_attribs_tbl;

870: RETURN l_extend_attrib_values_tbl;
871: END Init_ext_attrib_values_tbl;
872:
873: FUNCTION Init_Pricing_Attribs_Tbl RETURN CSI_DATASTRUCTURES_PUB.pricing_attribs_tbl IS
874: l_Pricing_Attribs_Tbl CSI_DATASTRUCTURES_PUB.pricing_attribs_tbl;
875: BEGIN
876: RETURN l_Pricing_Attribs_Tbl;
877: END Init_Pricing_Attribs_Tbl;
878:

Line 879: FUNCTION Init_Org_Assignments_Tbl RETURN CSI_DATASTRUCTURES_PUB.organization_units_tbl IS

875: BEGIN
876: RETURN l_Pricing_Attribs_Tbl;
877: END Init_Pricing_Attribs_Tbl;
878:
879: FUNCTION Init_Org_Assignments_Tbl RETURN CSI_DATASTRUCTURES_PUB.organization_units_tbl IS
880: l_Org_Assignments_Tbl CSI_DATASTRUCTURES_PUB.organization_units_tbl;
881: BEGIN
882: RETURN l_Org_Assignments_Tbl;
883: END Init_Org_Assignments_Tbl;

Line 880: l_Org_Assignments_Tbl CSI_DATASTRUCTURES_PUB.organization_units_tbl;

876: RETURN l_Pricing_Attribs_Tbl;
877: END Init_Pricing_Attribs_Tbl;
878:
879: FUNCTION Init_Org_Assignments_Tbl RETURN CSI_DATASTRUCTURES_PUB.organization_units_tbl IS
880: l_Org_Assignments_Tbl CSI_DATASTRUCTURES_PUB.organization_units_tbl;
881: BEGIN
882: RETURN l_Org_Assignments_Tbl;
883: END Init_Org_Assignments_Tbl;
884:

Line 885: FUNCTION Init_Asset_Assignment_Tbl RETURN CSI_DATASTRUCTURES_PUB.instance_asset_tbl IS

881: BEGIN
882: RETURN l_Org_Assignments_Tbl;
883: END Init_Org_Assignments_Tbl;
884:
885: FUNCTION Init_Asset_Assignment_Tbl RETURN CSI_DATASTRUCTURES_PUB.instance_asset_tbl IS
886: l_Asset_Assignment_Tbl CSI_DATASTRUCTURES_PUB.instance_asset_tbl;
887: BEGIN
888: RETURN l_Asset_Assignment_Tbl;
889: END Init_Asset_Assignment_Tbl;

Line 886: l_Asset_Assignment_Tbl CSI_DATASTRUCTURES_PUB.instance_asset_tbl;

882: RETURN l_Org_Assignments_Tbl;
883: END Init_Org_Assignments_Tbl;
884:
885: FUNCTION Init_Asset_Assignment_Tbl RETURN CSI_DATASTRUCTURES_PUB.instance_asset_tbl IS
886: l_Asset_Assignment_Tbl CSI_DATASTRUCTURES_PUB.instance_asset_tbl;
887: BEGIN
888: RETURN l_Asset_Assignment_Tbl;
889: END Init_Asset_Assignment_Tbl;
890:

Line 891: FUNCTION Init_Instance_Asset_Query_Rec RETURN CSI_DATASTRUCTURES_PUB.instance_asset_Query_Rec IS

887: BEGIN
888: RETURN l_Asset_Assignment_Tbl;
889: END Init_Asset_Assignment_Tbl;
890:
891: FUNCTION Init_Instance_Asset_Query_Rec RETURN CSI_DATASTRUCTURES_PUB.instance_asset_Query_Rec IS
892: l_instance_asset_Query_Rec CSI_DATASTRUCTURES_PUB.instance_asset_Query_Rec;
893: BEGIN
894: RETURN l_instance_asset_Query_Rec;
895: END Init_Instance_Asset_Query_Rec;

Line 892: l_instance_asset_Query_Rec CSI_DATASTRUCTURES_PUB.instance_asset_Query_Rec;

888: RETURN l_Asset_Assignment_Tbl;
889: END Init_Asset_Assignment_Tbl;
890:
891: FUNCTION Init_Instance_Asset_Query_Rec RETURN CSI_DATASTRUCTURES_PUB.instance_asset_Query_Rec IS
892: l_instance_asset_Query_Rec CSI_DATASTRUCTURES_PUB.instance_asset_Query_Rec;
893: BEGIN
894: RETURN l_instance_asset_Query_Rec;
895: END Init_Instance_Asset_Query_Rec;
896:

Line 897: FUNCTION Init_Instance_Asset_Rec RETURN CSI_DATASTRUCTURES_PUB.instance_asset_Rec IS

893: BEGIN
894: RETURN l_instance_asset_Query_Rec;
895: END Init_Instance_Asset_Query_Rec;
896:
897: FUNCTION Init_Instance_Asset_Rec RETURN CSI_DATASTRUCTURES_PUB.instance_asset_Rec IS
898: l_instance_asset_Rec CSI_DATASTRUCTURES_PUB.instance_asset_Rec;
899: BEGIN
900: RETURN l_instance_asset_Rec;
901: END Init_Instance_Asset_Rec;

Line 898: l_instance_asset_Rec CSI_DATASTRUCTURES_PUB.instance_asset_Rec;

894: RETURN l_instance_asset_Query_Rec;
895: END Init_Instance_Asset_Query_Rec;
896:
897: FUNCTION Init_Instance_Asset_Rec RETURN CSI_DATASTRUCTURES_PUB.instance_asset_Rec IS
898: l_instance_asset_Rec CSI_DATASTRUCTURES_PUB.instance_asset_Rec;
899: BEGIN
900: RETURN l_instance_asset_Rec;
901: END Init_Instance_Asset_Rec;
902:

Line 970: IF csi_datastructures_pub.g_install_param_rec.fetch_flag IS NULL

966:
967: l_project_location_id NUMBER :=0;
968:
969: BEGIN
970: IF csi_datastructures_pub.g_install_param_rec.fetch_flag IS NULL
971: THEN
972: csi_gen_utility_pvt.populate_install_param_rec;
973: END IF;
974: l_project_location_id := csi_datastructures_pub.g_install_param_rec.project_location_id;

Line 974: l_project_location_id := csi_datastructures_pub.g_install_param_rec.project_location_id;

970: IF csi_datastructures_pub.g_install_param_rec.fetch_flag IS NULL
971: THEN
972: csi_gen_utility_pvt.populate_install_param_rec;
973: END IF;
974: l_project_location_id := csi_datastructures_pub.g_install_param_rec.project_location_id;
975: RETURN l_project_location_id;
976: END Get_Dflt_Project_Location_Id;
977:
978: FUNCTION Get_Default_Status_Id (p_transaction_id in number) RETURN NUMBER IS

Line 1033: FUNCTION Init_Txn_Rec RETURN CSI_DATASTRUCTURES_PUB.TRANSACTION_Rec IS

1029: CLOSE c_id;
1030: RETURN l_employee_id;
1031: END Get_Fnd_Employee_Id;
1032:
1033: FUNCTION Init_Txn_Rec RETURN CSI_DATASTRUCTURES_PUB.TRANSACTION_Rec IS
1034: l_Txn_Rec CSI_DATASTRUCTURES_PUB.TRANSACTION_Rec;
1035: BEGIN
1036: RETURN l_Txn_Rec;
1037: END Init_Txn_Rec;

Line 1034: l_Txn_Rec CSI_DATASTRUCTURES_PUB.TRANSACTION_Rec;

1030: RETURN l_employee_id;
1031: END Get_Fnd_Employee_Id;
1032:
1033: FUNCTION Init_Txn_Rec RETURN CSI_DATASTRUCTURES_PUB.TRANSACTION_Rec IS
1034: l_Txn_Rec CSI_DATASTRUCTURES_PUB.TRANSACTION_Rec;
1035: BEGIN
1036: RETURN l_Txn_Rec;
1037: END Init_Txn_Rec;
1038:

Line 1039: FUNCTION Init_Txn_Error_Rec RETURN CSI_DATASTRUCTURES_PUB.TRANSACTION_Error_Rec IS

1035: BEGIN
1036: RETURN l_Txn_Rec;
1037: END Init_Txn_Rec;
1038:
1039: FUNCTION Init_Txn_Error_Rec RETURN CSI_DATASTRUCTURES_PUB.TRANSACTION_Error_Rec IS
1040: l_Txn_Error_Rec CSI_DATASTRUCTURES_PUB.TRANSACTION_Error_Rec;
1041: BEGIN
1042: l_Txn_Error_Rec.processed_flag := CSE_DATASTRUCTURES_PUB.G_TXN_ERROR;
1043: RETURN l_Txn_Error_Rec;

Line 1040: l_Txn_Error_Rec CSI_DATASTRUCTURES_PUB.TRANSACTION_Error_Rec;

1036: RETURN l_Txn_Rec;
1037: END Init_Txn_Rec;
1038:
1039: FUNCTION Init_Txn_Error_Rec RETURN CSI_DATASTRUCTURES_PUB.TRANSACTION_Error_Rec IS
1040: l_Txn_Error_Rec CSI_DATASTRUCTURES_PUB.TRANSACTION_Error_Rec;
1041: BEGIN
1042: l_Txn_Error_Rec.processed_flag := CSE_DATASTRUCTURES_PUB.G_TXN_ERROR;
1043: RETURN l_Txn_Error_Rec;
1044: END Init_Txn_Error_Rec;

Line 1046: FUNCTION Init_Party_Query_Rec RETURN CSI_DATASTRUCTURES_PUB.Party_Query_Rec IS

1042: l_Txn_Error_Rec.processed_flag := CSE_DATASTRUCTURES_PUB.G_TXN_ERROR;
1043: RETURN l_Txn_Error_Rec;
1044: END Init_Txn_Error_Rec;
1045:
1046: FUNCTION Init_Party_Query_Rec RETURN CSI_DATASTRUCTURES_PUB.Party_Query_Rec IS
1047: l_Party_Query_Rec CSI_DATASTRUCTURES_PUB.Party_Query_Rec;
1048: l_Party_Id NUMBER;
1049:
1050: BEGIN

Line 1047: l_Party_Query_Rec CSI_DATASTRUCTURES_PUB.Party_Query_Rec;

1043: RETURN l_Txn_Error_Rec;
1044: END Init_Txn_Error_Rec;
1045:
1046: FUNCTION Init_Party_Query_Rec RETURN CSI_DATASTRUCTURES_PUB.Party_Query_Rec IS
1047: l_Party_Query_Rec CSI_DATASTRUCTURES_PUB.Party_Query_Rec;
1048: l_Party_Id NUMBER;
1049:
1050: BEGIN
1051:

Line 1052: IF csi_datastructures_pub.g_install_param_rec.fetch_flag IS NULL

1048: l_Party_Id NUMBER;
1049:
1050: BEGIN
1051:
1052: IF csi_datastructures_pub.g_install_param_rec.fetch_flag IS NULL
1053: THEN
1054: csi_gen_utility_pvt.populate_install_param_rec;
1055: END IF;
1056:

Line 1057: l_Party_ID := csi_datastructures_pub.g_install_param_rec.Internal_Party_Id;

1053: THEN
1054: csi_gen_utility_pvt.populate_install_param_rec;
1055: END IF;
1056:
1057: l_Party_ID := csi_datastructures_pub.g_install_param_rec.Internal_Party_Id;
1058:
1059:
1060: l_Party_Query_Rec.party_id := l_Party_Id;
1061: l_Party_Query_Rec.relationship_type_code := 'OWNER';

Line 1335: ,x_inst_dtls_tbl OUT NOCOPY csi_datastructures_pub.instance_header_tbl

1331: PROCEDURE get_inst_n_comp_dtls(
1332: p_instance_id IN NUMBER
1333: ,p_transaction_id IN NUMBER
1334: ,p_transaction_date IN DATE
1335: ,x_inst_dtls_tbl OUT NOCOPY csi_datastructures_pub.instance_header_tbl
1336: ,x_return_status OUT NOCOPY VARCHAR2
1337: ,x_error_message OUT NOCOPY VARCHAR2)
1338: IS
1339:

Line 1350: l_instance_header_tbl_out csi_datastructures_pub.instance_header_tbl;

1346: l_api_version NUMBER DEFAULT 1.0;
1347: l_commit VARCHAR2(1) DEFAULT FND_API.G_FALSE;
1348: l_init_msg_list VARCHAR2(1) DEFAULT FND_API.G_TRUE;
1349: l_validation_level NUMBER := fnd_api.g_valid_level_full;
1350: l_instance_header_tbl_out csi_datastructures_pub.instance_header_tbl;
1351: l_resolve_id_columns VARCHAR2(1) DEFAULT FND_API.G_FALSE;
1352: l_msg_index NUMBER;
1353: l_msg_data VARCHAR2(2000);
1354: l_msg_count NUMBER;

Line 1357: l_instance_rec csi_datastructures_pub.instance_header_rec ;

1353: l_msg_data VARCHAR2(2000);
1354: l_msg_count NUMBER;
1355: l_return_status VARCHAR2(1);
1356: l_error_message VARCHAR2(2000);
1357: l_instance_rec csi_datastructures_pub.instance_header_rec ;
1358: l_party_header_tbl csi_datastructures_pub.party_header_tbl ;
1359: l_account_header_tbl csi_datastructures_pub.party_account_header_tbl ;
1360: l_org_header_tbl csi_datastructures_pub.org_units_header_tbl ;
1361: l_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl ;

Line 1358: l_party_header_tbl csi_datastructures_pub.party_header_tbl ;

1354: l_msg_count NUMBER;
1355: l_return_status VARCHAR2(1);
1356: l_error_message VARCHAR2(2000);
1357: l_instance_rec csi_datastructures_pub.instance_header_rec ;
1358: l_party_header_tbl csi_datastructures_pub.party_header_tbl ;
1359: l_account_header_tbl csi_datastructures_pub.party_account_header_tbl ;
1360: l_org_header_tbl csi_datastructures_pub.org_units_header_tbl ;
1361: l_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl ;
1362: l_ext_attrib_tbl csi_datastructures_pub.extend_attrib_values_tbl ;

Line 1359: l_account_header_tbl csi_datastructures_pub.party_account_header_tbl ;

1355: l_return_status VARCHAR2(1);
1356: l_error_message VARCHAR2(2000);
1357: l_instance_rec csi_datastructures_pub.instance_header_rec ;
1358: l_party_header_tbl csi_datastructures_pub.party_header_tbl ;
1359: l_account_header_tbl csi_datastructures_pub.party_account_header_tbl ;
1360: l_org_header_tbl csi_datastructures_pub.org_units_header_tbl ;
1361: l_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl ;
1362: l_ext_attrib_tbl csi_datastructures_pub.extend_attrib_values_tbl ;
1363: l_ext_attrib_def_tbl csi_datastructures_pub.extend_attrib_tbl ;

Line 1360: l_org_header_tbl csi_datastructures_pub.org_units_header_tbl ;

1356: l_error_message VARCHAR2(2000);
1357: l_instance_rec csi_datastructures_pub.instance_header_rec ;
1358: l_party_header_tbl csi_datastructures_pub.party_header_tbl ;
1359: l_account_header_tbl csi_datastructures_pub.party_account_header_tbl ;
1360: l_org_header_tbl csi_datastructures_pub.org_units_header_tbl ;
1361: l_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl ;
1362: l_ext_attrib_tbl csi_datastructures_pub.extend_attrib_values_tbl ;
1363: l_ext_attrib_def_tbl csi_datastructures_pub.extend_attrib_tbl ;
1364: l_asset_header_tbl csi_datastructures_pub.instance_asset_header_tbl;

Line 1361: l_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl ;

1357: l_instance_rec csi_datastructures_pub.instance_header_rec ;
1358: l_party_header_tbl csi_datastructures_pub.party_header_tbl ;
1359: l_account_header_tbl csi_datastructures_pub.party_account_header_tbl ;
1360: l_org_header_tbl csi_datastructures_pub.org_units_header_tbl ;
1361: l_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl ;
1362: l_ext_attrib_tbl csi_datastructures_pub.extend_attrib_values_tbl ;
1363: l_ext_attrib_def_tbl csi_datastructures_pub.extend_attrib_tbl ;
1364: l_asset_header_tbl csi_datastructures_pub.instance_asset_header_tbl;
1365: l_relationship_query_rec csi_datastructures_pub.relationship_query_rec ;

Line 1362: l_ext_attrib_tbl csi_datastructures_pub.extend_attrib_values_tbl ;

1358: l_party_header_tbl csi_datastructures_pub.party_header_tbl ;
1359: l_account_header_tbl csi_datastructures_pub.party_account_header_tbl ;
1360: l_org_header_tbl csi_datastructures_pub.org_units_header_tbl ;
1361: l_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl ;
1362: l_ext_attrib_tbl csi_datastructures_pub.extend_attrib_values_tbl ;
1363: l_ext_attrib_def_tbl csi_datastructures_pub.extend_attrib_tbl ;
1364: l_asset_header_tbl csi_datastructures_pub.instance_asset_header_tbl;
1365: l_relationship_query_rec csi_datastructures_pub.relationship_query_rec ;
1366: l_ii_relationship_tbl csi_datastructures_pub.ii_relationship_tbl ;

Line 1363: l_ext_attrib_def_tbl csi_datastructures_pub.extend_attrib_tbl ;

1359: l_account_header_tbl csi_datastructures_pub.party_account_header_tbl ;
1360: l_org_header_tbl csi_datastructures_pub.org_units_header_tbl ;
1361: l_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl ;
1362: l_ext_attrib_tbl csi_datastructures_pub.extend_attrib_values_tbl ;
1363: l_ext_attrib_def_tbl csi_datastructures_pub.extend_attrib_tbl ;
1364: l_asset_header_tbl csi_datastructures_pub.instance_asset_header_tbl;
1365: l_relationship_query_rec csi_datastructures_pub.relationship_query_rec ;
1366: l_ii_relationship_tbl csi_datastructures_pub.ii_relationship_tbl ;
1367: e_error EXCEPTION ;

Line 1364: l_asset_header_tbl csi_datastructures_pub.instance_asset_header_tbl;

1360: l_org_header_tbl csi_datastructures_pub.org_units_header_tbl ;
1361: l_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl ;
1362: l_ext_attrib_tbl csi_datastructures_pub.extend_attrib_values_tbl ;
1363: l_ext_attrib_def_tbl csi_datastructures_pub.extend_attrib_tbl ;
1364: l_asset_header_tbl csi_datastructures_pub.instance_asset_header_tbl;
1365: l_relationship_query_rec csi_datastructures_pub.relationship_query_rec ;
1366: l_ii_relationship_tbl csi_datastructures_pub.ii_relationship_tbl ;
1367: e_error EXCEPTION ;
1368: i INTEGER ;

Line 1365: l_relationship_query_rec csi_datastructures_pub.relationship_query_rec ;

1361: l_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl ;
1362: l_ext_attrib_tbl csi_datastructures_pub.extend_attrib_values_tbl ;
1363: l_ext_attrib_def_tbl csi_datastructures_pub.extend_attrib_tbl ;
1364: l_asset_header_tbl csi_datastructures_pub.instance_asset_header_tbl;
1365: l_relationship_query_rec csi_datastructures_pub.relationship_query_rec ;
1366: l_ii_relationship_tbl csi_datastructures_pub.ii_relationship_tbl ;
1367: e_error EXCEPTION ;
1368: i INTEGER ;
1369: j INTEGER ;

Line 1366: l_ii_relationship_tbl csi_datastructures_pub.ii_relationship_tbl ;

1362: l_ext_attrib_tbl csi_datastructures_pub.extend_attrib_values_tbl ;
1363: l_ext_attrib_def_tbl csi_datastructures_pub.extend_attrib_tbl ;
1364: l_asset_header_tbl csi_datastructures_pub.instance_asset_header_tbl;
1365: l_relationship_query_rec csi_datastructures_pub.relationship_query_rec ;
1366: l_ii_relationship_tbl csi_datastructures_pub.ii_relationship_tbl ;
1367: e_error EXCEPTION ;
1368: i INTEGER ;
1369: j INTEGER ;
1370: k INTEGER ;