DBA Data[Home] [Help]

APPS.ENG_REVISED_ITEM_UTIL dependencies on ENG_GLOBALS

Line 411: ENG_Globals.Cancel_Operation

407: ***********************************************************************/
408:
409: FOR rev_opseq IN c_getRevisedOps
410: LOOP
411: ENG_Globals.Cancel_Operation
412: ( p_operation_sequence_id => rev_opseq.operation_sequence_id
413: , p_cancel_comments => cancel_comments
414: , p_op_seq_num => rev_opseq.operation_seq_num -- Added by MK on 11/27/00
415: , p_user_id => user_id

Line 754: l_user_id := Eng_Globals.Get_User_Id;

750: l_revision_id NUMBER;
751:
752: BEGIN
753:
754: l_user_id := Eng_Globals.Get_User_Id;
755: l_login_id := Eng_Globals.Get_Login_Id;
756: l_request_id := ENG_GLOBALS.Get_request_id;
757: l_prog_appid := ENG_GLOBALS.Get_prog_appid;
758: l_prog_id := ENG_GLOBALS.Get_prog_id;

Line 755: l_login_id := Eng_Globals.Get_Login_Id;

751:
752: BEGIN
753:
754: l_user_id := Eng_Globals.Get_User_Id;
755: l_login_id := Eng_Globals.Get_Login_Id;
756: l_request_id := ENG_GLOBALS.Get_request_id;
757: l_prog_appid := ENG_GLOBALS.Get_prog_appid;
758: l_prog_id := ENG_GLOBALS.Get_prog_id;
759:

Line 756: l_request_id := ENG_GLOBALS.Get_request_id;

752: BEGIN
753:
754: l_user_id := Eng_Globals.Get_User_Id;
755: l_login_id := Eng_Globals.Get_Login_Id;
756: l_request_id := ENG_GLOBALS.Get_request_id;
757: l_prog_appid := ENG_GLOBALS.Get_prog_appid;
758: l_prog_id := ENG_GLOBALS.Get_prog_id;
759:
760:

Line 757: l_prog_appid := ENG_GLOBALS.Get_prog_appid;

753:
754: l_user_id := Eng_Globals.Get_User_Id;
755: l_login_id := Eng_Globals.Get_Login_Id;
756: l_request_id := ENG_GLOBALS.Get_request_id;
757: l_prog_appid := ENG_GLOBALS.Get_prog_appid;
758: l_prog_id := ENG_GLOBALS.Get_prog_id;
759:
760:
761:

Line 758: l_prog_id := ENG_GLOBALS.Get_prog_id;

754: l_user_id := Eng_Globals.Get_User_Id;
755: l_login_id := Eng_Globals.Get_Login_Id;
756: l_request_id := ENG_GLOBALS.Get_request_id;
757: l_prog_appid := ENG_GLOBALS.Get_prog_appid;
758: l_prog_id := ENG_GLOBALS.Get_prog_id;
759:
760:
761:
762: IF Bom_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug('Updating revised item . . . seq id : ' ||

Line 1585: l_user_id := Eng_Globals.Get_User_Id;

1581: BEGIN
1582:
1583: x_return_status := FND_API.G_RET_STS_SUCCESS;
1584:
1585: l_user_id := Eng_Globals.Get_User_Id;
1586: l_login_id := Eng_Globals.Get_Login_Id;
1587: l_request_id := ENG_GLOBALS.Get_request_id;
1588: l_prog_appid := ENG_GLOBALS.Get_prog_appid;
1589: l_prog_id := ENG_GLOBALS.Get_prog_id;

Line 1586: l_login_id := Eng_Globals.Get_Login_Id;

1582:
1583: x_return_status := FND_API.G_RET_STS_SUCCESS;
1584:
1585: l_user_id := Eng_Globals.Get_User_Id;
1586: l_login_id := Eng_Globals.Get_Login_Id;
1587: l_request_id := ENG_GLOBALS.Get_request_id;
1588: l_prog_appid := ENG_GLOBALS.Get_prog_appid;
1589: l_prog_id := ENG_GLOBALS.Get_prog_id;
1590:

Line 1587: l_request_id := ENG_GLOBALS.Get_request_id;

1583: x_return_status := FND_API.G_RET_STS_SUCCESS;
1584:
1585: l_user_id := Eng_Globals.Get_User_Id;
1586: l_login_id := Eng_Globals.Get_Login_Id;
1587: l_request_id := ENG_GLOBALS.Get_request_id;
1588: l_prog_appid := ENG_GLOBALS.Get_prog_appid;
1589: l_prog_id := ENG_GLOBALS.Get_prog_id;
1590:
1591: -- 11.5.10E

Line 1588: l_prog_appid := ENG_GLOBALS.Get_prog_appid;

1584:
1585: l_user_id := Eng_Globals.Get_User_Id;
1586: l_login_id := Eng_Globals.Get_Login_Id;
1587: l_request_id := ENG_GLOBALS.Get_request_id;
1588: l_prog_appid := ENG_GLOBALS.Get_prog_appid;
1589: l_prog_id := ENG_GLOBALS.Get_prog_id;
1590:
1591: -- 11.5.10E
1592: -- populating the current_item_revision_id to from_revision_id

Line 1589: l_prog_id := ENG_GLOBALS.Get_prog_id;

1585: l_user_id := Eng_Globals.Get_User_Id;
1586: l_login_id := Eng_Globals.Get_Login_Id;
1587: l_request_id := ENG_GLOBALS.Get_request_id;
1588: l_prog_appid := ENG_GLOBALS.Get_prog_appid;
1589: l_prog_id := ENG_GLOBALS.Get_prog_id;
1590:
1591: -- 11.5.10E
1592: -- populating the current_item_revision_id to from_revision_id
1593: l_current_item_revision_id := p_rev_item_unexp_rec.from_item_revision_id;

Line 1909: l_assembly_type := ENG_Globals.Get_ECO_Assembly_Type

1905:
1906: IF Eng_Default_Revised_Item.G_CREATE_ALTERNATE
1907: THEN
1908:
1909: l_assembly_type := ENG_Globals.Get_ECO_Assembly_Type
1910: ( p_change_notice =>
1911: p_revised_item_rec.eco_name
1912: , p_organization_id =>
1913: p_rev_item_unexp_rec.organization_id

Line 1966: l_assembly_type := ENG_Globals.Get_ECO_Assembly_Type

1962:
1963: IF Eng_Default_Revised_Item.G_CREATE_RTG_ALTERNATE
1964: THEN
1965: IF l_assembly_type IS NULL THEN
1966: l_assembly_type := ENG_Globals.Get_ECO_Assembly_Type
1967: ( p_change_notice => p_revised_item_rec.eco_name
1968: , p_organization_id => p_rev_item_unexp_rec.organization_id
1969: );
1970: END IF ;

Line 1987: ENG_Globals.Create_New_Routing

1983:
1984: END IF;
1985:
1986:
1987: ENG_Globals.Create_New_Routing
1988: ( p_assembly_item_id => p_rev_item_unexp_rec.revised_item_id
1989: , p_organization_id => p_rev_item_unexp_rec.organization_id
1990: , p_alternate_routing_code => p_revised_item_rec.alternate_bom_code
1991: , p_pending_from_ecn => p_revised_item_rec.eco_name

Line 2314: x_return_status := ENG_Globals.G_RECORD_FOUND;

2310: AND NVL(from_end_item_unit_number, 'NONE')
2311: = NVL(p_from_end_item_number, 'NONE')
2312: AND NVL(alternate_bom_designator,'-9999999999') = NVL(p_alternate_designator,'-9999999999');
2313:
2314: x_return_status := ENG_Globals.G_RECORD_FOUND;
2315:
2316: x_revised_item_Rec := l_revised_item_rec;
2317: x_rev_item_unexp_rec := l_rev_item_unexp_rec;
2318:

Line 2327: x_return_status := Eng_Globals.G_RECORD_NOT_FOUND;

2323: WHEN NO_DATA_FOUND THEN
2324:
2325: IF Bom_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug('Query Revised Item: ' || SQLERRM); END IF;
2326:
2327: x_return_status := Eng_Globals.G_RECORD_NOT_FOUND;
2328: x_revised_item_Rec := l_revised_item_rec;
2329: x_rev_item_unexp_rec := l_rev_item_unexp_rec;
2330:
2331: WHEN OTHERS THEN

Line 2367: IF p_revised_item_rec.transaction_type = Eng_Globals.G_OPR_CREATE

2363: l_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type;
2364: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
2365: BEGIN
2366:
2367: IF p_revised_item_rec.transaction_type = Eng_Globals.G_OPR_CREATE
2368: THEN
2369: Insert_Row( p_revised_item_rec => p_revised_item_rec
2370: , p_rev_item_unexp_rec => p_rev_item_unexp_rec
2371: , p_control_rec => p_control_rec

Line 2378: ELSIF p_revised_item_rec.transaction_type = Eng_Globals.G_OPR_UPDATE

2374: );
2375: x_Mesg_Token_Tbl := l_Mesg_Token_Tbl;
2376: x_return_status := l_return_status;
2377:
2378: ELSIF p_revised_item_rec.transaction_type = Eng_Globals.G_OPR_UPDATE
2379: THEN
2380: Update_Row( p_revised_item_rec => p_revised_item_rec
2381: , p_rev_item_unexp_rec => p_rev_item_unexp_rec
2382: , p_control_rec => p_control_rec

Line 2389: ELSIF p_revised_item_rec.transaction_type = Eng_Globals.G_OPR_DELETE

2385: );
2386: x_Mesg_Token_Tbl := l_Mesg_Token_Tbl;
2387: x_return_status := l_return_status;
2388:
2389: ELSIF p_revised_item_rec.transaction_type = Eng_Globals.G_OPR_DELETE
2390: THEN
2391: l_return_status := FND_API.G_RET_STS_SUCCESS;
2392:
2393: IF p_control_rec.caller_type <> 'FORM'

Line 2698: l_revised_item_rec.transaction_type := Eng_Globals.G_OPR_CREATE;

2694: l_revised_item_rec.eco_for_production := 2;
2695: l_rev_item_unexp_rec.change_id := l_old_revised_item_rec.change_id;
2696: l_revised_item_rec.alternate_bom_code := l_old_revised_item_rec.ALTERNATE_BOM_DESIGNATOR;
2697: l_rev_item_unexp_rec.status_code := l_old_revised_item_rec.status_code;
2698: l_revised_item_rec.transaction_type := Eng_Globals.G_OPR_CREATE;
2699: --
2700: -- Call attribute defaulting
2701: --
2702: Eng_Default_Revised_Item.Attribute_Defaulting(