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.CSD_REPAIRS_UTIL dependencies on CSD_REPAIRS

Line 1: Package BODY Csd_Repairs_Util AS

1: Package BODY Csd_Repairs_Util AS
2: /* $Header: csdxutlb.pls 120.21.12020000.5 2013/04/09 05:15:50 subhat ship $ */
3: --
4: -- Package name : CSD_REPAIRS_UTIL
5: -- Purpose : This package contains utility programs for the Depot

Line 4: -- Package name : CSD_REPAIRS_UTIL

1: Package BODY Csd_Repairs_Util AS
2: /* $Header: csdxutlb.pls 120.21.12020000.5 2013/04/09 05:15:50 subhat ship $ */
3: --
4: -- Package name : CSD_REPAIRS_UTIL
5: -- Purpose : This package contains utility programs for the Depot
6: -- Repair module. Access is restricted to Oracle Depot
7: -- Repair Internal Development.
8: -- History :

Line 23: G_PKG_NAME CONSTANT VARCHAR2(30) := 'CSD_REPAIRS_UTIL';

19: -- 120.2 07/13/05 vparvath Added utility proc for webservice
20: --
21: -- NOTE :
22: --
23: G_PKG_NAME CONSTANT VARCHAR2(30) := 'CSD_REPAIRS_UTIL';
24: G_FILE_NAME CONSTANT VARCHAR2(12) := 'csdxutlb.pls';
25: g_debug NUMBER := Csd_Gen_Utility_Pvt.g_debug_level;
26:
27: procedure debug( l_msg in varchar2)

Line 103: p_attr_values IN OUT NOCOPY CSD_REPAIRS_UTIL.DEF_Rec_Type,

99:
100: FUNCTION Is_DescFlex_Valid
101: ( p_api_name IN VARCHAR2,
102: p_desc_flex_name IN VARCHAR2,
103: p_attr_values IN OUT NOCOPY CSD_REPAIRS_UTIL.DEF_Rec_Type,
104: -- bug#7151536, subhat.
105: p_validate_only IN VARCHAR2 := FND_API.G_TRUE
106: ) RETURN BOOLEAN IS
107: --

Line 179: -- Note: In case any new columns are added to CSD_REPAIRS DFF, they need to be added here too.

175: end if;
176: l_return_status := FALSE;
177: -- bug#7043215, subhat
178: -- added else to populate the derived/validated value to the global collection
179: -- Note: In case any new columns are added to CSD_REPAIRS DFF, they need to be added here too.
180: else
181: -- populate the out rec only if its in create mode.
182: if l_values_or_ids = 'V' then
183: l_segment_count := fnd_flex_descval.segment_count;

Line 342: x_Repln_Rec OUT NOCOPY Csd_Repairs_Pub.Repln_Rec_Type

338: p_RESOLVE_BY_DATE IN DATE := Fnd_Api.G_MISS_DATE, -- rfieldma: 5355051
339: p_BULLETIN_CHECK_DATE IN DATE := Fnd_Api.G_MISS_DATE,
340: p_ESCALATION_CODE IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
341: p_RO_WARRANTY_STATUS_CODE IN VARCHAR2 := Fnd_Api.G_MISS_CHAR,
342: x_Repln_Rec OUT NOCOPY Csd_Repairs_Pub.Repln_Rec_Type
343: ) IS
344: --
345: BEGIN
346:

Line 466: x_DEF_Rec OUT NOCOPY Csd_Repairs_Util.DEF_Rec_Type

462: p_attribute27 IN VARCHAR2 := FND_API.G_MISS_CHAR,
463: p_attribute28 IN VARCHAR2 := FND_API.G_MISS_CHAR,
464: p_attribute29 IN VARCHAR2 := FND_API.G_MISS_CHAR,
465: p_attribute30 IN VARCHAR2 := FND_API.G_MISS_CHAR,
466: x_DEF_Rec OUT NOCOPY Csd_Repairs_Util.DEF_Rec_Type
467: ) IS
468: --
469: BEGIN
470: --

Line 764: SELECT repair_mode FROM csd_repairs

760: AND wip_entity_id IS NULL;
761:
762: -- Cursor to get the repair mode
763: CURSOR repair_details_cur IS
764: SELECT repair_mode FROM csd_repairs
765: WHERE repair_line_id = p_repair_line_id;
766:
767:
768:

