836: , all_org => l_all_org
837: , val_item_flag => 1 -- validate item
838: , pro_item_flag => l_only_validate -- process validated items
839: , del_rec_flag => 2 -- do not delete processed records
840: , prog_appid => fnd_global.prog_appl_id
841: , prog_id => fnd_global.conc_program_id
842: , request_id => fnd_global.conc_request_id
843: , user_id => fnd_global.user_id
844: , login_id => fnd_global.login_id
837: , val_item_flag => 1 -- validate item
838: , pro_item_flag => l_only_validate -- process validated items
839: , del_rec_flag => 2 -- do not delete processed records
840: , prog_appid => fnd_global.prog_appl_id
841: , prog_id => fnd_global.conc_program_id
842: , request_id => fnd_global.conc_request_id
843: , user_id => fnd_global.user_id
844: , login_id => fnd_global.login_id
845: , err_text => l_err_text
838: , pro_item_flag => l_only_validate -- process validated items
839: , del_rec_flag => 2 -- do not delete processed records
840: , prog_appid => fnd_global.prog_appl_id
841: , prog_id => fnd_global.conc_program_id
842: , request_id => fnd_global.conc_request_id
843: , user_id => fnd_global.user_id
844: , login_id => fnd_global.login_id
845: , err_text => l_err_text
846: , xset_id => l_set_process_id -- only run for the current item record
839: , del_rec_flag => 2 -- do not delete processed records
840: , prog_appid => fnd_global.prog_appl_id
841: , prog_id => fnd_global.conc_program_id
842: , request_id => fnd_global.conc_request_id
843: , user_id => fnd_global.user_id
844: , login_id => fnd_global.login_id
845: , err_text => l_err_text
846: , xset_id => l_set_process_id -- only run for the current item record
847: , commit_flag => l_IOI_commit_flag
840: , prog_appid => fnd_global.prog_appl_id
841: , prog_id => fnd_global.conc_program_id
842: , request_id => fnd_global.conc_request_id
843: , user_id => fnd_global.user_id
844: , login_id => fnd_global.login_id
845: , err_text => l_err_text
846: , xset_id => l_set_process_id -- only run for the current item record
847: , commit_flag => l_IOI_commit_flag
848: , run_mode => l_IOI_run_mode
4157: ,l_Item_rec.GLOBAL_ATTRIBUTE18
4158: ,l_Item_rec.GLOBAL_ATTRIBUTE19
4159: ,l_Item_rec.GLOBAL_ATTRIBUTE20
4160: ,SYSDATE
4161: ,FND_GLOBAL.user_id
4162: ,SYSDATE
4163: ,FND_GLOBAL.user_id
4164: ,FND_GLOBAL.login_id
4165: ,FND_GLOBAL.conc_request_id
4159: ,l_Item_rec.GLOBAL_ATTRIBUTE20
4160: ,SYSDATE
4161: ,FND_GLOBAL.user_id
4162: ,SYSDATE
4163: ,FND_GLOBAL.user_id
4164: ,FND_GLOBAL.login_id
4165: ,FND_GLOBAL.conc_request_id
4166: ,FND_GLOBAL.prog_appl_id
4167: ,FND_GLOBAL.conc_program_id
4160: ,SYSDATE
4161: ,FND_GLOBAL.user_id
4162: ,SYSDATE
4163: ,FND_GLOBAL.user_id
4164: ,FND_GLOBAL.login_id
4165: ,FND_GLOBAL.conc_request_id
4166: ,FND_GLOBAL.prog_appl_id
4167: ,FND_GLOBAL.conc_program_id
4168: ,SYSDATE
4161: ,FND_GLOBAL.user_id
4162: ,SYSDATE
4163: ,FND_GLOBAL.user_id
4164: ,FND_GLOBAL.login_id
4165: ,FND_GLOBAL.conc_request_id
4166: ,FND_GLOBAL.prog_appl_id
4167: ,FND_GLOBAL.conc_program_id
4168: ,SYSDATE
4169: ,l_Item_rec.VMI_MINIMUM_UNITS
4162: ,SYSDATE
4163: ,FND_GLOBAL.user_id
4164: ,FND_GLOBAL.login_id
4165: ,FND_GLOBAL.conc_request_id
4166: ,FND_GLOBAL.prog_appl_id
4167: ,FND_GLOBAL.conc_program_id
4168: ,SYSDATE
4169: ,l_Item_rec.VMI_MINIMUM_UNITS
4170: ,l_Item_rec.VMI_MINIMUM_DAYS
4163: ,FND_GLOBAL.user_id
4164: ,FND_GLOBAL.login_id
4165: ,FND_GLOBAL.conc_request_id
4166: ,FND_GLOBAL.prog_appl_id
4167: ,FND_GLOBAL.conc_program_id
4168: ,SYSDATE
4169: ,l_Item_rec.VMI_MINIMUM_UNITS
4170: ,l_Item_rec.VMI_MINIMUM_DAYS
4171: ,l_Item_rec.VMI_MAXIMUM_UNITS
4374: --5208102: Supporting template for UDA's at revisions
4375: ,DECODE(p_Revision_rec.TEMPLATE_ID ,g_Null_NUM ,p_Upd_Null_NUM ,g_MISS_NUM ,NULL ,p_Revision_rec.TEMPLATE_ID)
4376: ,DECODE(p_Revision_rec.TEMPLATE_NAME ,g_Null_CHAR ,p_Upd_Null_CHAR ,g_MISS_CHAR ,NULL ,p_Revision_rec.TEMPLATE_NAME)
4377: ,SYSDATE
4378: ,FND_GLOBAL.user_id
4379: ,SYSDATE
4380: ,FND_GLOBAL.user_id
4381: ,FND_GLOBAL.login_id
4382: ,FND_GLOBAL.conc_request_id
4376: ,DECODE(p_Revision_rec.TEMPLATE_NAME ,g_Null_CHAR ,p_Upd_Null_CHAR ,g_MISS_CHAR ,NULL ,p_Revision_rec.TEMPLATE_NAME)
4377: ,SYSDATE
4378: ,FND_GLOBAL.user_id
4379: ,SYSDATE
4380: ,FND_GLOBAL.user_id
4381: ,FND_GLOBAL.login_id
4382: ,FND_GLOBAL.conc_request_id
4383: ,FND_GLOBAL.prog_appl_id
4384: ,FND_GLOBAL.conc_program_id
4377: ,SYSDATE
4378: ,FND_GLOBAL.user_id
4379: ,SYSDATE
4380: ,FND_GLOBAL.user_id
4381: ,FND_GLOBAL.login_id
4382: ,FND_GLOBAL.conc_request_id
4383: ,FND_GLOBAL.prog_appl_id
4384: ,FND_GLOBAL.conc_program_id
4385: ,SYSDATE);
4378: ,FND_GLOBAL.user_id
4379: ,SYSDATE
4380: ,FND_GLOBAL.user_id
4381: ,FND_GLOBAL.login_id
4382: ,FND_GLOBAL.conc_request_id
4383: ,FND_GLOBAL.prog_appl_id
4384: ,FND_GLOBAL.conc_program_id
4385: ,SYSDATE);
4386: END IF;
4379: ,SYSDATE
4380: ,FND_GLOBAL.user_id
4381: ,FND_GLOBAL.login_id
4382: ,FND_GLOBAL.conc_request_id
4383: ,FND_GLOBAL.prog_appl_id
4384: ,FND_GLOBAL.conc_program_id
4385: ,SYSDATE);
4386: END IF;
4387:
4380: ,FND_GLOBAL.user_id
4381: ,FND_GLOBAL.login_id
4382: ,FND_GLOBAL.conc_request_id
4383: ,FND_GLOBAL.prog_appl_id
4384: ,FND_GLOBAL.conc_program_id
4385: ,SYSDATE);
4386: END IF;
4387:
4388: EXCEPTION