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 933: l_user_id fnd_user.user_id%TYPE := 0;

929: /* Define all variables specific to this procedure */
930: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_RECIPE_MTL';
931: l_api_version CONSTANT NUMBER := 1.0;
932:
933: l_user_id fnd_user.user_id%TYPE := 0;
934: l_recipe_id GMD_RECIPES.recipe_id%TYPE := 0;
935:
936: /* Variables used for defining status */
937: l_return_status varchar2(1) := FND_API.G_RET_STS_SUCCESS;

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

1212: /* Defining all local variables */
1213: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_RECIPE_PROCESS_LOSS';
1214: l_api_version CONSTANT NUMBER := 1.0;
1215:
1216: l_user_id fnd_user.user_id%TYPE := 0;
1217: l_recipe_id GMD_RECIPES.recipe_id%TYPE := 0;
1218:
1219: /* Variables used for defining status */
1220: l_return_status varchar2(1) := FND_API.G_RET_STS_SUCCESS;

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

1434: /* Defining all local variables */
1435: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_RECIPE_CUSTOMERS';
1436: l_api_version CONSTANT NUMBER := 1.0;
1437:
1438: l_user_id fnd_user.user_id%TYPE := 0;
1439: l_recipe_id GMD_RECIPES.recipe_id%TYPE := 0;
1440: l_customer_id NUMBER := 0;
1441: l_site_id NUMBER := 0;
1442: l_org_id NUMBER := 0;

Line 1658: l_user_id fnd_user.user_id%TYPE;

1654: /* Define all variables specific to this procedure */
1655: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_RECIPE_VR';
1656: l_api_version CONSTANT NUMBER := 2.0;
1657:
1658: l_user_id fnd_user.user_id%TYPE;
1659: l_recipe_id GMD_RECIPES.recipe_id%TYPE := 0;
1660:
1661: /* Variables used for defining status */
1662: l_return_status varchar2(1) := FND_API.G_RET_STS_SUCCESS;

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

2143: /* Define all variables specific to this procedure */
2144: l_api_name CONSTANT VARCHAR2(30) := 'RECIPE_ROUTING_STEPS';
2145: l_api_version CONSTANT NUMBER := 2.0;
2146:
2147: l_user_id fnd_user.user_id%TYPE := 0;
2148: l_recipe_id GMD_RECIPES.recipe_id%TYPE := 0;
2149:
2150: /* Variables used for defining status */
2151: l_return_status varchar2(1) := FND_API.G_RET_STS_SUCCESS;

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

2607: /* Define all variables specific to this procedure */
2608: l_api_name CONSTANT VARCHAR2(30) := 'RECIPE_ORGN_OPERATIONS';
2609: l_api_version CONSTANT NUMBER := 2.0;
2610: l_rowid VARCHAR2(32);
2611: l_user_id fnd_user.user_id%TYPE := 0;
2612: l_recipe_id GMD_RECIPES.recipe_id%TYPE := 0;
2613:
2614: /* Variables used for defining status */
2615: l_return_status varchar2(1) := FND_API.G_RET_STS_SUCCESS;

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

3053: l_dml_type VARCHAR2(1) := 'I';
3054: l_api_name CONSTANT VARCHAR2(30) := 'RECIPE_ORGN_RESOURCES';
3055: l_api_version CONSTANT NUMBER := 2.0;
3056:
3057: l_user_id fnd_user.user_id%TYPE := 0;
3058: l_recipe_id GMD_RECIPES.recipe_id%TYPE := 0;
3059:
3060: /* Variables used for defining status */
3061: l_return_status varchar2(1) := FND_API.G_RET_STS_SUCCESS;