2098: ,p_pricing_attribs_rec.attribute12
2099: ,p_pricing_attribs_rec.attribute13
2100: ,p_pricing_attribs_rec.attribute14
2101: ,p_pricing_attribs_rec.attribute15
2102: ,fnd_global.user_id
2103: ,sysdate
2104: ,fnd_global.user_id
2105: ,sysdate
2106: ,fnd_global.user_id
2100: ,p_pricing_attribs_rec.attribute14
2101: ,p_pricing_attribs_rec.attribute15
2102: ,fnd_global.user_id
2103: ,sysdate
2104: ,fnd_global.user_id
2105: ,sysdate
2106: ,fnd_global.user_id
2107: ,1
2108: ,p_pricing_attribs_rec.pricing_context
2102: ,fnd_global.user_id
2103: ,sysdate
2104: ,fnd_global.user_id
2105: ,sysdate
2106: ,fnd_global.user_id
2107: ,1
2108: ,p_pricing_attribs_rec.pricing_context
2109: ,p_pricing_attribs_rec.pricing_attribute1
2110: ,p_pricing_attribs_rec.pricing_attribute2
2478: p_NEW_ATTRIBUTE14 => p_pricing_attribs_rec.ATTRIBUTE14 ,
2479: p_OLD_ATTRIBUTE15 => NULL ,
2480: p_NEW_ATTRIBUTE15 => p_pricing_attribs_rec.ATTRIBUTE15 ,
2481: p_FULL_DUMP_FLAG => 'N',
2482: p_CREATED_BY => fnd_global.user_id,
2483: p_CREATION_DATE => sysdate,
2484: p_LAST_UPDATED_BY => fnd_global.user_id,
2485: p_LAST_UPDATE_DATE => sysdate,
2486: p_LAST_UPDATE_LOGIN => fnd_global.user_id,
2480: p_NEW_ATTRIBUTE15 => p_pricing_attribs_rec.ATTRIBUTE15 ,
2481: p_FULL_DUMP_FLAG => 'N',
2482: p_CREATED_BY => fnd_global.user_id,
2483: p_CREATION_DATE => sysdate,
2484: p_LAST_UPDATED_BY => fnd_global.user_id,
2485: p_LAST_UPDATE_DATE => sysdate,
2486: p_LAST_UPDATE_LOGIN => fnd_global.user_id,
2487: p_OBJECT_VERSION_NUMBER => 1);
2488:
2482: p_CREATED_BY => fnd_global.user_id,
2483: p_CREATION_DATE => sysdate,
2484: p_LAST_UPDATED_BY => fnd_global.user_id,
2485: p_LAST_UPDATE_DATE => sysdate,
2486: p_LAST_UPDATE_LOGIN => fnd_global.user_id,
2487: p_OBJECT_VERSION_NUMBER => 1);
2488:
2489:
2490: -- END IF;
2737: ,p_pricing_attribs_rec.attribute12
2738: ,p_pricing_attribs_rec.attribute13
2739: ,p_pricing_attribs_rec.attribute14
2740: ,p_pricing_attribs_rec.attribute15
2741: ,fnd_api.g_miss_num -- fnd_global.user_id
2742: ,fnd_api.g_miss_date
2743: ,fnd_global.user_id
2744: ,sysdate
2745: ,fnd_global.user_id
2739: ,p_pricing_attribs_rec.attribute14
2740: ,p_pricing_attribs_rec.attribute15
2741: ,fnd_api.g_miss_num -- fnd_global.user_id
2742: ,fnd_api.g_miss_date
2743: ,fnd_global.user_id
2744: ,sysdate
2745: ,fnd_global.user_id
2746: ,l_pricing_attribs_rec.object_version_number
2747: ,p_pricing_attribs_rec.pricing_context
2741: ,fnd_api.g_miss_num -- fnd_global.user_id
2742: ,fnd_api.g_miss_date
2743: ,fnd_global.user_id
2744: ,sysdate
2745: ,fnd_global.user_id
2746: ,l_pricing_attribs_rec.object_version_number
2747: ,p_pricing_attribs_rec.pricing_context
2748: ,p_pricing_attribs_rec.pricing_attribute1
2749: ,p_pricing_attribs_rec.pricing_attribute2
3153: p_NEW_ATTRIBUTE14 => l_temp_pricing_attribs_rec.ATTRIBUTE14 ,
3154: p_OLD_ATTRIBUTE15 => fnd_api.g_miss_char ,
3155: p_NEW_ATTRIBUTE15 => l_temp_pricing_attribs_rec.ATTRIBUTE15 ,
3156: p_FULL_DUMP_FLAG => fnd_api.g_miss_char ,
3157: p_CREATED_BY => fnd_api.g_miss_num, -- fnd_global.user_id,
3158: p_CREATION_DATE => fnd_api.g_miss_date ,
3159: p_LAST_UPDATED_BY => fnd_global.user_id ,
3160: p_LAST_UPDATE_DATE => sysdate ,
3161: p_LAST_UPDATE_LOGIN => fnd_global.user_id ,
3155: p_NEW_ATTRIBUTE15 => l_temp_pricing_attribs_rec.ATTRIBUTE15 ,
3156: p_FULL_DUMP_FLAG => fnd_api.g_miss_char ,
3157: p_CREATED_BY => fnd_api.g_miss_num, -- fnd_global.user_id,
3158: p_CREATION_DATE => fnd_api.g_miss_date ,
3159: p_LAST_UPDATED_BY => fnd_global.user_id ,
3160: p_LAST_UPDATE_DATE => sysdate ,
3161: p_LAST_UPDATE_LOGIN => fnd_global.user_id ,
3162: p_OBJECT_VERSION_NUMBER => fnd_api.g_miss_num );
3163:
3157: p_CREATED_BY => fnd_api.g_miss_num, -- fnd_global.user_id,
3158: p_CREATION_DATE => fnd_api.g_miss_date ,
3159: p_LAST_UPDATED_BY => fnd_global.user_id ,
3160: p_LAST_UPDATE_DATE => sysdate ,
3161: p_LAST_UPDATE_LOGIN => fnd_global.user_id ,
3162: p_OBJECT_VERSION_NUMBER => fnd_api.g_miss_num );
3163:
3164: ELSE
3165: --
5191: p_new_attribute14 => l_pricing_hist_csr.new_attribute14 ,
5192: p_old_attribute15 => l_pricing_hist_csr.old_attribute15 ,
5193: p_new_attribute15 => l_pricing_hist_csr.new_attribute15 ,
5194: p_full_dump_flag => fnd_api.g_miss_char ,
5195: p_created_by => fnd_api.g_miss_num, -- fnd_global.user_id,
5196: p_creation_date => fnd_api.g_miss_date ,
5197: p_last_updated_by => fnd_global.user_id ,
5198: p_last_update_date => sysdate ,
5199: p_last_update_login => fnd_global.user_id ,
5193: p_new_attribute15 => l_pricing_hist_csr.new_attribute15 ,
5194: p_full_dump_flag => fnd_api.g_miss_char ,
5195: p_created_by => fnd_api.g_miss_num, -- fnd_global.user_id,
5196: p_creation_date => fnd_api.g_miss_date ,
5197: p_last_updated_by => fnd_global.user_id ,
5198: p_last_update_date => sysdate ,
5199: p_last_update_login => fnd_global.user_id ,
5200: p_object_version_number => fnd_api.g_miss_num );
5201:
5195: p_created_by => fnd_api.g_miss_num, -- fnd_global.user_id,
5196: p_creation_date => fnd_api.g_miss_date ,
5197: p_last_updated_by => fnd_global.user_id ,
5198: p_last_update_date => sysdate ,
5199: p_last_update_login => fnd_global.user_id ,
5200: p_object_version_number => fnd_api.g_miss_num );
5201:
5202: END IF;
5203: EXCEPTION
5929: p_NEW_ATTRIBUTE14 => l_temp_pricing_attribs_rec.ATTRIBUTE14 ,
5930: p_OLD_ATTRIBUTE15 => l_pricing_attribs_rec.ATTRIBUTE15 ,
5931: p_NEW_ATTRIBUTE15 => l_temp_pricing_attribs_rec.ATTRIBUTE15 ,
5932: p_FULL_DUMP_FLAG => l_dump_frequency_flag,
5933: p_CREATED_BY => fnd_global.user_id,
5934: p_CREATION_DATE => sysdate,
5935: p_LAST_UPDATED_BY => fnd_global.user_id,
5936: p_LAST_UPDATE_DATE => sysdate,
5937: p_LAST_UPDATE_LOGIN => fnd_global.user_id,
5931: p_NEW_ATTRIBUTE15 => l_temp_pricing_attribs_rec.ATTRIBUTE15 ,
5932: p_FULL_DUMP_FLAG => l_dump_frequency_flag,
5933: p_CREATED_BY => fnd_global.user_id,
5934: p_CREATION_DATE => sysdate,
5935: p_LAST_UPDATED_BY => fnd_global.user_id,
5936: p_LAST_UPDATE_DATE => sysdate,
5937: p_LAST_UPDATE_LOGIN => fnd_global.user_id,
5938: p_OBJECT_VERSION_NUMBER => 1);
5939: ELSE
5933: p_CREATED_BY => fnd_global.user_id,
5934: p_CREATION_DATE => sysdate,
5935: p_LAST_UPDATED_BY => fnd_global.user_id,
5936: p_LAST_UPDATE_DATE => sysdate,
5937: p_LAST_UPDATE_LOGIN => fnd_global.user_id,
5938: p_OBJECT_VERSION_NUMBER => 1);
5939: ELSE
5940:
5941: l_dump_frequency_flag := 'N';
7269: p_NEW_ATTRIBUTE14 => l_pricing_history_rec.new_ATTRIBUTE14,
7270: p_OLD_ATTRIBUTE15 => l_pricing_history_rec.old_ATTRIBUTE15,
7271: p_NEW_ATTRIBUTE15 => l_pricing_history_rec.new_ATTRIBUTE15,
7272: p_FULL_DUMP_FLAG => l_dump_frequency_flag,
7273: p_CREATED_BY => fnd_global.user_id,
7274: p_CREATION_DATE => sysdate,
7275: p_LAST_UPDATED_BY => fnd_global.user_id,
7276: p_LAST_UPDATE_DATE => sysdate,
7277: p_LAST_UPDATE_LOGIN => fnd_global.user_id,
7271: p_NEW_ATTRIBUTE15 => l_pricing_history_rec.new_ATTRIBUTE15,
7272: p_FULL_DUMP_FLAG => l_dump_frequency_flag,
7273: p_CREATED_BY => fnd_global.user_id,
7274: p_CREATION_DATE => sysdate,
7275: p_LAST_UPDATED_BY => fnd_global.user_id,
7276: p_LAST_UPDATE_DATE => sysdate,
7277: p_LAST_UPDATE_LOGIN => fnd_global.user_id,
7278: p_OBJECT_VERSION_NUMBER => 1);
7279:
7273: p_CREATED_BY => fnd_global.user_id,
7274: p_CREATION_DATE => sysdate,
7275: p_LAST_UPDATED_BY => fnd_global.user_id,
7276: p_LAST_UPDATE_DATE => sysdate,
7277: p_LAST_UPDATE_LOGIN => fnd_global.user_id,
7278: p_OBJECT_VERSION_NUMBER => 1);
7279:
7280: END IF;
7281: END;