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
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'
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
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;
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(
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,
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,
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 ,
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,
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
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,
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,
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,
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,
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 = '
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';
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 || ','||
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 || ',' ||
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,
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,
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,
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: );
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
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);
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: );
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
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');
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: );
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
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);
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: );
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
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);