DBA Data[Home] [Help]

APPS.BOM_GLOBALS dependencies on BOM_GLOBALS

Line 1: PACKAGE BODY BOM_Globals AS

1: PACKAGE BODY BOM_Globals AS
2: /* $Header: BOMSGLBB.pls 120.24.12010000.2 2008/11/17 11:05:21 gliang ship $ */
3: /**********************************************************************
4: --
5: -- Copyright (c) 1996 Oracle Corporation, Redwood Shores, CA, USA

Line 14: -- Body of package BOM_Globals

10: -- BOMSGLBB.pls
11: --
12: -- DESCRIPTION
13: --
14: -- Body of package BOM_Globals
15: --
16: -- NOTES
17: --
18: -- HISTORY

Line 29: G_PKG_NAME CONSTANT VARCHAR2(30) := 'BOM_Globals';

25: --
26: -- 08-Apr-2003 snelloli Added Functions Get_Alternate Get_Structure_Type
27: **********************************************************************/
28:
29: G_PKG_NAME CONSTANT VARCHAR2(30) := 'BOM_Globals';
30:
31: -- Global variable holding ECO workflow approval process name
32:
33: G_PROCESS_NAME VARCHAR2(30) := NULL;

Line 43: Bom_Globals.Set_user_id( p_user_id => FND_GLOBAL.user_id);

39: , x_return_status IN OUT NOCOPY VARCHAR2
40: )
41: IS
42: BEGIN
43: Bom_Globals.Set_user_id( p_user_id => FND_GLOBAL.user_id);
44: Bom_Globals.Set_login_id( p_login_id => FND_GLOBAL.login_id);
45: Bom_Globals.Set_prog_id( p_prog_id => FND_GLOBAL.conc_program_id);
46: Bom_Globals.Set_prog_appid( p_prog_appid => FND_GLOBAL.prog_appl_id);
47: Bom_Globals.Set_request_id( p_request_id => FND_GLOBAL.conc_request_id);

Line 44: Bom_Globals.Set_login_id( p_login_id => FND_GLOBAL.login_id);

40: )
41: IS
42: BEGIN
43: Bom_Globals.Set_user_id( p_user_id => FND_GLOBAL.user_id);
44: Bom_Globals.Set_login_id( p_login_id => FND_GLOBAL.login_id);
45: Bom_Globals.Set_prog_id( p_prog_id => FND_GLOBAL.conc_program_id);
46: Bom_Globals.Set_prog_appid( p_prog_appid => FND_GLOBAL.prog_appl_id);
47: Bom_Globals.Set_request_id( p_request_id => FND_GLOBAL.conc_request_id);
48:

Line 45: Bom_Globals.Set_prog_id( p_prog_id => FND_GLOBAL.conc_program_id);

41: IS
42: BEGIN
43: Bom_Globals.Set_user_id( p_user_id => FND_GLOBAL.user_id);
44: Bom_Globals.Set_login_id( p_login_id => FND_GLOBAL.login_id);
45: Bom_Globals.Set_prog_id( p_prog_id => FND_GLOBAL.conc_program_id);
46: Bom_Globals.Set_prog_appid( p_prog_appid => FND_GLOBAL.prog_appl_id);
47: Bom_Globals.Set_request_id( p_request_id => FND_GLOBAL.conc_request_id);
48:
49: END Init_System_Info_Rec;

Line 46: Bom_Globals.Set_prog_appid( p_prog_appid => FND_GLOBAL.prog_appl_id);

42: BEGIN
43: Bom_Globals.Set_user_id( p_user_id => FND_GLOBAL.user_id);
44: Bom_Globals.Set_login_id( p_login_id => FND_GLOBAL.login_id);
45: Bom_Globals.Set_prog_id( p_prog_id => FND_GLOBAL.conc_program_id);
46: Bom_Globals.Set_prog_appid( p_prog_appid => FND_GLOBAL.prog_appl_id);
47: Bom_Globals.Set_request_id( p_request_id => FND_GLOBAL.conc_request_id);
48:
49: END Init_System_Info_Rec;
50:

Line 47: Bom_Globals.Set_request_id( p_request_id => FND_GLOBAL.conc_request_id);

