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.37.12020000.4 2013/02/27 01:32:06 chulhale ship $ */
3: /*==========================================================================+
4: | Copyright (c) 1993 Oracle Corporation Belmont, California, USA |
5: | All rights reserved. |

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

818: BIC.to_end_item_minor_rev_id TEMREVID,
819: BET.NEW_COMPONENT_CODE CLCC,
820: BET.SORT_ORDER PARENT_SORT_ORDER,
821: to_number(NULL) CCBSI,
822: BOM_EXPLODER_PUB.Get_Comp_Bill_Seq_Id (BIC.OBJ_NAME, BET.TOP_ALTERNATE_DESIGNATOR,
823: --NVL(BET.COMMON_ORGANIZATION_ID,BET.ORGANIZATION_ID),
824: BET.ORGANIZATION_ID,
825: BIC.pk1_value,BIC.pk2_value) CBSID, -- comp_bill_seq_id
826: 'T' ACFLAG,

Line 974: OR (NVL(BOM_EXPLODER_PUB.GET_CURRENT_REVISIONDETAILS(BET.COMPONENT_ITEM_ID,BET.ORGANIZATION_ID,C_REV_DATE),

970: WHERE INVENTORY_ITEM_ID = BET.COMPONENT_ITEM_ID
971: AND ORGANIZATION_ID = BET.ORGANIZATION_ID
972: AND REVISION_ID = BIC.FROM_END_ITEM_REV_ID)
973: AND (BIC.TO_END_ITEM_REV_ID IS NULL
974: OR (NVL(BOM_EXPLODER_PUB.GET_CURRENT_REVISIONDETAILS(BET.COMPONENT_ITEM_ID,BET.ORGANIZATION_ID,C_REV_DATE),
975: (SELECT STARTING_REVISION
976: FROM MTL_PARAMETERS
977: WHERE ORGANIZATION_ID = BET.ORGANIZATION_ID)) <= (SELECT REVISION
978: FROM MTL_ITEM_REVISIONS_B

Line 988: OR (BOM_EXPLODER_PUB.GET_CURRENT_REVISIONDETAILS(L_END_ITEM_ID,L_END_ITEM_ORG_ID,C_REV_DATE) <= (SELECT REVISION

984: WHERE INVENTORY_ITEM_ID = L_END_ITEM_ID
985: AND ORGANIZATION_ID = L_END_ITEM_ORG_ID
986: AND REVISION_ID = BIC.FROM_END_ITEM_REV_ID)
987: AND (BIC.TO_END_ITEM_REV_ID IS NULL
988: OR (BOM_EXPLODER_PUB.GET_CURRENT_REVISIONDETAILS(L_END_ITEM_ID,L_END_ITEM_ORG_ID,C_REV_DATE) <= (SELECT REVISION
989: FROM MTL_ITEM_REVISIONS_B
990: WHERE INVENTORY_ITEM_ID = L_END_ITEM_ID
991: AND ORGANIZATION_ID = L_END_ITEM_ORG_ID
992: AND REVISION_ID = BIC.TO_END_ITEM_REV_ID))))))

Line 1002: AND ((NVL(BOM_EXPLODER_PUB.GET_CURRENT_REVISIONDETAILS(BET.COMPONENT_ITEM_ID,BET.ORGANIZATION_ID,C_REV_DATE),

998: FROM MTL_ITEM_REVISIONS_B
999: WHERE INVENTORY_ITEM_ID = BET.COMPONENT_ITEM_ID
1000: AND ORGANIZATION_ID = BET.ORGANIZATION_ID
1001: AND REVISION_ID = BIC.FROM_END_ITEM_REV_ID)
1002: AND ((NVL(BOM_EXPLODER_PUB.GET_CURRENT_REVISIONDETAILS(BET.COMPONENT_ITEM_ID,BET.ORGANIZATION_ID,C_REV_DATE),
1003: (SELECT STARTING_REVISION
1004: FROM MTL_PARAMETERS
1005: WHERE ORGANIZATION_ID = BET.ORGANIZATION_ID)) > = (SELECT REVISION
1006: FROM MTL_ITEM_REVISIONS_B

Line 1011: OR (NVL(BOM_EXPLODER_PUB.GET_CURRENT_REVISIONDETAILS(BET.COMPONENT_ITEM_ID,BET.ORGANIZATION_ID,C_REV_DATE),

1007: WHERE INVENTORY_ITEM_ID = BET.COMPONENT_ITEM_ID
1008: AND ORGANIZATION_ID = BET.ORGANIZATION_ID
1009: AND REVISION_ID = BIC.FROM_END_ITEM_REV_ID))
1010: AND (BIC.TO_END_ITEM_REV_ID IS NULL
1011: OR (NVL(BOM_EXPLODER_PUB.GET_CURRENT_REVISIONDETAILS(BET.COMPONENT_ITEM_ID,BET.ORGANIZATION_ID,C_REV_DATE),
1012: (SELECT STARTING_REVISION
1013: FROM MTL_PARAMETERS
1014: WHERE ORGANIZATION_ID = BET.ORGANIZATION_ID)) <= (SELECT REVISION
1015: FROM MTL_ITEM_REVISIONS_B

Line 1025: AND ((BOM_EXPLODER_PUB.GET_CURRENT_REVISIONDETAILS(L_END_ITEM_ID,L_END_ITEM_ORG_ID,C_REV_DATE) >= (SELECT REVISION

1021: FROM MTL_ITEM_REVISIONS_B
1022: WHERE INVENTORY_ITEM_ID = L_END_ITEM_ID
1023: AND ORGANIZATION_ID = L_END_ITEM_ORG_ID
1024: AND REVISION_ID = BIC.FROM_END_ITEM_REV_ID)
1025: AND ((BOM_EXPLODER_PUB.GET_CURRENT_REVISIONDETAILS(L_END_ITEM_ID,L_END_ITEM_ORG_ID,C_REV_DATE) >= (SELECT REVISION
1026: FROM MTL_ITEM_REVISIONS_B
1027: WHERE INVENTORY_ITEM_ID = L_END_ITEM_ID
1028: AND ORGANIZATION_ID = L_END_ITEM_ORG_ID
1029: AND REVISION_ID = BIC.FROM_END_ITEM_REV_ID))

Line 1031: OR (BOM_EXPLODER_PUB.GET_CURRENT_REVISIONDETAILS(L_END_ITEM_ID,L_END_ITEM_ORG_ID,C_REV_DATE) <= (SELECT REVISION

1027: WHERE INVENTORY_ITEM_ID = L_END_ITEM_ID
1028: AND ORGANIZATION_ID = L_END_ITEM_ORG_ID
1029: AND REVISION_ID = BIC.FROM_END_ITEM_REV_ID))
1030: AND (BIC.TO_END_ITEM_REV_ID IS NULL
1031: OR (BOM_EXPLODER_PUB.GET_CURRENT_REVISIONDETAILS(L_END_ITEM_ID,L_END_ITEM_ORG_ID,C_REV_DATE) <= (SELECT REVISION
1032: FROM MTL_ITEM_REVISIONS_B
1033: WHERE INVENTORY_ITEM_ID = L_END_ITEM_ID
1034: AND ORGANIZATION_ID = L_END_ITEM_ORG_ID
1035: AND REVISION_ID = BIC.TO_END_ITEM_REV_ID))))

Line 2403: p_pkg_name => 'BOM_EXPLODER_PUB',

2399:
2400: EXCEPTION WHEN OTHERS THEN
2401: error_code := SQLCODE;
2402: Fnd_Msg_Pub.Build_Exc_Msg(
2403: p_pkg_name => 'BOM_EXPLODER_PUB',
2404: p_procedure_name => 'BOM_EXPLODER',
2405: p_error_text => SQLERRM);
2406: err_msg := Fnd_Message.Get_Encoded;
2407: Raise exploder_error;

Line 2894: BOM_EXPLODER_PUB.Get_Current_RevisionDetails(BE.component_item_id,

2890: CURSOR revTable (p_group_id IN NUMBER) IS
2891: SELECT nvl(BE.component_sequence_id,0) component_sequence_id, --nvl(BE.current_revision,
2892: --always call Get_Current_RevisionDetails, we want to pick the rev label from items
2893: -- even for fixed rev comps.
2894: BOM_EXPLODER_PUB.Get_Current_RevisionDetails(BE.component_item_id,
2895: BE.organization_id,
2896: decode(nvl(BE.component_item_revision_id, BE.comp_fixed_revision_id),
2897: null,
2898: BOM_EXPLODER_PUB.get_explosion_date,

Line 2898: BOM_EXPLODER_PUB.get_explosion_date,

2894: BOM_EXPLODER_PUB.Get_Current_RevisionDetails(BE.component_item_id,
2895: BE.organization_id,
2896: decode(nvl(BE.component_item_revision_id, BE.comp_fixed_revision_id),
2897: null,
2898: BOM_EXPLODER_PUB.get_explosion_date,
2899: BOM_EXPLODER_PUB.Get_Revision_HighDate(nvl(BE.component_item_revision_id, BE.comp_fixed_revision_id)))) current_revision,
2900: nvl(BE.component_item_revision_id,BOM_EXPLODER_PUB.Get_Current_Revision_Id) REVISION_ID,
2901: --nvl(BE.revision_label,
2902: BOM_EXPLODER_PUB.Get_Current_Revision_Label revision_label,

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

2895: BE.organization_id,
2896: decode(nvl(BE.component_item_revision_id, BE.comp_fixed_revision_id),
2897: null,
2898: BOM_EXPLODER_PUB.get_explosion_date,
2899: BOM_EXPLODER_PUB.Get_Revision_HighDate(nvl(BE.component_item_revision_id, BE.comp_fixed_revision_id)))) current_revision,
2900: nvl(BE.component_item_revision_id,BOM_EXPLODER_PUB.Get_Current_Revision_Id) REVISION_ID,
2901: --nvl(BE.revision_label,
2902: BOM_EXPLODER_PUB.Get_Current_Revision_Label revision_label,
2903: BE.new_component_code component_code

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

2896: decode(nvl(BE.component_item_revision_id, BE.comp_fixed_revision_id),
2897: null,
2898: BOM_EXPLODER_PUB.get_explosion_date,
2899: BOM_EXPLODER_PUB.Get_Revision_HighDate(nvl(BE.component_item_revision_id, BE.comp_fixed_revision_id)))) current_revision,
2900: nvl(BE.component_item_revision_id,BOM_EXPLODER_PUB.Get_Current_Revision_Id) REVISION_ID,
2901: --nvl(BE.revision_label,
2902: BOM_EXPLODER_PUB.Get_Current_Revision_Label revision_label,
2903: BE.new_component_code component_code
2904: FROM bom_explosions_all BE WHERE BE.group_id = p_group_id;

Line 2902: BOM_EXPLODER_PUB.Get_Current_Revision_Label revision_label,

2898: BOM_EXPLODER_PUB.get_explosion_date,
2899: BOM_EXPLODER_PUB.Get_Revision_HighDate(nvl(BE.component_item_revision_id, BE.comp_fixed_revision_id)))) current_revision,
2900: nvl(BE.component_item_revision_id,BOM_EXPLODER_PUB.Get_Current_Revision_Id) REVISION_ID,
2901: --nvl(BE.revision_label,
2902: BOM_EXPLODER_PUB.Get_Current_Revision_Label revision_label,
2903: BE.new_component_code component_code
2904: FROM bom_explosions_all BE WHERE BE.group_id = p_group_id;
2905:
2906: CURSOR revTableWithAccessFlag (p_group_id IN NUMBER) IS

Line 2908: BOM_EXPLODER_PUB.Get_Current_RevisionDetails(BE.component_item_id,

2904: FROM bom_explosions_all BE WHERE BE.group_id = p_group_id;
2905:
2906: CURSOR revTableWithAccessFlag (p_group_id IN NUMBER) IS
2907: SELECT nvl(BE.component_sequence_id,0) component_sequence_id, nvl(BE.current_revision,
2908: BOM_EXPLODER_PUB.Get_Current_RevisionDetails(BE.component_item_id,
2909: BE.organization_id,
2910: decode(BE.comp_fixed_revision_id,
2911: null,
2912: BOM_EXPLODER_PUB.get_explosion_date,

Line 2912: BOM_EXPLODER_PUB.get_explosion_date,

2908: BOM_EXPLODER_PUB.Get_Current_RevisionDetails(BE.component_item_id,
2909: BE.organization_id,
2910: decode(BE.comp_fixed_revision_id,
2911: null,
2912: BOM_EXPLODER_PUB.get_explosion_date,
2913: BOM_EXPLODER_PUB.Get_Revision_HighDate(BE.comp_fixed_revision_id)))) current_revision,
2914: nvl(BE.component_item_revision_id,BOM_EXPLODER_PUB.Get_Current_Revision_Id) REVISION_ID,
2915: nvl(BE.revision_label, BOM_EXPLODER_PUB.Get_Current_Revision_Label) revision_label,
2916: BOM_SECURITY_PUB.CHECK_USER_PRIVILEGE(

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

2909: BE.organization_id,
2910: decode(BE.comp_fixed_revision_id,
2911: null,
2912: BOM_EXPLODER_PUB.get_explosion_date,
2913: BOM_EXPLODER_PUB.Get_Revision_HighDate(BE.comp_fixed_revision_id)))) current_revision,
2914: nvl(BE.component_item_revision_id,BOM_EXPLODER_PUB.Get_Current_Revision_Id) REVISION_ID,
2915: nvl(BE.revision_label, BOM_EXPLODER_PUB.Get_Current_Revision_Label) revision_label,
2916: BOM_SECURITY_PUB.CHECK_USER_PRIVILEGE(
2917: 1,

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

2910: decode(BE.comp_fixed_revision_id,
2911: null,
2912: BOM_EXPLODER_PUB.get_explosion_date,
2913: BOM_EXPLODER_PUB.Get_Revision_HighDate(BE.comp_fixed_revision_id)))) current_revision,
2914: nvl(BE.component_item_revision_id,BOM_EXPLODER_PUB.Get_Current_Revision_Id) REVISION_ID,
2915: nvl(BE.revision_label, BOM_EXPLODER_PUB.Get_Current_Revision_Label) revision_label,
2916: BOM_SECURITY_PUB.CHECK_USER_PRIVILEGE(
2917: 1,
2918: BOM_SECURITY_PUB.GET_FUNCTION_NAME_TO_CHECK,

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

2911: null,
2912: BOM_EXPLODER_PUB.get_explosion_date,
2913: BOM_EXPLODER_PUB.Get_Revision_HighDate(BE.comp_fixed_revision_id)))) current_revision,
2914: nvl(BE.component_item_revision_id,BOM_EXPLODER_PUB.Get_Current_Revision_Id) REVISION_ID,
2915: nvl(BE.revision_label, BOM_EXPLODER_PUB.Get_Current_Revision_Label) revision_label,
2916: BOM_SECURITY_PUB.CHECK_USER_PRIVILEGE(
2917: 1,
2918: BOM_SECURITY_PUB.GET_FUNCTION_NAME_TO_CHECK,
2919: 'EGO_ITEM',

Line 2925: BOM_EXPLODER_PUB.Get_EGO_User) ACCESS_FLAG

2921: BE.ORGANIZATION_ID,
2922: NULL,
2923: NULL,
2924: NULL,
2925: BOM_EXPLODER_PUB.Get_EGO_User) ACCESS_FLAG
2926: FROM bom_explosions_all BE WHERE BE.group_id = p_group_id;
2927:
2928:
2929: CURSOR changePolicy (p_group_id IN NUMBER) IS

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

2938: FROM bom_explosions_all bet, mtl_item_revisions_b mirb, MTL_SYSTEM_ITEMS_b msi
2939: WHERE bet.group_id = p_group_id AND bet.comp_bill_seq_id IS NOT NULL
2940: AND bet.component_item_id = msi.INVENTORY_ITEM_ID AND
2941: bet.organization_id = msi.ORGANIZATION_ID AND
2942: mirb.revision_id = BOM_EXPLODER_PUB.Get_Component_Revision_Id(NVL(BET.component_sequence_id,0))
2943: AND (mirb.current_phase_id IS NOT NULL OR msi.current_phase_id IS NOT NULL)) ITEM_DTLS,
2944: ENG_CHANGE_POLICIES_V ECP
2945: WHERE --ecp.policy_object_pk1_value = item_dtls.item_catalog_group_id
2946: ecp.policy_object_pk1_value =

Line 3130: --BOM_EXPLOSIONS_V will filter the components with right explode_option (BOM_EXPLODER_PUB.Get_Explode_Option())

3126: -- For rev effective BOMS, explosions are seperately maintained for "Current" and "Current and Future" options
3127: l_show_rev := 2;
3128: --bug 9530687, for effectivity control BOM, when explosion option = 2(Current), set explosion option to 3
3129: --Current and Future explosion option contains all the components satisfying Current option
3130: --BOM_EXPLOSIONS_V will filter the components with right explode_option (BOM_EXPLODER_PUB.Get_Explode_Option())
3131: --this make sure that future components does not shown the explosion structure of Current explode option
3132: --IF nvl(l_effectivity_control,1) = 1
3133: --THEN
3134: -- l_explode_option := explode_option;

Line 3300: OR BOM_EXPLODER_PUB.GET_CURRENT_REVISIONDETAILS(l_pk_value1, l_pk_value2,l_exploded_date) <> BOM_EXPLODER_PUB.GET_CURRENT_REVISIONDETAILS(l_pk_value1, l_pk_value2,l_rev_date)

3296:
3297: IF nvl(l_rexplode_flag,'0') = '1' OR nvl(max_level, 60) <> nvl(l_max_bill_level, 60) OR
3298: l_Pkg_Structure_Type_Id = l_structure_type_id
3299: /*Changes done as part of bug 8635467 with base bug 8628001*/
3300: OR BOM_EXPLODER_PUB.GET_CURRENT_REVISIONDETAILS(l_pk_value1, l_pk_value2,l_exploded_date) <> BOM_EXPLODER_PUB.GET_CURRENT_REVISIONDETAILS(l_pk_value1, l_pk_value2,l_rev_date)
3301: OR l_exploded_option <> explode_option
3302: /*End of change*/
3303:
3304: -- change made for P4Telco CMR, bug# 8761845

