DBA Data[Home] [Help]

APPS.ASO_COPY_TMPL_PUB dependencies on FND_GLOBAL

Line 17: G_USER_ID NUMBER := FND_GLOBAL.USER_ID;

13: -- NOTE :
14: --
15: -- End of Comments
16:
17: G_USER_ID NUMBER := FND_GLOBAL.USER_ID;
18: G_LOGIN_ID NUMBER := FND_GLOBAL.CONC_LOGIN_ID;
19: G_PKG_NAME CONSTANT VARCHAR2 ( 30 ) := 'ASO_COPY_TMPL _PUB';
20: G_FILE_NAME CONSTANT VARCHAR2 ( 12 ) := 'asoptcpb.pls';
21:

Line 18: G_LOGIN_ID NUMBER := FND_GLOBAL.CONC_LOGIN_ID;

14: --
15: -- End of Comments
16:
17: G_USER_ID NUMBER := FND_GLOBAL.USER_ID;
18: G_LOGIN_ID NUMBER := FND_GLOBAL.CONC_LOGIN_ID;
19: G_PKG_NAME CONSTANT VARCHAR2 ( 30 ) := 'ASO_COPY_TMPL _PUB';
20: G_FILE_NAME CONSTANT VARCHAR2 ( 12 ) := 'asoptcpb.pls';
21:
22:

Line 105: IF FND_GLOBAL.User_Id IS NULL THEN

101: --
102: -- ******************************************************************
103: -- Validate Environment
104: -- ******************************************************************
105: IF FND_GLOBAL.User_Id IS NULL THEN
106: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_ERROR ) THEN
107: FND_MESSAGE.Set_Name ('ASO' , 'UT_CANNOT_GET_PROFILE_VALUE' );
108: FND_MESSAGE.Set_Token ('PROFILE' , 'USER_ID', FALSE );
109: FND_MSG_PUB.ADD;

Line 514: G_USER_ID NUMBER := FND_GLOBAL.USER_ID;

510: l_service_item_flag VARCHAR2 ( 1 );
511: l_serviceable_product_flag VARCHAR2 ( 1 );
512: l_return_status VARCHAR2 ( 1 );
513: l_api_version_number CONSTANT NUMBER := 1.0;
514: G_USER_ID NUMBER := FND_GLOBAL.USER_ID;
515: G_LOGIN_ID NUMBER := FND_GLOBAL.CONC_LOGIN_ID;
516: l_ship_id NUMBER;
517: l_orig_item_id_tbl CZ_API_PUB.number_tbl_type;
518: l_new_item_id_tbl CZ_API_PUB.number_tbl_type;

Line 515: G_LOGIN_ID NUMBER := FND_GLOBAL.CONC_LOGIN_ID;

511: l_serviceable_product_flag VARCHAR2 ( 1 );
512: l_return_status VARCHAR2 ( 1 );
513: l_api_version_number CONSTANT NUMBER := 1.0;
514: G_USER_ID NUMBER := FND_GLOBAL.USER_ID;
515: G_LOGIN_ID NUMBER := FND_GLOBAL.CONC_LOGIN_ID;
516: l_ship_id NUMBER;
517: l_orig_item_id_tbl CZ_API_PUB.number_tbl_type;
518: l_new_item_id_tbl CZ_API_PUB.number_tbl_type;
519: -- hyang: for bug 2692785