43: Bom_Globals.Set_user_id( p_user_id => FND_GLOBAL.user_id);
44: Bom_Globals.Set_login_id( p_login_id => FND_GLOBAL.login_id);
45: Bom_Globals.Set_prog_id( p_prog_id => FND_GLOBAL.conc_program_id);
46: Bom_Globals.Set_prog_appid( p_prog_appid => FND_GLOBAL.prog_appl_id);
47: Bom_Globals.Set_request_id( p_request_id => FND_GLOBAL.conc_request_id);
48:
49: END Init_System_Info_Rec;
50:
51: /****************************************************************************

Line 72: FUNCTION Get_System_Information RETURN Bom_Globals.System_Information_Rec_Type

68: * Parameters OUT: None
69: * Purpose : This procedure will return the value of the system information
70: * record.
71: ****************************************************************************/
72: FUNCTION Get_System_Information RETURN Bom_Globals.System_Information_Rec_Type
73: IS
74: BEGIN
75: RETURN G_System_Information;
76:

Line 90: Bom_Globals.System_Information_Rec_Type)

86: * record.
87: ****************************************************************************/
88: PROCEDURE Set_System_Information
89: ( p_system_information_rec IN
90: Bom_Globals.System_Information_Rec_Type)
91: IS
92: BEGIN
93: G_System_Information := p_system_information_rec;
94:

Line 110: l_process_name := BOM_Globals.Get_Process_Name;

106: l_approval_status_type NUMBER;
107: BEGIN
108: x_processed := FALSE;
109: -- Get Workflow Process name
110: l_process_name := BOM_Globals.Get_Process_Name;
111: SELECT approval_status_type
112: INTO l_approval_status_type
113: FROM eng_engineering_changes
114: WHERE change_notice = p_change_notice

Line 1663: PROCEDURE Get_Orgs(p_org_hier IN VARCHAR2 , p_organization_id IN NUMBER, x_org_list IN OUT NOCOPY BOM_GLOBALS.OrgID_tbl_type )

1659: WHEN NO_DATA_FOUND THEN
1660: return null;
1661: END Get_Item_Name;
1662:
1663: PROCEDURE Get_Orgs(p_org_hier IN VARCHAR2 , p_organization_id IN NUMBER, x_org_list IN OUT NOCOPY BOM_GLOBALS.OrgID_tbl_type )
1664: IS
1665: t_org_code_list Inv_Orghierarchy_Pvt.OrgID_tbl_type;
1666: starting_org_counter NUMBER ;
1667: I NUMBER := 1 ;

Line 2765: , Bom_Globals.Get_Prog_AppId

2761: , ref_desg.change_notice
2762: , l_component_seqeunce_id
2763: , ref_desg.acd_type
2764: , NULL /* Request Id */
2765: , Bom_Globals.Get_Prog_AppId
2766: , Bom_Globals.Get_Prog_Id
2767: , SYSDATE
2768: , ref_desg.attribute_category
2769: , ref_desg.attribute1

Line 2766: , Bom_Globals.Get_Prog_Id

2762: , l_component_seqeunce_id
2763: , ref_desg.acd_type
2764: , NULL /* Request Id */
2765: , Bom_Globals.Get_Prog_AppId
2766: , Bom_Globals.Get_Prog_Id
2767: , SYSDATE
2768: , ref_desg.attribute_category
2769: , ref_desg.attribute1
2770: , ref_desg.attribute2

Line 2837: , Bom_Globals.Get_Prog_AppId

2833: , l_component_seqeunce_id
2834: , sub_comp.acd_type
2835: , sub_comp.Change_Notice
2836: , NULL /* Request Id */
2837: , Bom_Globals.Get_Prog_AppId
2838: , SYSDATE
2839: , sub_comp.attribute_category
2840: , sub_comp.attribute1
2841: , sub_comp.attribute2

Line 2855: , Bom_Globals.Get_Prog_Id

2851: , sub_comp.attribute12
2852: , sub_comp.attribute13
2853: , sub_comp.attribute14
2854: , sub_comp.attribute15
2855: , Bom_Globals.Get_Prog_Id
2856: , sub_comp.Original_System_Reference
2857: , sub_comp.enforce_int_requirements
2858: , sub_comp.common_component_sequence_id
2859: FROM BOM_SUBSTITUTE_COMPONENTS sub_comp

Line 3372: END BOM_Globals;

3368:
3369: fnd_profile.put('MFG_ORGANIZATION_ID', p_org_id);
3370:
3371: END Set_Profile_Org_id;
3372: END BOM_Globals;