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.GME_CREATE_STEP_PVT dependencies on STANDARD

Line 860: l_gme_batch_step_dep (j).standard_delay :=

856:
857: l_gme_batch_step_dep (j).dep_type := p_routing_depd_tbl (i).dep_type;
858: l_gme_batch_step_dep (j).rework_code :=
859: p_routing_depd_tbl (i).rework_code;
860: l_gme_batch_step_dep (j).standard_delay :=
861: p_routing_depd_tbl (i).standard_delay;
862: l_gme_batch_step_dep (j).min_delay :=
863: p_routing_depd_tbl (i).minimum_delay;
864: l_gme_batch_step_dep (j).max_delay :=

Line 861: p_routing_depd_tbl (i).standard_delay;

857: l_gme_batch_step_dep (j).dep_type := p_routing_depd_tbl (i).dep_type;
858: l_gme_batch_step_dep (j).rework_code :=
859: p_routing_depd_tbl (i).rework_code;
860: l_gme_batch_step_dep (j).standard_delay :=
861: p_routing_depd_tbl (i).standard_delay;
862: l_gme_batch_step_dep (j).min_delay :=
863: p_routing_depd_tbl (i).minimum_delay;
864: l_gme_batch_step_dep (j).max_delay :=
865: p_routing_depd_tbl (i).max_delay;

Line 963: --multiply the step qty with standard factor to get mass qty

959:
960: --Bug#5231180 used gme_common_pvt variables rather GMD spec variables
961: --IF l_uom_class = NVL(gmd_auto_step_calc.g_profile_mass_um_type,gme_common_pvt.g_mass_um_type) THEN
962: IF l_uom_class = gme_common_pvt.g_mass_um_type THEN
963: --multiply the step qty with standard factor to get mass qty
964: l_mass_qty := p_recipe_rout_step_tbl (1).step_qty * l_std_factor;
965: --ELSIF l_uom_class = NVL(gmd_auto_step_calc.g_profile_volume_um_type,gme_common_pvt.g_volume_um_type) THEN
966: ELSIF l_uom_class = gme_common_pvt.g_volume_um_type THEN
967: --multiply the step qty with standard factor to get vol qty

Line 967: --multiply the step qty with standard factor to get vol qty

963: --multiply the step qty with standard factor to get mass qty
964: l_mass_qty := p_recipe_rout_step_tbl (1).step_qty * l_std_factor;
965: --ELSIF l_uom_class = NVL(gmd_auto_step_calc.g_profile_volume_um_type,gme_common_pvt.g_volume_um_type) THEN
966: ELSIF l_uom_class = gme_common_pvt.g_volume_um_type THEN
967: --multiply the step qty with standard factor to get vol qty
968: l_volume_qty := p_recipe_rout_step_tbl (1).step_qty * l_std_factor;
969: END IF;
970:
971: IF NVL (g_debug, -1) = gme_debug.g_log_statement THEN

Line 1669: ,standard_delay

1665: IS
1666: CURSOR cur_get_step_date_4_cal (v_step_id NUMBER, v_batch_id NUMBER)
1667: IS
1668: SELECT dep_type, r.plan_start_date, r.plan_cmplt_date
1669: ,standard_delay
1670: FROM gme_batch_step_dependencies d, gme_batch_steps r
1671: WHERE d.batch_id = r.batch_id
1672: AND d.batch_id = v_batch_id
1673: AND r.batchstep_id = d.dep_step_id

Line 1679: ,1, r.plan_start_date + standard_delay / 24

1675:
1676: CURSOR cur_get_step_date (v_step_id NUMBER, v_batch_id NUMBER)
1677: IS
1678: SELECT MAX (DECODE (dep_type
1679: ,1, r.plan_start_date + standard_delay / 24
1680: ,0, r.plan_cmplt_date + standard_delay / 24) )
1681: FROM gme_batch_step_dependencies d, gme_batch_steps r
1682: WHERE d.batch_id = r.batch_id
1683: AND d.batch_id = v_batch_id

Line 1680: ,0, r.plan_cmplt_date + standard_delay / 24) )

1676: CURSOR cur_get_step_date (v_step_id NUMBER, v_batch_id NUMBER)
1677: IS
1678: SELECT MAX (DECODE (dep_type
1679: ,1, r.plan_start_date + standard_delay / 24
1680: ,0, r.plan_cmplt_date + standard_delay / 24) )
1681: FROM gme_batch_step_dependencies d, gme_batch_steps r
1682: WHERE d.batch_id = r.batch_id
1683: AND d.batch_id = v_batch_id
1684: AND r.batchstep_id = d.dep_step_id

Line 1709: ,p_offset => rec.standard_delay

1705: END IF;
1706:
1707: l_plan_start_date :=
1708: get_working_start_time (p_start_date => l_date
1709: ,p_offset => rec.standard_delay
1710: ,p_calendar_code => p_calendar_code);
1711:
1712: IF l_plan_start_date IS NULL THEN
1713: RETURN NULL;

Line 2710: Characters 12-14 is standard delay 001

