DBA Data[Home] [Help]

APPS.GMF_ALLOCATIONDEFINITION_PUB dependencies on FND_USER

Line 89: ,x_user_id OUT NOCOPY fnd_user.user_id%TYPE

85: PROCEDURE Validate_Input_Params
86: (
87: p_alloc_def_rec IN Allocation_Definition_Rec_Type
88: ,x_alloc_def_rec OUT NOCOPY Allocation_Definition_Rec_Type
89: ,x_user_id OUT NOCOPY fnd_user.user_id%TYPE
90: ,x_return_status OUT NOCOPY VARCHAR2
91: ) ;
92: --
93: -- Function to check existence of allocation definition

Line 187: l_user_id fnd_user.user_id%TYPE ;

183: IS
184: l_api_name CONSTANT VARCHAR2(30) := 'Create_Allocation_Definition' ;
185: l_api_version CONSTANT NUMBER := 3.0 ;
186: l_alloc_def_rec Allocation_Definition_Rec_Type ;
187: l_user_id fnd_user.user_id%TYPE ;
188: l_return_status VARCHAR2(2) ;
189: l_count NUMBER(10) ;
190: l_data VARCHAR2(2000) ;
191: l_no_rows_ins NUMBER(10) ;

Line 386: l_user_id fnd_user.user_id%TYPE ;

382: IS
383: l_api_name CONSTANT VARCHAR2(30) := 'Update_Allocation_Definition' ;
384: l_api_version CONSTANT NUMBER := 3.0 ;
385: l_alloc_def_rec Allocation_Definition_Rec_Type ;
386: l_user_id fnd_user.user_id%TYPE ;
387: l_no_rows_upd NUMBER(10) ;
388: l_return_status VARCHAR2(2) ;
389: l_count NUMBER(10) ;
390: l_cnt NUMBER(10) ; -- used for validate basis account

Line 635: l_user_id fnd_user.user_id%TYPE ;

631: l_api_name CONSTANT VARCHAR2(30) := 'Delete_Allocation_Definition' ;
632: l_api_version CONSTANT NUMBER := 3.0 ;
633:
634: l_alloc_def_rec Allocation_Definition_Rec_Type ;
635: l_user_id fnd_user.user_id%TYPE ;
636: l_no_rows_del NUMBER(10) ;
637: l_count NUMBER(10) ;
638: l_cnt NUMBER(10) ;
639: l_user_name fnd_user.user_name%TYPE ; --:= FND_API.G_MISS_CHAR ; Bug 2659435

Line 639: l_user_name fnd_user.user_name%TYPE ; --:= FND_API.G_MISS_CHAR ; Bug 2659435

635: l_user_id fnd_user.user_id%TYPE ;
636: l_no_rows_del NUMBER(10) ;
637: l_count NUMBER(10) ;
638: l_cnt NUMBER(10) ;
639: l_user_name fnd_user.user_name%TYPE ; --:= FND_API.G_MISS_CHAR ; Bug 2659435
640: l_return_status VARCHAR2(2) ;
641: l_data VARCHAR2(2000) ;
642:
643: BEGIN

Line 948: ,x_user_id OUT NOCOPY fnd_user.user_id%TYPE

944: PROCEDURE Validate_Input_Params
945: (
946: p_alloc_def_rec IN Allocation_Definition_Rec_Type
947: ,x_alloc_def_rec OUT NOCOPY Allocation_Definition_Rec_Type
948: ,x_user_id OUT NOCOPY fnd_user.user_id%TYPE
949: ,x_return_status OUT NOCOPY VARCHAR2
950: )
951: IS
952: -- Bug 2659435. Commented all default assignments to increase performance.

Line 971: l_user_name fnd_user.user_name%TYPE ; -- := FND_API.G_MISS_CHAR ;

967: l_cost_cmpntcls_code cm_cmpt_mst.cost_cmpntcls_code%TYPE ; -- := FND_API.G_MISS_CHAR ;
968: l_analysis_code cm_alys_mst.cost_analysis_code%TYPE ; -- := FND_API.G_MISS_CHAR ;
969: l_organization_id NUMBER ; -- := FND_API.G_MISS_CHAR ;
970: l_delete_mark NUMBER ; -- := FND_API.G_MISS_NUM ;
971: l_user_name fnd_user.user_name%TYPE ; -- := FND_API.G_MISS_CHAR ;
972: l_user_id NUMBER ; -- := FND_API.G_MISS_NUM ;
973: l_usage_ind cm_cmpt_mst.usage_ind%TYPE ;
974: l_status NUMBER(2) ; -- used for validate basis account
975: l_organization_code mtl_parameters.organization_code%TYPE;