[Home] [Help]
23: g_sr_severity NUMBER;
24: g_sr_owner NUMBER;
25: g_sr_summary VARCHAR2(240);
26: g_sr_status NUMBER;
27: g_sr_owner_type VARCHAR2(80) := FND_PROFILE.value('CS_SR_DEFAULT_OWNER_TYPE');
28:
29: g_ro_attribs_cached BOOLEAN := FALSE;
30: g_auto_process_rma VARCHAR2(1);
31: g_business_process_id NUMBER;
39: g_completion_subinv JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();
40: g_completion_locid JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
41: g_sc_id NUMBER;
42: g_upgrade_item_id NUMBER;
43: g_job_prefix VARCHAR2(30) := fnd_profile.value('CSD_DEFAULT_JOB_PREFIX');
44:
45: -- Private procedures.
46: /****************************************************************************************/
47: /* Procedure Name: process_post_wip_massload. */
245: THEN
246: RAISE fnd_api.g_exc_error;
247: END IF;
248:
249: l_default_ro_item := nvl(FND_PROFILE.VALUE('CSD_DEFAULT_RO_ITEM_AS_MATERIAL_ON_JOB'), 'N');
250:
251: IF g_upgrade_item_id IS NOT NULL OR l_default_ro_item = 'Y'
252: THEN
253: -- check if the operation exists.
276: THEN
277: SELECT department_id, supply_subinventory
278: INTO l_department_id, l_supply_subinventory
279: FROM csd_recall_parameters
280: WHERE organization_id = fnd_profile.value('CSD_DEF_REP_INV_ORG');
281: END IF;
282:
283: l_op_dtls_tbl(1).new_row := 'Y';
284: l_op_dtls_tbl(1).wip_entity_id := l_post_wipml_tbl(i).wip_entity_id;
321: THEN
322: SELECT department_id, supply_subinventory
323: INTO l_department_id, l_supply_subinventory
324: FROM csd_recall_parameters
325: WHERE organization_id = fnd_profile.value('CSD_DEF_REP_INV_ORG');
326: END IF;
327:
328: l_mtl_txn_dtls_tbl(i).new_row := 'Y';
329: l_mtl_txn_dtls_tbl(i).operation_seq_num := l_operation_seq_num;
400: AND crl.instance_id = cii.instance_id
401: AND crl.repair_line_id = cr.repair_line_id (+)
402: AND crl.incident_id = cs.incident_id (+)
403: AND crl.inventory_item_id = msi.inventory_item_id
404: AND msi.organization_id = fnd_profile.value('CSD_DEF_REP_INV_ORG');
405:
406: BEGIN
407:
408: -- print the header.
805: g_sr_urgency,
806: g_sr_owner,
807: g_sr_summary
808: FROM csd_recall_parameters
809: WHERE organization_id = FND_PROFILE.VALUE('CSD_DEF_REP_INV_ORG');
810:
811: l_service_request_rec.status_id := g_sr_status;
812: l_service_request_rec.severity_id := g_sr_severity;
813: l_service_request_rec.urgency_id := g_sr_urgency;
870: WHERE repair_type_id = p_ro_type_id;
871: END IF;
872:
873: -- get the contract
874: fnd_profile.get('SERVER_TIMEZONE_ID', l_server_tz_id);
875:
876: -- bug#9808614. if bill to and ship to are not yet cached, do so.
877: IF NOT g_csd_shipto_billto_cache.EXISTS(l_csd_recall_lines_tbl(l_index).owner_party_id)
878: THEN
1032: IF l_job_status = 0 THEN
1033: SELECT wip_job_status
1034: INTO l_job_status
1035: FROM csd_recall_parameters
1036: WHERE organization_id = FND_PROFILE.VALUE('CSD_DEF_REP_INV_ORG');
1037: END IF;
1038: -- find the bill and route from the service code provided.
1039: -- prepare the job attributes.
1040: IF NOT g_bill_details_cached
1056: bom_bill_of_materials bom ,
1057: bom_operational_routings bor
1058: WHERE cscwe.service_code_id = p_service_code_id
1059: AND cscwe.work_entity_type_code = 'BOM'
1060: AND cscwe.work_entity_id3 = fnd_profile.value('csd_def_rep_inv_org')
1061: AND cscwe.work_entity_id1 = bom.bill_sequence_id (+)
1062: AND cscwe.work_entity_id2 = bor.routing_sequence_id (+);
1063:
1064: g_bill_details_cached := TRUE;
1070: IF g_bill_id.COUNT = 0
1071: THEN
1072: l_job_header_tbl(l_job_header_index).source_code := 'DEPOT_REPAIR';
1073: l_job_header_tbl(l_job_header_index).source_line_id := l_csd_recall_lines_tbl(l_index).repair_line_id;
1074: l_job_header_tbl(l_job_header_index).organization_id := NVL(p_wip_inv_org_id,fnd_profile.value('csd_def_rep_inv_org'));
1075: l_job_header_tbl(l_job_header_index).status_type := NVL(l_job_status,1);
1076: l_job_header_tbl(l_job_header_index).load_type := 4;
1077: l_job_header_tbl(l_job_header_index).process_phase := 2;
1078: l_job_header_tbl(l_job_header_index).process_status := 1;
1101: FOR l_job_index IN 1 ..g_bill_id.COUNT
1102: LOOP
1103: l_job_header_tbl(l_job_header_index).source_code := 'DEPOT_REPAIR';
1104: l_job_header_tbl(l_job_header_index).source_line_id := l_csd_recall_lines_tbl(l_index).repair_line_id;
1105: l_job_header_tbl(l_job_header_index).organization_id := NVL(p_wip_inv_org_id,fnd_profile.value('csd_def_rep_inv_org'));
1106: l_job_header_tbl(l_job_header_index).status_type := NVL(l_job_status,1);
1107: l_job_header_tbl(l_job_header_index).load_type := 4;
1108: l_job_header_tbl(l_job_header_index).process_phase := 2;
1109: l_job_header_tbl(l_job_header_index).process_status := 1;