Line 3506: BOM_EXPLODER_PUB.p_explode_option := explode_option ;

3502: END IF;
3503:
3504: /* Before retuen set the group id context for the view */
3505:
3506: BOM_EXPLODER_PUB.p_explode_option := explode_option ;
3507: BOM_EXPLODER_PUB.p_group_id := grp_id;
3508: Return;
3509:
3510: END IF;

Line 3507: BOM_EXPLODER_PUB.p_group_id := grp_id;

3503:
3504: /* Before retuen set the group id context for the view */
3505:
3506: BOM_EXPLODER_PUB.p_explode_option := explode_option ;
3507: BOM_EXPLODER_PUB.p_group_id := grp_id;
3508: Return;
3509:
3510: END IF;
3511: END;

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

3635:
3636: /* Assign the context information so that the view filters the data further
3637: to make it more specific to the current session criteria */
3638:
3639: --BOM_EXPLODER_PUB.p_top_bill_sequence_id := l_bill_sequence_id;
3640: BOM_EXPLODER_PUB.p_explode_option := explode_option ;
3641: BOM_EXPLODER_PUB.p_explosion_date := l_rev_date;
3642: BOM_EXPLODER_PUB.p_expl_end_item_rev := l_end_item_revision_id;
3643: BOM_EXPLODER_PUB.p_expl_end_item_rev_code := l_end_item_revision_code;

Line 3640: BOM_EXPLODER_PUB.p_explode_option := explode_option ;

3636: /* Assign the context information so that the view filters the data further
3637: to make it more specific to the current session criteria */
3638:
3639: --BOM_EXPLODER_PUB.p_top_bill_sequence_id := l_bill_sequence_id;
3640: BOM_EXPLODER_PUB.p_explode_option := explode_option ;
3641: BOM_EXPLODER_PUB.p_explosion_date := l_rev_date;
3642: BOM_EXPLODER_PUB.p_expl_end_item_rev := l_end_item_revision_id;
3643: BOM_EXPLODER_PUB.p_expl_end_item_rev_code := l_end_item_revision_code;
3644: BOM_EXPLODER_PUB.p_expl_end_item_id := l_end_item_id;

Line 3641: BOM_EXPLODER_PUB.p_explosion_date := l_rev_date;

3637: to make it more specific to the current session criteria */
3638:
3639: --BOM_EXPLODER_PUB.p_top_bill_sequence_id := l_bill_sequence_id;
3640: BOM_EXPLODER_PUB.p_explode_option := explode_option ;
3641: BOM_EXPLODER_PUB.p_explosion_date := l_rev_date;
3642: BOM_EXPLODER_PUB.p_expl_end_item_rev := l_end_item_revision_id;
3643: BOM_EXPLODER_PUB.p_expl_end_item_rev_code := l_end_item_revision_code;
3644: BOM_EXPLODER_PUB.p_expl_end_item_id := l_end_item_id;
3645: BOM_EXPLODER_PUB.p_expl_end_item_org_id := l_end_item_org_id;

Line 3642: BOM_EXPLODER_PUB.p_expl_end_item_rev := l_end_item_revision_id;

3638:
3639: --BOM_EXPLODER_PUB.p_top_bill_sequence_id := l_bill_sequence_id;
3640: BOM_EXPLODER_PUB.p_explode_option := explode_option ;
3641: BOM_EXPLODER_PUB.p_explosion_date := l_rev_date;
3642: BOM_EXPLODER_PUB.p_expl_end_item_rev := l_end_item_revision_id;
3643: BOM_EXPLODER_PUB.p_expl_end_item_rev_code := l_end_item_revision_code;
3644: BOM_EXPLODER_PUB.p_expl_end_item_id := l_end_item_id;
3645: BOM_EXPLODER_PUB.p_expl_end_item_org_id := l_end_item_org_id;
3646: BOM_EXPLODER_PUB.p_expl_unit_number := unit_number;

Line 3643: BOM_EXPLODER_PUB.p_expl_end_item_rev_code := l_end_item_revision_code;

3639: --BOM_EXPLODER_PUB.p_top_bill_sequence_id := l_bill_sequence_id;
3640: BOM_EXPLODER_PUB.p_explode_option := explode_option ;
3641: BOM_EXPLODER_PUB.p_explosion_date := l_rev_date;
3642: BOM_EXPLODER_PUB.p_expl_end_item_rev := l_end_item_revision_id;
3643: BOM_EXPLODER_PUB.p_expl_end_item_rev_code := l_end_item_revision_code;
3644: BOM_EXPLODER_PUB.p_expl_end_item_id := l_end_item_id;
3645: BOM_EXPLODER_PUB.p_expl_end_item_org_id := l_end_item_org_id;
3646: BOM_EXPLODER_PUB.p_expl_unit_number := unit_number;
3647: BOM_EXPLODER_PUB.p_group_id := grp_id;

