DBA Data[Home] [Help]

APPS.GMD_RECIPE_DETAIL dependencies on FND_USER

Line 50: l_user_id fnd_user.user_id%TYPE := 0;

46: /* Defining all local variables */
47: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_RECIPE_PROCESS_LOSS';
48: l_api_version CONSTANT NUMBER := 1.0;
49:
50: l_user_id fnd_user.user_id%TYPE := 0;
51: l_recipe_id GMD_RECIPES.recipe_id%TYPE := 0;
52:
53: /* Variables used for defining status */
54: l_return_status varchar2(1) := FND_API.G_RET_STS_SUCCESS;

Line 264: l_user_id fnd_user.user_id%TYPE := 0;

260: /* Defining all local variables */
261: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_RECIPE_CUSTOMERS';
262: l_api_version CONSTANT NUMBER := 1.0;
263:
264: l_user_id fnd_user.user_id%TYPE := 0;
265: l_recipe_id GMD_RECIPES.recipe_id%TYPE := 0;
266: l_customer_id NUMBER := 0;
267: l_site_id NUMBER := 0;
268: l_org_id NUMBER := 0;

Line 532: l_user_id fnd_user.user_id%TYPE := 0;

528: /* Define all variables specific to this procedure */
529: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_RECIPE_VR';
530: l_api_version CONSTANT NUMBER := 1.0;
531:
532: l_user_id fnd_user.user_id%TYPE := 0;
533: l_recipe_id GMD_RECIPES.recipe_id%TYPE := 0;
534:
535: /* Variables used for defining status */
536: l_return_status varchar2(1) := FND_API.G_RET_STS_SUCCESS;

Line 903: l_user_id fnd_user.user_id%TYPE := 0;

899: /* Define all variables specific to this procedure */
900: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_RECIPE_MTL';
901: l_api_version CONSTANT NUMBER := 1.0;
902:
903: l_user_id fnd_user.user_id%TYPE := 0;
904: l_recipe_id GMD_RECIPES.recipe_id%TYPE := 0;
905:
906: /* Variables used for defining status */
907: l_return_status varchar2(1) := FND_API.G_RET_STS_SUCCESS;

Line 1117: l_user_id fnd_user.user_id%TYPE := 0;

1113: /* Defining all local variables */
1114: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_RECIPE_PROCESS_LOSS';
1115: l_api_version CONSTANT NUMBER := 1.0;
1116:
1117: l_user_id fnd_user.user_id%TYPE := 0;
1118: l_recipe_id GMD_RECIPES.recipe_id%TYPE := 0;
1119:
1120: /* Variables used for defining status */
1121: l_return_status varchar2(1) := FND_API.G_RET_STS_SUCCESS;

Line 1339: l_user_id fnd_user.user_id%TYPE := 0;

1335: /* Defining all local variables */
1336: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_RECIPE_CUSTOMERS';
1337: l_api_version CONSTANT NUMBER := 1.0;
1338:
1339: l_user_id fnd_user.user_id%TYPE := 0;
1340: l_recipe_id GMD_RECIPES.recipe_id%TYPE := 0;
1341: l_customer_id NUMBER := 0;
1342: l_site_id NUMBER := 0;
1343: l_org_id NUMBER := 0;

Line 1559: l_user_id fnd_user.user_id%TYPE;

1555: /* Define all variables specific to this procedure */
1556: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_RECIPE_VR';
1557: l_api_version CONSTANT NUMBER := 2.0;
1558:
1559: l_user_id fnd_user.user_id%TYPE;
1560: l_recipe_id GMD_RECIPES.recipe_id%TYPE := 0;
1561:
1562: /* Variables used for defining status */
1563: l_return_status varchar2(1) := FND_API.G_RET_STS_SUCCESS;

Line 2020: l_user_id fnd_user.user_id%TYPE := 0;

2016: /* Define all variables specific to this procedure */
2017: l_api_name CONSTANT VARCHAR2(30) := 'RECIPE_ROUTING_STEPS';
2018: l_api_version CONSTANT NUMBER := 2.0;
2019:
2020: l_user_id fnd_user.user_id%TYPE := 0;
2021: l_recipe_id GMD_RECIPES.recipe_id%TYPE := 0;
2022:
2023: /* Variables used for defining status */
2024: l_return_status varchar2(1) := FND_API.G_RET_STS_SUCCESS;

Line 2484: l_user_id fnd_user.user_id%TYPE := 0;

2480: /* Define all variables specific to this procedure */
2481: l_api_name CONSTANT VARCHAR2(30) := 'RECIPE_ORGN_OPERATIONS';
2482: l_api_version CONSTANT NUMBER := 2.0;
2483: l_rowid VARCHAR2(32);
2484: l_user_id fnd_user.user_id%TYPE := 0;
2485: l_recipe_id GMD_RECIPES.recipe_id%TYPE := 0;
2486:
2487: /* Variables used for defining status */
2488: l_return_status varchar2(1) := FND_API.G_RET_STS_SUCCESS;

Line 2930: l_user_id fnd_user.user_id%TYPE := 0;

2926: l_dml_type VARCHAR2(1) := 'I';
2927: l_api_name CONSTANT VARCHAR2(30) := 'RECIPE_ORGN_RESOURCES';
2928: l_api_version CONSTANT NUMBER := 2.0;
2929:
2930: l_user_id fnd_user.user_id%TYPE := 0;
2931: l_recipe_id GMD_RECIPES.recipe_id%TYPE := 0;
2932:
2933: /* Variables used for defining status */
2934: l_return_status varchar2(1) := FND_API.G_RET_STS_SUCCESS;