Line 776: Fnd_Log.STRING (Fnd_Log.LEVEL_PROCEDURE, 'csd.plsql.csd_repairs_util.check_task_n_wipjob.begin',

772: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
773: l_debug_level := Fnd_Log.G_CURRENT_RUNTIME_LEVEL;
774:
775: IF (Fnd_Log.LEVEL_PROCEDURE >= l_debug_level) THEN
776: Fnd_Log.STRING (Fnd_Log.LEVEL_PROCEDURE, 'csd.plsql.csd_repairs_util.check_task_n_wipjob.begin',
777: '-------------Entered check_task_n_wipjob----------------');
778: END IF;
779:
780:

Line 798: Fnd_Log.STRING (Fnd_Log.LEVEL_EVENT, 'csd.plsql.csd_repairs_util.check_task_n_wipjob',

794: ****/
795: IF( p_repair_status = C_CLOSED_STATUS) THEN
796:
797: IF (Fnd_Log.LEVEL_EVENT >= l_debug_level) THEN
798: Fnd_Log.STRING (Fnd_Log.LEVEL_EVENT, 'csd.plsql.csd_repairs_util.check_task_n_wipjob',
799: '-------------status is being changed to close,ro['||p_repair_line_id||']-----');
800: END IF;
801:
802: IF (l_repair_mode = C_WIP_MODE) THEN

Line 805: Fnd_Log.STRING (Fnd_Log.LEVEL_STATEMENT, 'csd.plsql.csd_repairs_util.check_task_n_wipjob',

801:
802: IF (l_repair_mode = C_WIP_MODE) THEN
803:
804: IF (Fnd_Log.LEVEL_STATEMENT >= l_debug_level) THEN
805: Fnd_Log.STRING (Fnd_Log.LEVEL_STATEMENT, 'csd.plsql.csd_repairs_util.check_task_n_wipjob',
806: '-------------checking for open jobs---------------');
807: END IF;
808:
809: OPEN wipjob_cur;

Line 814: Fnd_Log.STRING (Fnd_Log.LEVEL_STATEMENT, 'csd.plsql.csd_repairs_util.check_task_n_wipjob',

810: FETCH wipjob_cur INTO l_tmp_char;
811: IF(wipjob_cur%NOTFOUND) THEN
812: CLOSE wipjob_cur;
813: IF (Fnd_Log.LEVEL_STATEMENT >= l_debug_level) THEN
814: Fnd_Log.STRING (Fnd_Log.LEVEL_STATEMENT, 'csd.plsql.csd_repairs_util.check_task_n_wipjob',
815: '-------------there are open jobs---------------');
816: END IF;
817: Fnd_Message.set_name('CSD', 'CSD_API_OPEN_WIP_JOBS');
818: Fnd_Msg_Pub.ADD;

Line 825: Fnd_Log.STRING (Fnd_Log.LEVEL_STATEMENT, 'csd.plsql.csd_repairs_util.check_task_n_wipjob',

821: CLOSE wipjob_cur;
822: ELSIF (l_repair_mode = C_TASK_MODE) THEN
823:
824: IF (Fnd_Log.LEVEL_STATEMENT >= l_debug_level) THEN
825: Fnd_Log.STRING (Fnd_Log.LEVEL_STATEMENT, 'csd.plsql.csd_repairs_util.check_task_n_wipjob',
826: '-------------checking for open tasks---------------');
827: END IF;
828:
829: OPEN task_cur;

Line 834: Fnd_Log.STRING (Fnd_Log.LEVEL_STATEMENT, 'csd.plsql.csd_repairs_util.check_task_n_wipjob',

830: FETCH task_cur INTO l_tmp_char;
831: IF(task_cur%NOTFOUND) THEN
832: CLOSE task_cur;
833: IF (Fnd_Log.LEVEL_STATEMENT >= l_debug_level) THEN
834: Fnd_Log.STRING (Fnd_Log.LEVEL_STATEMENT, 'csd.plsql.csd_repairs_util.check_task_n_wipjob',
835: '-------------there are open tasks---------------');
836: END IF;
837: Fnd_Message.set_name('CSD', 'CSD_API_OPEN_TASKS');
838: Fnd_Msg_Pub.ADD;

Line 846: Fnd_Log.STRING (Fnd_Log.level_procedure, 'csd.plsql.csd_repairs_util.check_task_n_wipjob.end',

842: END IF;
843: END IF;
844:
845: IF (Fnd_Log.level_procedure >= l_debug_level) THEN
846: Fnd_Log.STRING (Fnd_Log.level_procedure, 'csd.plsql.csd_repairs_util.check_task_n_wipjob.end',
847: '-------------Leaving check_task_n_wipjob----------------');
848: END IF;
849:
850: EXCEPTION

Line 856: 'csd.plsql.csd_repairs_util.check_task_n_wipjob',

852: x_return_status := Fnd_Api.G_RET_STS_ERROR ;
853: Fnd_Msg_Pub.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
854: IF ( Fnd_Log.LEVEL_ERROR >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL ) THEN
855: Fnd_Log.STRING(Fnd_Log.LEVEL_ERROR,
856: 'csd.plsql.csd_repairs_util.check_task_n_wipjob',
857: 'EXC_ERROR ['||x_msg_data||']');
858: END IF;
859:
860: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN

Line 865: 'csd.plsql.csd_repairs_util.check_task_n_wipjob',

861: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR ;
862: Fnd_Msg_Pub.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data );
863: IF ( Fnd_Log.LEVEL_EXCEPTION >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL ) THEN
864: Fnd_Log.STRING(Fnd_Log.LEVEL_EXCEPTION,
865: 'csd.plsql.csd_repairs_util.check_task_n_wipjob',
866: 'EXC_UNEXPECTED_ERROR ['||x_msg_data||']');
867: END IF;
868:
869: WHEN OTHERS THEN

Line 879: 'csd.plsql.csd_repairs_util.check_task_n_wipjob',

875: Fnd_Msg_Pub.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data );
876:
877: IF ( Fnd_Log.LEVEL_EXCEPTION >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL ) THEN
878: Fnd_Log.STRING(Fnd_Log.LEVEL_EXCEPTION,
879: 'csd.plsql.csd_repairs_util.check_task_n_wipjob',
880: 'SQL Message ['||SQLERRM||']');
881: END IF;
882:
883:

Line 893: -- p_status_rec IN CSD_REPAIRS_PUB.REPAIR_STATUS_REC_TYPE ,

889: -- Type : Private
890: -- Pre-Req : None
891: -- Parameters:
892: -- IN
893: -- p_status_rec IN CSD_REPAIRS_PUB.REPAIR_STATUS_REC_TYPE ,
894: -- OUT
895: -- x_status_rec OUT CSD_REPAIRS_PUB.REPAIR_STATUS_REC_TYPE ,
896: -- x_return_status
897: --

Line 895: -- x_status_rec OUT CSD_REPAIRS_PUB.REPAIR_STATUS_REC_TYPE ,

891: -- Parameters:
892: -- IN
893: -- p_status_rec IN CSD_REPAIRS_PUB.REPAIR_STATUS_REC_TYPE ,
894: -- OUT
895: -- x_status_rec OUT CSD_REPAIRS_PUB.REPAIR_STATUS_REC_TYPE ,
896: -- x_return_status
897: --
898: -- Version : Current version 1.0
899: -- Initial Version 1.0

Line 905: PROCEDURE Convert_status_Val_to_Id(p_repair_status_rec IN Csd_Repairs_Pub.REPAIR_STATUS_REC_TYPE,

901: -- Description : Converts value to Ids in the input repair status record.
902: --
903: -- ***********************************************************
904:
905: PROCEDURE Convert_status_Val_to_Id(p_repair_status_rec IN Csd_Repairs_Pub.REPAIR_STATUS_REC_TYPE,
906: x_repair_status_rec OUT NOCOPY Csd_Repairs_Pub.REPAIR_STATUS_REC_TYPE,
907: x_return_status OUT NOCOPY VARCHAR2)
908: IS
909: l_debug_level NUMBER;

Line 906: x_repair_status_rec OUT NOCOPY Csd_Repairs_Pub.REPAIR_STATUS_REC_TYPE,

902: --
903: -- ***********************************************************
904:
905: PROCEDURE Convert_status_Val_to_Id(p_repair_status_rec IN Csd_Repairs_Pub.REPAIR_STATUS_REC_TYPE,
906: x_repair_status_rec OUT NOCOPY Csd_Repairs_Pub.REPAIR_STATUS_REC_TYPE,
907: x_return_status OUT NOCOPY VARCHAR2)
908: IS
909: l_debug_level NUMBER;
910:

Line 914: FROM CSD_REPAIRS

910:
911: --Value to id conversion cursor
912: CURSOR repair_id_conv_cur(p_repair_number VARCHAR2) IS
913: SELECT REPAIR_LINE_ID
914: FROM CSD_REPAIRS
915: WHERE repair_number = p_repair_number;
916:
917: -- Get status_id from status_Code
918: CURSOR flow_stat_cur(p_repair_status VARCHAR2) IS

Line 932: Fnd_Log.STRING (Fnd_Log.LEVEL_PROCEDURE, 'csd.plsql.csd_repairs_util.Convert_Status_val_to_Id.begin',

928: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
929: l_debug_level := Fnd_Log.G_CURRENT_RUNTIME_LEVEL;
930:
931: IF (Fnd_Log.LEVEL_PROCEDURE >= l_debug_level) THEN
932: Fnd_Log.STRING (Fnd_Log.LEVEL_PROCEDURE, 'csd.plsql.csd_repairs_util.Convert_Status_val_to_Id.begin',
933: '-------------Entered Convert_Status_val_to_Id----------------');
934: END IF;
935:
936:

Line 1006: Fnd_Log.STRING (Fnd_Log.level_procedure, 'csd.plsql.csd_repairs_util.Convert_Status_Val_to_Id.end',

1002:
1003:
1004:
1005: IF (Fnd_Log.level_procedure >= l_debug_level) THEN
1006: Fnd_Log.STRING (Fnd_Log.level_procedure, 'csd.plsql.csd_repairs_util.Convert_Status_Val_to_Id.end',
1007: '-------------Leaving Convert_Status_Val_to_Id----------------');
1008: END IF;
1009:
1010: END Convert_status_Val_to_Id;

Line 1090: l_sql_str := 'Select ''x'' from csd_repairs ro '

1086: ELSE
1087: IF(l_predicate IS NOT NULL AND l_predicate <> '(1=1)') THEN
1088:
1089: debug('forming sql str');
1090: l_sql_str := 'Select ''x'' from csd_repairs ro '
1091: || ' Where ro.repair_line_id = :1 and '
1092: || l_predicate ;
1093:
1094: debug('l_sql before['||l_sql_str||']');

Line 1136: l_sql_str := ' Select ''x'' from csd_repairs_v ro, csd_product_txns_v prd, '

1132: p_table_alias => l_table_alias );
1133:
1134: IF(l_predicate IS NULL OR l_predicate <> '(1=1)') THEN
1135:
1136: l_sql_str := ' Select ''x'' from csd_repairs_v ro, csd_product_txns_v prd, '
1137: + ' cs_estimate_details csd Where ro.repair_line_id = :1'
1138: + ' And prd.repair_line_id = ro.repair_line_id '
1139: + ' And prd.action_code = :2 '
1140: + ' And prd.action_type = :3 '

Line 1180: l_sql_str := ' Select ''x'' from csd_repairs_v ro, csd_product_txns_v prd, '

1176: p_table_alias => l_table_alias );
1177:
1178: IF(l_predicate IS NULL OR l_predicate <> '(1=1)') THEN
1179:
1180: l_sql_str := ' Select ''x'' from csd_repairs_v ro, csd_product_txns_v prd, '
1181: + ' cs_estimate_details csd Where ro.repair_line_id = :1'
1182: + ' And prd.repair_line_id = ro.repair_line_id '
1183: + ' And prd.action_code = :2 '
1184: + ' And prd.action_type = :3 '

Line 1326: 'CSD.PLSQL.CSD_REPAIRS_UTIL.CHANGE_ITEM_IB_OWNER.BEGIN',

1322: savepoint CHANGE_ITEM_IB_OWNER;
1323:
1324: if (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) then
1325: fnd_log.STRING (fnd_log.level_procedure,
1326: 'CSD.PLSQL.CSD_REPAIRS_UTIL.CHANGE_ITEM_IB_OWNER.BEGIN',
1327: 'Enter - Change Item IB Owner');
1328: end if;
1329:
1330: -- Initialize API return status to success

Line 1485: 'CSD.PLSQL.CSD_REPAIRS_UTIL.CHANGE_ITEM_IB_OWNER.END',

1481: COMMIT WORK;
1482:
1483: If (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) then
1484: fnd_log.STRING (fnd_log.level_procedure,
1485: 'CSD.PLSQL.CSD_REPAIRS_UTIL.CHANGE_ITEM_IB_OWNER.END',
1486: 'Exit - Change Item IB Owner');
1487: End if;
1488:
1489: EXCEPTION

Line 1587: lc_api_name CONSTANT VARCHAR2(50) := 'csd_repairs_util.get_contract_resolve_by_date';

1583: x_msg_data OUT NOCOPY VARCHAR2,
1584: x_resolve_by_date OUT NOCOPY DATE
1585: ) IS
1586: -- define constants
1587: lc_api_name CONSTANT VARCHAR2(50) := 'csd_repairs_util.get_contract_resolve_by_date';
1588:
1589: -- define variables
1590: l_server_timezone_id NUMBER;
1591:

Line 1766: lc_mod_name varchar2(100) := 'csd.plsql.csd_repairs_util.auto_update_ro_status';

1762: l_repair_type_id number;
1763: l_object_version_number number;
1764: lc_log_level number := fnd_log.g_current_runtime_level;
1765: lc_procedure_level number := fnd_log.level_procedure;
1766: lc_mod_name varchar2(100) := 'csd.plsql.csd_repairs_util.auto_update_ro_status';
1767: lc_api_version_number number := 1.0;
1768: lc_api_name varchar2(60) := 'auto_update_ro_status';
1769: l_un_rcvd_lines_exists varchar2(3);
1770:

Line 1857: from csd_repairs cr

1853: cr.object_version_number
1854: into l_from_flow_status_id,
1855: l_repair_type_id,
1856: l_object_version_number
1857: from csd_repairs cr
1858: where cr.repair_line_id = p_repair_line_id;
1859: exception
1860: when no_data_found then
1861: -- should never get in here.

Line 1879: fnd_log.string(lc_log_level,lc_mod_name,'calling csd_repairs_pvt.update_flow_status API');

1875: end if;
1876: end if;
1877: -- call the update flow status API to update the RO status.
1878: if lc_log_level >= lc_procedure_level then
1879: fnd_log.string(lc_log_level,lc_mod_name,'calling csd_repairs_pvt.update_flow_status API');
1880: end if;
1881:
1882: csd_repairs_pvt.update_flow_status(p_api_version => 1,
1883: p_commit => fnd_api.g_false,

Line 1882: csd_repairs_pvt.update_flow_status(p_api_version => 1,

1878: if lc_log_level >= lc_procedure_level then
1879: fnd_log.string(lc_log_level,lc_mod_name,'calling csd_repairs_pvt.update_flow_status API');
1880: end if;
1881:
1882: csd_repairs_pvt.update_flow_status(p_api_version => 1,
1883: p_commit => fnd_api.g_false,
1884: p_init_msg_list => fnd_api.g_false,
1885: p_validation_level => fnd_api.g_valid_level_full,
1886: x_return_status => x_return_status,

Line 1900: fnd_log.string(lc_log_level,lc_mod_name,'Error in csd_repairs_pvt.update_flow_status

1896: p_object_version_number => l_object_version_number,
1897: x_object_version_number => x_object_version_number );
1898: if x_return_status <> fnd_api.g_ret_sts_success then
1899: if lc_log_level >= lc_procedure_level then
1900: fnd_log.string(lc_log_level,lc_mod_name,'Error in csd_repairs_pvt.update_flow_status
1901: ['||x_msg_data||']');
1902: end if;
1903:
1904: if p_validation_level = fnd_api.g_valid_level_full then

Line 1936: -- px_repln_rec in out nocopy CSD_REPAIRS_PUB.REPLN_REC_TYPE Y

1932: -- Type : Private
1933: -- Pre-Req : None
1934: -- Parameters:
1935: -- IN OUT required?
1936: -- px_repln_rec in out nocopy CSD_REPAIRS_PUB.REPLN_REC_TYPE Y
1937: --
1938: -- Version : Current version 1.0
1939: -- Initial Version 1.0
1940: --

Line 1962: px_repln_rec in out nocopy csd_repairs_pub.repln_rec_type,

1958: PROCEDURE DEFAULT_RO_ATTRS_FROM_RULE (
1959: p_api_version in number,
1960: p_commit in varchar2,
1961: p_init_msg_list in varchar2,
1962: px_repln_rec in out nocopy csd_repairs_pub.repln_rec_type,
1963: x_return_status out nocopy varchar2,
1964: x_msg_count out nocopy number,
1965: x_msg_data out nocopy varchar2)
1966: IS

Line 1998: lc_mod_name varchar2(100) := 'csd.plsql.csd_repairs_util.default_ro_attrs_from_rule';

1994: l_repair_mode VARCHAR2(30) := ''; -- repair mode display name
1995: l_auto_process_rma VARCHAR2(30) := '';
1996: lc_log_level number := fnd_log.g_current_runtime_level;
1997: lc_procedure_level number := fnd_log.level_procedure;
1998: lc_mod_name varchar2(100) := 'csd.plsql.csd_repairs_util.default_ro_attrs_from_rule';
1999: lc_api_version_number number := 1.0;
2000: lc_api_name varchar2(60) := 'default_ro_attrs_from_rule';
2001:
2002: BEGIN

Line 2276: lc_mod_name CONSTANT VARCHAR2(40) := 'csd_repairs_util.create_requisition';

2272: ) IS
2273:
2274: lc_api_version CONSTANT NUMBER default 1.0;
2275: lc_api_name CONSTANT VARCHAR2(30) := 'CREATE_REQUISITION';
2276: lc_mod_name CONSTANT VARCHAR2(40) := 'csd_repairs_util.create_requisition';
2277:
2278: l_person_id NUMBER;
2279: l_material_account JTF_NUMBER_TABLE;
2280: l_material_variance_account JTF_NUMBER_TABLE;

Line 3025: lc_mod_name CONSTANT VARCHAR2(50) := 'csd_repairs_util.create_repair_warranty';

3021: )
3022: IS
3023: lc_api_version CONSTANT NUMBER DEFAULT 1.0;
3024: lc_api_name CONSTANT VARCHAR2(30) := 'create_repair_warranty';
3025: lc_mod_name CONSTANT VARCHAR2(50) := 'csd_repairs_util.create_repair_warranty';
3026:
3027: l_repair_line_id NUMBER;
3028: l_incident_id NUMBER;
3029: l_service_item_id NUMBER;

Line 3186: csd_repairs cr

3182: SELECT cpt.repair_line_id,oeh.header_id,ced.inventory_item_id,cr.incident_id
3183: INTO l_repair_line_id,l_header_id,l_ship_inv_item_id,l_incident_id
3184: FROM oe_order_lines_all oel, oe_order_headers_all oeh,
3185: cs_estimate_details ced, csd_product_transactions cpt,wsh_delivery_details wdd,
3186: csd_repairs cr
3187: WHERE oel.line_id = p_order_line_id
3188: AND oel.header_id = oeh.header_id
3189: AND oeh.header_id = ced.order_header_id
3190: AND oel.line_id = ced.order_line_id

Line 3693: lc_mod_name CONSTANT VARCHAR2(50) := 'csd_repairs_util.create_inst_party_relation';

3689: ) IS
3690:
3691: lc_api_version CONSTANT NUMBER DEFAULT 1.0;
3692: lc_api_name CONSTANT VARCHAR2(30) := 'create_inst_party_relation';
3693: lc_mod_name CONSTANT VARCHAR2(50) := 'csd_repairs_util.create_inst_party_relation';
3694:
3695: l_exists VARCHAR2(1);
3696:
3697: -- csi datastructures.

Line 3849: END Csd_Repairs_Util;

3845: END IF;
3846:
3847: END create_inst_party_relation;
3848:
3849: END Csd_Repairs_Util;