Line 3644: BOM_EXPLODER_PUB.p_expl_end_item_id := l_end_item_id;

3640: BOM_EXPLODER_PUB.p_explode_option := explode_option ;
3641: BOM_EXPLODER_PUB.p_explosion_date := l_rev_date;
3642: BOM_EXPLODER_PUB.p_expl_end_item_rev := l_end_item_revision_id;
3643: BOM_EXPLODER_PUB.p_expl_end_item_rev_code := l_end_item_revision_code;
3644: BOM_EXPLODER_PUB.p_expl_end_item_id := l_end_item_id;
3645: BOM_EXPLODER_PUB.p_expl_end_item_org_id := l_end_item_org_id;
3646: BOM_EXPLODER_PUB.p_expl_unit_number := unit_number;
3647: BOM_EXPLODER_PUB.p_group_id := grp_id;
3648: BOM_EXPLODER_PUB.p_top_effectivity_control := nvl(l_effectivity_control,1);

Line 3645: BOM_EXPLODER_PUB.p_expl_end_item_org_id := l_end_item_org_id;

3641: BOM_EXPLODER_PUB.p_explosion_date := l_rev_date;
3642: BOM_EXPLODER_PUB.p_expl_end_item_rev := l_end_item_revision_id;
3643: BOM_EXPLODER_PUB.p_expl_end_item_rev_code := l_end_item_revision_code;
3644: BOM_EXPLODER_PUB.p_expl_end_item_id := l_end_item_id;
3645: BOM_EXPLODER_PUB.p_expl_end_item_org_id := l_end_item_org_id;
3646: BOM_EXPLODER_PUB.p_expl_unit_number := unit_number;
3647: BOM_EXPLODER_PUB.p_group_id := grp_id;
3648: BOM_EXPLODER_PUB.p_top_effectivity_control := nvl(l_effectivity_control,1);
3649:

