476: L_ROW_ID VARCHAR2(40);
477: P_API_VERSION_NUMBER NUMBER := 1.0;
478: P_INIT_MSG_LST VARCHAR2(50);
479:
480: L_USERID NUMBER := FND_GLOBAL.USER_ID;
481: L_LOGINID NUMBER := FND_GLOBAL.LOGIN_ID;
482:
483: L_INV_ATTRIBUTES_TBL CHAR_TBL;
484: L_UOM_ATTRIBUTES_TBL CHAR_TBL;
477: P_API_VERSION_NUMBER NUMBER := 1.0;
478: P_INIT_MSG_LST VARCHAR2(50);
479:
480: L_USERID NUMBER := FND_GLOBAL.USER_ID;
481: L_LOGINID NUMBER := FND_GLOBAL.LOGIN_ID;
482:
483: L_INV_ATTRIBUTES_TBL CHAR_TBL;
484: L_UOM_ATTRIBUTES_TBL CHAR_TBL;
485: -- CNT NUMBER;
1117: P_BASE_UNIT_OF_MEASURE,
1118: P_BASE_UOM_CODE,
1119: P_UOM_CLASS,
1120: SYSDATE,
1121: L_USERID , --fnd_global.user_id,
1122: SYSDATE,
1123: L_USERID, -- fnd_global.user_id,
1124: L_LOGINID,
1125: 1,
1119: P_UOM_CLASS,
1120: SYSDATE,
1121: L_USERID , --fnd_global.user_id,
1122: SYSDATE,
1123: L_USERID, -- fnd_global.user_id,
1124: L_LOGINID,
1125: 1,
1126: 'N'
1127: );
1155: P_BASE_UNIT_OF_MEASURE,
1156: P_BASE_UOM_CODE,
1157: P_UOM_CLASS,
1158: SYSDATE,
1159: L_USERID , -- fnd_global.user_id,
1160: SYSDATE,
1161: L_USERID , -- fnd_global.user_id,
1162: L_LOGINID,
1163: 1
1157: P_UOM_CLASS,
1158: SYSDATE,
1159: L_USERID , -- fnd_global.user_id,
1160: SYSDATE,
1161: L_USERID , -- fnd_global.user_id,
1162: L_LOGINID,
1163: 1
1164: );
1165: END;
1323: -- P_CREATED_BY NUMBER := -1;
1324:
1325: L_DESC_FLEX_NAME VARCHAR2(30) := 'MTL_UNITS_OF_MEASURE' ;
1326:
1327: L_USERID NUMBER := FND_GLOBAL.USER_ID;
1328: L_LOGINID NUMBER := FND_GLOBAL.LOGIN_ID;
1329:
1330: L_INV_ATTRIBUTES_TBL CHAR_TBL;
1331: -- CNT NUMBER;
1324:
1325: L_DESC_FLEX_NAME VARCHAR2(30) := 'MTL_UNITS_OF_MEASURE' ;
1326:
1327: L_USERID NUMBER := FND_GLOBAL.USER_ID;
1328: L_LOGINID NUMBER := FND_GLOBAL.LOGIN_ID;
1329:
1330: L_INV_ATTRIBUTES_TBL CHAR_TBL;
1331: -- CNT NUMBER;
1332: l_att_count number;
1957: L_ATT NUMBER;
1958: L_ATR NUMBER;
1959: l_reason_count number;
1960:
1961: L_USERID NUMBER := FND_GLOBAL.USER_ID;
1962: L_LOGINID NUMBER := FND_GLOBAL.LOGIN_ID;
1963:
1964: CURSOR GET_BATCH
1965: IS
1958: L_ATR NUMBER;
1959: l_reason_count number;
1960:
1961: L_USERID NUMBER := FND_GLOBAL.USER_ID;
1962: L_LOGINID NUMBER := FND_GLOBAL.LOGIN_ID;
1963:
1964: CURSOR GET_BATCH
1965: IS
1966: SELECT * FROM GME_BATCH_HEADER WHERE BATCH_ID = NVL(X_PHANTOM_ID, X_BATCH_ID);