[Home] [Help]
1890: CLOSE c_Visit;
1891:
1892: --PRAKKUM :: 11/06/2012 :: Bug 14068468
1893: -- Flag to find whether visit is component visit or not
1894: l_is_comp_visit := AHL_CMP_UTIL_PKG.Is_Comp_Visit (p_visit_id);
1895: IF (l_log_statement >= l_log_current_level) THEN
1896: fnd_log.string(l_log_statement,L_DEBUG_KEY,'p_visit_id ** l_is_comp_visit--@> '||p_visit_id||' ** '||l_is_comp_visit);
1897: END IF;
1898:
2722: FETCH is_rep_batch_have_trans INTO l_is_vst_hav_trx_on_rep_btch;
2723: CLOSE is_rep_batch_have_trans;
2724:
2725: --PRAKKUM :: 11/06/2012 :: Bug 14068468
2726: l_is_comp_visit := AHL_CMP_UTIL_PKG.Is_Comp_Visit (p_visit_id);
2727: IF (l_log_statement >= l_log_current_level) THEN
2728: fnd_log.string(l_log_statement,L_DEBUG_KEY,'p_visit_id --@> '||p_visit_id);
2729: fnd_log.string(l_log_statement,L_DEBUG_KEY,'l_is_vst_hav_trx_on_rep_btch--@> '||l_is_vst_hav_trx_on_rep_btch);
2730: fnd_log.string(l_log_statement,L_DEBUG_KEY,'l_is_comp_visit--@> '||l_is_comp_visit);
5336: * Following validation needs to be bypassed for Component Visits, else it will fail when
5337: * the Component Visit is in Planning status, and it contains only Repair Batches (summary tasks).
5338: */
5339: IF c_task_rec.visit_task_id IS NULL AND c_visit_rec.STATUS_CODE = 'PLANNING' AND
5340: AHL_CMP_UTIL_PKG.Is_Comp_Visit (c_visit_rec.visit_id) = 'N' THEN
5341:
5342: IF (l_log_statement >= l_log_current_level) THEN
5343: fnd_log.string(l_log_statement,
5344: L_DEBUG_KEY,
6107: --PRAKKUM :: PIE :: 13-OCT-2010
6108: l_new_structure_flag VARCHAR2(1);
6109: l_def_stage_task_id NUMBER; --added by tchimira for VWPE
6110: l_planned_order_flag VARCHAR2(1); --added by skpathak for VWPE
6111: l_is_comp_visit VARCHAR2(1) := AHL_CMP_UTIL_PKG.Is_Comp_Visit (p_visit_id);
6112: -- SATRAJEN :: Bug 12990261 :: Sum up all error messages :: Jun 2012
6113: l_task_nos_1 VARCHAR2(1000):= '';
6114: l_task_nos_2 VARCHAR2(1000):= '';
6115: l_task_nos_3 VARCHAR2(1000):= '';
10130: * change similar to the way Visit status changes as Repair Batches are like mini-visits.
10131: * So, if all tasks under the Repair Batch are P2P, then its status should be 'RELEASED',
10132: * otherwise 'PARTIALLY RELEASED'.
10133: */
10134: IF (AHL_CMP_UTIL_PKG.Is_Comp_Visit (p_visit_id) = 'Y') THEN
10135:
10136: -- find which Repair Batch, the selected tasks belongs to
10137: OPEN get_rpr_batch_for_task_csr (p_tasks_tbl(p_tasks_tbl.FIRST).visit_task_id);
10138: FETCH get_rpr_batch_for_task_csr INTO l_repair_batch_name;
11688: /* MANESING::Bug 13713141, 16-Apr-2012, For Component Visits, Repair Batch status should also
11689: * change similar to the way Visit status changes as Repair Batches are like mini-visits.
11690: * So, if all tasks under the Repair Batch are P2P, then its status should be changed to 'RELEASED'.
11691: */
11692: IF (AHL_CMP_UTIL_PKG.Is_Comp_Visit (c_visit_rec.visit_id) = 'Y') THEN
11693:
11694: -- find which Repair Batch, the selected tasks belongs to
11695: OPEN get_rpr_batch_for_task_csr (l_visit_task_for_rpr_calc);
11696: FETCH get_rpr_batch_for_task_csr INTO l_repair_batch_name;
13975: END IF;
13976:
13977: -- SKPATHAK :: Bug 14016007 :: 03-MAY-2012 :: START
13978: -- Component Visits always have new structure and similarly visits with stage tasks will always have new structure
13979: l_is_comp_visit := AHL_CMP_UTIL_PKG.Is_Comp_Visit (p_visit_id);
13980: IF (l_log_statement >= l_log_current_level) THEN
13981: fnd_log.string(l_log_statement,L_DEBUG_KEY,'p_visit_id ** l_is_comp_visit--@> '||p_visit_id||' ** '||l_is_comp_visit);
13982: END IF;
13983: