eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BOM_EXPLODER_PUB dependencies on BOM_EXPLODER_PUB

Line 1: package body BOM_EXPLODER_PUB as

1: package body BOM_EXPLODER_PUB as
2: /* $Header: BOMPLMXB.pls 120.22.12010000.3 2008/09/09 11:16:33 hvutukur ship $ */
3: /*==========================================================================+
4: | Copyright (c) 1993 Oracle Corporation Belmont, California, USA |
5: | All rights reserved. |

Line 807: BOM_EXPLODER_PUB.Get_Comp_Bill_Seq_Id (BIC.OBJ_NAME, BET.TOP_ALTERNATE_DESIGNATOR,

803: BIC.to_end_item_minor_rev_id TEMREVID,
804: BET.NEW_COMPONENT_CODE CLCC,
805: BET.SORT_ORDER PARENT_SORT_ORDER,
806: to_number(NULL) CCBSI,
807: BOM_EXPLODER_PUB.Get_Comp_Bill_Seq_Id (BIC.OBJ_NAME, BET.TOP_ALTERNATE_DESIGNATOR,
808: --NVL(BET.COMMON_ORGANIZATION_ID,BET.ORGANIZATION_ID),
809: BET.ORGANIZATION_ID,
810: BIC.pk1_value,BIC.pk2_value) CBSID, -- comp_bill_seq_id
811: 'T' ACFLAG,

Line 2322: p_pkg_name => 'BOM_EXPLODER_PUB',

2318:
2319: EXCEPTION WHEN OTHERS THEN
2320: error_code := SQLCODE;
2321: Fnd_Msg_Pub.Build_Exc_Msg(
2322: p_pkg_name => 'BOM_EXPLODER_PUB',
2323: p_procedure_name => 'BOM_EXPLODER',
2324: p_error_text => SQLERRM);
2325: err_msg := Fnd_Message.Get_Encoded;
2326: Raise exploder_error;

Line 2804: BOM_EXPLODER_PUB.Get_Current_RevisionDetails(BE.component_item_id,

2800: CURSOR revTable (p_group_id IN NUMBER) IS
2801: SELECT nvl(BE.component_sequence_id,0) component_sequence_id, --nvl(BE.current_revision,
2802: --always call Get_Current_RevisionDetails, we want to pick the rev label from items
2803: -- even for fixed rev comps.
2804: BOM_EXPLODER_PUB.Get_Current_RevisionDetails(BE.component_item_id,
2805: BE.organization_id,
2806: decode(nvl(BE.component_item_revision_id, BE.comp_fixed_revision_id),
2807: null,
2808: BOM_EXPLODER_PUB.get_explosion_date,

Line 2808: BOM_EXPLODER_PUB.get_explosion_date,

2804: BOM_EXPLODER_PUB.Get_Current_RevisionDetails(BE.component_item_id,
2805: BE.organization_id,
2806: decode(nvl(BE.component_item_revision_id, BE.comp_fixed_revision_id),
2807: null,
2808: BOM_EXPLODER_PUB.get_explosion_date,
2809: BOM_EXPLODER_PUB.Get_Revision_HighDate(nvl(BE.component_item_revision_id, BE.comp_fixed_revision_id)))) current_revision,
2810: nvl(BE.component_item_revision_id,BOM_EXPLODER_PUB.Get_Current_Revision_Id) REVISION_ID,
2811: --nvl(BE.revision_label,
2812: BOM_EXPLODER_PUB.Get_Current_Revision_Label revision_label,

Line 2809: BOM_EXPLODER_PUB.Get_Revision_HighDate(nvl(BE.component_item_revision_id, BE.comp_fixed_revision_id)))) current_revision,

2805: BE.organization_id,
2806: decode(nvl(BE.component_item_revision_id, BE.comp_fixed_revision_id),
2807: null,
2808: BOM_EXPLODER_PUB.get_explosion_date,
2809: BOM_EXPLODER_PUB.Get_Revision_HighDate(nvl(BE.component_item_revision_id, BE.comp_fixed_revision_id)))) current_revision,
2810: nvl(BE.component_item_revision_id,BOM_EXPLODER_PUB.Get_Current_Revision_Id) REVISION_ID,
2811: --nvl(BE.revision_label,
2812: BOM_EXPLODER_PUB.Get_Current_Revision_Label revision_label,
2813: BE.new_component_code component_code

Line 2810: nvl(BE.component_item_revision_id,BOM_EXPLODER_PUB.Get_Current_Revision_Id) REVISION_ID,

2806: decode(nvl(BE.component_item_revision_id, BE.comp_fixed_revision_id),
2807: null,
2808: BOM_EXPLODER_PUB.get_explosion_date,
2809: BOM_EXPLODER_PUB.Get_Revision_HighDate(nvl(BE.component_item_revision_id, BE.comp_fixed_revision_id)))) current_revision,
2810: nvl(BE.component_item_revision_id,BOM_EXPLODER_PUB.Get_Current_Revision_Id) REVISION_ID,
2811: --nvl(BE.revision_label,
2812: BOM_EXPLODER_PUB.Get_Current_Revision_Label revision_label,
2813: BE.new_component_code component_code
2814: FROM bom_explosions_all BE WHERE BE.group_id = p_group_id;

Line 2812: BOM_EXPLODER_PUB.Get_Current_Revision_Label revision_label,

2808: BOM_EXPLODER_PUB.get_explosion_date,
2809: BOM_EXPLODER_PUB.Get_Revision_HighDate(nvl(BE.component_item_revision_id, BE.comp_fixed_revision_id)))) current_revision,
2810: nvl(BE.component_item_revision_id,BOM_EXPLODER_PUB.Get_Current_Revision_Id) REVISION_ID,
2811: --nvl(BE.revision_label,
2812: BOM_EXPLODER_PUB.Get_Current_Revision_Label revision_label,
2813: BE.new_component_code component_code
2814: FROM bom_explosions_all BE WHERE BE.group_id = p_group_id;
2815:
2816: CURSOR revTableWithAccessFlag (p_group_id IN NUMBER) IS

Line 2818: BOM_EXPLODER_PUB.Get_Current_RevisionDetails(BE.component_item_id,

2814: FROM bom_explosions_all BE WHERE BE.group_id = p_group_id;
2815:
2816: CURSOR revTableWithAccessFlag (p_group_id IN NUMBER) IS
2817: SELECT nvl(BE.component_sequence_id,0) component_sequence_id, nvl(BE.current_revision,
2818: BOM_EXPLODER_PUB.Get_Current_RevisionDetails(BE.component_item_id,
2819: BE.organization_id,
2820: decode(BE.comp_fixed_revision_id,
2821: null,
2822: BOM_EXPLODER_PUB.get_explosion_date,

Line 2822: BOM_EXPLODER_PUB.get_explosion_date,

2818: BOM_EXPLODER_PUB.Get_Current_RevisionDetails(BE.component_item_id,
2819: BE.organization_id,
2820: decode(BE.comp_fixed_revision_id,
2821: null,
2822: BOM_EXPLODER_PUB.get_explosion_date,
2823: BOM_EXPLODER_PUB.Get_Revision_HighDate(BE.comp_fixed_revision_id)))) current_revision,
2824: nvl(BE.component_item_revision_id,BOM_EXPLODER_PUB.Get_Current_Revision_Id) REVISION_ID,
2825: nvl(BE.revision_label, BOM_EXPLODER_PUB.Get_Current_Revision_Label) revision_label,
2826: BOM_SECURITY_PUB.CHECK_USER_PRIVILEGE(

Line 2823: BOM_EXPLODER_PUB.Get_Revision_HighDate(BE.comp_fixed_revision_id)))) current_revision,

2819: BE.organization_id,
2820: decode(BE.comp_fixed_revision_id,
2821: null,
2822: BOM_EXPLODER_PUB.get_explosion_date,
2823: BOM_EXPLODER_PUB.Get_Revision_HighDate(BE.comp_fixed_revision_id)))) current_revision,
2824: nvl(BE.component_item_revision_id,BOM_EXPLODER_PUB.Get_Current_Revision_Id) REVISION_ID,
2825: nvl(BE.revision_label, BOM_EXPLODER_PUB.Get_Current_Revision_Label) revision_label,
2826: BOM_SECURITY_PUB.CHECK_USER_PRIVILEGE(
2827: 1,

Line 2824: nvl(BE.component_item_revision_id,BOM_EXPLODER_PUB.Get_Current_Revision_Id) REVISION_ID,

2820: decode(BE.comp_fixed_revision_id,
2821: null,
2822: BOM_EXPLODER_PUB.get_explosion_date,
2823: BOM_EXPLODER_PUB.Get_Revision_HighDate(BE.comp_fixed_revision_id)))) current_revision,
2824: nvl(BE.component_item_revision_id,BOM_EXPLODER_PUB.Get_Current_Revision_Id) REVISION_ID,
2825: nvl(BE.revision_label, BOM_EXPLODER_PUB.Get_Current_Revision_Label) revision_label,
2826: BOM_SECURITY_PUB.CHECK_USER_PRIVILEGE(
2827: 1,
2828: BOM_SECURITY_PUB.GET_FUNCTION_NAME_TO_CHECK,

Line 2825: nvl(BE.revision_label, BOM_EXPLODER_PUB.Get_Current_Revision_Label) revision_label,

2821: null,
2822: BOM_EXPLODER_PUB.get_explosion_date,
2823: BOM_EXPLODER_PUB.Get_Revision_HighDate(BE.comp_fixed_revision_id)))) current_revision,
2824: nvl(BE.component_item_revision_id,BOM_EXPLODER_PUB.Get_Current_Revision_Id) REVISION_ID,
2825: nvl(BE.revision_label, BOM_EXPLODER_PUB.Get_Current_Revision_Label) revision_label,
2826: BOM_SECURITY_PUB.CHECK_USER_PRIVILEGE(
2827: 1,
2828: BOM_SECURITY_PUB.GET_FUNCTION_NAME_TO_CHECK,
2829: 'EGO_ITEM',

Line 2835: BOM_EXPLODER_PUB.Get_EGO_User) ACCESS_FLAG

2831: BE.ORGANIZATION_ID,
2832: NULL,
2833: NULL,
2834: NULL,
2835: BOM_EXPLODER_PUB.Get_EGO_User) ACCESS_FLAG
2836: FROM bom_explosions_all BE WHERE BE.group_id = p_group_id;
2837:
2838:
2839: CURSOR changePolicy (p_group_id IN NUMBER) IS

Line 2852: mirb.revision_id = BOM_EXPLODER_PUB.Get_Component_Revision_Id(NVL(BET.component_sequence_id,0))

2848: FROM bom_explosions_all bet, mtl_item_revisions_b mirb, MTL_SYSTEM_ITEMS_b msi
2849: WHERE bet.group_id = p_group_id AND bet.comp_bill_seq_id IS NOT NULL
2850: AND bet.component_item_id = msi.INVENTORY_ITEM_ID AND
2851: bet.organization_id = msi.ORGANIZATION_ID AND
2852: mirb.revision_id = BOM_EXPLODER_PUB.Get_Component_Revision_Id(NVL(BET.component_sequence_id,0))
2853: AND (mirb.current_phase_id IS NOT NULL OR msi.current_phase_id IS NOT NULL)) ITEM_DTLS,
2854: ENG_CHANGE_POLICIES_V ECP
2855: WHERE --ecp.policy_object_pk1_value = item_dtls.item_catalog_group_id
2856: ecp.policy_object_pk1_value =

Line 3392: BOM_EXPLODER_PUB.p_explode_option := explode_option ;

3388: END IF;
3389:
3390: /* Before retuen set the group id context for the view */
3391:
3392: BOM_EXPLODER_PUB.p_explode_option := explode_option ;
3393: BOM_EXPLODER_PUB.p_group_id := grp_id;
3394: Return;
3395:
3396: END IF;

Line 3393: BOM_EXPLODER_PUB.p_group_id := grp_id;

3389:
3390: /* Before retuen set the group id context for the view */
3391:
3392: BOM_EXPLODER_PUB.p_explode_option := explode_option ;
3393: BOM_EXPLODER_PUB.p_group_id := grp_id;
3394: Return;
3395:
3396: END IF;
3397: END;

Line 3525: --BOM_EXPLODER_PUB.p_top_bill_sequence_id := l_bill_sequence_id;

3521:
3522: /* Assign the context information so that the view filters the data further
3523: to make it more specific to the current session criteria */
3524:
3525: --BOM_EXPLODER_PUB.p_top_bill_sequence_id := l_bill_sequence_id;
3526: BOM_EXPLODER_PUB.p_explode_option := explode_option ;
3527: BOM_EXPLODER_PUB.p_explosion_date := l_rev_date;
3528: BOM_EXPLODER_PUB.p_expl_end_item_rev := l_end_item_revision_id;
3529: BOM_EXPLODER_PUB.p_expl_end_item_rev_code := l_end_item_revision_code;

Line 3526: BOM_EXPLODER_PUB.p_explode_option := explode_option ;

3522: /* Assign the context information so that the view filters the data further
3523: to make it more specific to the current session criteria */
3524:
3525: --BOM_EXPLODER_PUB.p_top_bill_sequence_id := l_bill_sequence_id;
3526: BOM_EXPLODER_PUB.p_explode_option := explode_option ;
3527: BOM_EXPLODER_PUB.p_explosion_date := l_rev_date;
3528: BOM_EXPLODER_PUB.p_expl_end_item_rev := l_end_item_revision_id;
3529: BOM_EXPLODER_PUB.p_expl_end_item_rev_code := l_end_item_revision_code;
3530: BOM_EXPLODER_PUB.p_expl_end_item_id := l_end_item_id;

Line 3527: BOM_EXPLODER_PUB.p_explosion_date := l_rev_date;

3523: to make it more specific to the current session criteria */
3524:
3525: --BOM_EXPLODER_PUB.p_top_bill_sequence_id := l_bill_sequence_id;
3526: BOM_EXPLODER_PUB.p_explode_option := explode_option ;
3527: BOM_EXPLODER_PUB.p_explosion_date := l_rev_date;
3528: BOM_EXPLODER_PUB.p_expl_end_item_rev := l_end_item_revision_id;
3529: BOM_EXPLODER_PUB.p_expl_end_item_rev_code := l_end_item_revision_code;
3530: BOM_EXPLODER_PUB.p_expl_end_item_id := l_end_item_id;
3531: BOM_EXPLODER_PUB.p_expl_end_item_org_id := l_end_item_org_id;

Line 3528: BOM_EXPLODER_PUB.p_expl_end_item_rev := l_end_item_revision_id;

3524:
3525: --BOM_EXPLODER_PUB.p_top_bill_sequence_id := l_bill_sequence_id;
3526: BOM_EXPLODER_PUB.p_explode_option := explode_option ;
3527: BOM_EXPLODER_PUB.p_explosion_date := l_rev_date;
3528: BOM_EXPLODER_PUB.p_expl_end_item_rev := l_end_item_revision_id;
3529: BOM_EXPLODER_PUB.p_expl_end_item_rev_code := l_end_item_revision_code;
3530: BOM_EXPLODER_PUB.p_expl_end_item_id := l_end_item_id;
3531: BOM_EXPLODER_PUB.p_expl_end_item_org_id := l_end_item_org_id;
3532: BOM_EXPLODER_PUB.p_expl_unit_number := unit_number;

Line 3529: BOM_EXPLODER_PUB.p_expl_end_item_rev_code := l_end_item_revision_code;

3525: --BOM_EXPLODER_PUB.p_top_bill_sequence_id := l_bill_sequence_id;
3526: BOM_EXPLODER_PUB.p_explode_option := explode_option ;
3527: BOM_EXPLODER_PUB.p_explosion_date := l_rev_date;
3528: BOM_EXPLODER_PUB.p_expl_end_item_rev := l_end_item_revision_id;
3529: BOM_EXPLODER_PUB.p_expl_end_item_rev_code := l_end_item_revision_code;
3530: BOM_EXPLODER_PUB.p_expl_end_item_id := l_end_item_id;
3531: BOM_EXPLODER_PUB.p_expl_end_item_org_id := l_end_item_org_id;
3532: BOM_EXPLODER_PUB.p_expl_unit_number := unit_number;
3533: BOM_EXPLODER_PUB.p_group_id := grp_id;

Line 3530: BOM_EXPLODER_PUB.p_expl_end_item_id := l_end_item_id;

3526: BOM_EXPLODER_PUB.p_explode_option := explode_option ;
3527: BOM_EXPLODER_PUB.p_explosion_date := l_rev_date;
3528: BOM_EXPLODER_PUB.p_expl_end_item_rev := l_end_item_revision_id;
3529: BOM_EXPLODER_PUB.p_expl_end_item_rev_code := l_end_item_revision_code;
3530: BOM_EXPLODER_PUB.p_expl_end_item_id := l_end_item_id;
3531: BOM_EXPLODER_PUB.p_expl_end_item_org_id := l_end_item_org_id;
3532: BOM_EXPLODER_PUB.p_expl_unit_number := unit_number;
3533: BOM_EXPLODER_PUB.p_group_id := grp_id;
3534: BOM_EXPLODER_PUB.p_top_effectivity_control := nvl(l_effectivity_control,1);

Line 3531: BOM_EXPLODER_PUB.p_expl_end_item_org_id := l_end_item_org_id;

3527: BOM_EXPLODER_PUB.p_explosion_date := l_rev_date;
3528: BOM_EXPLODER_PUB.p_expl_end_item_rev := l_end_item_revision_id;
3529: BOM_EXPLODER_PUB.p_expl_end_item_rev_code := l_end_item_revision_code;
3530: BOM_EXPLODER_PUB.p_expl_end_item_id := l_end_item_id;
3531: BOM_EXPLODER_PUB.p_expl_end_item_org_id := l_end_item_org_id;
3532: BOM_EXPLODER_PUB.p_expl_unit_number := unit_number;
3533: BOM_EXPLODER_PUB.p_group_id := grp_id;
3534: BOM_EXPLODER_PUB.p_top_effectivity_control := nvl(l_effectivity_control,1);
3535:

Line 3532: BOM_EXPLODER_PUB.p_expl_unit_number := unit_number;

3528: BOM_EXPLODER_PUB.p_expl_end_item_rev := l_end_item_revision_id;
3529: BOM_EXPLODER_PUB.p_expl_end_item_rev_code := l_end_item_revision_code;
3530: BOM_EXPLODER_PUB.p_expl_end_item_id := l_end_item_id;
3531: BOM_EXPLODER_PUB.p_expl_end_item_org_id := l_end_item_org_id;
3532: BOM_EXPLODER_PUB.p_expl_unit_number := unit_number;
3533: BOM_EXPLODER_PUB.p_group_id := grp_id;
3534: BOM_EXPLODER_PUB.p_top_effectivity_control := nvl(l_effectivity_control,1);
3535:
3536: IF l_bill_expl_exists = 'Y' AND nvl(l_rexplode_flag,'0') <> '1'

Line 3533: BOM_EXPLODER_PUB.p_group_id := grp_id;

3529: BOM_EXPLODER_PUB.p_expl_end_item_rev_code := l_end_item_revision_code;
3530: BOM_EXPLODER_PUB.p_expl_end_item_id := l_end_item_id;
3531: BOM_EXPLODER_PUB.p_expl_end_item_org_id := l_end_item_org_id;
3532: BOM_EXPLODER_PUB.p_expl_unit_number := unit_number;
3533: BOM_EXPLODER_PUB.p_group_id := grp_id;
3534: BOM_EXPLODER_PUB.p_top_effectivity_control := nvl(l_effectivity_control,1);
3535:
3536: IF l_bill_expl_exists = 'Y' AND nvl(l_rexplode_flag,'0') <> '1'
3537: THEN

Line 3534: BOM_EXPLODER_PUB.p_top_effectivity_control := nvl(l_effectivity_control,1);

3530: BOM_EXPLODER_PUB.p_expl_end_item_id := l_end_item_id;
3531: BOM_EXPLODER_PUB.p_expl_end_item_org_id := l_end_item_org_id;
3532: BOM_EXPLODER_PUB.p_expl_unit_number := unit_number;
3533: BOM_EXPLODER_PUB.p_group_id := grp_id;
3534: BOM_EXPLODER_PUB.p_top_effectivity_control := nvl(l_effectivity_control,1);
3535:
3536: IF l_bill_expl_exists = 'Y' AND nvl(l_rexplode_flag,'0') <> '1'
3537: THEN
3538:

Line 4125: p_pkg_name => 'BOM_EXPLODER_PUB',

4121: END IF;
4122: error_code := -1;
4123: err_msg := 'parameter error';
4124: Fnd_Msg_Pub.Build_Exc_Msg(
4125: p_pkg_name => 'BOM_EXPLODER_PUB',
4126: p_procedure_name => 'exploder_userexit',
4127: p_error_text => 'verify parameters');
4128: err_msg := Fnd_Message.Get_Encoded;
4129: WHEN inv_uom_conv_exe THEN

Line 4143: p_pkg_name => 'BOM_EXPLODER_PUB',

4139: rollback;
4140: END IF;
4141: error_code := SQLCODE;
4142: Fnd_Msg_Pub.Build_Exc_Msg(
4143: p_pkg_name => 'BOM_EXPLODER_PUB',
4144: p_procedure_name => 'exploder_userexit',
4145: p_error_text => SQLERRM);
4146: err_msg := Fnd_Message.Get_Encoded;
4147: --ROLLBACK;

Line 4446: Return BOM_EXPLODER_PUB.p_Top_Bill_Sequence_Id;

4442:
4443: FUNCTION Get_Top_Bill_Sequence_Id RETURN NUMBER
4444: IS
4445: BEGIN
4446: Return BOM_EXPLODER_PUB.p_Top_Bill_Sequence_Id;
4447: END;
4448:
4449: FUNCTION Get_Explosion_Date RETURN DATE IS
4450: BEGIN

Line 4451: Return BOM_EXPLODER_PUB.p_Explosion_Date;

4447: END;
4448:
4449: FUNCTION Get_Explosion_Date RETURN DATE IS
4450: BEGIN
4451: Return BOM_EXPLODER_PUB.p_Explosion_Date;
4452: END;
4453:
4454: FUNCTION Get_Expl_End_Item_Rev RETURN NUMBER IS
4455: BEGIN

Line 4456: Return BOM_EXPLODER_PUB.p_Expl_End_Item_Rev;

4452: END;
4453:
4454: FUNCTION Get_Expl_End_Item_Rev RETURN NUMBER IS
4455: BEGIN
4456: Return BOM_EXPLODER_PUB.p_Expl_End_Item_Rev;
4457: END;
4458:
4459: FUNCTION Get_Expl_End_Item_Rev_Code RETURN VARCHAR2 IS
4460: BEGIN

