DBA Data[Home] [Help]

APPS.BOM_SET_CONTEXT dependencies on DBMS_SESSION

Line 32: DBMS_SESSION.SET_CONTEXT('Struct_Type_Ctx','struct_type_id',l_structure_type_id);

28: INTO l_structure_type_id
29: FROM bom_structure_types_b
30: WHERE structure_type_name = nvl(p_struct_type,'All-Structure Types');
31:
32: DBMS_SESSION.SET_CONTEXT('Struct_Type_Ctx','struct_type_id',l_structure_type_id);
33:
34: l_pkghier_type_id := null;
35: BEGIN
36: SELECT structure_type_id

Line 45: DBMS_SESSION.SET_CONTEXT('Struct_Type_Ctx','pkg_struct_type_id',l_pkghier_type_id);

41: WHEN NO_DATA_FOUND THEN
42: NULL;
43: END;
44:
45: DBMS_SESSION.SET_CONTEXT('Struct_Type_Ctx','pkg_struct_type_id',l_pkghier_type_id);
46: END set_struct_type_context;
47:
48: PROCEDURE set_application_id IS
49: resp_appl_id NUMBER;

Line 53: DBMS_SESSION.SET_CONTEXT('Struct_Type_Ctx', 'appl_id', resp_appl_id);

49: resp_appl_id NUMBER;
50: BEGIN
51: SELECT fnd_global.resp_appl_id INTO resp_appl_id
52: FROM dual;
53: DBMS_SESSION.SET_CONTEXT('Struct_Type_Ctx', 'appl_id', resp_appl_id);
54: set_struct_type_context('Asset BOM');
55: END set_application_id;
56:
57: PROCEDURE set_application_id (p_appl_resp_id IN NUMBER) IS

Line 59: DBMS_SESSION.SET_CONTEXT('Struct_Type_Ctx', 'appl_id', p_appl_resp_id);

55: END set_application_id;
56:
57: PROCEDURE set_application_id (p_appl_resp_id IN NUMBER) IS
58: BEGIN
59: DBMS_SESSION.SET_CONTEXT('Struct_Type_Ctx', 'appl_id', p_appl_resp_id);
60: set_struct_type_context('Asset BOM');
61: END set_application_id;
62: END Bom_Set_Context;