[Home] [Help]
13: -- wait for 6000 seconds for the concurrent request to complete.
14: g_total_request_time CONSTANT NUMBER := 6000;
15:
16: -- Bug 3684073. Modified the constants to VARCHAR2 below.
17: -- We are no longer using mfg_lookups to derive the lookup_code.
18: -- g_lookup_yes CONSTANT NUMBER := 1; -- 1 is lookup_code for 'YES' in mfg_lookups.
19: -- g_lookup_no CONSTANT NUMBER := 2; -- 2 is lookup_code for 'NO' in mfg_lookups.
20:
21: g_lookup_yes CONSTANT VARCHAR2(3) := 'YES';
14: g_total_request_time CONSTANT NUMBER := 6000;
15:
16: -- Bug 3684073. Modified the constants to VARCHAR2 below.
17: -- We are no longer using mfg_lookups to derive the lookup_code.
18: -- g_lookup_yes CONSTANT NUMBER := 1; -- 1 is lookup_code for 'YES' in mfg_lookups.
19: -- g_lookup_no CONSTANT NUMBER := 2; -- 2 is lookup_code for 'NO' in mfg_lookups.
20:
21: g_lookup_yes CONSTANT VARCHAR2(3) := 'YES';
22: g_lookup_no CONSTANT VARCHAR2(3) := 'NO';
15:
16: -- Bug 3684073. Modified the constants to VARCHAR2 below.
17: -- We are no longer using mfg_lookups to derive the lookup_code.
18: -- g_lookup_yes CONSTANT NUMBER := 1; -- 1 is lookup_code for 'YES' in mfg_lookups.
19: -- g_lookup_no CONSTANT NUMBER := 2; -- 2 is lookup_code for 'NO' in mfg_lookups.
20:
21: g_lookup_yes CONSTANT VARCHAR2(3) := 'YES';
22: g_lookup_no CONSTANT VARCHAR2(3) := 'NO';
23:
32: -------------------------------------------------------------------------------
33: -- Forward declaration of Local functions.
34: -------------------------------------------------------------------------------
35:
36: FUNCTION get_mfg_lookups_value (p_meaning VARCHAR2,
37: p_lookup_type VARCHAR2) RETURN NUMBER;
38:
39: FUNCTION get_organization_id (p_organization_code VARCHAR2) RETURN NUMBER;
40: FUNCTION get_plan_id(p_plan_name VARCHAR2) RETURN NUMBER;
198:
199: -- Get the value entered in confirm_action Collection element.
200:
201: -- Bug 3684073. We should not derive the lookup_code value from
202: -- mfg_lookups because the value passed to this api would be the
203: -- qa_plan_char_value_lookups.short_code, which is not a translated
204: -- column. The mfg_lookups view would have the lookup meaning in the
205: -- language used in the current session.
206: --
200:
201: -- Bug 3684073. We should not derive the lookup_code value from
202: -- mfg_lookups because the value passed to this api would be the
203: -- qa_plan_char_value_lookups.short_code, which is not a translated
204: -- column. The mfg_lookups view would have the lookup meaning in the
205: -- language used in the current session.
206: --
207: -- Commented the below piece of code and compared p_launch_action
208: -- and p_action_fired parameters below with the new constants to resolve
207: -- Commented the below piece of code and compared p_launch_action
208: -- and p_action_fired parameters below with the new constants to resolve
209: -- the value entered. kabalakr.
210:
211: -- l_launch_action := get_mfg_lookups_value(p_launch_action,'SYS_YES_NO');
212: -- l_action_fired := get_mfg_lookups_value(p_action_fired,'SYS_YES_NO');
213:
214: -- The Action Code should get executed only if
215: -- Launch_action is 'Yes' and Action_fired is 'No'
208: -- and p_action_fired parameters below with the new constants to resolve
209: -- the value entered. kabalakr.
210:
211: -- l_launch_action := get_mfg_lookups_value(p_launch_action,'SYS_YES_NO');
212: -- l_action_fired := get_mfg_lookups_value(p_action_fired,'SYS_YES_NO');
213:
214: -- The Action Code should get executed only if
215: -- Launch_action is 'Yes' and Action_fired is 'No'
216:
647:
648: -- Get the value entered in confirm_action Collection element.
649:
650: -- Bug 3684073. We should not derive the lookup_code value from
651: -- mfg_lookups because the value passed to this api would be the
652: -- qa_plan_char_value_lookups.short_code, which is not a translated
653: -- column. The mfg_lookups view would have the lookup meaning in the
654: -- language used in the current session.
655: --
649:
650: -- Bug 3684073. We should not derive the lookup_code value from
651: -- mfg_lookups because the value passed to this api would be the
652: -- qa_plan_char_value_lookups.short_code, which is not a translated
653: -- column. The mfg_lookups view would have the lookup meaning in the
654: -- language used in the current session.
655: --
656: -- Commented the below piece of code and compared p_launch_action
657: -- and p_action_fired parameters below with the new constants to resolve
656: -- Commented the below piece of code and compared p_launch_action
657: -- and p_action_fired parameters below with the new constants to resolve
658: -- the value entered. kabalakr.
659:
660: -- l_launch_action := get_mfg_lookups_value(p_launch_action,'SYS_YES_NO');
661: -- l_action_fired := get_mfg_lookups_value(p_action_fired,'SYS_YES_NO');
662:
663: -- The Action Code should get executed only if
664: -- Launch_action is 'Yes' and relaunch_flag is 'No'
657: -- and p_action_fired parameters below with the new constants to resolve
658: -- the value entered. kabalakr.
659:
660: -- l_launch_action := get_mfg_lookups_value(p_launch_action,'SYS_YES_NO');
661: -- l_action_fired := get_mfg_lookups_value(p_action_fired,'SYS_YES_NO');
662:
663: -- The Action Code should get executed only if
664: -- Launch_action is 'Yes' and relaunch_flag is 'No'
665:
682: l_item_id := qa_flex_util.get_item_id(l_organization_id, p_item);
683:
684: -- Get transaction_id and lookup code for the Intraoperation step.
685:
686: l_to_step := get_mfg_lookups_value(p_to_intra_step,'WIP_INTRAOPERATION_STEP');
687: l_from_step := get_mfg_lookups_value(p_from_intra_step,'WIP_INTRAOPERATION_STEP');
688:
689: -- IF the To Intraoperation step is not 'SCRAP', do not execute the action.
690: -- Write back INT_ERROR and RETURN.
683:
684: -- Get transaction_id and lookup code for the Intraoperation step.
685:
686: l_to_step := get_mfg_lookups_value(p_to_intra_step,'WIP_INTRAOPERATION_STEP');
687: l_from_step := get_mfg_lookups_value(p_from_intra_step,'WIP_INTRAOPERATION_STEP');
688:
689: -- IF the To Intraoperation step is not 'SCRAP', do not execute the action.
690: -- Write back INT_ERROR and RETURN.
691:
1094:
1095: -- Get the value entered in confirm_action Collection element.
1096:
1097: -- Bug 3684073. We should not derive the lookup_code value from
1098: -- mfg_lookups because the value passed to this api would be the
1099: -- qa_plan_char_value_lookups.short_code, which is not a translated
1100: -- column. The mfg_lookups view would have the lookup meaning in the
1101: -- language used in the current session.
1102: --
1096:
1097: -- Bug 3684073. We should not derive the lookup_code value from
1098: -- mfg_lookups because the value passed to this api would be the
1099: -- qa_plan_char_value_lookups.short_code, which is not a translated
1100: -- column. The mfg_lookups view would have the lookup meaning in the
1101: -- language used in the current session.
1102: --
1103: -- Commented the below piece of code and compared p_launch_action
1104: -- and p_action_fired parameters below with the new constants to resolve
1103: -- Commented the below piece of code and compared p_launch_action
1104: -- and p_action_fired parameters below with the new constants to resolve
1105: -- the value entered. kabalakr.
1106:
1107: -- l_launch_action := get_mfg_lookups_value(p_launch_action,'SYS_YES_NO');
1108: -- l_action_fired := get_mfg_lookups_value(p_action_fired,'SYS_YES_NO');
1109:
1110: -- The Action Code should get executed only if
1111: -- launch_action is 'Yes' and action_fired is 'No'
1104: -- and p_action_fired parameters below with the new constants to resolve
1105: -- the value entered. kabalakr.
1106:
1107: -- l_launch_action := get_mfg_lookups_value(p_launch_action,'SYS_YES_NO');
1108: -- l_action_fired := get_mfg_lookups_value(p_action_fired,'SYS_YES_NO');
1109:
1110: -- The Action Code should get executed only if
1111: -- launch_action is 'Yes' and action_fired is 'No'
1112:
1548:
1549: -- Get the value entered in confirm_action Collection element.
1550:
1551: -- Bug 3684073. We should not derive the lookup_code value from
1552: -- mfg_lookups because the value passed to this api would be the
1553: -- qa_plan_char_value_lookups.short_code, which is not a translated
1554: -- column. The mfg_lookups view would have the lookup meaning in the
1555: -- language used in the current session.
1556: --
1550:
1551: -- Bug 3684073. We should not derive the lookup_code value from
1552: -- mfg_lookups because the value passed to this api would be the
1553: -- qa_plan_char_value_lookups.short_code, which is not a translated
1554: -- column. The mfg_lookups view would have the lookup meaning in the
1555: -- language used in the current session.
1556: --
1557: -- Commented the below piece of code and compared p_launch_action
1558: -- and p_action_fired parameters below with the new constants to resolve
1557: -- Commented the below piece of code and compared p_launch_action
1558: -- and p_action_fired parameters below with the new constants to resolve
1559: -- the value entered. kabalakr.
1560:
1561: -- l_launch_action := get_mfg_lookups_value(p_launch_action,'SYS_YES_NO');
1562: -- l_action_fired := get_mfg_lookups_value(p_action_fired,'SYS_YES_NO');
1563:
1564: -- The Action Code should get executed only if
1565: -- Launch_action is 'Yes' and Action_fired is 'No'
1558: -- and p_action_fired parameters below with the new constants to resolve
1559: -- the value entered. kabalakr.
1560:
1561: -- l_launch_action := get_mfg_lookups_value(p_launch_action,'SYS_YES_NO');
1562: -- l_action_fired := get_mfg_lookups_value(p_action_fired,'SYS_YES_NO');
1563:
1564: -- The Action Code should get executed only if
1565: -- Launch_action is 'Yes' and Action_fired is 'No'
1566:
1907:
1908: -- Get the value entered in confirm_action Collection element.
1909:
1910: -- Bug 3684073. We should not derive the lookup_code value from
1911: -- mfg_lookups because the value passed to this api would be the
1912: -- qa_plan_char_value_lookups.short_code, which is not a translated
1913: -- column. The mfg_lookups view would have the lookup meaning in the
1914: -- language used in the current session.
1915: --
1909:
1910: -- Bug 3684073. We should not derive the lookup_code value from
1911: -- mfg_lookups because the value passed to this api would be the
1912: -- qa_plan_char_value_lookups.short_code, which is not a translated
1913: -- column. The mfg_lookups view would have the lookup meaning in the
1914: -- language used in the current session.
1915: --
1916: -- Commented the below piece of code and compared p_launch_action
1917: -- and p_action_fired parameters below with the new constants to resolve
1916: -- Commented the below piece of code and compared p_launch_action
1917: -- and p_action_fired parameters below with the new constants to resolve
1918: -- the value entered. kabalakr.
1919:
1920: -- l_launch_action := get_mfg_lookups_value(p_launch_action,'SYS_YES_NO');
1921: -- l_action_fired := get_mfg_lookups_value(p_action_fired,'SYS_YES_NO');
1922:
1923: -- The Action Code should get executed only if
1924: -- launch_action is 'Yes' and action_fired is 'No'
1917: -- and p_action_fired parameters below with the new constants to resolve
1918: -- the value entered. kabalakr.
1919:
1920: -- l_launch_action := get_mfg_lookups_value(p_launch_action,'SYS_YES_NO');
1921: -- l_action_fired := get_mfg_lookups_value(p_action_fired,'SYS_YES_NO');
1922:
1923: -- The Action Code should get executed only if
1924: -- launch_action is 'Yes' and action_fired is 'No'
1925:
2132:
2133: -- Get the value entered in confirm_action Collection element.
2134:
2135: -- Bug 3684073. We should not derive the lookup_code value from
2136: -- mfg_lookups because the value passed to this api would be the
2137: -- qa_plan_char_value_lookups.short_code, which is not a translated
2138: -- column. The mfg_lookups view would have the lookup meaning in the
2139: -- language used in the current session.
2140: --
2134:
2135: -- Bug 3684073. We should not derive the lookup_code value from
2136: -- mfg_lookups because the value passed to this api would be the
2137: -- qa_plan_char_value_lookups.short_code, which is not a translated
2138: -- column. The mfg_lookups view would have the lookup meaning in the
2139: -- language used in the current session.
2140: --
2141: -- Commented the below piece of code and compared p_launch_action
2142: -- and p_action_fired parameters below with the new constants to resolve
2141: -- Commented the below piece of code and compared p_launch_action
2142: -- and p_action_fired parameters below with the new constants to resolve
2143: -- the value entered. kabalakr.
2144:
2145: -- l_launch_action := get_mfg_lookups_value(p_launch_action,'SYS_YES_NO');
2146: -- l_action_fired := get_mfg_lookups_value(p_action_fired,'SYS_YES_NO');
2147:
2148:
2149: -- The Action Code should get executed only if
2142: -- and p_action_fired parameters below with the new constants to resolve
2143: -- the value entered. kabalakr.
2144:
2145: -- l_launch_action := get_mfg_lookups_value(p_launch_action,'SYS_YES_NO');
2146: -- l_action_fired := get_mfg_lookups_value(p_action_fired,'SYS_YES_NO');
2147:
2148:
2149: -- The Action Code should get executed only if
2150: -- launch_action is 'Yes' and action_fired is 'No'
2576:
2577: -- Get the value entered in confirm_action Collection element.
2578:
2579: -- Bug 3684073. We should not derive the lookup_code value from
2580: -- mfg_lookups because the value passed to this api would be the
2581: -- qa_plan_char_value_lookups.short_code, which is not a translated
2582: -- column. The mfg_lookups view would have the lookup meaning in the
2583: -- language used in the current session.
2584: --
2578:
2579: -- Bug 3684073. We should not derive the lookup_code value from
2580: -- mfg_lookups because the value passed to this api would be the
2581: -- qa_plan_char_value_lookups.short_code, which is not a translated
2582: -- column. The mfg_lookups view would have the lookup meaning in the
2583: -- language used in the current session.
2584: --
2585: -- Commented the below piece of code and compared p_launch_action
2586: -- and p_action_fired parameters below with the new constants to resolve
2585: -- Commented the below piece of code and compared p_launch_action
2586: -- and p_action_fired parameters below with the new constants to resolve
2587: -- the value entered. kabalakr.
2588:
2589: -- l_launch_action := get_mfg_lookups_value(p_launch_action,'SYS_YES_NO');
2590: -- l_action_fired := get_mfg_lookups_value(p_action_fired,'SYS_YES_NO');
2591:
2592: -- The Action Code should get executed only if
2593: -- Launch_action is 'Yes' and relaunch_flag is 'No'
2586: -- and p_action_fired parameters below with the new constants to resolve
2587: -- the value entered. kabalakr.
2588:
2589: -- l_launch_action := get_mfg_lookups_value(p_launch_action,'SYS_YES_NO');
2590: -- l_action_fired := get_mfg_lookups_value(p_action_fired,'SYS_YES_NO');
2591:
2592: -- The Action Code should get executed only if
2593: -- Launch_action is 'Yes' and relaunch_flag is 'No'
2594:
2611: l_item_id := qa_flex_util.get_item_id(l_organization_id, p_item);
2612:
2613: -- Get transaction_id and lookup code for the Intraoperation step.
2614:
2615: l_to_step := get_mfg_lookups_value(p_to_intra_step,'WIP_INTRAOPERATION_STEP');
2616: l_from_step := get_mfg_lookups_value(p_from_intra_step,'WIP_INTRAOPERATION_STEP');
2617:
2618: UPDATE_STATUS(l_plan_id,p_collection_id,p_occurrence);
2619:
2612:
2613: -- Get transaction_id and lookup code for the Intraoperation step.
2614:
2615: l_to_step := get_mfg_lookups_value(p_to_intra_step,'WIP_INTRAOPERATION_STEP');
2616: l_from_step := get_mfg_lookups_value(p_from_intra_step,'WIP_INTRAOPERATION_STEP');
2617:
2618: UPDATE_STATUS(l_plan_id,p_collection_id,p_occurrence);
2619:
2620: OPEN txn_cur;
2953:
2954: -- Get the value entered in confirm_action Collection element.
2955:
2956: -- Bug 3684073. We should not derive the lookup_code value from
2957: -- mfg_lookups because the value passed to this api would be the
2958: -- qa_plan_char_value_lookups.short_code, which is not a translated
2959: -- column. The mfg_lookups view would have the lookup meaning in the
2960: -- language used in the current session.
2961: --
2955:
2956: -- Bug 3684073. We should not derive the lookup_code value from
2957: -- mfg_lookups because the value passed to this api would be the
2958: -- qa_plan_char_value_lookups.short_code, which is not a translated
2959: -- column. The mfg_lookups view would have the lookup meaning in the
2960: -- language used in the current session.
2961: --
2962: -- Commented the below piece of code and compared p_launch_action
2963: -- and p_action_fired parameters below with the new constants to resolve
2962: -- Commented the below piece of code and compared p_launch_action
2963: -- and p_action_fired parameters below with the new constants to resolve
2964: -- the value entered. kabalakr.
2965:
2966: -- l_launch_action := get_mfg_lookups_value(p_launch_action,'SYS_YES_NO');
2967: -- l_action_fired := get_mfg_lookups_value(p_action_fired,'SYS_YES_NO');
2968:
2969: -- The Action Code should get executed only if
2970: -- Launch_action is 'Yes' and Action_fired is 'No'
2963: -- and p_action_fired parameters below with the new constants to resolve
2964: -- the value entered. kabalakr.
2965:
2966: -- l_launch_action := get_mfg_lookups_value(p_launch_action,'SYS_YES_NO');
2967: -- l_action_fired := get_mfg_lookups_value(p_action_fired,'SYS_YES_NO');
2968:
2969: -- The Action Code should get executed only if
2970: -- Launch_action is 'Yes' and Action_fired is 'No'
2971:
3829:
3830: /*
3831: CURSOR lookup_cur(l_lookup_code NUMBER) IS
3832: SELECT substr(ltrim(rtrim(meaning)),1,20)
3833: FROM mfg_lookups
3834: WHERE lookup_type = 'SYS_YES_NO'
3835: AND lookup_code = l_lookup_code ;
3836: */
3837:
3960: COMMIT;
3961:
3962: END WRITE_BACK;
3963:
3964: FUNCTION get_mfg_lookups_value (p_meaning VARCHAR2,
3965: p_lookup_type VARCHAR2)
3966: RETURN NUMBER IS
3967:
3968: l_lookup_code VARCHAR2(2);
3968: l_lookup_code VARCHAR2(2);
3969:
3970: CURSOR meaning_cur IS
3971: SELECT lookup_code
3972: FROM mfg_lookups
3973: WHERE lookup_type = p_lookup_type
3974: AND upper(meaning) = upper(ltrim(rtrim(p_meaning)));
3975:
3976: BEGIN
3980: CLOSE meaning_cur;
3981:
3982: RETURN l_lookup_code;
3983:
3984: END get_mfg_lookups_value;
3985:
3986: FUNCTION get_plan_id(p_plan_name VARCHAR2)
3987: RETURN NUMBER IS
3988: