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_RO_BULLETINS_PVT dependencies on CSD_REPAIRS

Line 611: l_repln_rec CSD_REPAIRS_PUB.REPLN_Rec_Type;

607: l_rule_id NUMBER := NULL;
608: l_rule_results_tbl CSD_RULES_ENGINE_PVT.CSD_RULE_RESULTS_TBL_TYPE;
609: l_rule_results_rec CSD_RULES_ENGINE_PVT.CSD_RULE_RESULTS_REC_TYPE;
610: l_rec_ind INTEGER := NULL;
611: l_repln_rec CSD_REPAIRS_PUB.REPLN_Rec_Type;
612:
613: BEGIN
614: --* Standard Start of API savepoint
615: SAVEPOINT LINK_BULLETINS_TO_RO_PVT;

Line 644: l_repln_rec.object_version_number := GET_CSD_REPAIRS_OBJ_VER_NUM(p_repair_line_id);

640: --** debug starts!!
641: --dbms_output.put_line('in CREATE_NEW_RO_BULLETIN_LINK bulletin_check_date = ' || l_repln_rec.bulletin_check_date);
642: --** debug ends!!
643:
644: l_repln_rec.object_version_number := GET_CSD_REPAIRS_OBJ_VER_NUM(p_repair_line_id);
645: CSD_REPAIRS_PVT.update_repair_order(
646: p_api_version_number => p_api_version_number,
647: p_init_msg_list => p_init_msg_list,
648: p_commit => p_commit,

Line 645: CSD_REPAIRS_PVT.update_repair_order(

641: --dbms_output.put_line('in CREATE_NEW_RO_BULLETIN_LINK bulletin_check_date = ' || l_repln_rec.bulletin_check_date);
642: --** debug ends!!
643:
644: l_repln_rec.object_version_number := GET_CSD_REPAIRS_OBJ_VER_NUM(p_repair_line_id);
645: CSD_REPAIRS_PVT.update_repair_order(
646: p_api_version_number => p_api_version_number,
647: p_init_msg_list => p_init_msg_list,
648: p_commit => p_commit,
649: p_validation_level => p_validation_level,

Line 880: l_repln_rec CSD_REPAIRS_PUB.REPLN_Rec_Type;

876: l_wf_item_type VARCHAR2(8) := NULL;
877: l_wf_process_name VARCHAR2(30) := NULL;
878: l_wf_item_key VARCHAR2(240) := NULL;
879: l_wf_current_threshold NUMBER := NULL;
880: l_repln_rec CSD_REPAIRS_PUB.REPLN_Rec_Type;
881: l_instance_id NUMBER := NULL;
882: l_freq_code VARCHAR2(30) := NULL;
883: l_create_new_ro_bulletin_link VARCHAR2(1) := FND_API.G_FALSE;
884:

Line 935: FROM csd_repairs

931: SELECT a.ro_bulletin_id
932: FROM csd_ro_bulletins a
933: WHERE a.repair_line_id IN
934: (SELECT repair_line_id
935: FROM csd_repairs
936: WHERE customer_product_id = p_instance_id)
937: AND a.bulletin_id = p_bulletin_id
938: ; --* end cur_check_by_instance *--
939: BEGIN

Line 1063: --* ##################Call csd_repairs_pvt to update Bulletin check date

1059: END IF;
1060: RAISE FND_API.G_EXC_ERROR;
1061: END IF; --* end IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) *--
1062:
1063: --* ##################Call csd_repairs_pvt to update Bulletin check date
1064:
1065: --** debug starts!!
1066: --dbms_output.put_line('in CREATE_NEW_RO_BULLETIN_LINK x_return_status = ' || x_return_status);
1067: --** debug ends!!

Line 1102: --* update csd_repairs with escalation_code

1098: --** debug starts!!
1099: --dbms_output.put_line('in CREATE_NEW_RO_BULLETIN_LINK l_escalation_code = ' || l_escalation_code);
1100: --** debug ends!!
1101:
1102: --* update csd_repairs with escalation_code
1103: --* via csd_repairs_pvt
1104:
1105:
1106: IF (l_escalation_code IS NOT NULL ) THEN --* pass in when not null

Line 1103: --* via csd_repairs_pvt

1099: --dbms_output.put_line('in CREATE_NEW_RO_BULLETIN_LINK l_escalation_code = ' || l_escalation_code);
1100: --** debug ends!!
1101:
1102: --* update csd_repairs with escalation_code
1103: --* via csd_repairs_pvt
1104:
1105:
1106: IF (l_escalation_code IS NOT NULL ) THEN --* pass in when not null
1107: l_repln_rec.escalation_code := l_escalation_code;

Line 1112: l_repln_rec.object_version_number := GET_CSD_REPAIRS_OBJ_VER_NUM(p_repair_line_id);

1108: ELSE
1109: l_repln_rec.escalation_code := FND_API.G_MISS_CHAR; --* don't wipe out old value
1110: END IF; --* end IF (l_escalation_code IS NOT NULL ) *--
1111:
1112: l_repln_rec.object_version_number := GET_CSD_REPAIRS_OBJ_VER_NUM(p_repair_line_id);
1113:
1114:
1115: CSD_REPAIRS_PVT.update_repair_order(
1116: p_api_version_number => p_api_version_number,

Line 1115: CSD_REPAIRS_PVT.update_repair_order(

1111:
1112: l_repln_rec.object_version_number := GET_CSD_REPAIRS_OBJ_VER_NUM(p_repair_line_id);
1113:
1114:
1115: CSD_REPAIRS_PVT.update_repair_order(
1116: p_api_version_number => p_api_version_number,
1117: p_init_msg_list => p_init_msg_list,
1118: p_commit => p_commit,
1119: p_validation_level => p_validation_level,

Line 1244: -- API Name: GET_CSD_REPAIRS_OBJ_VER_NUM

1240:
1241: -- *******************************************************
1242: -- Start of Comments
1243: -- *******************************************************
1244: -- API Name: GET_CSD_REPAIRS_OBJ_VER_NUM
1245: -- Type : Private
1246: -- Pre-Req :
1247: -- Parameters:
1248: -- IN

Line 1256: FUNCTION GET_CSD_REPAIRS_OBJ_VER_NUM(

1252: -- History: Jan-17-2008 rfieldma created
1253: -- -------------------
1254: -- End of Comments
1255: -- -------------------
1256: FUNCTION GET_CSD_REPAIRS_OBJ_VER_NUM(
1257: p_repair_line_id IN NUMBER
1258: ) RETURN NUMBER IS
1259: ---- local vars ----
1260: l_obj_ver_num NUMBER := NULL;

Line 1264: FROM csd_repairs

1260: l_obj_ver_num NUMBER := NULL;
1261: ---- cursors ----
1262: CURSOR cur_get_obj_ver_num(p_repair_line_id NUMBER) IS
1263: SELECT object_version_number
1264: FROM csd_repairs
1265: WHERE repair_line_id = p_repair_line_id
1266: ; --* end cur_get_obj_ver_num *--
1267:
1268: BEGIN

Line 1274: END GET_CSD_REPAIRS_OBJ_VER_NUM;

1270: FETCH cur_get_obj_ver_num INTO l_obj_ver_num;
1271: CLOSE cur_get_obj_ver_num;
1272:
1273: RETURN l_obj_ver_num;
1274: END GET_CSD_REPAIRS_OBJ_VER_NUM;
1275:
1276:
1277: /*--------------------------------------------------------------------*/
1278: /* procedure name: LINK_BULLETINS_TO_REPAIRS_CP */

Line 1695: csd_sc_domains_v dom, CSD_REPAIRS dra

1691: p_repair_line_id number)
1692: IS
1693: SELECT 'X'
1694: FROM
1695: csd_sc_domains_v dom, CSD_REPAIRS dra
1696: WHERE dom.service_code_id = p_service_code_id
1697: AND dra.repair_line_id = p_repair_line_id
1698: AND (dom.inventory_item_id = dra.inventory_item_id
1699: OR (dom.category_set_id = fnd_profile.value('CSD_DEFAULT_CATEGORY_SET')

Line 1743: FROM CSD_REPAIRS

1739:
1740: CURSOR c_get_ro_item (p_repair_line_id number)
1741: IS
1742: SELECT inventory_item_id
1743: FROM CSD_REPAIRS
1744: WHERE repair_line_id = p_repair_line_id;
1745:
1746: -- STANDARD CONSTANTS
1747: l_api_name CONSTANT VARCHAR2(30) := 'APPLY_BULLETIN_SCS_TO_RO';