Line 3646: BOM_EXPLODER_PUB.p_expl_unit_number := unit_number;

3642: BOM_EXPLODER_PUB.p_expl_end_item_rev := l_end_item_revision_id;
3643: BOM_EXPLODER_PUB.p_expl_end_item_rev_code := l_end_item_revision_code;
3644: BOM_EXPLODER_PUB.p_expl_end_item_id := l_end_item_id;
3645: BOM_EXPLODER_PUB.p_expl_end_item_org_id := l_end_item_org_id;
3646: BOM_EXPLODER_PUB.p_expl_unit_number := unit_number;
3647: BOM_EXPLODER_PUB.p_group_id := grp_id;
3648: BOM_EXPLODER_PUB.p_top_effectivity_control := nvl(l_effectivity_control,1);
3649:
3650: IF l_bill_expl_exists = 'Y' AND nvl(l_rexplode_flag,'0') <> '1'

Line 3647: BOM_EXPLODER_PUB.p_group_id := grp_id;

3643: BOM_EXPLODER_PUB.p_expl_end_item_rev_code := l_end_item_revision_code;
3644: BOM_EXPLODER_PUB.p_expl_end_item_id := l_end_item_id;
3645: BOM_EXPLODER_PUB.p_expl_end_item_org_id := l_end_item_org_id;
3646: BOM_EXPLODER_PUB.p_expl_unit_number := unit_number;
3647: BOM_EXPLODER_PUB.p_group_id := grp_id;
3648: BOM_EXPLODER_PUB.p_top_effectivity_control := nvl(l_effectivity_control,1);
3649:
3650: IF l_bill_expl_exists = 'Y' AND nvl(l_rexplode_flag,'0') <> '1'
3651: THEN

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

3644: BOM_EXPLODER_PUB.p_expl_end_item_id := l_end_item_id;
3645: BOM_EXPLODER_PUB.p_expl_end_item_org_id := l_end_item_org_id;
3646: BOM_EXPLODER_PUB.p_expl_unit_number := unit_number;
3647: BOM_EXPLODER_PUB.p_group_id := grp_id;
3648: BOM_EXPLODER_PUB.p_top_effectivity_control := nvl(l_effectivity_control,1);
3649:
3650: IF l_bill_expl_exists = 'Y' AND nvl(l_rexplode_flag,'0') <> '1'
3651: THEN
3652:

Line 4265: p_pkg_name => 'BOM_EXPLODER_PUB',

4261: END IF;
4262: error_code := -1;
4263: err_msg := 'parameter error';
4264: Fnd_Msg_Pub.Build_Exc_Msg(
4265: p_pkg_name => 'BOM_EXPLODER_PUB',
4266: p_procedure_name => 'exploder_userexit',
4267: p_error_text => 'verify parameters');
4268: err_msg := Fnd_Message.Get_Encoded;
4269: WHEN inv_uom_conv_exe THEN

