DBA Data[Home] [Help]

APPS.AMS_ACT_LIST_PVT dependencies on FND_GLOBAL

Line 292: ,FND_GLOBAL.User_Id

288: )
289: VALUES (
290: ams_act_logs_s.NEXTVAL
291: ,SYSDATE
292: ,FND_GLOBAL.User_Id
293: ,SYSDATE
294: ,FND_GLOBAL.User_Id
295: ,FND_GLOBAL.Conc_Login_Id
296: ,1

Line 294: ,FND_GLOBAL.User_Id

290: ams_act_logs_s.NEXTVAL
291: ,SYSDATE
292: ,FND_GLOBAL.User_Id
293: ,SYSDATE
294: ,FND_GLOBAL.User_Id
295: ,FND_GLOBAL.Conc_Login_Id
296: ,1
297: ,g_list_header_id
298: ,'LIST'

Line 295: ,FND_GLOBAL.Conc_Login_Id

291: ,SYSDATE
292: ,FND_GLOBAL.User_Id
293: ,SYSDATE
294: ,FND_GLOBAL.User_Id
295: ,FND_GLOBAL.Conc_Login_Id
296: ,1
297: ,g_list_header_id
298: ,'LIST'
299: ,ams_act_logs_transaction_id_s.NEXTVAL

Line 483: IF FND_GLOBAL.User_Id IS NULL

479: -- =========================================================================
480: -- Validate Environment
481: -- =========================================================================
482:
483: IF FND_GLOBAL.User_Id IS NULL
484: THEN
485: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_USER_PROFILE_MISSING');
486: RAISE FND_API.G_EXC_ERROR;
487: END IF;

Line 539: l_list_group_rec.last_updated_by := fnd_global.user_id;

535: l_list_group_rec.group_code := l_act_list_rec.group_code ;
536: l_list_group_rec.act_list_used_by_id := p_act_list_rec.list_used_by_id;
537: l_list_group_rec.arc_act_list_used_by := 'TARGET';
538: l_list_group_rec.last_update_date := sysdate;
539: l_list_group_rec.last_updated_by := fnd_global.user_id;
540: l_list_group_rec.creation_date := sysdate;
541: l_list_group_rec.created_by := fnd_global.user_id;
542: if l_act_list_group_id is null then
543: AMS_List_Group_PVT.Create_List_Group(

Line 541: l_list_group_rec.created_by := fnd_global.user_id;

537: l_list_group_rec.arc_act_list_used_by := 'TARGET';
538: l_list_group_rec.last_update_date := sysdate;
539: l_list_group_rec.last_updated_by := fnd_global.user_id;
540: l_list_group_rec.creation_date := sysdate;
541: l_list_group_rec.created_by := fnd_global.user_id;
542: if l_act_list_group_id is null then
543: AMS_List_Group_PVT.Create_List_Group(
544: p_api_version_number => 1.0,
545: p_init_msg_list => FND_API.G_FALSE,

Line 570: p_last_updated_by => FND_GLOBAL.USER_ID,

566:
567: AMS_ACT_LISTS_PKG.Insert_Row(
568: px_act_list_header_id => l_act_list_header_id,
569: p_last_update_date => SYSDATE,
570: p_last_updated_by => FND_GLOBAL.USER_ID,
571: p_creation_date => SYSDATE,
572: p_created_by => FND_GLOBAL.USER_ID,
573: px_object_version_number => l_object_version_number,
574: p_last_update_login => FND_GLOBAL.conc_LOGIN_ID,

Line 572: p_created_by => FND_GLOBAL.USER_ID,

568: px_act_list_header_id => l_act_list_header_id,
569: p_last_update_date => SYSDATE,
570: p_last_updated_by => FND_GLOBAL.USER_ID,
571: p_creation_date => SYSDATE,
572: p_created_by => FND_GLOBAL.USER_ID,
573: px_object_version_number => l_object_version_number,
574: p_last_update_login => FND_GLOBAL.conc_LOGIN_ID,
575: p_list_header_id => l_act_list_rec.list_header_id,
576: p_group_code => l_act_list_rec.group_code ,

Line 574: p_last_update_login => FND_GLOBAL.conc_LOGIN_ID,

570: p_last_updated_by => FND_GLOBAL.USER_ID,
571: p_creation_date => SYSDATE,
572: p_created_by => FND_GLOBAL.USER_ID,
573: px_object_version_number => l_object_version_number,
574: p_last_update_login => FND_GLOBAL.conc_LOGIN_ID,
575: p_list_header_id => l_act_list_rec.list_header_id,
576: p_group_code => l_act_list_rec.group_code ,
577: p_list_used_by_id => l_act_list_rec.list_used_by_id,
578: p_list_used_by => l_act_list_rec.list_used_by,

Line 984: l_list_group_rec.last_updated_by := fnd_global.user_id;

980: l_list_group_rec.group_code := l_act_list_rec.group_code ;
981: l_list_group_rec.act_list_used_by_id := l_act_list_rec.list_used_by_id;
982: l_list_group_rec.arc_act_list_used_by := 'TARGET';
983: l_list_group_rec.last_update_date := sysdate;
984: l_list_group_rec.last_updated_by := fnd_global.user_id;
985: l_list_group_rec.creation_date := sysdate;
986: l_list_group_rec.created_by := fnd_global.user_id;
987:
988: if l_act_list_group_id is null then

Line 986: l_list_group_rec.created_by := fnd_global.user_id;

982: l_list_group_rec.arc_act_list_used_by := 'TARGET';
983: l_list_group_rec.last_update_date := sysdate;
984: l_list_group_rec.last_updated_by := fnd_global.user_id;
985: l_list_group_rec.creation_date := sysdate;
986: l_list_group_rec.created_by := fnd_global.user_id;
987:
988: if l_act_list_group_id is null then
989: AMS_List_Group_PVT.Create_List_Group(
990: p_api_version_number => 1.0,

Line 1009: p_last_updated_by => FND_GLOBAL.USER_ID,

1005:
1006: AMS_ACT_LISTS_PKG.Update_Row(
1007: p_act_list_header_id => l_act_list_rec.act_list_header_id,
1008: p_last_update_date => SYSDATE,
1009: p_last_updated_by => FND_GLOBAL.USER_ID,
1010: p_creation_date => SYSDATE,
1011: p_created_by => FND_GLOBAL.USER_ID,
1012: p_object_version_number => p_act_list_rec.object_version_number,
1013: p_last_update_login => FND_GLOBAL.conc_LOGIN_ID,

Line 1011: p_created_by => FND_GLOBAL.USER_ID,

1007: p_act_list_header_id => l_act_list_rec.act_list_header_id,
1008: p_last_update_date => SYSDATE,
1009: p_last_updated_by => FND_GLOBAL.USER_ID,
1010: p_creation_date => SYSDATE,
1011: p_created_by => FND_GLOBAL.USER_ID,
1012: p_object_version_number => p_act_list_rec.object_version_number,
1013: p_last_update_login => FND_GLOBAL.conc_LOGIN_ID,
1014: p_list_header_id => l_act_list_rec.list_header_id,
1015: p_group_code => l_act_list_rec.group_code,

Line 1013: p_last_update_login => FND_GLOBAL.conc_LOGIN_ID,

1009: p_last_updated_by => FND_GLOBAL.USER_ID,
1010: p_creation_date => SYSDATE,
1011: p_created_by => FND_GLOBAL.USER_ID,
1012: p_object_version_number => p_act_list_rec.object_version_number,
1013: p_last_update_login => FND_GLOBAL.conc_LOGIN_ID,
1014: p_list_header_id => l_act_list_rec.list_header_id,
1015: p_group_code => l_act_list_rec.group_code,
1016: p_list_used_by_id => l_act_list_rec.list_used_by_id,
1017: p_list_used_by => l_act_list_rec.list_used_by,

Line 3176: elsif p_input_string = fnd_global.newline then

3172: ,p_valid_string OUT NOCOPY varchar2) IS
3173: BEGIN
3174: if p_input_string = ' ' then
3175: p_valid_string :='Y';
3176: elsif p_input_string = fnd_global.newline then
3177: p_valid_string :='Y';
3178: elsif p_input_string = fnd_global.tab then
3179: p_valid_string :='Y';
3180: elsif p_input_string = '

Line 3178: elsif p_input_string = fnd_global.tab then

3174: if p_input_string = ' ' then
3175: p_valid_string :='Y';
3176: elsif p_input_string = fnd_global.newline then
3177: p_valid_string :='Y';
3178: elsif p_input_string = fnd_global.tab then
3179: p_valid_string :='Y';
3180: elsif p_input_string = '
3181: ' then
3182: p_valid_string :='Y';

Line 3463: to_char(FND_GLOBAL.login_id )|| ',' ||''''||

3459: ''''||p_master_type||''''||','||
3460: 0 || ',' ||
3461: to_char(g_list_header_id )|| ',' ||''''||
3462: to_char(sysdate )|| ''''||','||
3463: to_char(FND_GLOBAL.login_id )|| ',' ||''''||
3464: to_char(sysdate )|| ''''||','||
3465: to_char(nvl(l_created_by, FND_GLOBAL.login_id) )|| ',' ||
3466: 'ams_list_entries_s.nextval' || ','||
3467: 1 || ','||

Line 3465: to_char(nvl(l_created_by, FND_GLOBAL.login_id) )|| ',' ||

3461: to_char(g_list_header_id )|| ',' ||''''||
3462: to_char(sysdate )|| ''''||','||
3463: to_char(FND_GLOBAL.login_id )|| ',' ||''''||
3464: to_char(sysdate )|| ''''||','||
3465: to_char(nvl(l_created_by, FND_GLOBAL.login_id) )|| ',' ||
3466: 'ams_list_entries_s.nextval' || ','||
3467: 1 || ','||
3468: ''''||'NONE' ||'''' || ','||
3469: 0 || ',' ||

Line 4184: FND_GLOBAL.User_Id,

4180: ams_list_rule_usages_s.nextval,
4181: l_list_header_id,
4182: l_list_rule_id,
4183: sysdate,
4184: FND_GLOBAL.User_Id,
4185: sysdate,
4186: FND_GLOBAL.User_Id,
4187: FND_GLOBAL.Conc_Login_Id,
4188: 1,

Line 4186: FND_GLOBAL.User_Id,

4182: l_list_rule_id,
4183: sysdate,
4184: FND_GLOBAL.User_Id,
4185: sysdate,
4186: FND_GLOBAL.User_Id,
4187: FND_GLOBAL.Conc_Login_Id,
4188: 1,
4189: sysdate,
4190: null,

Line 4187: FND_GLOBAL.Conc_Login_Id,

4183: sysdate,
4184: FND_GLOBAL.User_Id,
4185: sysdate,
4186: FND_GLOBAL.User_Id,
4187: FND_GLOBAL.Conc_Login_Id,
4188: 1,
4189: sysdate,
4190: null,
4191: null,

Line 4780: X_CREATED_BY => FND_GLOBAL.User_Id,

4776: X_PARAMETER_VALUE =>l_query_param_rec.parameter_value,
4777: X_OBJECT_VERSION_NUMBER => 1,
4778: X_DISPLAY_NAME => l_query_param_rec.display_name,
4779: X_CREATION_DATE => SYSDATE,
4780: X_CREATED_BY => FND_GLOBAL.User_Id,
4781: X_LAST_UPDATE_DATE => SYSDATE,
4782: X_LAST_UPDATED_BY => FND_GLOBAL.User_Id,
4783: X_LAST_UPDATE_LOGIN =>FND_GLOBAL.CONC_LOGIN_ID
4784: );

Line 4782: X_LAST_UPDATED_BY => FND_GLOBAL.User_Id,

4778: X_DISPLAY_NAME => l_query_param_rec.display_name,
4779: X_CREATION_DATE => SYSDATE,
4780: X_CREATED_BY => FND_GLOBAL.User_Id,
4781: X_LAST_UPDATE_DATE => SYSDATE,
4782: X_LAST_UPDATED_BY => FND_GLOBAL.User_Id,
4783: X_LAST_UPDATE_LOGIN =>FND_GLOBAL.CONC_LOGIN_ID
4784: );
4785:
4786: IF (AMS_DEBUG_HIGH_ON) THEN

Line 4783: X_LAST_UPDATE_LOGIN =>FND_GLOBAL.CONC_LOGIN_ID

4779: X_CREATION_DATE => SYSDATE,
4780: X_CREATED_BY => FND_GLOBAL.User_Id,
4781: X_LAST_UPDATE_DATE => SYSDATE,
4782: X_LAST_UPDATED_BY => FND_GLOBAL.User_Id,
4783: X_LAST_UPDATE_LOGIN =>FND_GLOBAL.CONC_LOGIN_ID
4784: );
4785:
4786: IF (AMS_DEBUG_HIGH_ON) THEN
4787: AMS_Utility_PVT.debug_message('copy_query_list_params in loop' || l_list_query_param_id);

Line 4851: X_CREATED_BY => FND_GLOBAL.USER_ID,

4847: X_VIEW_APPLICATION_ID => l_templ_inst_rec.view_application_id,
4848: X_INSTANCE_USED_BY => 'LIST',
4849: X_INSTANCE_USED_BY_ID => p_new_header_id ,
4850: X_CREATION_DATE => SYSDATE ,
4851: X_CREATED_BY => FND_GLOBAL.USER_ID,
4852: X_LAST_UPDATE_DATE => SYSDATE ,
4853: X_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,
4854: X_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_ID
4855: );

Line 4853: X_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,

4849: X_INSTANCE_USED_BY_ID => p_new_header_id ,
4850: X_CREATION_DATE => SYSDATE ,
4851: X_CREATED_BY => FND_GLOBAL.USER_ID,
4852: X_LAST_UPDATE_DATE => SYSDATE ,
4853: X_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,
4854: X_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_ID
4855: );
4856:
4857: IF (AMS_DEBUG_HIGH_ON) THEN

Line 4854: X_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_ID

4850: X_CREATION_DATE => SYSDATE ,
4851: X_CREATED_BY => FND_GLOBAL.USER_ID,
4852: X_LAST_UPDATE_DATE => SYSDATE ,
4853: X_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,
4854: X_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_ID
4855: );
4856:
4857: IF (AMS_DEBUG_HIGH_ON) THEN
4858: AMS_Utility_PVT.debug_message('copy_template_instance in loop done');

Line 4934: X_CREATED_BY => FND_GLOBAL.USER_ID,

4930: X_DELTA => l_cond_assoc_rec.delta ,
4931: X_OBJECT_VERSION_NUMBER =>1,
4932: X_REQUEST_ID =>NULL,
4933: X_CREATION_DATE => SYSDATE ,
4934: X_CREATED_BY => FND_GLOBAL.USER_ID,
4935: X_LAST_UPDATE_DATE => SYSDATE ,
4936: X_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,
4937: X_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_ID
4938: );

Line 4936: X_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,

4932: X_REQUEST_ID =>NULL,
4933: X_CREATION_DATE => SYSDATE ,
4934: X_CREATED_BY => FND_GLOBAL.USER_ID,
4935: X_LAST_UPDATE_DATE => SYSDATE ,
4936: X_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,
4937: X_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_ID
4938: );
4939:
4940: IF (AMS_DEBUG_HIGH_ON) THEN

Line 4937: X_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_ID

4933: X_CREATION_DATE => SYSDATE ,
4934: X_CREATED_BY => FND_GLOBAL.USER_ID,
4935: X_LAST_UPDATE_DATE => SYSDATE ,
4936: X_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,
4937: X_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_ID
4938: );
4939:
4940: IF (AMS_DEBUG_HIGH_ON) THEN
4941: AMS_Utility_PVT.debug_message('copy_conditions new assoc'||l_assoc_id);

Line 4964: X_CREATED_BY => FND_GLOBAL.USER_ID,

4960: X_LOV_VALUES_INCLUDED_FLAG => l_cond_value_rec.lov_values_included_flag,
4961: X_OBJECT_VERSION_NUMBER =>1,
4962: X_REQUEST_ID => NULL,
4963: X_CREATION_DATE => SYSDATE ,
4964: X_CREATED_BY => FND_GLOBAL.USER_ID,
4965: X_LAST_UPDATE_DATE => SYSDATE ,
4966: X_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,
4967: X_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_ID
4968: );

Line 4966: X_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,

4962: X_REQUEST_ID => NULL,
4963: X_CREATION_DATE => SYSDATE ,
4964: X_CREATED_BY => FND_GLOBAL.USER_ID,
4965: X_LAST_UPDATE_DATE => SYSDATE ,
4966: X_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,
4967: X_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_ID
4968: );
4969:
4970: IF (AMS_DEBUG_HIGH_ON) THEN

Line 4967: X_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_ID

4963: X_CREATION_DATE => SYSDATE ,
4964: X_CREATED_BY => FND_GLOBAL.USER_ID,
4965: X_LAST_UPDATE_DATE => SYSDATE ,
4966: X_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,
4967: X_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_ID
4968: );
4969:
4970: IF (AMS_DEBUG_HIGH_ON) THEN
4971: AMS_Utility_PVT.debug_message('copy_conditions new cond values '||l_assoc_id||'::::'||l_cond_value_id);