DBA Data[Home] [Help]

APPS.INV_UOM_API_PUB dependencies on FND_GLOBAL

Line 480: L_USERID NUMBER := FND_GLOBAL.USER_ID;

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;

Line 481: L_LOGINID NUMBER := FND_GLOBAL.LOGIN_ID;

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;

Line 1121: L_USERID , --fnd_global.user_id,

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,

Line 1123: L_USERID, -- fnd_global.user_id,

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: );

Line 1159: L_USERID , -- fnd_global.user_id,

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

Line 1161: L_USERID , -- fnd_global.user_id,

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;

Line 1327: L_USERID NUMBER := FND_GLOBAL.USER_ID;

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;

Line 1328: L_LOGINID NUMBER := FND_GLOBAL.LOGIN_ID;

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;

Line 1961: L_USERID NUMBER := FND_GLOBAL.USER_ID;

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

Line 1962: L_LOGINID NUMBER := FND_GLOBAL.LOGIN_ID;

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);