2706: /* Each record is built up of 14 character strings like this 00020000100001 by the query below
2707: Characters 1-5 is step_no 00020
2708: Characters 6-10 is dep_step_no 00010
2709: Character 11 is dep_type 0
2710: Characters 12-14 is standard delay 001
2711: If there is a dependency like 30 -> 20 -> 10 then the output would be 0003000020000100020000100001
2712: If there are multiple branches then we will get multiple records like the above */
2713: CURSOR Cur_get_branches(v_batch_id NUMBER, v_batchstep_id NUMBER) IS
2714: SELECT branch, LENGTH(branch) sz

Line 2715: FROM (SELECT REPLACE(sys_connect_by_path(LPAD(s.batchstep_no, 5, 0)||LPAD(p.batchstep_no, 5, 0 )||dep_type||LPAD(standard_delay, 3,0),' '), ' ', NULL) branch

2711: If there is a dependency like 30 -> 20 -> 10 then the output would be 0003000020000100020000100001
2712: If there are multiple branches then we will get multiple records like the above */
2713: CURSOR Cur_get_branches(v_batch_id NUMBER, v_batchstep_id NUMBER) IS
2714: SELECT branch, LENGTH(branch) sz
2715: FROM (SELECT REPLACE(sys_connect_by_path(LPAD(s.batchstep_no, 5, 0)||LPAD(p.batchstep_no, 5, 0 )||dep_type||LPAD(standard_delay, 3,0),' '), ' ', NULL) branch
2716: FROM (SELECT * FROM gme_batch_step_dependencies WHERE batch_id = v_batch_id) d,
2717: (SELECT * FROM gme_batch_steps WHERE batch_id = v_batch_id) s,
2718: (SELECT * FROM gme_batch_steps WHERE batch_id = v_batch_id) p
2719: WHERE s.batchstep_id = d.batchstep_id

Line 2733: l_standard_delay NUMBER;

2729: l_duration NUMBER := 0;
2730: l_step_no NUMBER;
2731: l_dep_step_no NUMBER;
2732: l_dep_type NUMBER;
2733: l_standard_delay NUMBER;
2734: BEGIN
2735: IF g_debug <= gme_debug.g_log_procedure THEN
2736: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'|| l_api_name);
2737: END IF;

Line 2762: /* Divide by 14 because length of step_no = 5, dep_step_no = 5, dep_type = 1, standard_delay = 3 */

2758: gme_debug.put_line(g_pkg_name || '.'|| l_api_name||' current branch: ' || l_branches_tbl(j).branch);
2759: END IF;
2760: m := 1;
2761: n := 5;
2762: /* Divide by 14 because length of step_no = 5, dep_step_no = 5, dep_type = 1, standard_delay = 3 */
2763: FOR k IN 1..l_branches_tbl(j).sz/14 LOOP --Start parsing string now
2764: l_step_no := SUBSTR(l_branches_tbl(j).branch, m, 5);
2765: m := n + 1;
2766: n := m + 4;

Line 2773: l_standard_delay := SUBSTR(l_branches_tbl(j).branch, m, 3);

2769: n := m + 0;
2770: l_dep_type := SUBSTR(l_branches_tbl(j).branch, m, 1);
2771: m := n + 1;
2772: n := m + 2;
2773: l_standard_delay := SUBSTR(l_branches_tbl(j).branch, m, 3);
2774: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
2775: gme_debug.put_line(g_pkg_name || '.'|| l_api_name||' Step->Depstep->Deptype->Delay = '||l_step_no||'->'||l_dep_step_no||'->'||l_dep_type||'->'||l_standard_delay);
2776: END IF;
2777: IF (k = 1) THEN

Line 2775: gme_debug.put_line(g_pkg_name || '.'|| l_api_name||' Step->Depstep->Deptype->Delay = '||l_step_no||'->'||l_dep_step_no||'->'||l_dep_type||'->'||l_standard_delay);

2771: m := n + 1;
2772: n := m + 2;
2773: l_standard_delay := SUBSTR(l_branches_tbl(j).branch, m, 3);
2774: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
2775: gme_debug.put_line(g_pkg_name || '.'|| l_api_name||' Step->Depstep->Deptype->Delay = '||l_step_no||'->'||l_dep_step_no||'->'||l_dep_type||'->'||l_standard_delay);
2776: END IF;
2777: IF (k = 1) THEN
2778: l_duration := l_step_duration_tab(l_step_no);
2779: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN

Line 2783: l_duration := l_duration + l_standard_delay;

2779: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
2780: gme_debug.put_line(g_pkg_name || '.'|| l_api_name||' step->duration: ' || l_step_no||'->'||l_duration);
2781: END IF;
2782: END IF;
2783: l_duration := l_duration + l_standard_delay;
2784: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
2785: gme_debug.put_line(g_pkg_name || '.'|| l_api_name||' depstep->duration: ' || l_dep_step_no||'->'||l_duration);
2786: END IF;
2787: IF (l_dep_type = 1) THEN -- Start to Start