Line 4461: Return BOM_EXPLODER_PUB.p_Expl_End_Item_Rev_Code;

4457: END;
4458:
4459: FUNCTION Get_Expl_End_Item_Rev_Code RETURN VARCHAR2 IS
4460: BEGIN
4461: Return BOM_EXPLODER_PUB.p_Expl_End_Item_Rev_Code;
4462: END;
4463:
4464: FUNCTION Get_Expl_Unit_Number RETURN VARCHAR2 IS
4465: BEGIN

Line 4466: Return BOM_EXPLODER_PUB.p_Expl_Unit_Number;

4462: END;
4463:
4464: FUNCTION Get_Expl_Unit_Number RETURN VARCHAR2 IS
4465: BEGIN
4466: Return BOM_EXPLODER_PUB.p_Expl_Unit_Number;
4467: END;
4468:
4469: FUNCTION Get_Explode_Option RETURN NUMBER IS
4470: BEGIN

Line 4471: Return BOM_EXPLODER_PUB.p_Explode_Option;

4467: END;
4468:
4469: FUNCTION Get_Explode_Option RETURN NUMBER IS
4470: BEGIN
4471: Return BOM_EXPLODER_PUB.p_Explode_Option;
4472: END;
4473:
4474: FUNCTION Get_Group_Id RETURN NUMBER IS
4475: BEGIN

Line 4476: Return BOM_EXPLODER_PUB.p_Group_Id;

4472: END;
4473:
4474: FUNCTION Get_Group_Id RETURN NUMBER IS
4475: BEGIN
4476: Return BOM_EXPLODER_PUB.p_Group_Id;
4477: END;
4478:
4479: FUNCTION Get_Top_Effectivity_Control RETURN NUMBER IS
4480: BEGIN

Line 4481: Return BOM_EXPLODER_PUB.p_Group_Id;

4477: END;
4478:
4479: FUNCTION Get_Top_Effectivity_Control RETURN NUMBER IS
4480: BEGIN
4481: Return BOM_EXPLODER_PUB.p_Group_Id;
4482: END;
4483:
4484: FUNCTION Get_Component_Revision(p_component_sequence_id NUMBER) RETURN VARCHAR2 IS
4485: BEGIN

Line 4486: Return BOM_EXPLODER_PUB.component_revision_array(p_component_sequence_id);

4482: END;
4483:
4484: FUNCTION Get_Component_Revision(p_component_sequence_id NUMBER) RETURN VARCHAR2 IS
4485: BEGIN
4486: Return BOM_EXPLODER_PUB.component_revision_array(p_component_sequence_id);
4487: END;
4488:
4489: FUNCTION Get_Component_Revision_Id(p_component_sequence_id NUMBER) RETURN NUMBER IS
4490: BEGIN

Line 4491: Return BOM_EXPLODER_PUB.component_revision_id_array(p_component_sequence_id);

4487: END;
4488:
4489: FUNCTION Get_Component_Revision_Id(p_component_sequence_id NUMBER) RETURN NUMBER IS
4490: BEGIN
4491: Return BOM_EXPLODER_PUB.component_revision_id_array(p_component_sequence_id);
4492: END;
4493:
4494: FUNCTION Get_Component_Revision_Label(p_component_sequence_id NUMBER) RETURN VARCHAR2 IS
4495: BEGIN

Line 4496: Return BOM_EXPLODER_PUB.component_revision_label_array(p_component_sequence_id);

4492: END;
4493:
4494: FUNCTION Get_Component_Revision_Label(p_component_sequence_id NUMBER) RETURN VARCHAR2 IS
4495: BEGIN
4496: Return BOM_EXPLODER_PUB.component_revision_label_array(p_component_sequence_id);
4497: END;
4498:
4499: FUNCTION Get_Revision_HighDate(p_revision_id NUMBER) RETURN DATE IS
4500: BEGIN

