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.MTL_CATEGORIES_PKG dependencies on MTL_CATEGORIES_B

Line 62: from MTL_CATEGORIES_B

58: ) is
59:
60: cursor C is
61: select ROWID
62: from MTL_CATEGORIES_B
63: where CATEGORY_ID = X_CATEGORY_ID ;
64:
65: begin
66:

Line 67: insert into MTL_CATEGORIES_B (

63: where CATEGORY_ID = X_CATEGORY_ID ;
64:
65: begin
66:
67: insert into MTL_CATEGORIES_B (
68: CATEGORY_ID,
69: STRUCTURE_ID,
70: DISABLE_DATE,
71: WEB_STATUS,

Line 342: from MTL_CATEGORIES_B

338: ATTRIBUTE15
339: -- WH_UPDATE_DATE,
340: -- TOTAL_PROD_ID,
341: -- REQUEST_ID,
342: from MTL_CATEGORIES_B
343: where CATEGORY_ID = X_CATEGORY_ID
344: for update of CATEGORY_ID nowait;
345:
346: recinfo c%rowtype;

Line 544: update MTL_CATEGORIES_B

540: l_msg_count NUMBER;
541: l_msg_data VARCHAR2(2000);
542: BEGIN
543:
544: update MTL_CATEGORIES_B
545: set
546: STRUCTURE_ID = X_STRUCTURE_ID,
547: DISABLE_DATE = X_DISABLE_DATE,
548: WEB_STATUS = X_WEB_STATUS,

Line 702: delete from MTL_CATEGORIES_B

698: if (sql%notfound) then
699: raise no_data_found;
700: end if;
701:
702: delete from MTL_CATEGORIES_B
703: where CATEGORY_ID = X_CATEGORY_ID ;
704:
705: if (sql%notfound) then
706: raise no_data_found;

Line 720: from MTL_CATEGORIES_B B

716:
717: delete from MTL_CATEGORIES_TL T
718: where not exists
719: ( select NULL
720: from MTL_CATEGORIES_B B
721: where B.CATEGORY_ID = T.CATEGORY_ID
722: );
723:
724: update MTL_CATEGORIES_TL T set (

Line 898: ,X_SEGMENT1 IN MTL_CATEGORIES_B.SEGMENT1%TYPE

894: PROCEDURE Load_Row
895: (
896: x_CATEGORY_NAME IN MTL_CATEGORIES_KFV.CONCATENATED_SEGMENTS%TYPE
897: ,x_STRUCTURE_CODE IN FND_ID_FLEX_STRUCTURES.ID_FLEX_STRUCTURE_CODE%TYPE --BUG 6975120
898: ,X_SEGMENT1 IN MTL_CATEGORIES_B.SEGMENT1%TYPE
899: ,X_SEGMENT2 IN MTL_CATEGORIES_B.SEGMENT1%TYPE
900: ,X_SEGMENT3 IN MTL_CATEGORIES_B.SEGMENT1%TYPE
901: ,X_SEGMENT4 IN MTL_CATEGORIES_B.SEGMENT1%TYPE
902: ,X_SEGMENT5 IN MTL_CATEGORIES_B.SEGMENT1%TYPE

Line 899: ,X_SEGMENT2 IN MTL_CATEGORIES_B.SEGMENT1%TYPE

895: (
896: x_CATEGORY_NAME IN MTL_CATEGORIES_KFV.CONCATENATED_SEGMENTS%TYPE
897: ,x_STRUCTURE_CODE IN FND_ID_FLEX_STRUCTURES.ID_FLEX_STRUCTURE_CODE%TYPE --BUG 6975120
898: ,X_SEGMENT1 IN MTL_CATEGORIES_B.SEGMENT1%TYPE
899: ,X_SEGMENT2 IN MTL_CATEGORIES_B.SEGMENT1%TYPE
900: ,X_SEGMENT3 IN MTL_CATEGORIES_B.SEGMENT1%TYPE
901: ,X_SEGMENT4 IN MTL_CATEGORIES_B.SEGMENT1%TYPE
902: ,X_SEGMENT5 IN MTL_CATEGORIES_B.SEGMENT1%TYPE
903: ,X_SEGMENT6 IN MTL_CATEGORIES_B.SEGMENT1%TYPE

Line 900: ,X_SEGMENT3 IN MTL_CATEGORIES_B.SEGMENT1%TYPE

896: x_CATEGORY_NAME IN MTL_CATEGORIES_KFV.CONCATENATED_SEGMENTS%TYPE
897: ,x_STRUCTURE_CODE IN FND_ID_FLEX_STRUCTURES.ID_FLEX_STRUCTURE_CODE%TYPE --BUG 6975120
898: ,X_SEGMENT1 IN MTL_CATEGORIES_B.SEGMENT1%TYPE
899: ,X_SEGMENT2 IN MTL_CATEGORIES_B.SEGMENT1%TYPE
900: ,X_SEGMENT3 IN MTL_CATEGORIES_B.SEGMENT1%TYPE
901: ,X_SEGMENT4 IN MTL_CATEGORIES_B.SEGMENT1%TYPE
902: ,X_SEGMENT5 IN MTL_CATEGORIES_B.SEGMENT1%TYPE
903: ,X_SEGMENT6 IN MTL_CATEGORIES_B.SEGMENT1%TYPE
904: ,X_SEGMENT7 IN MTL_CATEGORIES_B.SEGMENT1%TYPE

Line 901: ,X_SEGMENT4 IN MTL_CATEGORIES_B.SEGMENT1%TYPE

897: ,x_STRUCTURE_CODE IN FND_ID_FLEX_STRUCTURES.ID_FLEX_STRUCTURE_CODE%TYPE --BUG 6975120
898: ,X_SEGMENT1 IN MTL_CATEGORIES_B.SEGMENT1%TYPE
899: ,X_SEGMENT2 IN MTL_CATEGORIES_B.SEGMENT1%TYPE
900: ,X_SEGMENT3 IN MTL_CATEGORIES_B.SEGMENT1%TYPE
901: ,X_SEGMENT4 IN MTL_CATEGORIES_B.SEGMENT1%TYPE
902: ,X_SEGMENT5 IN MTL_CATEGORIES_B.SEGMENT1%TYPE
903: ,X_SEGMENT6 IN MTL_CATEGORIES_B.SEGMENT1%TYPE
904: ,X_SEGMENT7 IN MTL_CATEGORIES_B.SEGMENT1%TYPE
905: ,X_SEGMENT8 IN MTL_CATEGORIES_B.SEGMENT1%TYPE

Line 902: ,X_SEGMENT5 IN MTL_CATEGORIES_B.SEGMENT1%TYPE

898: ,X_SEGMENT1 IN MTL_CATEGORIES_B.SEGMENT1%TYPE
899: ,X_SEGMENT2 IN MTL_CATEGORIES_B.SEGMENT1%TYPE
900: ,X_SEGMENT3 IN MTL_CATEGORIES_B.SEGMENT1%TYPE
901: ,X_SEGMENT4 IN MTL_CATEGORIES_B.SEGMENT1%TYPE
902: ,X_SEGMENT5 IN MTL_CATEGORIES_B.SEGMENT1%TYPE
903: ,X_SEGMENT6 IN MTL_CATEGORIES_B.SEGMENT1%TYPE
904: ,X_SEGMENT7 IN MTL_CATEGORIES_B.SEGMENT1%TYPE
905: ,X_SEGMENT8 IN MTL_CATEGORIES_B.SEGMENT1%TYPE
906: ,X_SEGMENT9 IN MTL_CATEGORIES_B.SEGMENT1%TYPE

Line 903: ,X_SEGMENT6 IN MTL_CATEGORIES_B.SEGMENT1%TYPE

899: ,X_SEGMENT2 IN MTL_CATEGORIES_B.SEGMENT1%TYPE
900: ,X_SEGMENT3 IN MTL_CATEGORIES_B.SEGMENT1%TYPE
901: ,X_SEGMENT4 IN MTL_CATEGORIES_B.SEGMENT1%TYPE
902: ,X_SEGMENT5 IN MTL_CATEGORIES_B.SEGMENT1%TYPE
903: ,X_SEGMENT6 IN MTL_CATEGORIES_B.SEGMENT1%TYPE
904: ,X_SEGMENT7 IN MTL_CATEGORIES_B.SEGMENT1%TYPE
905: ,X_SEGMENT8 IN MTL_CATEGORIES_B.SEGMENT1%TYPE
906: ,X_SEGMENT9 IN MTL_CATEGORIES_B.SEGMENT1%TYPE
907: ,X_SEGMENT10 IN MTL_CATEGORIES_B.SEGMENT1%TYPE

Line 904: ,X_SEGMENT7 IN MTL_CATEGORIES_B.SEGMENT1%TYPE

900: ,X_SEGMENT3 IN MTL_CATEGORIES_B.SEGMENT1%TYPE
901: ,X_SEGMENT4 IN MTL_CATEGORIES_B.SEGMENT1%TYPE
902: ,X_SEGMENT5 IN MTL_CATEGORIES_B.SEGMENT1%TYPE
903: ,X_SEGMENT6 IN MTL_CATEGORIES_B.SEGMENT1%TYPE
904: ,X_SEGMENT7 IN MTL_CATEGORIES_B.SEGMENT1%TYPE
905: ,X_SEGMENT8 IN MTL_CATEGORIES_B.SEGMENT1%TYPE
906: ,X_SEGMENT9 IN MTL_CATEGORIES_B.SEGMENT1%TYPE
907: ,X_SEGMENT10 IN MTL_CATEGORIES_B.SEGMENT1%TYPE
908: ,X_SEGMENT11 IN MTL_CATEGORIES_B.SEGMENT1%TYPE

Line 905: ,X_SEGMENT8 IN MTL_CATEGORIES_B.SEGMENT1%TYPE

901: ,X_SEGMENT4 IN MTL_CATEGORIES_B.SEGMENT1%TYPE
902: ,X_SEGMENT5 IN MTL_CATEGORIES_B.SEGMENT1%TYPE
903: ,X_SEGMENT6 IN MTL_CATEGORIES_B.SEGMENT1%TYPE
904: ,X_SEGMENT7 IN MTL_CATEGORIES_B.SEGMENT1%TYPE
905: ,X_SEGMENT8 IN MTL_CATEGORIES_B.SEGMENT1%TYPE
906: ,X_SEGMENT9 IN MTL_CATEGORIES_B.SEGMENT1%TYPE
907: ,X_SEGMENT10 IN MTL_CATEGORIES_B.SEGMENT1%TYPE
908: ,X_SEGMENT11 IN MTL_CATEGORIES_B.SEGMENT1%TYPE
909: ,X_SEGMENT12 IN MTL_CATEGORIES_B.SEGMENT1%TYPE

Line 906: ,X_SEGMENT9 IN MTL_CATEGORIES_B.SEGMENT1%TYPE

902: ,X_SEGMENT5 IN MTL_CATEGORIES_B.SEGMENT1%TYPE
903: ,X_SEGMENT6 IN MTL_CATEGORIES_B.SEGMENT1%TYPE
904: ,X_SEGMENT7 IN MTL_CATEGORIES_B.SEGMENT1%TYPE
905: ,X_SEGMENT8 IN MTL_CATEGORIES_B.SEGMENT1%TYPE
906: ,X_SEGMENT9 IN MTL_CATEGORIES_B.SEGMENT1%TYPE
907: ,X_SEGMENT10 IN MTL_CATEGORIES_B.SEGMENT1%TYPE
908: ,X_SEGMENT11 IN MTL_CATEGORIES_B.SEGMENT1%TYPE
909: ,X_SEGMENT12 IN MTL_CATEGORIES_B.SEGMENT1%TYPE
910: ,X_SEGMENT13 IN MTL_CATEGORIES_B.SEGMENT1%TYPE

Line 907: ,X_SEGMENT10 IN MTL_CATEGORIES_B.SEGMENT1%TYPE

903: ,X_SEGMENT6 IN MTL_CATEGORIES_B.SEGMENT1%TYPE
904: ,X_SEGMENT7 IN MTL_CATEGORIES_B.SEGMENT1%TYPE
905: ,X_SEGMENT8 IN MTL_CATEGORIES_B.SEGMENT1%TYPE
906: ,X_SEGMENT9 IN MTL_CATEGORIES_B.SEGMENT1%TYPE
907: ,X_SEGMENT10 IN MTL_CATEGORIES_B.SEGMENT1%TYPE
908: ,X_SEGMENT11 IN MTL_CATEGORIES_B.SEGMENT1%TYPE
909: ,X_SEGMENT12 IN MTL_CATEGORIES_B.SEGMENT1%TYPE
910: ,X_SEGMENT13 IN MTL_CATEGORIES_B.SEGMENT1%TYPE
911: ,X_SEGMENT14 IN MTL_CATEGORIES_B.SEGMENT1%TYPE

Line 908: ,X_SEGMENT11 IN MTL_CATEGORIES_B.SEGMENT1%TYPE

904: ,X_SEGMENT7 IN MTL_CATEGORIES_B.SEGMENT1%TYPE
905: ,X_SEGMENT8 IN MTL_CATEGORIES_B.SEGMENT1%TYPE
906: ,X_SEGMENT9 IN MTL_CATEGORIES_B.SEGMENT1%TYPE
907: ,X_SEGMENT10 IN MTL_CATEGORIES_B.SEGMENT1%TYPE
908: ,X_SEGMENT11 IN MTL_CATEGORIES_B.SEGMENT1%TYPE
909: ,X_SEGMENT12 IN MTL_CATEGORIES_B.SEGMENT1%TYPE
910: ,X_SEGMENT13 IN MTL_CATEGORIES_B.SEGMENT1%TYPE
911: ,X_SEGMENT14 IN MTL_CATEGORIES_B.SEGMENT1%TYPE
912: ,X_SEGMENT15 IN MTL_CATEGORIES_B.SEGMENT1%TYPE

Line 909: ,X_SEGMENT12 IN MTL_CATEGORIES_B.SEGMENT1%TYPE

905: ,X_SEGMENT8 IN MTL_CATEGORIES_B.SEGMENT1%TYPE
906: ,X_SEGMENT9 IN MTL_CATEGORIES_B.SEGMENT1%TYPE
907: ,X_SEGMENT10 IN MTL_CATEGORIES_B.SEGMENT1%TYPE
908: ,X_SEGMENT11 IN MTL_CATEGORIES_B.SEGMENT1%TYPE
909: ,X_SEGMENT12 IN MTL_CATEGORIES_B.SEGMENT1%TYPE
910: ,X_SEGMENT13 IN MTL_CATEGORIES_B.SEGMENT1%TYPE
911: ,X_SEGMENT14 IN MTL_CATEGORIES_B.SEGMENT1%TYPE
912: ,X_SEGMENT15 IN MTL_CATEGORIES_B.SEGMENT1%TYPE
913: ,X_SEGMENT16 IN MTL_CATEGORIES_B.SEGMENT1%TYPE

Line 910: ,X_SEGMENT13 IN MTL_CATEGORIES_B.SEGMENT1%TYPE

906: ,X_SEGMENT9 IN MTL_CATEGORIES_B.SEGMENT1%TYPE
907: ,X_SEGMENT10 IN MTL_CATEGORIES_B.SEGMENT1%TYPE
908: ,X_SEGMENT11 IN MTL_CATEGORIES_B.SEGMENT1%TYPE
909: ,X_SEGMENT12 IN MTL_CATEGORIES_B.SEGMENT1%TYPE
910: ,X_SEGMENT13 IN MTL_CATEGORIES_B.SEGMENT1%TYPE
911: ,X_SEGMENT14 IN MTL_CATEGORIES_B.SEGMENT1%TYPE
912: ,X_SEGMENT15 IN MTL_CATEGORIES_B.SEGMENT1%TYPE
913: ,X_SEGMENT16 IN MTL_CATEGORIES_B.SEGMENT1%TYPE
914: ,X_SEGMENT17 IN MTL_CATEGORIES_B.SEGMENT1%TYPE

Line 911: ,X_SEGMENT14 IN MTL_CATEGORIES_B.SEGMENT1%TYPE

907: ,X_SEGMENT10 IN MTL_CATEGORIES_B.SEGMENT1%TYPE
908: ,X_SEGMENT11 IN MTL_CATEGORIES_B.SEGMENT1%TYPE
909: ,X_SEGMENT12 IN MTL_CATEGORIES_B.SEGMENT1%TYPE
910: ,X_SEGMENT13 IN MTL_CATEGORIES_B.SEGMENT1%TYPE
911: ,X_SEGMENT14 IN MTL_CATEGORIES_B.SEGMENT1%TYPE
912: ,X_SEGMENT15 IN MTL_CATEGORIES_B.SEGMENT1%TYPE
913: ,X_SEGMENT16 IN MTL_CATEGORIES_B.SEGMENT1%TYPE
914: ,X_SEGMENT17 IN MTL_CATEGORIES_B.SEGMENT1%TYPE
915: ,X_SEGMENT18 IN MTL_CATEGORIES_B.SEGMENT1%TYPE

Line 912: ,X_SEGMENT15 IN MTL_CATEGORIES_B.SEGMENT1%TYPE

908: ,X_SEGMENT11 IN MTL_CATEGORIES_B.SEGMENT1%TYPE
909: ,X_SEGMENT12 IN MTL_CATEGORIES_B.SEGMENT1%TYPE
910: ,X_SEGMENT13 IN MTL_CATEGORIES_B.SEGMENT1%TYPE
911: ,X_SEGMENT14 IN MTL_CATEGORIES_B.SEGMENT1%TYPE
912: ,X_SEGMENT15 IN MTL_CATEGORIES_B.SEGMENT1%TYPE
913: ,X_SEGMENT16 IN MTL_CATEGORIES_B.SEGMENT1%TYPE
914: ,X_SEGMENT17 IN MTL_CATEGORIES_B.SEGMENT1%TYPE
915: ,X_SEGMENT18 IN MTL_CATEGORIES_B.SEGMENT1%TYPE
916: ,X_SEGMENT19 IN MTL_CATEGORIES_B.SEGMENT1%TYPE

Line 913: ,X_SEGMENT16 IN MTL_CATEGORIES_B.SEGMENT1%TYPE

909: ,X_SEGMENT12 IN MTL_CATEGORIES_B.SEGMENT1%TYPE
910: ,X_SEGMENT13 IN MTL_CATEGORIES_B.SEGMENT1%TYPE
911: ,X_SEGMENT14 IN MTL_CATEGORIES_B.SEGMENT1%TYPE
912: ,X_SEGMENT15 IN MTL_CATEGORIES_B.SEGMENT1%TYPE
913: ,X_SEGMENT16 IN MTL_CATEGORIES_B.SEGMENT1%TYPE
914: ,X_SEGMENT17 IN MTL_CATEGORIES_B.SEGMENT1%TYPE
915: ,X_SEGMENT18 IN MTL_CATEGORIES_B.SEGMENT1%TYPE
916: ,X_SEGMENT19 IN MTL_CATEGORIES_B.SEGMENT1%TYPE
917: ,X_SEGMENT20 IN MTL_CATEGORIES_B.SEGMENT1%TYPE

Line 914: ,X_SEGMENT17 IN MTL_CATEGORIES_B.SEGMENT1%TYPE

910: ,X_SEGMENT13 IN MTL_CATEGORIES_B.SEGMENT1%TYPE
911: ,X_SEGMENT14 IN MTL_CATEGORIES_B.SEGMENT1%TYPE
912: ,X_SEGMENT15 IN MTL_CATEGORIES_B.SEGMENT1%TYPE
913: ,X_SEGMENT16 IN MTL_CATEGORIES_B.SEGMENT1%TYPE
914: ,X_SEGMENT17 IN MTL_CATEGORIES_B.SEGMENT1%TYPE
915: ,X_SEGMENT18 IN MTL_CATEGORIES_B.SEGMENT1%TYPE
916: ,X_SEGMENT19 IN MTL_CATEGORIES_B.SEGMENT1%TYPE
917: ,X_SEGMENT20 IN MTL_CATEGORIES_B.SEGMENT1%TYPE
918: ,X_SUMMARY_FLAG IN MTL_CATEGORIES_B.SUMMARY_FLAG%TYPE

Line 915: ,X_SEGMENT18 IN MTL_CATEGORIES_B.SEGMENT1%TYPE

911: ,X_SEGMENT14 IN MTL_CATEGORIES_B.SEGMENT1%TYPE
912: ,X_SEGMENT15 IN MTL_CATEGORIES_B.SEGMENT1%TYPE
913: ,X_SEGMENT16 IN MTL_CATEGORIES_B.SEGMENT1%TYPE
914: ,X_SEGMENT17 IN MTL_CATEGORIES_B.SEGMENT1%TYPE
915: ,X_SEGMENT18 IN MTL_CATEGORIES_B.SEGMENT1%TYPE
916: ,X_SEGMENT19 IN MTL_CATEGORIES_B.SEGMENT1%TYPE
917: ,X_SEGMENT20 IN MTL_CATEGORIES_B.SEGMENT1%TYPE
918: ,X_SUMMARY_FLAG IN MTL_CATEGORIES_B.SUMMARY_FLAG%TYPE
919: ,X_ENABLED_FLAG IN MTL_CATEGORIES_B.ENABLED_FLAG%TYPE

Line 916: ,X_SEGMENT19 IN MTL_CATEGORIES_B.SEGMENT1%TYPE

912: ,X_SEGMENT15 IN MTL_CATEGORIES_B.SEGMENT1%TYPE
913: ,X_SEGMENT16 IN MTL_CATEGORIES_B.SEGMENT1%TYPE
914: ,X_SEGMENT17 IN MTL_CATEGORIES_B.SEGMENT1%TYPE
915: ,X_SEGMENT18 IN MTL_CATEGORIES_B.SEGMENT1%TYPE
916: ,X_SEGMENT19 IN MTL_CATEGORIES_B.SEGMENT1%TYPE
917: ,X_SEGMENT20 IN MTL_CATEGORIES_B.SEGMENT1%TYPE
918: ,X_SUMMARY_FLAG IN MTL_CATEGORIES_B.SUMMARY_FLAG%TYPE
919: ,X_ENABLED_FLAG IN MTL_CATEGORIES_B.ENABLED_FLAG%TYPE
920: ,X_START_DATE_ACTIVE IN MTL_CATEGORIES_B.START_DATE_ACTIVE%TYPE

Line 917: ,X_SEGMENT20 IN MTL_CATEGORIES_B.SEGMENT1%TYPE

913: ,X_SEGMENT16 IN MTL_CATEGORIES_B.SEGMENT1%TYPE
914: ,X_SEGMENT17 IN MTL_CATEGORIES_B.SEGMENT1%TYPE
915: ,X_SEGMENT18 IN MTL_CATEGORIES_B.SEGMENT1%TYPE
916: ,X_SEGMENT19 IN MTL_CATEGORIES_B.SEGMENT1%TYPE
917: ,X_SEGMENT20 IN MTL_CATEGORIES_B.SEGMENT1%TYPE
918: ,X_SUMMARY_FLAG IN MTL_CATEGORIES_B.SUMMARY_FLAG%TYPE
919: ,X_ENABLED_FLAG IN MTL_CATEGORIES_B.ENABLED_FLAG%TYPE
920: ,X_START_DATE_ACTIVE IN MTL_CATEGORIES_B.START_DATE_ACTIVE%TYPE
921: ,X_END_DATE_ACTIVE IN MTL_CATEGORIES_B.END_DATE_ACTIVE%TYPE

Line 918: ,X_SUMMARY_FLAG IN MTL_CATEGORIES_B.SUMMARY_FLAG%TYPE

914: ,X_SEGMENT17 IN MTL_CATEGORIES_B.SEGMENT1%TYPE
915: ,X_SEGMENT18 IN MTL_CATEGORIES_B.SEGMENT1%TYPE
916: ,X_SEGMENT19 IN MTL_CATEGORIES_B.SEGMENT1%TYPE
917: ,X_SEGMENT20 IN MTL_CATEGORIES_B.SEGMENT1%TYPE
918: ,X_SUMMARY_FLAG IN MTL_CATEGORIES_B.SUMMARY_FLAG%TYPE
919: ,X_ENABLED_FLAG IN MTL_CATEGORIES_B.ENABLED_FLAG%TYPE
920: ,X_START_DATE_ACTIVE IN MTL_CATEGORIES_B.START_DATE_ACTIVE%TYPE
921: ,X_END_DATE_ACTIVE IN MTL_CATEGORIES_B.END_DATE_ACTIVE%TYPE
922: ,X_DISABLE_DATE IN MTL_CATEGORIES_B.DISABLE_DATE%TYPE

Line 919: ,X_ENABLED_FLAG IN MTL_CATEGORIES_B.ENABLED_FLAG%TYPE

915: ,X_SEGMENT18 IN MTL_CATEGORIES_B.SEGMENT1%TYPE
916: ,X_SEGMENT19 IN MTL_CATEGORIES_B.SEGMENT1%TYPE
917: ,X_SEGMENT20 IN MTL_CATEGORIES_B.SEGMENT1%TYPE
918: ,X_SUMMARY_FLAG IN MTL_CATEGORIES_B.SUMMARY_FLAG%TYPE
919: ,X_ENABLED_FLAG IN MTL_CATEGORIES_B.ENABLED_FLAG%TYPE
920: ,X_START_DATE_ACTIVE IN MTL_CATEGORIES_B.START_DATE_ACTIVE%TYPE
921: ,X_END_DATE_ACTIVE IN MTL_CATEGORIES_B.END_DATE_ACTIVE%TYPE
922: ,X_DISABLE_DATE IN MTL_CATEGORIES_B.DISABLE_DATE%TYPE
923: ,X_CATEGORY_SET_ID IN MTL_CATEGORY_SETS_B.CATEGORY_SET_ID%TYPE

Line 920: ,X_START_DATE_ACTIVE IN MTL_CATEGORIES_B.START_DATE_ACTIVE%TYPE

916: ,X_SEGMENT19 IN MTL_CATEGORIES_B.SEGMENT1%TYPE
917: ,X_SEGMENT20 IN MTL_CATEGORIES_B.SEGMENT1%TYPE
918: ,X_SUMMARY_FLAG IN MTL_CATEGORIES_B.SUMMARY_FLAG%TYPE
919: ,X_ENABLED_FLAG IN MTL_CATEGORIES_B.ENABLED_FLAG%TYPE
920: ,X_START_DATE_ACTIVE IN MTL_CATEGORIES_B.START_DATE_ACTIVE%TYPE
921: ,X_END_DATE_ACTIVE IN MTL_CATEGORIES_B.END_DATE_ACTIVE%TYPE
922: ,X_DISABLE_DATE IN MTL_CATEGORIES_B.DISABLE_DATE%TYPE
923: ,X_CATEGORY_SET_ID IN MTL_CATEGORY_SETS_B.CATEGORY_SET_ID%TYPE
924: ,X_CATEGORY_SET_NAME IN MTL_CATEGORY_SETS_TL.CATEGORY_SET_NAME%TYPE

Line 921: ,X_END_DATE_ACTIVE IN MTL_CATEGORIES_B.END_DATE_ACTIVE%TYPE

917: ,X_SEGMENT20 IN MTL_CATEGORIES_B.SEGMENT1%TYPE
918: ,X_SUMMARY_FLAG IN MTL_CATEGORIES_B.SUMMARY_FLAG%TYPE
919: ,X_ENABLED_FLAG IN MTL_CATEGORIES_B.ENABLED_FLAG%TYPE
920: ,X_START_DATE_ACTIVE IN MTL_CATEGORIES_B.START_DATE_ACTIVE%TYPE
921: ,X_END_DATE_ACTIVE IN MTL_CATEGORIES_B.END_DATE_ACTIVE%TYPE
922: ,X_DISABLE_DATE IN MTL_CATEGORIES_B.DISABLE_DATE%TYPE
923: ,X_CATEGORY_SET_ID IN MTL_CATEGORY_SETS_B.CATEGORY_SET_ID%TYPE
924: ,X_CATEGORY_SET_NAME IN MTL_CATEGORY_SETS_TL.CATEGORY_SET_NAME%TYPE
925: ,X_OWNER IN VARCHAR2

Line 922: ,X_DISABLE_DATE IN MTL_CATEGORIES_B.DISABLE_DATE%TYPE

918: ,X_SUMMARY_FLAG IN MTL_CATEGORIES_B.SUMMARY_FLAG%TYPE
919: ,X_ENABLED_FLAG IN MTL_CATEGORIES_B.ENABLED_FLAG%TYPE
920: ,X_START_DATE_ACTIVE IN MTL_CATEGORIES_B.START_DATE_ACTIVE%TYPE
921: ,X_END_DATE_ACTIVE IN MTL_CATEGORIES_B.END_DATE_ACTIVE%TYPE
922: ,X_DISABLE_DATE IN MTL_CATEGORIES_B.DISABLE_DATE%TYPE
923: ,X_CATEGORY_SET_ID IN MTL_CATEGORY_SETS_B.CATEGORY_SET_ID%TYPE
924: ,X_CATEGORY_SET_NAME IN MTL_CATEGORY_SETS_TL.CATEGORY_SET_NAME%TYPE
925: ,X_OWNER IN VARCHAR2
926: ,X_LAST_UPDATE_DATE IN MTL_CATEGORIES_B.LAST_UPDATE_DATE%TYPE

Line 926: ,X_LAST_UPDATE_DATE IN MTL_CATEGORIES_B.LAST_UPDATE_DATE%TYPE

922: ,X_DISABLE_DATE IN MTL_CATEGORIES_B.DISABLE_DATE%TYPE
923: ,X_CATEGORY_SET_ID IN MTL_CATEGORY_SETS_B.CATEGORY_SET_ID%TYPE
924: ,X_CATEGORY_SET_NAME IN MTL_CATEGORY_SETS_TL.CATEGORY_SET_NAME%TYPE
925: ,X_OWNER IN VARCHAR2
926: ,X_LAST_UPDATE_DATE IN MTL_CATEGORIES_B.LAST_UPDATE_DATE%TYPE
927: ,X_DESCRIPTION IN MTL_CATEGORIES_TL.DESCRIPTION%TYPE
928: ,X_APPLICATION_SHORT_NAME IN VARCHAR2
929: ,X_UPLOAD_TO_FUNCTIONAL_AREA IN VARCHAR2
930: ) IS

Line 934: l_category_id MTL_CATEGORIES_B.CATEGORY_ID%TYPE;

930: ) IS
931:
932: l_category_set_id MTL_CATEGORY_SETS_B.CATEGORY_SET_ID%TYPE;
933: l_structure_id MTL_CATEGORY_SETS_B.STRUCTURE_ID%TYPE;
934: l_category_id MTL_CATEGORIES_B.CATEGORY_ID%TYPE;
935: l_category_rec INV_ITEM_CATEGORY_PUB.CATEGORY_REC_TYPE;
936: l_new_catg_id NUMBER;
937: l_category_set_name MTL_CATEGORY_SETS_TL.CATEGORY_SET_NAME%TYPE := X_CATEGORY_SET_NAME ;
938: l_return_status VARCHAR2(1);

Line 965: FROM MTL_CATEGORIES_B_KFV

961:
962: /*CURSOR get_category_id(cp_structure_id NUMBER
963: ,cp_concatenated_segs VARCHAR2) IS
964: SELECT CATEGORY_ID
965: FROM MTL_CATEGORIES_B_KFV
966: WHERE structure_id = cp_structure_id
967: AND CONCATENATED_SEGMENTS = cp_concatenated_segs;*/
968:
969: begin

Line 1158: --There is a chance that mtl_categories_b_kfv is not

1154:
1155: ELSE
1156:
1157: --Bug 7659277
1158: --There is a chance that mtl_categories_b_kfv is not
1159: --prepared before this code runs.
1160: --hence using INVPUOPI.mtl_pr_parse_flex_name to get
1161: --the category id.
1162: /*OPEN get_category_id(l_structure_id,l_concat_segs);