2733: OZF_RESALE_ADJUSTMENTS_PKG.Insert_Row(
2734: px_resale_adjustment_id => l_adjustment_id,
2735: px_object_version_number => l_obj_ver_num,
2736: p_last_update_date => sysdate,
2737: p_last_updated_by => NVL(FND_GLOBAL.user_id,-1),
2738: p_creation_date => sysdate,
2739: p_request_id => FND_GLOBAL.CONC_REQUEST_ID,
2740: p_created_by => NVL(FND_GLOBAL.user_id,-1),
2741: p_created_from => p_price_adj_rec.created_from,
2735: px_object_version_number => l_obj_ver_num,
2736: p_last_update_date => sysdate,
2737: p_last_updated_by => NVL(FND_GLOBAL.user_id,-1),
2738: p_creation_date => sysdate,
2739: p_request_id => FND_GLOBAL.CONC_REQUEST_ID,
2740: p_created_by => NVL(FND_GLOBAL.user_id,-1),
2741: p_created_from => p_price_adj_rec.created_from,
2742: p_last_update_login => NVL(FND_GLOBAL.conc_login_id,-1),
2743: p_program_application_id => FND_GLOBAL.PROG_APPL_ID,
2736: p_last_update_date => sysdate,
2737: p_last_updated_by => NVL(FND_GLOBAL.user_id,-1),
2738: p_creation_date => sysdate,
2739: p_request_id => FND_GLOBAL.CONC_REQUEST_ID,
2740: p_created_by => NVL(FND_GLOBAL.user_id,-1),
2741: p_created_from => p_price_adj_rec.created_from,
2742: p_last_update_login => NVL(FND_GLOBAL.conc_login_id,-1),
2743: p_program_application_id => FND_GLOBAL.PROG_APPL_ID,
2744: p_program_update_date => sysdate,
2738: p_creation_date => sysdate,
2739: p_request_id => FND_GLOBAL.CONC_REQUEST_ID,
2740: p_created_by => NVL(FND_GLOBAL.user_id,-1),
2741: p_created_from => p_price_adj_rec.created_from,
2742: p_last_update_login => NVL(FND_GLOBAL.conc_login_id,-1),
2743: p_program_application_id => FND_GLOBAL.PROG_APPL_ID,
2744: p_program_update_date => sysdate,
2745: p_program_id => FND_GLOBAL.CONC_PROGRAM_ID,
2746: p_resale_line_id => p_price_adj_rec.resale_line_id,
2739: p_request_id => FND_GLOBAL.CONC_REQUEST_ID,
2740: p_created_by => NVL(FND_GLOBAL.user_id,-1),
2741: p_created_from => p_price_adj_rec.created_from,
2742: p_last_update_login => NVL(FND_GLOBAL.conc_login_id,-1),
2743: p_program_application_id => FND_GLOBAL.PROG_APPL_ID,
2744: p_program_update_date => sysdate,
2745: p_program_id => FND_GLOBAL.CONC_PROGRAM_ID,
2746: p_resale_line_id => p_price_adj_rec.resale_line_id,
2747: p_resale_batch_id => p_price_adj_rec.resale_batch_id,
2741: p_created_from => p_price_adj_rec.created_from,
2742: p_last_update_login => NVL(FND_GLOBAL.conc_login_id,-1),
2743: p_program_application_id => FND_GLOBAL.PROG_APPL_ID,
2744: p_program_update_date => sysdate,
2745: p_program_id => FND_GLOBAL.CONC_PROGRAM_ID,
2746: p_resale_line_id => p_price_adj_rec.resale_line_id,
2747: p_resale_batch_id => p_price_adj_rec.resale_batch_id,
2748: p_orig_system_agreement_uom => p_price_adj_rec.orig_system_agreement_uom,
2749: p_orig_system_agreement_name => p_price_adj_rec.orig_system_agreement_name,
3509: OZF_RESALE_HEADERS_PKG.Insert_Row(
3510: px_resale_header_id => l_header_id,
3511: px_object_version_number => l_object_version_number,
3512: p_last_update_date => SYSdate,
3513: p_last_updated_by => NVL(FND_GLOBAL.user_id,-1),
3514: p_creation_date => SYSdate,
3515: p_request_id => FND_GLOBAL.CONC_REQUEST_ID,
3516: p_created_by => NVL(FND_GLOBAL.user_id,-1),
3517: p_last_update_login => NVL(FND_GLOBAL.conc_login_id,-1),
3511: px_object_version_number => l_object_version_number,
3512: p_last_update_date => SYSdate,
3513: p_last_updated_by => NVL(FND_GLOBAL.user_id,-1),
3514: p_creation_date => SYSdate,
3515: p_request_id => FND_GLOBAL.CONC_REQUEST_ID,
3516: p_created_by => NVL(FND_GLOBAL.user_id,-1),
3517: p_last_update_login => NVL(FND_GLOBAL.conc_login_id,-1),
3518: p_program_application_id => FND_GLOBAL.PROG_APPL_ID,
3519: p_program_update_date => SYSdate,
3512: p_last_update_date => SYSdate,
3513: p_last_updated_by => NVL(FND_GLOBAL.user_id,-1),
3514: p_creation_date => SYSdate,
3515: p_request_id => FND_GLOBAL.CONC_REQUEST_ID,
3516: p_created_by => NVL(FND_GLOBAL.user_id,-1),
3517: p_last_update_login => NVL(FND_GLOBAL.conc_login_id,-1),
3518: p_program_application_id => FND_GLOBAL.PROG_APPL_ID,
3519: p_program_update_date => SYSdate,
3520: p_program_id => FND_GLOBAL.CONC_PROGRAM_ID,
3513: p_last_updated_by => NVL(FND_GLOBAL.user_id,-1),
3514: p_creation_date => SYSdate,
3515: p_request_id => FND_GLOBAL.CONC_REQUEST_ID,
3516: p_created_by => NVL(FND_GLOBAL.user_id,-1),
3517: p_last_update_login => NVL(FND_GLOBAL.conc_login_id,-1),
3518: p_program_application_id => FND_GLOBAL.PROG_APPL_ID,
3519: p_program_update_date => SYSdate,
3520: p_program_id => FND_GLOBAL.CONC_PROGRAM_ID,
3521: p_created_from => p_line_int_rec.created_from,
3514: p_creation_date => SYSdate,
3515: p_request_id => FND_GLOBAL.CONC_REQUEST_ID,
3516: p_created_by => NVL(FND_GLOBAL.user_id,-1),
3517: p_last_update_login => NVL(FND_GLOBAL.conc_login_id,-1),
3518: p_program_application_id => FND_GLOBAL.PROG_APPL_ID,
3519: p_program_update_date => SYSdate,
3520: p_program_id => FND_GLOBAL.CONC_PROGRAM_ID,
3521: p_created_from => p_line_int_rec.created_from,
3522: p_date_shipped => p_line_int_rec.date_shipped,
3516: p_created_by => NVL(FND_GLOBAL.user_id,-1),
3517: p_last_update_login => NVL(FND_GLOBAL.conc_login_id,-1),
3518: p_program_application_id => FND_GLOBAL.PROG_APPL_ID,
3519: p_program_update_date => SYSdate,
3520: p_program_id => FND_GLOBAL.CONC_PROGRAM_ID,
3521: p_created_from => p_line_int_rec.created_from,
3522: p_date_shipped => p_line_int_rec.date_shipped,
3523: p_date_ordered => p_line_int_rec.date_ordered,
3524: p_order_type_id => p_line_int_rec.order_type_id,
3723: p_resale_header_id => p_header_id ,
3724: p_resale_transfer_type => p_line_int_rec.resale_transfer_type ,
3725: px_object_version_number => l_obj_ver_num,
3726: p_last_update_date => SYSdate,
3727: p_last_updated_by => NVL(FND_GLOBAL.user_id,-1),
3728: p_creation_date => SYSdate,
3729: p_request_id => FND_GLOBAL.CONC_REQUEST_ID,
3730: p_created_by => NVL(FND_GLOBAL.user_id,-1),
3731: p_last_update_login => NVL(FND_GLOBAL.conc_login_id,-1),
3725: px_object_version_number => l_obj_ver_num,
3726: p_last_update_date => SYSdate,
3727: p_last_updated_by => NVL(FND_GLOBAL.user_id,-1),
3728: p_creation_date => SYSdate,
3729: p_request_id => FND_GLOBAL.CONC_REQUEST_ID,
3730: p_created_by => NVL(FND_GLOBAL.user_id,-1),
3731: p_last_update_login => NVL(FND_GLOBAL.conc_login_id,-1),
3732: p_program_application_id => FND_GLOBAL.PROG_APPL_ID,
3733: p_program_update_date => SYSdate,
3726: p_last_update_date => SYSdate,
3727: p_last_updated_by => NVL(FND_GLOBAL.user_id,-1),
3728: p_creation_date => SYSdate,
3729: p_request_id => FND_GLOBAL.CONC_REQUEST_ID,
3730: p_created_by => NVL(FND_GLOBAL.user_id,-1),
3731: p_last_update_login => NVL(FND_GLOBAL.conc_login_id,-1),
3732: p_program_application_id => FND_GLOBAL.PROG_APPL_ID,
3733: p_program_update_date => SYSdate,
3734: p_program_id => FND_GLOBAL.CONC_PROGRAM_ID,
3727: p_last_updated_by => NVL(FND_GLOBAL.user_id,-1),
3728: p_creation_date => SYSdate,
3729: p_request_id => FND_GLOBAL.CONC_REQUEST_ID,
3730: p_created_by => NVL(FND_GLOBAL.user_id,-1),
3731: p_last_update_login => NVL(FND_GLOBAL.conc_login_id,-1),
3732: p_program_application_id => FND_GLOBAL.PROG_APPL_ID,
3733: p_program_update_date => SYSdate,
3734: p_program_id => FND_GLOBAL.CONC_PROGRAM_ID,
3735: p_created_from => p_line_int_rec.created_from,
3728: p_creation_date => SYSdate,
3729: p_request_id => FND_GLOBAL.CONC_REQUEST_ID,
3730: p_created_by => NVL(FND_GLOBAL.user_id,-1),
3731: p_last_update_login => NVL(FND_GLOBAL.conc_login_id,-1),
3732: p_program_application_id => FND_GLOBAL.PROG_APPL_ID,
3733: p_program_update_date => SYSdate,
3734: p_program_id => FND_GLOBAL.CONC_PROGRAM_ID,
3735: p_created_from => p_line_int_rec.created_from,
3736: p_status_code => G_BATCH_ADJ_PROCESSED ,
3730: p_created_by => NVL(FND_GLOBAL.user_id,-1),
3731: p_last_update_login => NVL(FND_GLOBAL.conc_login_id,-1),
3732: p_program_application_id => FND_GLOBAL.PROG_APPL_ID,
3733: p_program_update_date => SYSdate,
3734: p_program_id => FND_GLOBAL.CONC_PROGRAM_ID,
3735: p_created_from => p_line_int_rec.created_from,
3736: p_status_code => G_BATCH_ADJ_PROCESSED ,
3737: p_product_trans_movement_type => p_line_int_rec.product_transfer_movement_type ,
3738: p_product_transfer_date => p_line_int_rec.product_transfer_date,
4038: p_resale_batch_id => p_resale_batch_id,
4039: p_resale_line_id => p_line_id,
4040: px_object_version_number => l_obj_ver_num,
4041: p_last_update_date => SYSdate,
4042: p_last_updated_by => NVL(FND_GLOBAL.user_id,-1),
4043: p_creation_date => SYSdate,
4044: p_request_id => FND_GLOBAL.CONC_REQUEST_ID,
4045: p_created_by => NVL(FND_GLOBAL.user_id,-1),
4046: p_last_update_login => NVL(FND_GLOBAL.conc_login_id,-1),
4040: px_object_version_number => l_obj_ver_num,
4041: p_last_update_date => SYSdate,
4042: p_last_updated_by => NVL(FND_GLOBAL.user_id,-1),
4043: p_creation_date => SYSdate,
4044: p_request_id => FND_GLOBAL.CONC_REQUEST_ID,
4045: p_created_by => NVL(FND_GLOBAL.user_id,-1),
4046: p_last_update_login => NVL(FND_GLOBAL.conc_login_id,-1),
4047: p_program_application_id => FND_GLOBAL.PROG_APPL_ID,
4048: p_program_update_date => SYSdate,
4041: p_last_update_date => SYSdate,
4042: p_last_updated_by => NVL(FND_GLOBAL.user_id,-1),
4043: p_creation_date => SYSdate,
4044: p_request_id => FND_GLOBAL.CONC_REQUEST_ID,
4045: p_created_by => NVL(FND_GLOBAL.user_id,-1),
4046: p_last_update_login => NVL(FND_GLOBAL.conc_login_id,-1),
4047: p_program_application_id => FND_GLOBAL.PROG_APPL_ID,
4048: p_program_update_date => SYSdate,
4049: p_program_id => FND_GLOBAL.CONC_PROGRAM_ID,
4042: p_last_updated_by => NVL(FND_GLOBAL.user_id,-1),
4043: p_creation_date => SYSdate,
4044: p_request_id => FND_GLOBAL.CONC_REQUEST_ID,
4045: p_created_by => NVL(FND_GLOBAL.user_id,-1),
4046: p_last_update_login => NVL(FND_GLOBAL.conc_login_id,-1),
4047: p_program_application_id => FND_GLOBAL.PROG_APPL_ID,
4048: p_program_update_date => SYSdate,
4049: p_program_id => FND_GLOBAL.CONC_PROGRAM_ID,
4050: p_created_from => NULL,
4043: p_creation_date => SYSdate,
4044: p_request_id => FND_GLOBAL.CONC_REQUEST_ID,
4045: p_created_by => NVL(FND_GLOBAL.user_id,-1),
4046: p_last_update_login => NVL(FND_GLOBAL.conc_login_id,-1),
4047: p_program_application_id => FND_GLOBAL.PROG_APPL_ID,
4048: p_program_update_date => SYSdate,
4049: p_program_id => FND_GLOBAL.CONC_PROGRAM_ID,
4050: p_created_from => NULL,
4051: p_attribute_category => NULL,
4045: p_created_by => NVL(FND_GLOBAL.user_id,-1),
4046: p_last_update_login => NVL(FND_GLOBAL.conc_login_id,-1),
4047: p_program_application_id => FND_GLOBAL.PROG_APPL_ID,
4048: p_program_update_date => SYSdate,
4049: p_program_id => FND_GLOBAL.CONC_PROGRAM_ID,
4050: p_created_from => NULL,
4051: p_attribute_category => NULL,
4052: p_attribute1 => NULL,
4053: p_attribute2 => NULL,