DBA Data[Home] [Help]

APPS.ENG_REVISED_ITEM_UTIL dependencies on ENG_GLOBALS

Line 428: ENG_Globals.Cancel_Operation

424: ***********************************************************************/
425:
426: FOR rev_opseq IN c_getRevisedOps
427: LOOP
428: ENG_Globals.Cancel_Operation
429: ( p_operation_sequence_id => rev_opseq.operation_sequence_id
430: , p_cancel_comments => cancel_comments
431: , p_op_seq_num => rev_opseq.operation_seq_num -- Added by MK on 11/27/00
432: , p_user_id => user_id

Line 771: l_user_id := Eng_Globals.Get_User_Id;

767: l_revision_id NUMBER;
768:
769: BEGIN
770:
771: l_user_id := Eng_Globals.Get_User_Id;
772: l_login_id := Eng_Globals.Get_Login_Id;
773: l_request_id := ENG_GLOBALS.Get_request_id;
774: l_prog_appid := ENG_GLOBALS.Get_prog_appid;
775: l_prog_id := ENG_GLOBALS.Get_prog_id;

Line 772: l_login_id := Eng_Globals.Get_Login_Id;

768:
769: BEGIN
770:
771: l_user_id := Eng_Globals.Get_User_Id;
772: l_login_id := Eng_Globals.Get_Login_Id;
773: l_request_id := ENG_GLOBALS.Get_request_id;
774: l_prog_appid := ENG_GLOBALS.Get_prog_appid;
775: l_prog_id := ENG_GLOBALS.Get_prog_id;
776:

Line 773: l_request_id := ENG_GLOBALS.Get_request_id;

769: BEGIN
770:
771: l_user_id := Eng_Globals.Get_User_Id;
772: l_login_id := Eng_Globals.Get_Login_Id;
773: l_request_id := ENG_GLOBALS.Get_request_id;
774: l_prog_appid := ENG_GLOBALS.Get_prog_appid;
775: l_prog_id := ENG_GLOBALS.Get_prog_id;
776:
777:

Line 774: l_prog_appid := ENG_GLOBALS.Get_prog_appid;

770:
771: l_user_id := Eng_Globals.Get_User_Id;
772: l_login_id := Eng_Globals.Get_Login_Id;
773: l_request_id := ENG_GLOBALS.Get_request_id;
774: l_prog_appid := ENG_GLOBALS.Get_prog_appid;
775: l_prog_id := ENG_GLOBALS.Get_prog_id;
776:
777:
778:

Line 775: l_prog_id := ENG_GLOBALS.Get_prog_id;

771: l_user_id := Eng_Globals.Get_User_Id;
772: l_login_id := Eng_Globals.Get_Login_Id;
773: l_request_id := ENG_GLOBALS.Get_request_id;
774: l_prog_appid := ENG_GLOBALS.Get_prog_appid;
775: l_prog_id := ENG_GLOBALS.Get_prog_id;
776:
777:
778:
779: IF Bom_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug('Updating revised item . . . seq id : ' ||

Line 1603: l_user_id := Eng_Globals.Get_User_Id;

1599: BEGIN
1600:
1601: x_return_status := FND_API.G_RET_STS_SUCCESS;
1602:
1603: l_user_id := Eng_Globals.Get_User_Id;
1604: l_login_id := Eng_Globals.Get_Login_Id;
1605: l_request_id := ENG_GLOBALS.Get_request_id;
1606: l_prog_appid := ENG_GLOBALS.Get_prog_appid;
1607: l_prog_id := ENG_GLOBALS.Get_prog_id;

Line 1604: l_login_id := Eng_Globals.Get_Login_Id;

1600:
1601: x_return_status := FND_API.G_RET_STS_SUCCESS;
1602:
1603: l_user_id := Eng_Globals.Get_User_Id;
1604: l_login_id := Eng_Globals.Get_Login_Id;
1605: l_request_id := ENG_GLOBALS.Get_request_id;
1606: l_prog_appid := ENG_GLOBALS.Get_prog_appid;
1607: l_prog_id := ENG_GLOBALS.Get_prog_id;
1608:

Line 1605: l_request_id := ENG_GLOBALS.Get_request_id;

1601: x_return_status := FND_API.G_RET_STS_SUCCESS;
1602:
1603: l_user_id := Eng_Globals.Get_User_Id;
1604: l_login_id := Eng_Globals.Get_Login_Id;
1605: l_request_id := ENG_GLOBALS.Get_request_id;
1606: l_prog_appid := ENG_GLOBALS.Get_prog_appid;
1607: l_prog_id := ENG_GLOBALS.Get_prog_id;
1608:
1609: -- 11.5.10E

Line 1606: l_prog_appid := ENG_GLOBALS.Get_prog_appid;

1602:
1603: l_user_id := Eng_Globals.Get_User_Id;
1604: l_login_id := Eng_Globals.Get_Login_Id;
1605: l_request_id := ENG_GLOBALS.Get_request_id;
1606: l_prog_appid := ENG_GLOBALS.Get_prog_appid;
1607: l_prog_id := ENG_GLOBALS.Get_prog_id;
1608:
1609: -- 11.5.10E
1610: -- populating the current_item_revision_id to from_revision_id

Line 1607: l_prog_id := ENG_GLOBALS.Get_prog_id;

1603: l_user_id := Eng_Globals.Get_User_Id;
1604: l_login_id := Eng_Globals.Get_Login_Id;
1605: l_request_id := ENG_GLOBALS.Get_request_id;
1606: l_prog_appid := ENG_GLOBALS.Get_prog_appid;
1607: l_prog_id := ENG_GLOBALS.Get_prog_id;
1608:
1609: -- 11.5.10E
1610: -- populating the current_item_revision_id to from_revision_id
1611: l_current_item_revision_id := p_rev_item_unexp_rec.from_item_revision_id;

Line 1933: l_assembly_type := ENG_Globals.Get_ECO_Assembly_Type

1929:
1930: IF Eng_Default_Revised_Item.G_CREATE_ALTERNATE
1931: THEN
1932:
1933: l_assembly_type := ENG_Globals.Get_ECO_Assembly_Type
1934: ( p_change_notice =>
1935: p_revised_item_rec.eco_name
1936: , p_organization_id =>
1937: p_rev_item_unexp_rec.organization_id

Line 1990: l_assembly_type := ENG_Globals.Get_ECO_Assembly_Type

1986:
1987: /*IF Eng_Default_Revised_Item.G_CREATE_RTG_ALTERNATE
1988: THEN
1989: IF l_assembly_type IS NULL THEN
1990: l_assembly_type := ENG_Globals.Get_ECO_Assembly_Type
1991: ( p_change_notice => p_revised_item_rec.eco_name
1992: , p_organization_id => p_rev_item_unexp_rec.organization_id
1993: );
1994: END IF ;

Line 2011: ENG_Globals.Create_New_Routing

2007:
2008: END IF;
2009:
2010:
2011: ENG_Globals.Create_New_Routing
2012: ( p_assembly_item_id => p_rev_item_unexp_rec.revised_item_id
2013: , p_organization_id => p_rev_item_unexp_rec.organization_id
2014: , p_alternate_routing_code => p_revised_item_rec.alternate_bom_code
2015: , p_pending_from_ecn => p_revised_item_rec.eco_name

Line 2338: x_return_status := ENG_Globals.G_RECORD_FOUND;

2334: AND NVL(from_end_item_unit_number, 'NONE')
2335: = NVL(p_from_end_item_number, 'NONE')
2336: AND NVL(alternate_bom_designator,'-9999999999') = NVL(p_alternate_designator,'-9999999999');
2337:
2338: x_return_status := ENG_Globals.G_RECORD_FOUND;
2339:
2340: x_revised_item_Rec := l_revised_item_rec;
2341: x_rev_item_unexp_rec := l_rev_item_unexp_rec;
2342:

Line 2351: x_return_status := Eng_Globals.G_RECORD_NOT_FOUND;

2347: WHEN NO_DATA_FOUND THEN
2348:
2349: IF Bom_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug('Query Revised Item: ' || SQLERRM); END IF;
2350:
2351: x_return_status := Eng_Globals.G_RECORD_NOT_FOUND;
2352: x_revised_item_Rec := l_revised_item_rec;
2353: x_rev_item_unexp_rec := l_rev_item_unexp_rec;
2354:
2355: WHEN OTHERS THEN

Line 2391: IF p_revised_item_rec.transaction_type = Eng_Globals.G_OPR_CREATE

2387: l_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type;
2388: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
2389: BEGIN
2390:
2391: IF p_revised_item_rec.transaction_type = Eng_Globals.G_OPR_CREATE
2392: THEN
2393: Insert_Row( p_revised_item_rec => p_revised_item_rec
2394: , p_rev_item_unexp_rec => p_rev_item_unexp_rec
2395: , p_control_rec => p_control_rec

Line 2402: ELSIF p_revised_item_rec.transaction_type = Eng_Globals.G_OPR_UPDATE

2398: );
2399: x_Mesg_Token_Tbl := l_Mesg_Token_Tbl;
2400: x_return_status := l_return_status;
2401:
2402: ELSIF p_revised_item_rec.transaction_type = Eng_Globals.G_OPR_UPDATE
2403: THEN
2404: Update_Row( p_revised_item_rec => p_revised_item_rec
2405: , p_rev_item_unexp_rec => p_rev_item_unexp_rec
2406: , p_control_rec => p_control_rec

Line 2413: ELSIF p_revised_item_rec.transaction_type = Eng_Globals.G_OPR_DELETE

2409: );
2410: x_Mesg_Token_Tbl := l_Mesg_Token_Tbl;
2411: x_return_status := l_return_status;
2412:
2413: ELSIF p_revised_item_rec.transaction_type = Eng_Globals.G_OPR_DELETE
2414: THEN
2415: l_return_status := FND_API.G_RET_STS_SUCCESS;
2416:
2417: IF p_control_rec.caller_type <> 'FORM'

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

2718: l_revised_item_rec.eco_for_production := 2;
2719: l_rev_item_unexp_rec.change_id := l_old_revised_item_rec.change_id;
2720: l_revised_item_rec.alternate_bom_code := l_old_revised_item_rec.ALTERNATE_BOM_DESIGNATOR;
2721: l_rev_item_unexp_rec.status_code := l_old_revised_item_rec.status_code;
2722: l_revised_item_rec.transaction_type := Eng_Globals.G_OPR_CREATE;
2723: --
2724: -- Call attribute defaulting
2725: --
2726: Eng_Default_Revised_Item.Attribute_Defaulting(