Line 4283: p_pkg_name => 'BOM_EXPLODER_PUB',

4279: rollback;
4280: END IF;
4281: error_code := SQLCODE;
4282: Fnd_Msg_Pub.Build_Exc_Msg(
4283: p_pkg_name => 'BOM_EXPLODER_PUB',
4284: p_procedure_name => 'exploder_userexit',
4285: p_error_text => SQLERRM);
4286: err_msg := Fnd_Message.Get_Encoded;
4287: --ROLLBACK;

Line 4606: Return BOM_EXPLODER_PUB.p_Top_Bill_Sequence_Id;

4602:
4603: FUNCTION Get_Top_Bill_Sequence_Id RETURN NUMBER
4604: IS
4605: BEGIN
4606: Return BOM_EXPLODER_PUB.p_Top_Bill_Sequence_Id;
4607: END;
4608:
4609: FUNCTION Get_Explosion_Date RETURN DATE IS
4610: BEGIN

Line 4611: Return BOM_EXPLODER_PUB.p_Explosion_Date;

4607: END;
4608:
4609: FUNCTION Get_Explosion_Date RETURN DATE IS
4610: BEGIN
4611: Return BOM_EXPLODER_PUB.p_Explosion_Date;
4612: END;
4613:
4614: FUNCTION Get_Expl_End_Item_Rev RETURN NUMBER IS
4615: BEGIN

Line 4616: Return BOM_EXPLODER_PUB.p_Expl_End_Item_Rev;

4612: END;
4613:
4614: FUNCTION Get_Expl_End_Item_Rev RETURN NUMBER IS
4615: BEGIN
4616: Return BOM_EXPLODER_PUB.p_Expl_End_Item_Rev;
4617: END;
4618:
4619: FUNCTION Get_Expl_End_Item_Rev_Code RETURN VARCHAR2 IS
4620: BEGIN

Line 4621: Return BOM_EXPLODER_PUB.p_Expl_End_Item_Rev_Code;

4617: END;
4618:
4619: FUNCTION Get_Expl_End_Item_Rev_Code RETURN VARCHAR2 IS
4620: BEGIN
4621: Return BOM_EXPLODER_PUB.p_Expl_End_Item_Rev_Code;
4622: END;
4623:
4624: FUNCTION Get_Expl_Unit_Number RETURN VARCHAR2 IS
4625: BEGIN

Line 4626: Return BOM_EXPLODER_PUB.p_Expl_Unit_Number;

4622: END;
4623:
4624: FUNCTION Get_Expl_Unit_Number RETURN VARCHAR2 IS
4625: BEGIN
4626: Return BOM_EXPLODER_PUB.p_Expl_Unit_Number;
4627: END;
4628:
4629: FUNCTION Get_Explode_Option RETURN NUMBER IS
4630: BEGIN

Line 4631: Return BOM_EXPLODER_PUB.p_Explode_Option;

4627: END;
4628:
4629: FUNCTION Get_Explode_Option RETURN NUMBER IS
4630: BEGIN
4631: Return BOM_EXPLODER_PUB.p_Explode_Option;
4632: END;
4633:
4634: FUNCTION Get_Group_Id RETURN NUMBER IS
4635: BEGIN

Line 4636: Return BOM_EXPLODER_PUB.p_Group_Id;

4632: END;
4633:
4634: FUNCTION Get_Group_Id RETURN NUMBER IS
4635: BEGIN
4636: Return BOM_EXPLODER_PUB.p_Group_Id;
4637: END;
4638:
4639: FUNCTION Get_Top_Effectivity_Control RETURN NUMBER IS
4640: BEGIN

Line 4641: Return BOM_EXPLODER_PUB.p_Group_Id;

4637: END;
4638:
4639: FUNCTION Get_Top_Effectivity_Control RETURN NUMBER IS
4640: BEGIN
4641: Return BOM_EXPLODER_PUB.p_Group_Id;
4642: END;
4643:
4644: FUNCTION Get_Component_Revision(p_component_sequence_id NUMBER) RETURN VARCHAR2 IS
4645: BEGIN

Line 4646: Return BOM_EXPLODER_PUB.component_revision_array(p_component_sequence_id);

4642: END;
4643:
4644: FUNCTION Get_Component_Revision(p_component_sequence_id NUMBER) RETURN VARCHAR2 IS
4645: BEGIN
4646: Return BOM_EXPLODER_PUB.component_revision_array(p_component_sequence_id);
4647: END;
4648:
4649: FUNCTION Get_Component_Revision_Id(p_component_sequence_id NUMBER) RETURN NUMBER IS
4650: BEGIN

Line 4651: Return BOM_EXPLODER_PUB.component_revision_id_array(p_component_sequence_id);

4647: END;
4648:
4649: FUNCTION Get_Component_Revision_Id(p_component_sequence_id NUMBER) RETURN NUMBER IS
4650: BEGIN
4651: Return BOM_EXPLODER_PUB.component_revision_id_array(p_component_sequence_id);
4652: END;
4653:
4654: FUNCTION Get_Component_Revision_Label(p_component_sequence_id NUMBER) RETURN VARCHAR2 IS
4655: BEGIN

Line 4656: Return BOM_EXPLODER_PUB.component_revision_label_array(p_component_sequence_id);

4652: END;
4653:
4654: FUNCTION Get_Component_Revision_Label(p_component_sequence_id NUMBER) RETURN VARCHAR2 IS
4655: BEGIN
4656: Return BOM_EXPLODER_PUB.component_revision_label_array(p_component_sequence_id);
4657: END;
4658:
4659: FUNCTION Get_Revision_HighDate(p_revision_id NUMBER) RETURN DATE IS
4660: BEGIN

Line 4661: Return BOM_EXPLODER_PUB.revision_highdate_array(p_revision_id);

4657: END;
4658:
4659: FUNCTION Get_Revision_HighDate(p_revision_id NUMBER) RETURN DATE IS
4660: BEGIN
4661: Return BOM_EXPLODER_PUB.revision_highdate_array(p_revision_id);
4662: END;
4663:
4664: FUNCTION Get_Component_Access_Flag(p_component_sequence_id NUMBER) RETURN VARCHAR2 IS
4665: BEGIN

Line 4666: Return BOM_EXPLODER_PUB.access_flag_array(p_component_sequence_id);

4662: END;
4663:
4664: FUNCTION Get_Component_Access_Flag(p_component_sequence_id NUMBER) RETURN VARCHAR2 IS
4665: BEGIN
4666: Return BOM_EXPLODER_PUB.access_flag_array(p_component_sequence_id);
4667: END;
4668:
4669: FUNCTION Get_EGO_User RETURN VARCHAR2 IS
4670: BEGIN

Line 4676: Return BOM_EXPLODER_PUB.p_current_revision_code;

4672: END;
4673:
4674: FUNCTION Get_Current_Revision_Code RETURN VARCHAR2 IS
4675: BEGIN
4676: Return BOM_EXPLODER_PUB.p_current_revision_code;
4677: END;
4678:
4679: FUNCTION Get_Current_Revision_Id RETURN NUMBER IS
4680: BEGIN

Line 4681: Return BOM_EXPLODER_PUB.p_current_revision_id;

4677: END;
4678:
4679: FUNCTION Get_Current_Revision_Id RETURN NUMBER IS
4680: BEGIN
4681: Return BOM_EXPLODER_PUB.p_current_revision_id;
4682: END;
4683:
4684: FUNCTION Get_Current_Revision_Label RETURN VARCHAR2 IS
4685: BEGIN

Line 4686: Return BOM_EXPLODER_PUB.p_current_revision_label;

4682: END;
4683:
4684: FUNCTION Get_Current_Revision_Label RETURN VARCHAR2 IS
4685: BEGIN
4686: Return BOM_EXPLODER_PUB.p_current_revision_label;
4687: END;
4688:
4689: FUNCTION Get_Change_Policy(p_component_sequence_id NUMBER) RETURN VARCHAR2 IS
4690: BEGIN

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

4687: END;
4688:
4689: FUNCTION Get_Change_Policy(p_component_sequence_id NUMBER) RETURN VARCHAR2 IS
4690: BEGIN
4691: --Return nvl(BOM_EXPLODER_PUB.change_policy_array(p_component_sequence_id),'ALLOWED');
4692: Return BOM_EXPLODER_PUB.change_policy_array(p_component_sequence_id);
4693: END;
4694:
4695: FUNCTION Get_Current_RevisionId( p_inventory_item_id IN NUMBER,

Line 4692: Return BOM_EXPLODER_PUB.change_policy_array(p_component_sequence_id);

4688:
4689: FUNCTION Get_Change_Policy(p_component_sequence_id NUMBER) RETURN VARCHAR2 IS
4690: BEGIN
4691: --Return nvl(BOM_EXPLODER_PUB.change_policy_array(p_component_sequence_id),'ALLOWED');
4692: Return BOM_EXPLODER_PUB.change_policy_array(p_component_sequence_id);
4693: END;
4694:
4695: FUNCTION Get_Current_RevisionId( p_inventory_item_id IN NUMBER,
4696: p_organization_id IN NUMBER,

Line 4725: END BOM_EXPLODER_PUB;

4721: Return null;
4722:
4723: END;
4724:
4725: END BOM_EXPLODER_PUB;