Line 4501: Return BOM_EXPLODER_PUB.revision_highdate_array(p_revision_id);

4497: END;
4498:
4499: FUNCTION Get_Revision_HighDate(p_revision_id NUMBER) RETURN DATE IS
4500: BEGIN
4501: Return BOM_EXPLODER_PUB.revision_highdate_array(p_revision_id);
4502: END;
4503:
4504: FUNCTION Get_Component_Access_Flag(p_component_sequence_id NUMBER) RETURN VARCHAR2 IS
4505: BEGIN

Line 4506: Return BOM_EXPLODER_PUB.access_flag_array(p_component_sequence_id);

4502: END;
4503:
4504: FUNCTION Get_Component_Access_Flag(p_component_sequence_id NUMBER) RETURN VARCHAR2 IS
4505: BEGIN
4506: Return BOM_EXPLODER_PUB.access_flag_array(p_component_sequence_id);
4507: END;
4508:
4509: FUNCTION Get_EGO_User RETURN VARCHAR2 IS
4510: BEGIN

Line 4516: Return BOM_EXPLODER_PUB.p_current_revision_code;

4512: END;
4513:
4514: FUNCTION Get_Current_Revision_Code RETURN VARCHAR2 IS
4515: BEGIN
4516: Return BOM_EXPLODER_PUB.p_current_revision_code;
4517: END;
4518:
4519: FUNCTION Get_Current_Revision_Id RETURN NUMBER IS
4520: BEGIN

Line 4521: Return BOM_EXPLODER_PUB.p_current_revision_id;

4517: END;
4518:
4519: FUNCTION Get_Current_Revision_Id RETURN NUMBER IS
4520: BEGIN
4521: Return BOM_EXPLODER_PUB.p_current_revision_id;
4522: END;
4523:
4524: FUNCTION Get_Current_Revision_Label RETURN VARCHAR2 IS
4525: BEGIN

Line 4526: Return BOM_EXPLODER_PUB.p_current_revision_label;

4522: END;
4523:
4524: FUNCTION Get_Current_Revision_Label RETURN VARCHAR2 IS
4525: BEGIN
4526: Return BOM_EXPLODER_PUB.p_current_revision_label;
4527: END;
4528:
4529: FUNCTION Get_Change_Policy(p_component_sequence_id NUMBER) RETURN VARCHAR2 IS
4530: BEGIN

Line 4531: --Return nvl(BOM_EXPLODER_PUB.change_policy_array(p_component_sequence_id),'ALLOWED');

4527: END;
4528:
4529: FUNCTION Get_Change_Policy(p_component_sequence_id NUMBER) RETURN VARCHAR2 IS
4530: BEGIN
4531: --Return nvl(BOM_EXPLODER_PUB.change_policy_array(p_component_sequence_id),'ALLOWED');
4532: Return BOM_EXPLODER_PUB.change_policy_array(p_component_sequence_id);
4533: END;
4534:
4535: FUNCTION Get_Current_RevisionId( p_inventory_item_id IN NUMBER,

Line 4532: Return BOM_EXPLODER_PUB.change_policy_array(p_component_sequence_id);

4528:
4529: FUNCTION Get_Change_Policy(p_component_sequence_id NUMBER) RETURN VARCHAR2 IS
4530: BEGIN
4531: --Return nvl(BOM_EXPLODER_PUB.change_policy_array(p_component_sequence_id),'ALLOWED');
4532: Return BOM_EXPLODER_PUB.change_policy_array(p_component_sequence_id);
4533: END;
4534:
4535: FUNCTION Get_Current_RevisionId( p_inventory_item_id IN NUMBER,
4536: p_organization_id IN NUMBER,

Line 4565: END BOM_EXPLODER_PUB;

4561: Return null;
4562:
4563: END;
4564:
4565: END BOM_EXPLODER_PUB;