[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
| 23-Mar-2011 BKUNJAN Bug fix 11873429 - CODE CONVERSION UPLOAD VIA WEB ADI GIVES `CANNOT UPDATE AN END DATED COD
| 20-APR-2011 MUTHSUBR Fix for Bug#11906081
| 27-MAY-2011 MUTHSUBR Bug#12559121 - CODE CONVERSION DOES NOT ALLOW ITEM NUMBER MAPPING ACROSS OUS
| 14-JUL-2011 NINARASI Bug 12717648 - FP of 12718707 - CODE CONVERSION UPLOAD VIA WEBADI FAILS AT OU IF ALREADY MAPPED AT CUSTOMER
+============================================================================*/
G_PKG_NAME CONSTANT VARCHAR2(30) := 'OZF_WEBADI_INTERFACE_PVT';
SELECT code_conversion_id,
object_version_number,
last_update_date,
last_updated_by,
creation_date,
created_by,
last_update_login,
org_id,
party_id,
cust_account_id,
code_conversion_type,
external_code,
internal_code,
description,
start_date_active,
end_date_active,
attribute_category,
attribute1,
attribute2,
attribute3,
attribute4,
attribute5,
attribute6,
attribute7,
attribute8,
attribute9,
attribute10,
attribute11,
attribute12,
attribute13,
attribute14,
attribute15,
security_group_id,
org_id
FROM ozf_code_conversions_all
WHERE external_code = cv_external_code
AND org_id = NVL(cv_org_id,0) -- Bug#12559121
AND code_conversion_type = NVL(cv_conversion_type,code_conversion_type) -- Bug#11906081
AND party_id = cv_party_id
AND cust_account_id = cv_account_id
AND TRUNC(cv_start_date_active) BETWEEN start_date_active and NVL(end_date_active,TRUNC(SYSDATE)) -- Bugfix 11822771
AND party_id IS NOT NULL
AND cust_account_id IS NOT NULL;
SELECT code_conversion_id,
object_version_number,
last_update_date,
last_updated_by,
creation_date,
created_by,
last_update_login,
org_id,
party_id,
cust_account_id,
code_conversion_type,
external_code,
internal_code,
description,
start_date_active,
end_date_active,
attribute_category,
attribute1,
attribute2,
attribute3,
attribute4,
attribute5,
attribute6,
attribute7,
attribute8,
attribute9,
attribute10,
attribute11,
attribute12,
attribute13,
attribute14,
attribute15,
security_group_id,
org_id
FROM ozf_code_conversions_all
WHERE external_code = cv_external_code
AND org_id = NVL(cv_org_id,0) -- Bug#12559121
AND code_conversion_type = NVL(cv_conversion_type,code_conversion_type) -- Bug#11906081
AND party_id = cv_party_id
AND TRUNC(cv_start_date_active) BETWEEN start_date_active and NVL(end_date_active,TRUNC(SYSDATE)) -- Bugfix 11822771
AND party_id IS NOT NULL
AND cust_account_id IS NULL;
SELECT code_conversion_id,
object_version_number,
last_update_date,
last_updated_by,
creation_date,
created_by,
last_update_login,
org_id,
party_id,
cust_account_id,
code_conversion_type,
external_code,
internal_code,
description,
start_date_active,
end_date_active,
attribute_category,
attribute1,
attribute2,
attribute3,
attribute4,
attribute5,
attribute6,
attribute7,
attribute8,
attribute9,
attribute10,
attribute11,
attribute12,
attribute13,
attribute14,
attribute15,
security_group_id,
org_id
FROM ozf_code_conversions_all
WHERE external_code = cv_external_code
AND org_id = NVL(cv_org_id,0) -- Bug#12559121
AND code_conversion_type = NVL(cv_conversion_type,code_conversion_type) -- Bug#11906081
AND TRUNC(cv_start_date_active) BETWEEN start_date_active and NVL(end_date_active,TRUNC(SYSDATE)) -- Bugfix 11822771
AND party_id IS NULL and cust_account_id IS NULL;
SELECT INVENTORY_ITEM_ID ID FROM MTL_SYSTEM_ITEMS_VL
WHERE ORGANIZATION_ID = FND_PROFILE.VALUE('AMS_ITEM_ORGANIZATION_ID')
AND CONCATENATED_SEGMENTS = p_item_name;
,l_code_conversion_rec.last_update_date
,l_code_conversion_rec.last_updated_by
,l_code_conversion_rec.creation_date
,l_code_conversion_rec.created_by
,l_code_conversion_rec.last_update_login
,l_code_conversion_rec.org_id
,l_code_conversion_rec.party_id
,l_code_conversion_rec.cust_account_id
,l_code_conversion_rec.code_conversion_type
,l_code_conversion_rec.external_code
,l_code_conversion_rec.internal_code
,l_code_conversion_rec.description
,l_code_conversion_rec.start_date_active
,l_code_conversion_rec.end_date_active
,l_code_conversion_rec.attribute_category
,l_code_conversion_rec.attribute1
,l_code_conversion_rec.attribute2
,l_code_conversion_rec.attribute3
,l_code_conversion_rec.attribute4
,l_code_conversion_rec.attribute5
,l_code_conversion_rec.attribute6
,l_code_conversion_rec.attribute7
,l_code_conversion_rec.attribute8
,l_code_conversion_rec.attribute9
,l_code_conversion_rec.attribute10
,l_code_conversion_rec.attribute11
,l_code_conversion_rec.attribute12
,l_code_conversion_rec.attribute13
,l_code_conversion_rec.attribute14
,l_code_conversion_rec.attribute15
,l_code_conversion_rec.security_group_id
,l_code_conversion_rec.org_id;
,l_code_conversion_rec.last_update_date
,l_code_conversion_rec.last_updated_by
,l_code_conversion_rec.creation_date
,l_code_conversion_rec.created_by
,l_code_conversion_rec.last_update_login
,l_code_conversion_rec.org_id
,l_code_conversion_rec.party_id
,l_code_conversion_rec.cust_account_id
,l_code_conversion_rec.code_conversion_type
,l_code_conversion_rec.external_code
,l_code_conversion_rec.internal_code
,l_code_conversion_rec.description
,l_code_conversion_rec.start_date_active
,l_code_conversion_rec.end_date_active
,l_code_conversion_rec.attribute_category
,l_code_conversion_rec.attribute1
,l_code_conversion_rec.attribute2
,l_code_conversion_rec.attribute3
,l_code_conversion_rec.attribute4
,l_code_conversion_rec.attribute5
,l_code_conversion_rec.attribute6
,l_code_conversion_rec.attribute7
,l_code_conversion_rec.attribute8
,l_code_conversion_rec.attribute9
,l_code_conversion_rec.attribute10
,l_code_conversion_rec.attribute11
,l_code_conversion_rec.attribute12
,l_code_conversion_rec.attribute13
,l_code_conversion_rec.attribute14
,l_code_conversion_rec.attribute15
,l_code_conversion_rec.security_group_id
,l_code_conversion_rec.org_id;
,l_code_conversion_rec.last_update_date
,l_code_conversion_rec.last_updated_by
,l_code_conversion_rec.creation_date
,l_code_conversion_rec.created_by
,l_code_conversion_rec.last_update_login
,l_code_conversion_rec.org_id
,l_code_conversion_rec.party_id
,l_code_conversion_rec.cust_account_id
,l_code_conversion_rec.code_conversion_type
,l_code_conversion_rec.external_code
,l_code_conversion_rec.internal_code
,l_code_conversion_rec.description
,l_code_conversion_rec.start_date_active
,l_code_conversion_rec.end_date_active
,l_code_conversion_rec.attribute_category
,l_code_conversion_rec.attribute1
,l_code_conversion_rec.attribute2
,l_code_conversion_rec.attribute3
,l_code_conversion_rec.attribute4
,l_code_conversion_rec.attribute5
,l_code_conversion_rec.attribute6
,l_code_conversion_rec.attribute7
,l_code_conversion_rec.attribute8
,l_code_conversion_rec.attribute9
,l_code_conversion_rec.attribute10
,l_code_conversion_rec.attribute11
,l_code_conversion_rec.attribute12
,l_code_conversion_rec.attribute13
,l_code_conversion_rec.attribute14
,l_code_conversion_rec.attribute15
,l_code_conversion_rec.security_group_id
,l_code_conversion_rec.org_id;
l_message := 'Cannot update internal code';
l_message := 'End date Active cannot be updated';
l_message := 'Cannot update an end dated code conversion map';
l_message := 'External Code Cannot be Updated';
OZF_CODE_CONVERSION_PVT.update_code_conversion
(
p_api_version_number => 1.0 ,
p_init_msg_list => FND_API.G_FALSE,
p_commit => FND_API.G_FALSE,
p_validation_level => FND_API.G_VALID_LEVEL_FULL,
x_return_status => x_return_Status,
x_msg_count => x_msg_Count,
x_msg_data => x_msg_Data,
p_code_conversion_tbl => l_code_conversion_tbl,
x_object_version_number => l_object_version_no_tbl
);
fnd_message.set_name ('OZF', 'OZF_WADI_UPDATE_ERROR');
l_code := 'OZF_WADI_UPDATE_ERROR';
SELECT count(hcsu.location)
FROM hz_cust_accounts hca,
hz_parties hp,
hz_cust_site_uses hcsu,
hz_cust_acct_sites hcas,
hz_party_sites hps
WHERE hcsu.cust_acct_site_id = hcas.cust_acct_site_id
AND hcas.party_site_id = hps.party_site_id
AND hcsu.status = 'A'
AND hps.status = 'A'
AND hp.status = 'A'
AND hcas.cust_account_id = hca.cust_account_id
AND hp.party_id = hca.party_id
AND hca.party_id = cv_party_id
AND hcsu.location = cv_location
AND hcsu.site_use_code = cv_site_use_code;
SELECT COUNT(batch_number)
FROM ozf_resale_batches_all
WHERE batch_number = pc_batch_number;
SELECT COUNT(b.resale_batch_id),a.status_code
FROM ozf_resale_batches_all a, ozf_resale_lines_int_all b
WHERE a.resale_batch_id = b.resale_batch_id
AND a.batch_number = pc_batch_number
GROUP BY a.resale_batch_id, a.status_code;
CURSOR c_get_update_record(pc_batch_number VARCHAR2, pc_resale_line_int_id NUMBER)
IS
SELECT a.resale_batch_id, a.object_version_number,
b.object_version_number
FROM ozf_resale_batches_all a, ozf_resale_lines_int_all b
WHERE a.resale_batch_id = b.resale_batch_id
AND a.batch_number = pc_batch_number
AND b.resale_line_int_id = pc_resale_line_int_id;
SELECT value
FROM v$parameter
WHERE name = 'utl_file_dir';
SELECT party_site_id
FROM hz_party_sites
WHERE party_site_number = cv_site_number;
l_batch_insert_flag VARCHAR2(1);
l_batch_update_flag VARCHAR2(1);
SELECT organization_id
FROM hr_operating_units
WHERE name = cv_org_name;
SELECT decode(instr(value,',',1,1), 0, value, substr(value,1,instr(value,',',1,1)-1))
INTO l_file_dir
FROM v$parameter
WHERE name = 'utl_file_dir';
l_resale_batch_rec.last_update_date := SYSDATE;
l_resale_batch_rec.last_updated_by := FND_GLOBAL.User_Id;
l_resale_batch_rec.last_update_login := FND_GLOBAL.User_Id;
l_int_line_tbl(1).last_update_date := SYSDATE;
l_int_line_tbl(1).last_updated_by := FND_GLOBAL.User_Id;
l_int_line_tbl(1).last_update_login := FND_GLOBAL.User_Id;
fnd_message.set_name ('OZF', 'OZF_WADI_CANNOT_UPDATE');
l_code := 'OZF_WADI_CANNOT_UPDATE';
l_error_message := 'Cannot update '||l_batch_status_n||' batch';
SELECT ozf_resale_batches_all_s.nextval
INTO l_resale_batch_rec.resale_batch_id
FROM DUAL;
SELECT TO_NUMBER(NVL(SUBSTRB(USERENV('CLIENT_INFO'),1,10),-99))
INTO l_resale_batch_rec.org_id FROM DUAL;
OZF_RESALE_BATCHES_PKG.INSERT_ROW
(
px_resale_batch_id => l_resale_batch_rec.resale_batch_id
,px_object_version_number => l_batch_obj
,p_last_update_date => SYSDATE
,p_last_updated_by => FND_GLOBAL.User_Id
,p_creation_date => SYSDATE
,p_request_id => NULL
,p_created_by => FND_GLOBAL.User_Id
,p_created_from => NULL
,p_last_update_login => FND_GLOBAL.User_Id
,p_program_application_id => NULL
,p_program_update_date => NULL
,p_program_id => NULL
,p_batch_number => l_resale_batch_rec.batch_number
,p_batch_type => l_resale_batch_rec.batch_type
,p_batch_count => l_resale_batch_rec.batch_count
,p_year => l_resale_batch_rec.year
,p_month => l_resale_batch_rec.month
,p_report_date => l_resale_batch_rec.report_date
,p_report_start_date => l_resale_batch_rec.report_start_date
,p_report_end_date => l_resale_batch_rec.report_end_date
,p_status_code => 'NEW'
,p_data_source_code => l_resale_batch_rec.data_source_code
,p_reference_type => l_resale_batch_rec.reference_type
,p_reference_number => l_resale_batch_rec.reference_number
,p_comments => l_resale_batch_rec.comments
,p_partner_claim_number => l_resale_batch_rec.partner_claim_number
,p_transaction_purpose_code => l_resale_batch_rec.transaction_purpose_code
,p_transaction_type_code => l_resale_batch_rec.transaction_type_code
,p_partner_type => l_resale_batch_rec.partner_type
,p_partner_id => NULL
,p_partner_party_id => l_resale_batch_rec.partner_party_id
,p_partner_cust_account_id => l_resale_batch_rec.partner_cust_account_id
,p_partner_site_id => l_resale_batch_rec.partner_site_id
,p_partner_contact_party_id => NULL
,p_partner_contact_name => l_resale_batch_rec.partner_contact_name
,p_partner_email => l_resale_batch_rec.partner_email
,p_partner_phone => l_resale_batch_rec.partner_phone
,p_partner_fax => l_resale_batch_rec.partner_fax
,p_header_tolerance_operand => NULL
,p_header_tolerance_calc_code => NULL
,p_line_tolerance_operand => NULL
,p_line_tolerance_calc_code => NULL
,p_currency_code => l_resale_batch_rec.currency_code
,p_claimed_amount => l_resale_batch_rec.claimed_amount
,p_allowed_amount => l_amount
,p_paid_amount => l_amount
,p_disputed_amount => l_amount
,p_accepted_amount => l_amount
,p_lines_invalid => l_amount
,p_lines_w_tolerance => l_amount
,p_lines_disputed => l_amount
,p_batch_set_id_code => 'WEBADI'
,p_credit_code => l_resale_batch_rec.credit_code
,p_credit_advice_date => l_resale_batch_rec.credit_advice_date
,p_purge_flag => NULL
,p_attribute_category => p_attribute_category
,p_attribute1 => p_attribute1
,p_attribute2 => p_attribute2
,p_attribute3 => p_attribute3
,p_attribute4 => p_attribute4
,p_attribute5 => p_attribute5
,p_attribute6 => p_attribute6
,p_attribute7 => p_attribute7
,p_attribute8 => p_attribute8
,p_attribute9 => p_attribute9
,p_attribute10 => p_attribute10
,p_attribute11 => p_attribute11
,p_attribute12 => p_attribute12
,p_attribute13 => p_attribute13
,p_attribute14 => p_attribute14
,p_attribute15 => p_attribute15
,px_org_id => l_org_id -- R12 MOAC Enhancement --l_resale_batch_rec.org_id
,p_direct_order_flag => l_resale_batch_rec.direct_order_flag -- For Bug#9447673 SSD IDSM
);
SELECT ozf_resale_lines_int_all_s.nextval
INTO l_int_line_tbl(1).resale_line_int_id
FROM DUAL;
SELECT resale_batch_id
INTO l_int_line_tbl(1).resale_batch_id
FROM ozf_resale_batches
WHERE batch_number = p_batch_number;
insert_resale_int_line (
p_api_version_number => 1.0,
p_init_msg_list => FND_API.G_FALSE,
p_Commit => FND_API.G_FALSE,
p_validation_level => FND_API.G_VALID_LEVEL_FULL,
p_int_line_tbl => l_int_line_tbl,
x_return_status => x_return_status,
x_msg_count => l_msg_count,
x_msg_data => l_msg_data );
OPEN c_get_update_record (P_BATCH_NUMBER, P_RESALE_LINE_INT_ID);
FETCH c_get_update_record
INTO l_resale_batch_rec.resale_batch_id,
l_resale_batch_rec.object_version_number,
l_object_version_no_tbl(1);
EXIT WHEN c_get_update_record%NOTFOUND;
CLOSE c_get_update_record;
Update_Resale_Batch
(
p_api_version_number => 1.0,
p_init_msg_list => FND_API.G_FALSE,
P_Commit => FND_API.G_FALSE,
p_validation_level => FND_API.G_VALID_LEVEL_FULL,
p_int_batch_rec => l_resale_batch_rec,
x_return_status => x_return_status,
x_msg_count => l_msg_count,
x_msg_data => l_msg_data
);
l_text := l_text||'Error in Update Batch '||SQLERRM||' \n ';
fnd_message.set_name ('OZF', 'OZF_WADI_UPDATE_BATCH_ERROR');
l_code := 'OZF_WADI_UPDATE_BATCH_ERROR';
Update_Resale_Int_Line
(
p_api_version_number => 1.0,
p_init_msg_list => FND_API.G_FALSE,
P_Commit => FND_API.G_FALSE,
p_validation_level => FND_API.G_VALID_LEVEL_FULL,
p_int_line_tbl => l_int_line_tbl,
x_return_status => x_return_status,
x_msg_count => l_msg_count,
x_msg_data => l_msg_data
);
l_text := l_text||'Error in Update Line '||SQLERRM||' \n ';
fnd_message.set_name ('OZF', 'OZF_WADI_UPDATE_LINE_ERROR');
l_code := 'OZF_WADI_UPDATE_LINE_ERROR';
l_text := l_text||'line record updated';
OZF_UTILITY_PVT.debug_message('Interface Lines Table is updated successfully ' ||x_return_status);
PROCEDURE Update_Resale_Batch (
p_api_version_number IN NUMBER,
p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
p_Commit IN VARCHAR2 := FND_API.G_FALSE,
p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
p_int_batch_rec IN ozf_resale_batches_all%rowtype,
x_return_status OUT NOCOPY VARCHAR2,
x_msg_count OUT NOCOPY NUMBER,
x_msg_data OUT NOCOPY VARCHAR2
)
IS
l_api_name CONSTANT VARCHAR2(30) := 'Update_Resale_Batch';
SELECT last_update_date,
last_updated_by,
last_update_login,
object_version_number,
NVL(p_int_batch_rec.batch_type,batch_type),
NVL(p_int_batch_rec.batch_count,batch_count),
NVL(p_int_batch_rec.year,year),
NVL(p_int_batch_rec.month,month),
NVL(p_int_batch_rec.report_date,report_date),
NVL(p_int_batch_rec.report_start_date,report_start_date),
NVL(p_int_batch_rec.report_end_date,report_end_date),
NVL(p_int_batch_rec.data_source_code,data_source_code),
NVL(p_int_batch_rec.reference_type,reference_type),
NVL(p_int_batch_rec.reference_number,reference_number),
NVL(p_int_batch_rec.comments,comments),
NVL(p_int_batch_rec.partner_claim_number,partner_claim_number),
NVL(p_int_batch_rec.transaction_purpose_code,transaction_purpose_code),
NVL(p_int_batch_rec.transaction_type_code,transaction_type_code),
NVL(p_int_batch_rec.partner_type,partner_type),
NVL(p_int_batch_rec.partner_party_id,partner_party_id),
DECODE(p_int_batch_rec.partner_cust_account_id,
NULL,partner_cust_account_id,
DECODE(p_int_batch_rec.partner_cust_account_id,partner_cust_account_id,partner_cust_account_id,p_int_batch_rec.partner_cust_account_id )),
DECODE(p_int_batch_rec.partner_site_id,
NULL,partner_site_id,
DECODE(p_int_batch_rec.partner_site_id,partner_site_id,partner_site_id,p_int_batch_rec.partner_site_id )),
DECODE(p_int_batch_rec.partner_contact_name,
NULL,partner_contact_party_id,
DECODE(p_int_batch_rec.partner_contact_name,partner_contact_name,partner_contact_party_id,NULL )),
NVL(p_int_batch_rec.partner_contact_name,partner_contact_name),
NVL(p_int_batch_rec.partner_email,partner_email ),
NVL(p_int_batch_rec.partner_phone,partner_phone),
NVL(p_int_batch_rec.partner_fax,partner_fax),
NVL(p_int_batch_rec.currency_code,currency_code),
NVL(p_int_batch_rec.claimed_amount,claimed_amount),
NVL(p_int_batch_rec.credit_code,credit_code),
NVL(p_int_batch_rec.attribute_category,attribute_category),
NVL(p_int_batch_rec.attribute1,attribute1),
NVL(p_int_batch_rec.attribute2,attribute2),
NVL(p_int_batch_rec.attribute3,attribute3),
NVL(p_int_batch_rec.attribute4,attribute4),
NVL(p_int_batch_rec.attribute5,attribute5),
NVL(p_int_batch_rec.attribute6,attribute6),
NVL(p_int_batch_rec.attribute7,attribute7),
NVL(p_int_batch_rec.attribute8,attribute8),
NVL(p_int_batch_rec.attribute9,attribute9),
NVL(p_int_batch_rec.attribute10,attribute10),
NVL(p_int_batch_rec.attribute11,attribute11),
NVL(p_int_batch_rec.attribute12,attribute12),
NVL(p_int_batch_rec.attribute13,attribute13),
NVL(p_int_batch_rec.attribute14,attribute14),
NVL(p_int_batch_rec.attribute15,attribute15),
NVL(p_int_batch_rec.batch_set_id_code,batch_set_id_code ),
NVL(p_int_batch_rec.credit_advice_date,credit_advice_date),
NVL(p_int_batch_rec.org_id,org_id),
NVL(p_int_batch_rec.header_tolerance_operand,header_tolerance_operand),
NVL(p_int_batch_rec.header_tolerance_calc_code,header_tolerance_calc_code),
NVL(p_int_batch_rec.line_tolerance_operand,line_tolerance_operand),
NVL(p_int_batch_rec.line_tolerance_calc_code,line_tolerance_calc_code),
NVL(p_int_batch_rec.allowed_amount,allowed_amount),
NVL(p_int_batch_rec.accepted_amount,accepted_amount),
NVL(p_int_batch_rec.paid_amount,paid_amount),
NVL(p_int_batch_rec.disputed_amount,disputed_amount),
NVL(p_int_batch_rec.lines_invalid,lines_invalid),
NVL(p_int_batch_rec.lines_w_tolerance,lines_w_tolerance),
NVL(p_int_batch_rec.lines_disputed,lines_disputed),
NVL(p_int_batch_rec.purge_flag,purge_flag),
NVL(p_int_batch_rec.direct_order_flag,direct_order_flag) -- For Bug#9447673 SSD IDSM
FROM ozf_resale_batches
WHERE batch_number = pc_batch_number;
INTO l_resale_batch_rec.last_update_date,
l_resale_batch_rec.last_updated_by,
l_resale_batch_rec.last_update_login,
l_resale_batch_rec.object_version_number,
l_resale_batch_rec.batch_type,
l_resale_batch_rec.batch_count,
l_resale_batch_rec.year,
l_resale_batch_rec.month,
l_resale_batch_rec.report_date,
l_resale_batch_rec.report_start_date,
l_resale_batch_rec.report_end_date,
l_resale_batch_rec.data_source_code,
l_resale_batch_rec.reference_type,
l_resale_batch_rec.reference_number,
l_resale_batch_rec.comments,
l_resale_batch_rec.partner_claim_number,
l_resale_batch_rec.transaction_purpose_code,
l_resale_batch_rec.transaction_type_code,
l_resale_batch_rec.partner_type,
l_resale_batch_rec.partner_party_id,
l_resale_batch_rec.partner_cust_account_id,
l_resale_batch_rec.partner_site_id,
l_resale_batch_rec.partner_contact_party_id,
l_resale_batch_rec.partner_contact_name,
l_resale_batch_rec.partner_email,
l_resale_batch_rec.partner_phone,
l_resale_batch_rec.partner_fax,
l_resale_batch_rec.currency_code,
l_resale_batch_rec.claimed_amount,
l_resale_batch_rec.credit_code,
l_resale_batch_rec.attribute_category,
l_resale_batch_rec.attribute1,
l_resale_batch_rec.attribute2,
l_resale_batch_rec.attribute3,
l_resale_batch_rec.attribute4,
l_resale_batch_rec.attribute5,
l_resale_batch_rec.attribute6,
l_resale_batch_rec.attribute7,
l_resale_batch_rec.attribute8,
l_resale_batch_rec.attribute9,
l_resale_batch_rec.attribute10,
l_resale_batch_rec.attribute11,
l_resale_batch_rec.attribute12,
l_resale_batch_rec.attribute13,
l_resale_batch_rec.attribute14,
l_resale_batch_rec.attribute15,
l_resale_batch_rec.batch_set_id_code,
l_resale_batch_rec.credit_advice_date,
l_resale_batch_rec.org_id,
l_resale_batch_rec.header_tolerance_operand,
l_resale_batch_rec.header_tolerance_calc_code,
l_resale_batch_rec.line_tolerance_operand,
l_resale_batch_rec.line_tolerance_calc_code,
l_resale_batch_rec.allowed_amount,
l_resale_batch_rec.accepted_amount,
l_resale_batch_rec.paid_amount,
l_resale_batch_rec.disputed_amount,
l_resale_batch_rec.lines_invalid,
l_resale_batch_rec.lines_w_tolerance,
l_resale_batch_rec.lines_disputed,
l_resale_batch_rec.purge_flag,
l_resale_batch_rec.direct_order_flag; -- For Bug#9447673 SSD IDSM
ozf_pre_process_pvt.update_interface_batch
(
p_api_version_number => 1.0,
p_init_msg_list => FND_API.G_FALSE,
P_Commit => FND_API.G_FALSE,
p_validation_level => FND_API.G_VALID_LEVEL_FULL,
p_int_batch_rec => l_resale_batch_rec,
x_return_status => x_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data
);
END Update_Resale_Batch;
PROCEDURE Update_Resale_Int_Line (
p_api_version_number IN NUMBER,
p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
p_Commit IN VARCHAR2 := FND_API.G_FALSE,
p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
p_int_line_tbl IN ozf_pre_process_pvt.resale_line_int_tbl_type,
x_return_status OUT NOCOPY VARCHAR2,
x_msg_count OUT NOCOPY NUMBER,
x_msg_data OUT NOCOPY VARCHAR2
)
IS
l_api_name CONSTANT VARCHAR2(30) := 'Update_Resale_Int_Line';
SELECT resale_line_int_id,
object_version_number,
last_update_date,
last_updated_by,
request_id,
created_from,
last_update_login,
nvl(p_int_line_tbl(1).program_application_id,program_application_id),
nvl(p_int_line_tbl(1).program_update_date,program_update_date),
nvl(p_int_line_tbl(1).program_id,program_id),
'OPEN',
nvl(p_int_line_tbl(1).resale_transfer_type,resale_transfer_type),
nvl(p_int_line_tbl(1).product_transfer_movement_type,product_transfer_movement_type ),
nvl(p_int_line_tbl(1).product_transfer_date,product_transfer_date),
nvl(p_int_line_tbl(1).tracing_flag,tracing_flag),
DECODE(p_int_line_tbl(1).ship_from_party_name
,NULL,ship_from_cust_account_id
,DECODE(p_int_line_tbl(1).ship_from_party_name,ship_from_party_name,ship_from_cust_account_id, NULL)),
DECODE(p_int_line_tbl(1).ship_from_location
,NULL,DECODE(p_int_line_tbl(1).ship_from_address
,NULL,ship_from_site_id
,DECODE(p_int_line_tbl(1).ship_from_address, ship_from_address,ship_from_site_id,NULL))
,DECODE(p_int_line_tbl(1).ship_from_location,ship_from_location,ship_from_site_id,NULL )),
DECODE(p_int_line_tbl(1).ship_from_party_name,
ship_from_party_name,ship_from_party_name,
p_int_line_tbl(1).ship_from_party_name),
nvl(p_int_line_tbl(1).ship_from_location,ship_from_location),
nvl(p_int_line_tbl(1).ship_from_address,ship_from_address),
nvl(p_int_line_tbl(1).ship_from_city,ship_from_city),
nvl(p_int_line_tbl(1).ship_from_state,ship_from_state),
nvl(p_int_line_tbl(1).ship_from_postal_code,ship_from_postal_code),
nvl(p_int_line_tbl(1).ship_from_country,ship_from_country),
DECODE(p_int_line_tbl(1).ship_from_contact_name
,NULL,ship_from_contact_party_id
,decode(p_int_line_tbl(1).ship_from_contact_name,ship_from_contact_name,ship_from_contact_party_id, NULL)),
nvl(p_int_line_tbl(1).ship_from_contact_name,ship_from_contact_name),
nvl(p_int_line_tbl(1).ship_from_email,ship_from_email),
nvl(p_int_line_tbl(1).ship_from_phone,ship_from_phone),
nvl(p_int_line_tbl(1).ship_from_fax,ship_from_fax),
DECODE(p_int_line_tbl(1).sold_from_party_name
,NULL,DECODE(p_int_line_tbl(1).ship_from_location, ship_from_location,sold_from_cust_account_id,
NULL)
,decode(p_int_line_tbl(1).sold_from_party_name,sold_from_party_name,sold_from_cust_account_id, NULL)),
DECODE(p_int_line_tbl(1).sold_from_location
,NULL,DECODE(p_int_line_tbl(1).sold_from_address
,NULL,DECODE(p_int_line_tbl(1).ship_from_location, ship_from_location,sold_from_site_id,
NULL)
,DECODE(p_int_line_tbl(1).sold_from_address, sold_from_address,sold_from_site_id,NULL))
,DECODE(p_int_line_tbl(1).sold_from_location,sold_from_location,sold_from_site_id,NULL )),
DECODE(p_int_line_tbl(1).sold_from_party_name,
sold_from_party_name,sold_from_party_name,
p_int_line_tbl(1).sold_from_party_name),
nvl(p_int_line_tbl(1).sold_from_location,sold_from_location),
nvl(p_int_line_tbl(1).sold_from_address,sold_from_address),
nvl(p_int_line_tbl(1).sold_from_city,sold_from_city),
nvl(p_int_line_tbl(1).sold_from_state,sold_from_state),
nvl(p_int_line_tbl(1).sold_from_postal_code,sold_from_postal_code),
nvl(p_int_line_tbl(1).sold_from_country,sold_from_country),
DECODE(p_int_line_tbl(1).sold_from_contact_name
,NULL,sold_from_contact_party_id
,decode(p_int_line_tbl(1).sold_from_contact_name,sold_from_contact_name,sold_from_contact_party_id, NULL)),
nvl(p_int_line_tbl(1).sold_from_contact_name,sold_from_contact_name),
nvl(p_int_line_tbl(1).sold_from_email,sold_from_email),
nvl(p_int_line_tbl(1).sold_from_phone,sold_from_phone),
nvl(p_int_line_tbl(1).sold_from_fax,sold_from_fax),
DECODE(p_int_line_tbl(1).bill_to_party_name
,NULL,DECODE(p_int_line_tbl(1).ship_to_location, ship_to_location,bill_to_cust_account_id,
NULL)
,decode(p_int_line_tbl(1).bill_to_party_name,bill_to_party_name,bill_to_cust_account_id, NULL)),
DECODE(p_int_line_tbl(1).bill_to_location
,NULL,DECODE(p_int_line_tbl(1).bill_to_address
,NULL,DECODE(p_int_line_tbl(1).ship_to_location, ship_to_location,bill_to_site_use_id,
NULL)
,DECODE(p_int_line_tbl(1).bill_to_address, bill_to_address,bill_to_site_use_id,NULL))
,DECODE(p_int_line_tbl(1).bill_to_location,bill_to_location,bill_to_site_use_id,NULL )),
DECODE(p_int_line_tbl(1).bill_to_party_name
,NULL,DECODE(p_int_line_tbl(1).ship_to_location, ship_to_location,bill_to_party_id,
NULL)
,decode(p_int_line_tbl(1).bill_to_party_name,bill_to_party_name,bill_to_party_id, NULL)),
DECODE(p_int_line_tbl(1).bill_to_location
,NULL,DECODE(p_int_line_tbl(1).bill_to_address
,NULL,DECODE(p_int_line_tbl(1).ship_to_location, ship_to_location,bill_to_party_site_id,
NULL)
,DECODE(p_int_line_tbl(1).bill_to_address, bill_to_address,bill_to_party_site_id,NULL))
,DECODE(p_int_line_tbl(1).bill_to_location,bill_to_location,bill_to_party_site_id,NULL )),
DECODE(p_int_line_tbl(1).bill_to_party_name, NULL,
bill_to_party_name,bill_to_party_name,
p_int_line_tbl(1).bill_to_party_name),
nvl(p_int_line_tbl(1).bill_to_duns_number,bill_to_duns_number),
nvl(p_int_line_tbl(1).bill_to_location,bill_to_location),
nvl(p_int_line_tbl(1).bill_to_address,bill_to_address),
nvl(p_int_line_tbl(1).bill_to_city,bill_to_city),
nvl(p_int_line_tbl(1).bill_to_state,bill_to_state),
nvl(p_int_line_tbl(1).bill_to_postal_code,bill_to_postal_code),
nvl(p_int_line_tbl(1).bill_to_country,bill_to_country),
DECODE(p_int_line_tbl(1).bill_to_contact_name
,NULL,bill_to_contact_party_id
,decode(p_int_line_tbl(1).bill_to_contact_name,bill_to_contact_name,bill_to_contact_party_id, NULL)),
nvl(p_int_line_tbl(1).bill_to_contact_name,bill_to_contact_name),
nvl(p_int_line_tbl(1).bill_to_email,bill_to_email),
nvl(p_int_line_tbl(1).bill_to_phone,bill_to_phone),
nvl(p_int_line_tbl(1).bill_to_fax,bill_to_fax),
DECODE(p_int_line_tbl(1).ship_to_party_name
,NULL,DECODE(p_int_line_tbl(1).ship_to_location, ship_to_location ,ship_to_cust_account_id,NULL)
,decode(p_int_line_tbl(1).ship_to_party_name,ship_to_party_name,ship_to_cust_account_id, NULL)),
DECODE(p_int_line_tbl(1).ship_to_location
,NULL,DECODE(p_int_line_tbl(1).ship_to_address
,NULL,ship_to_site_use_id
,DECODE(p_int_line_tbl(1).ship_to_address, ship_to_address,ship_to_site_use_id,NULL))
,DECODE(p_int_line_tbl(1).ship_to_location,ship_to_location,ship_to_site_use_id,NULL )),
DECODE(p_int_line_tbl(1).ship_to_party_name
,NULL,DECODE(p_int_line_tbl(1).ship_to_location, ship_to_location ,ship_to_cust_account_id,NULL)
,decode(p_int_line_tbl(1).ship_to_party_name,ship_to_party_name,ship_to_party_id, NULL)),
DECODE(p_int_line_tbl(1).ship_to_location
,NULL,DECODE(p_int_line_tbl(1).ship_to_address
,NULL,ship_to_party_site_id
,DECODE(p_int_line_tbl(1).ship_to_address, ship_to_address,ship_to_party_site_id,NULL))
,DECODE(p_int_line_tbl(1).ship_to_location,ship_to_location,ship_to_party_site_id,NULL )),
DECODE(p_int_line_tbl(1).ship_to_party_name,
ship_to_party_name,ship_to_party_name,
p_int_line_tbl(1).ship_to_party_name),
nvl(p_int_line_tbl(1).ship_to_duns_number,ship_to_duns_number),
nvl(p_int_line_tbl(1).ship_to_location,ship_to_location),
nvl(p_int_line_tbl(1).ship_to_address,ship_to_address),
nvl(p_int_line_tbl(1).ship_to_city,ship_to_city),
nvl(p_int_line_tbl(1).ship_to_state,ship_to_state),
nvl(p_int_line_tbl(1).ship_to_postal_code,ship_to_postal_code),
nvl(p_int_line_tbl(1).ship_to_country,ship_to_country),
DECODE(p_int_line_tbl(1).ship_to_contact_name
,NULL,ship_to_contact_party_id
,decode(p_int_line_tbl(1).ship_to_contact_name,ship_to_contact_name,ship_to_contact_party_id, NULL)),
nvl(p_int_line_tbl(1).ship_to_contact_name,ship_to_contact_name),
nvl(p_int_line_tbl(1).ship_to_email,ship_to_email),
nvl(p_int_line_tbl(1).ship_to_phone,ship_to_phone),
nvl(p_int_line_tbl(1).ship_to_fax,ship_to_fax),
DECODE(p_int_line_tbl(1).end_cust_party_name
,NULL,end_cust_party_id
,decode(p_int_line_tbl(1).end_cust_party_name,end_cust_party_name,end_cust_party_id, NULL)),
DECODE(p_int_line_tbl(1).end_cust_location
,NULL,DECODE(p_int_line_tbl(1).end_cust_address
,NULL,end_cust_site_use_id
,DECODE(p_int_line_tbl(1).end_cust_address, end_cust_address,end_cust_site_use_id,NULL))
,DECODE(p_int_line_tbl(1).end_cust_location,end_cust_location,end_cust_site_use_id,NULL )),
nvl(p_int_line_tbl(1).end_cust_site_use_code,end_cust_site_use_code),
DECODE(p_int_line_tbl(1).end_cust_location
,NULL,DECODE(p_int_line_tbl(1).end_cust_address
,NULL,end_cust_party_site_id
,DECODE(p_int_line_tbl(1).end_cust_address, end_cust_address,end_cust_party_site_id,NULL))
,DECODE(p_int_line_tbl(1).end_cust_location,end_cust_location,end_cust_party_site_id,NULL )),
nvl(p_int_line_tbl(1).end_cust_party_name,end_cust_party_name),
nvl(p_int_line_tbl(1).end_cust_location,end_cust_location),
nvl(p_int_line_tbl(1).end_cust_address,end_cust_address),
nvl(p_int_line_tbl(1).end_cust_city,end_cust_city),
nvl(p_int_line_tbl(1).end_cust_state,end_cust_state),
nvl(p_int_line_tbl(1).end_cust_postal_code,end_cust_postal_code),
nvl(p_int_line_tbl(1).end_cust_country,end_cust_country),
DECODE(p_int_line_tbl(1).end_cust_contact_name
,NULL,end_cust_contact_party_id
,decode(p_int_line_tbl(1).end_cust_contact_name,end_cust_contact_name,end_cust_contact_party_id, NULL)),
nvl(p_int_line_tbl(1).end_cust_contact_name,end_cust_contact_name),
nvl(p_int_line_tbl(1).end_cust_email,end_cust_email),
nvl(p_int_line_tbl(1).end_cust_phone,end_cust_phone),
nvl(p_int_line_tbl(1).end_cust_fax,end_cust_fax),
nvl(p_int_line_tbl(1).direct_customer_flag,direct_customer_flag ),
DECODE(p_int_line_tbl(1).order_type,NULL,order_type_id,NULL),
nvl(p_int_line_tbl(1).order_type,order_type),
nvl(p_int_line_tbl(1).order_category,order_category),
DECODE(p_int_line_tbl(1).orig_system_agreement_type,NULL
,decode(p_int_line_tbl(1).agreement_type,NULL,agreement_type, p_int_line_tbl(1).agreement_type)
,decode(p_int_line_tbl(1).orig_system_agreement_type,orig_system_agreement_type, agreement_type, NULL)),
DECODE(p_int_line_tbl(1).orig_system_agreement_name,NULL
,decode(p_int_line_tbl(1).agreement_name,NULL,agreement_id, NULL)
,decode(p_int_line_tbl(1).orig_system_agreement_name,orig_system_agreement_name, agreement_id, NULL)),
DECODE(p_int_line_tbl(1).orig_system_agreement_name,NULL
,decode(p_int_line_tbl(1).agreement_name,NULL,agreement_name, p_int_line_tbl(1).agreement_name)
,decode(p_int_line_tbl(1).orig_system_agreement_name,orig_system_agreement_name, agreement_name, NULL)),
DECODE(p_int_line_tbl(1).orig_system_agreement_price,NULL
,decode(p_int_line_tbl(1).agreement_price,NULL,agreement_price, p_int_line_tbl(1).agreement_price)
,decode(p_int_line_tbl(1).orig_system_agreement_price,orig_system_agreement_price, agreement_price, NULL)),
DECODE(p_int_line_tbl(1).orig_system_agreement_uom,NULL
,decode(p_int_line_tbl(1).agreement_uom_code,NULL,agreement_uom_code, p_int_line_tbl(1).agreement_uom_code)
,decode(p_int_line_tbl(1).orig_system_agreement_uom,orig_system_agreement_uom, agreement_uom_code, NULL)),
DECODE(p_int_line_tbl(1).orig_system_agreement_name,NULL
,decode(p_int_line_tbl(1).agreement_name,NULL,corrected_agreement_id, NULL)
,decode(p_int_line_tbl(1).orig_system_agreement_name,orig_system_agreement_name, corrected_agreement_id, NULL)),
DECODE(p_int_line_tbl(1).orig_system_agreement_name,NULL
,decode(p_int_line_tbl(1).agreement_name,NULL,corrected_agreement_name, NULL)
,decode(p_int_line_tbl(1).orig_system_agreement_name,orig_system_agreement_name, corrected_agreement_name, NULL)),
DECODE(p_int_line_tbl(1).price_list_name,NULL,price_list_id,NULL),
nvl(p_int_line_tbl(1).price_list_name,price_list_name),
nvl(p_int_line_tbl(1).orig_system_reference,orig_system_reference),
nvl(p_int_line_tbl(1).orig_system_line_reference,orig_system_line_reference),
nvl(p_int_line_tbl(1).orig_system_currency_code,orig_system_currency_code),
nvl(p_int_line_tbl(1).orig_system_selling_price,orig_system_selling_price),
nvl(p_int_line_tbl(1).orig_system_quantity,orig_system_quantity),
nvl(p_int_line_tbl(1).orig_system_uom,orig_system_uom),
nvl(p_int_line_tbl(1).orig_system_purchase_uom,orig_system_purchase_uom),
nvl(p_int_line_tbl(1).orig_system_purchase_curr,orig_system_purchase_curr),
nvl(p_int_line_tbl(1).orig_system_purchase_price,orig_system_purchase_price),
nvl(p_int_line_tbl(1).orig_system_purchase_quantity,orig_system_purchase_quantity),
nvl(p_int_line_tbl(1).orig_system_agreement_uom,orig_system_agreement_uom),
nvl(p_int_line_tbl(1).orig_system_agreement_name,orig_system_agreement_name),
nvl(p_int_line_tbl(1).orig_system_agreement_type,orig_system_agreement_type),
nvl(p_int_line_tbl(1).orig_system_agreement_status,orig_system_agreement_status),
nvl(p_int_line_tbl(1).orig_system_agreement_curr,orig_system_agreement_curr),
nvl(p_int_line_tbl(1).orig_system_agreement_price,orig_system_agreement_price),
nvl(p_int_line_tbl(1).orig_system_agreement_quantity,orig_system_agreement_quantity),
nvl(p_int_line_tbl(1).orig_system_item_number,orig_system_item_number),
nvl(p_int_line_tbl(1).currency_code,currency_code),
nvl(p_int_line_tbl(1).exchange_rate,exchange_rate),
nvl(p_int_line_tbl(1).exchange_rate_type,exchange_rate_type),
nvl(p_int_line_tbl(1).exchange_rate_date,exchange_rate_date),
nvl(p_int_line_tbl(1).po_number,po_number),
nvl(p_int_line_tbl(1).po_release_number,po_release_number),
nvl(p_int_line_tbl(1).po_type,po_type),
nvl(p_int_line_tbl(1).invoice_number,invoice_number),
nvl(p_int_line_tbl(1).date_invoiced,date_invoiced),
nvl(p_int_line_tbl(1).order_number,order_number),
nvl(p_int_line_tbl(1).date_ordered,date_ordered),
nvl(p_int_line_tbl(1).date_shipped,date_shipped),
nvl(p_int_line_tbl(1).claimed_amount,claimed_amount),
nvl(p_int_line_tbl(1).allowed_amount,allowed_amount),
nvl(p_int_line_tbl(1).total_allowed_amount,total_allowed_amount),
nvl(p_int_line_tbl(1).accepted_amount,accepted_amount),
nvl(p_int_line_tbl(1).total_accepted_amount,total_accepted_amount),
nvl(p_int_line_tbl(1).line_tolerance_amount,line_tolerance_amount),
nvl(p_int_line_tbl(1).tolerance_flag,tolerance_flag),
DECODE(p_int_line_tbl(1).quantity,
NULL,DECODE(p_int_line_tbl(1).orig_system_quantity,
orig_system_quantity, total_claimed_amount,
(p_int_line_tbl(1).orig_system_quantity*p_int_line_tbl(1).claimed_amount)),
DECODE(p_int_line_tbl(1).quantity, quantity,
total_claimed_amount,
(p_int_line_tbl(1).quantity*p_int_line_tbl(1).claimed_amount))),
DECODE(p_int_line_tbl(1).orig_system_purchase_price,NULL
,decode(p_int_line_tbl(1).purchase_price,NULL,purchase_price, p_int_line_tbl(1).purchase_price)
,decode(p_int_line_tbl(1).orig_system_purchase_price,orig_system_purchase_price, purchase_price, NULL)),
DECODE(p_int_line_tbl(1).orig_system_purchase_uom,NULL
,decode(p_int_line_tbl(1).purchase_uom_code,NULL,purchase_uom_code, p_int_line_tbl(1).purchase_uom_code)
,decode(p_int_line_tbl(1).orig_system_purchase_uom,orig_system_purchase_uom, purchase_uom_code, NULL)),
nvl(p_int_line_tbl(1).acctd_purchase_price,acctd_purchase_price),
DECODE(p_int_line_tbl(1).orig_system_selling_price,NULL
,decode(p_int_line_tbl(1).selling_price,NULL,selling_price, p_int_line_tbl(1).selling_price)
,decode(p_int_line_tbl(1).orig_system_selling_price,orig_system_selling_price, selling_price, NULL)),
nvl(p_int_line_tbl(1).acctd_selling_price,acctd_selling_price ),
DECODE(p_int_line_tbl(1).orig_system_uom,NULL
,decode(p_int_line_tbl(1).uom_code,NULL,uom_code, p_int_line_tbl(1).uom_code)
,decode(p_int_line_tbl(1).orig_system_uom,orig_system_uom, uom_code, NULL)),
DECODE(p_int_line_tbl(1).orig_system_quantity,NULL
,decode(p_int_line_tbl(1).quantity,NULL,quantity, p_int_line_tbl(1).quantity)
,decode(p_int_line_tbl(1).orig_system_quantity,orig_system_quantity, quantity, NULL)),
nvl(p_int_line_tbl(1).calculated_price,calculated_price),
nvl(p_int_line_tbl(1).acctd_calculated_price,acctd_calculated_price),
nvl(p_int_line_tbl(1).calculated_amount,calculated_amount),
nvl(p_int_line_tbl(1).credit_code,credit_code),
nvl(p_int_line_tbl(1).credit_advice_date,credit_advice_date),
nvl(p_int_line_tbl(1).upc_code,upc_code),
DECODE(p_int_line_tbl(1).orig_system_item_number,NULL
,decode(p_int_line_tbl(1).inventory_item_id,NULL,inventory_item_id, p_int_line_tbl(1).inventory_item_id)
,decode(p_int_line_tbl(1).orig_system_item_number,orig_system_item_number, inventory_item_id, NULL)),
nvl(p_int_line_tbl(1).item_number,item_number),
nvl(p_int_line_tbl(1).item_description,item_description),
nvl(p_int_line_tbl(1).inventory_item_segment1,inventory_item_segment1),
nvl(p_int_line_tbl(1).inventory_item_segment2,inventory_item_segment2),
nvl(p_int_line_tbl(1).inventory_item_segment3,inventory_item_segment3),
nvl(p_int_line_tbl(1).inventory_item_segment4,inventory_item_segment4),
nvl(p_int_line_tbl(1).inventory_item_segment5,inventory_item_segment5),
nvl(p_int_line_tbl(1).inventory_item_segment6,inventory_item_segment6),
nvl(p_int_line_tbl(1).inventory_item_segment7,inventory_item_segment7),
nvl(p_int_line_tbl(1).inventory_item_segment8,inventory_item_segment8),
nvl(p_int_line_tbl(1).inventory_item_segment9,inventory_item_segment9),
nvl(p_int_line_tbl(1).inventory_item_segment10,inventory_item_segment10),
nvl(p_int_line_tbl(1).inventory_item_segment11,inventory_item_segment11),
nvl(p_int_line_tbl(1).inventory_item_segment12,inventory_item_segment12),
nvl(p_int_line_tbl(1).inventory_item_segment13,inventory_item_segment13),
nvl(p_int_line_tbl(1).inventory_item_segment14,inventory_item_segment14),
nvl(p_int_line_tbl(1).inventory_item_segment15,inventory_item_segment15),
nvl(p_int_line_tbl(1).inventory_item_segment16,inventory_item_segment16),
nvl(p_int_line_tbl(1).inventory_item_segment17,inventory_item_segment17),
nvl(p_int_line_tbl(1).inventory_item_segment18,inventory_item_segment18),
nvl(p_int_line_tbl(1).inventory_item_segment19,inventory_item_segment19),
nvl(p_int_line_tbl(1).inventory_item_segment20,inventory_item_segment20),
nvl(p_int_line_tbl(1).product_category_id,product_category_id),
nvl(p_int_line_tbl(1).category_name,category_name),
nvl(p_int_line_tbl(1).duplicated_line_id,duplicated_line_id),
nvl(p_int_line_tbl(1).duplicated_adjustment_id,duplicated_adjustment_id),
nvl(p_int_line_tbl(1).response_type,response_type),
nvl(p_int_line_tbl(1).response_code,response_code),
nvl(p_int_line_tbl(1).reject_reason_code,reject_reason_code),
nvl(p_int_line_tbl(1).followup_action_code,followup_action_code),
nvl(p_int_line_tbl(1).net_adjusted_amount,net_adjusted_amount),
NULL dispute_code,
nvl(p_int_line_tbl(1).data_source_code,data_source_code),
nvl(p_int_line_tbl(1).header_attribute_category,header_attribute_category),
nvl(p_int_line_tbl(1).header_attribute1,header_attribute1),
nvl(p_int_line_tbl(1).header_attribute2,header_attribute2),
nvl(p_int_line_tbl(1).header_attribute3,header_attribute3),
nvl(p_int_line_tbl(1).header_attribute4,header_attribute4),
nvl(p_int_line_tbl(1).header_attribute5,header_attribute5),
nvl(p_int_line_tbl(1).header_attribute6,header_attribute6),
nvl(p_int_line_tbl(1).header_attribute7,header_attribute7),
nvl(p_int_line_tbl(1).header_attribute8,header_attribute8),
nvl(p_int_line_tbl(1).header_attribute9,header_attribute9),
nvl(p_int_line_tbl(1).header_attribute10,header_attribute10),
nvl(p_int_line_tbl(1).header_attribute11,header_attribute11),
nvl(p_int_line_tbl(1).header_attribute12,header_attribute12),
nvl(p_int_line_tbl(1).header_attribute13,header_attribute13),
nvl(p_int_line_tbl(1).header_attribute14,header_attribute14),
nvl(p_int_line_tbl(1).header_attribute15,header_attribute15),
nvl(p_int_line_tbl(1).line_attribute_category,line_attribute_category),
nvl(p_int_line_tbl(1).line_attribute1,line_attribute1),
nvl(p_int_line_tbl(1).line_attribute2,line_attribute2),
nvl(p_int_line_tbl(1).line_attribute3,line_attribute3),
nvl(p_int_line_tbl(1).line_attribute4,line_attribute4),
nvl(p_int_line_tbl(1).line_attribute5,line_attribute5),
nvl(p_int_line_tbl(1).line_attribute6,line_attribute6),
nvl(p_int_line_tbl(1).line_attribute7,line_attribute7),
nvl(p_int_line_tbl(1).line_attribute8,line_attribute8),
nvl(p_int_line_tbl(1).line_attribute9,line_attribute9),
nvl(p_int_line_tbl(1).line_attribute10,line_attribute10),
nvl(p_int_line_tbl(1).line_attribute11,line_attribute11),
nvl(p_int_line_tbl(1).line_attribute12,line_attribute12),
nvl(p_int_line_tbl(1).line_attribute13,line_attribute13),
nvl(p_int_line_tbl(1).line_attribute14,line_attribute14),
nvl(p_int_line_tbl(1).line_attribute15,line_attribute15),
nvl(p_int_line_tbl(1).org_id,org_id),
-- For Bug#9447673 SSD IDSM ER(+)
nvl(p_int_line_tbl(1).invoice_line_number,invoice_line_number),
nvl(p_int_line_tbl(1).order_line_number,order_line_number),
nvl(p_int_line_tbl(1).supplier_item_cost,supplier_item_cost),
nvl(p_int_line_tbl(1).supplier_item_uom,supplier_item_uom)
-- For Bug#9447673 SSD IDSM ER(-)
FROM ozf_resale_lines_int
WHERE resale_line_int_id = pc_line_id
AND resale_batch_id = pc_batch_id;
,l_int_line_tbl(1).last_update_date
,l_int_line_tbl(1).last_updated_by
,l_int_line_tbl(1).request_id
,l_int_line_tbl(1).created_from
,l_int_line_tbl(1).last_update_login
,l_int_line_tbl(1).program_application_id
,l_int_line_tbl(1).program_update_date
,l_int_line_tbl(1).program_id
,l_int_line_tbl(1).status_code
,l_int_line_tbl(1).resale_transfer_type
,l_int_line_tbl(1).product_transfer_movement_type
,l_int_line_tbl(1).product_transfer_date
,l_int_line_tbl(1).tracing_flag
,l_int_line_tbl(1).ship_from_cust_account_id
,l_int_line_tbl(1).ship_from_site_id
,l_int_line_tbl(1).ship_from_party_name
,l_int_line_tbl(1).ship_from_location
,l_int_line_tbl(1).ship_from_address
,l_int_line_tbl(1).ship_from_city
,l_int_line_tbl(1).ship_from_state
,l_int_line_tbl(1).ship_from_postal_code
,l_int_line_tbl(1).ship_from_country
,l_int_line_tbl(1).ship_from_contact_party_id
,l_int_line_tbl(1).ship_from_contact_name
,l_int_line_tbl(1).ship_from_email
,l_int_line_tbl(1).ship_from_phone
,l_int_line_tbl(1).ship_from_fax
,l_int_line_tbl(1).sold_from_cust_account_id
,l_int_line_tbl(1).sold_from_site_id
,l_int_line_tbl(1).sold_from_party_name
,l_int_line_tbl(1).sold_from_location
,l_int_line_tbl(1).sold_from_address
,l_int_line_tbl(1).sold_from_city
,l_int_line_tbl(1).sold_from_state
,l_int_line_tbl(1).sold_from_postal_code
,l_int_line_tbl(1).sold_from_country
,l_int_line_tbl(1).sold_from_contact_party_id
,l_int_line_tbl(1).sold_from_contact_name
,l_int_line_tbl(1).sold_from_email
,l_int_line_tbl(1).sold_from_phone
,l_int_line_tbl(1).sold_from_fax
,l_int_line_tbl(1).bill_to_cust_account_id
,l_int_line_tbl(1).bill_to_site_use_id
,l_int_line_tbl(1).bill_to_party_id
,l_int_line_tbl(1).bill_to_party_site_id
,l_int_line_tbl(1).bill_to_party_name
,l_int_line_tbl(1).bill_to_duns_number
,l_int_line_tbl(1).bill_to_location
,l_int_line_tbl(1).bill_to_address
,l_int_line_tbl(1).bill_to_city
,l_int_line_tbl(1).bill_to_state
,l_int_line_tbl(1).bill_to_postal_code
,l_int_line_tbl(1).bill_to_country
,l_int_line_tbl(1).bill_to_contact_party_id
,l_int_line_tbl(1).bill_to_contact_name
,l_int_line_tbl(1).bill_to_email
,l_int_line_tbl(1).bill_to_phone
,l_int_line_tbl(1).bill_to_fax
,l_int_line_tbl(1).ship_to_cust_account_id
,l_int_line_tbl(1).ship_to_site_use_id
,l_int_line_tbl(1).ship_to_party_id
,l_int_line_tbl(1).ship_to_party_site_id
,l_int_line_tbl(1).ship_to_party_name
,l_int_line_tbl(1).ship_to_duns_number
,l_int_line_tbl(1).ship_to_location
,l_int_line_tbl(1).ship_to_address
,l_int_line_tbl(1).ship_to_city
,l_int_line_tbl(1).ship_to_state
,l_int_line_tbl(1).ship_to_postal_code
,l_int_line_tbl(1).ship_to_country
,l_int_line_tbl(1).ship_to_contact_party_id
,l_int_line_tbl(1).ship_to_contact_name
,l_int_line_tbl(1).ship_to_email
,l_int_line_tbl(1).ship_to_phone
,l_int_line_tbl(1).ship_to_fax
,l_int_line_tbl(1).end_cust_party_id
,l_int_line_tbl(1).end_cust_site_use_id
,l_int_line_tbl(1).end_cust_site_use_code
,l_int_line_tbl(1).end_cust_party_site_id
,l_int_line_tbl(1).end_cust_party_name
,l_int_line_tbl(1).end_cust_location
,l_int_line_tbl(1).end_cust_address
,l_int_line_tbl(1).end_cust_city
,l_int_line_tbl(1).end_cust_state
,l_int_line_tbl(1).end_cust_postal_code
,l_int_line_tbl(1).end_cust_country
,l_int_line_tbl(1).end_cust_contact_party_id
,l_int_line_tbl(1).end_cust_contact_name
,l_int_line_tbl(1).end_cust_email
,l_int_line_tbl(1).end_cust_phone
,l_int_line_tbl(1).end_cust_fax
,l_int_line_tbl(1).direct_customer_flag
,l_int_line_tbl(1).order_type_id
,l_int_line_tbl(1).order_type
,l_int_line_tbl(1).order_category
,l_int_line_tbl(1).agreement_type
,l_int_line_tbl(1).agreement_id
,l_int_line_tbl(1).agreement_name
,l_int_line_tbl(1).agreement_price
,l_int_line_tbl(1).agreement_uom_code
,l_int_line_tbl(1).corrected_agreement_id
,l_int_line_tbl(1).corrected_agreement_name
,l_int_line_tbl(1).price_list_id
,l_int_line_tbl(1).price_list_name
,l_int_line_tbl(1).orig_system_reference
,l_int_line_tbl(1).orig_system_line_reference
,l_int_line_tbl(1).orig_system_currency_code
,l_int_line_tbl(1).orig_system_selling_price
,l_int_line_tbl(1).orig_system_quantity
,l_int_line_tbl(1).orig_system_uom
,l_int_line_tbl(1).orig_system_purchase_uom
,l_int_line_tbl(1).orig_system_purchase_curr
,l_int_line_tbl(1).orig_system_purchase_price
,l_int_line_tbl(1).orig_system_purchase_quantity
,l_int_line_tbl(1).orig_system_agreement_uom
,l_int_line_tbl(1).orig_system_agreement_name
,l_int_line_tbl(1).orig_system_agreement_type
,l_int_line_tbl(1).orig_system_agreement_status
,l_int_line_tbl(1).orig_system_agreement_curr
,l_int_line_tbl(1).orig_system_agreement_price
,l_int_line_tbl(1).orig_system_agreement_quantity
,l_int_line_tbl(1).orig_system_item_number
,l_int_line_tbl(1).currency_code
,l_int_line_tbl(1).exchange_rate
,l_int_line_tbl(1).exchange_rate_type
,l_int_line_tbl(1).exchange_rate_date
,l_int_line_tbl(1).po_number
,l_int_line_tbl(1).po_release_number
,l_int_line_tbl(1).po_type
,l_int_line_tbl(1).invoice_number
,l_int_line_tbl(1).date_invoiced
,l_int_line_tbl(1).order_number
,l_int_line_tbl(1).date_ordered
,l_int_line_tbl(1).date_shipped
,l_int_line_tbl(1).claimed_amount
,l_int_line_tbl(1).allowed_amount
,l_int_line_tbl(1).total_allowed_amount
,l_int_line_tbl(1).accepted_amount
,l_int_line_tbl(1).total_accepted_amount
,l_int_line_tbl(1).line_tolerance_amount
,l_int_line_tbl(1).tolerance_flag
,l_int_line_tbl(1).total_claimed_amount
,l_int_line_tbl(1).purchase_price
,l_int_line_tbl(1).purchase_uom_code
,l_int_line_tbl(1).acctd_purchase_price
,l_int_line_tbl(1).selling_price
,l_int_line_tbl(1).acctd_selling_price
,l_int_line_tbl(1).uom_code
,l_int_line_tbl(1).quantity
,l_int_line_tbl(1).calculated_price
,l_int_line_tbl(1).acctd_calculated_price
,l_int_line_tbl(1).calculated_amount
,l_int_line_tbl(1).credit_code
,l_int_line_tbl(1).credit_advice_date
,l_int_line_tbl(1).upc_code
,l_int_line_tbl(1).inventory_item_id
,l_int_line_tbl(1).item_number
,l_int_line_tbl(1).item_description
,l_int_line_tbl(1).inventory_item_segment1
,l_int_line_tbl(1).inventory_item_segment2
,l_int_line_tbl(1).inventory_item_segment3
,l_int_line_tbl(1).inventory_item_segment4
,l_int_line_tbl(1).inventory_item_segment5
,l_int_line_tbl(1).inventory_item_segment6
,l_int_line_tbl(1).inventory_item_segment7
,l_int_line_tbl(1).inventory_item_segment8
,l_int_line_tbl(1).inventory_item_segment9
,l_int_line_tbl(1).inventory_item_segment10
,l_int_line_tbl(1).inventory_item_segment11
,l_int_line_tbl(1).inventory_item_segment12
,l_int_line_tbl(1).inventory_item_segment13
,l_int_line_tbl(1).inventory_item_segment14
,l_int_line_tbl(1).inventory_item_segment15
,l_int_line_tbl(1).inventory_item_segment16
,l_int_line_tbl(1).inventory_item_segment17
,l_int_line_tbl(1).inventory_item_segment18
,l_int_line_tbl(1).inventory_item_segment19
,l_int_line_tbl(1).inventory_item_segment20
,l_int_line_tbl(1).product_category_id
,l_int_line_tbl(1).category_name
,l_int_line_tbl(1).duplicated_line_id
,l_int_line_tbl(1).duplicated_adjustment_id
,l_int_line_tbl(1).response_type
,l_int_line_tbl(1).response_code
,l_int_line_tbl(1).reject_reason_code
,l_int_line_tbl(1).followup_action_code
,l_int_line_tbl(1).net_adjusted_amount
,l_int_line_tbl(1).dispute_code
,l_int_line_tbl(1).data_source_code
,l_int_line_tbl(1).header_attribute_category
,l_int_line_tbl(1).header_attribute1
,l_int_line_tbl(1).header_attribute2
,l_int_line_tbl(1).header_attribute3
,l_int_line_tbl(1).header_attribute4
,l_int_line_tbl(1).header_attribute5
,l_int_line_tbl(1).header_attribute6
,l_int_line_tbl(1).header_attribute7
,l_int_line_tbl(1).header_attribute8
,l_int_line_tbl(1).header_attribute9
,l_int_line_tbl(1).header_attribute10
,l_int_line_tbl(1).header_attribute11
,l_int_line_tbl(1).header_attribute12
,l_int_line_tbl(1).header_attribute13
,l_int_line_tbl(1).header_attribute14
,l_int_line_tbl(1).header_attribute15
,l_int_line_tbl(1).line_attribute_category
,l_int_line_tbl(1).line_attribute1
,l_int_line_tbl(1).line_attribute2
,l_int_line_tbl(1).line_attribute3
,l_int_line_tbl(1).line_attribute4
,l_int_line_tbl(1).line_attribute5
,l_int_line_tbl(1).line_attribute6
,l_int_line_tbl(1).line_attribute7
,l_int_line_tbl(1).line_attribute8
,l_int_line_tbl(1).line_attribute9
,l_int_line_tbl(1).line_attribute10
,l_int_line_tbl(1).line_attribute11
,l_int_line_tbl(1).line_attribute12
,l_int_line_tbl(1).line_attribute13
,l_int_line_tbl(1).line_attribute14
,l_int_line_tbl(1).line_attribute15
,l_int_line_tbl(1).org_id
-- For Bug#9447673 SSD IDSM ER(+)
,l_int_line_tbl(1).invoice_line_number
,l_int_line_tbl(1).order_line_number
,l_int_line_tbl(1).supplier_item_cost
,l_int_line_tbl(1).supplier_item_uom;
Ozf_pre_process_pvt.Update_interface_line
(
p_api_version_number => 1.0,
p_init_msg_list => FND_API.G_FALSE,
P_Commit => FND_API.G_FALSE,
p_validation_level => FND_API.G_VALID_LEVEL_FULL,
p_int_line_tbl => l_int_line_tbl,
x_return_status => x_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data
);
END Update_Resale_Int_Line;
procedure insert_resale_int_line (
p_api_version_number IN NUMBER,
p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
p_Commit IN VARCHAR2 := FND_API.G_FALSE,
p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
p_int_line_tbl IN ozf_pre_process_pvt.resale_line_int_tbl_type,
x_return_status OUT NOCOPY VARCHAR2,
x_msg_count OUT NOCOPY NUMBER,
x_msg_data OUT NOCOPY VARCHAR2
)
IS
l_api_name CONSTANT VARCHAR2(30) := 'insert_resale_int_line';
OZF_RESALE_LINES_INT_PKG.INSERT_ROW
(
px_resale_line_int_id => l_resale_line_int_id,
px_object_version_number => l_object_version_number,
p_last_update_date => sysdate,
p_last_updated_by => FND_GLOBAL.user_id,
p_creation_date => sysdate,
p_request_id => NULL,
p_created_by => FND_GLOBAL.user_id,
p_created_from => NULL,
p_last_update_login => FND_GLOBAL.user_id,
p_program_application_id => NULL,
p_program_update_date => NULL,
p_program_id => NULL,
p_response_type => p_int_line_tbl(i).response_type,
p_response_code => p_int_line_tbl(i).response_code,
p_reject_reason_code => p_int_line_tbl(i).reject_reason_code,
p_followup_action_code => p_int_line_tbl(i).followup_action_code,
p_resale_transfer_type => p_int_line_tbl(i).resale_transfer_type,
p_product_trans_movement_type => p_int_line_tbl(i).product_transfer_movement_type,
p_product_transfer_date => p_int_line_tbl(i).product_transfer_date,
p_resale_batch_id => p_int_line_tbl(i).resale_batch_id,
p_status_code => 'NEW',
p_end_cust_party_id => p_int_line_tbl(i).end_cust_party_id,
p_end_cust_site_use_id => NULL,
p_end_cust_site_use_code => p_int_line_tbl(i).end_cust_site_use_code,
p_end_cust_party_site_id => NULL,
-- Bug 4469837 (+)
--p_end_cust_party_name => NULL,
p_end_cust_party_name => p_int_line_tbl(i).end_cust_party_name,
-- Bug 4469837 (-)
p_end_cust_location => p_int_line_tbl(i).end_cust_location,
p_end_cust_address => p_int_line_tbl(i).end_cust_address,
p_end_cust_city => p_int_line_tbl(i).end_cust_city,
p_end_cust_state => p_int_line_tbl(i).end_cust_state,
p_end_cust_postal_code => p_int_line_tbl(i).end_cust_postal_code,
p_end_cust_country => p_int_line_tbl(i).end_cust_country,
p_end_cust_contact_party_id => NULL,
p_end_cust_contact_name => p_int_line_tbl(i).end_cust_contact_name,
p_end_cust_email => p_int_line_tbl(i).end_cust_email,
p_end_cust_phone => p_int_line_tbl(i).end_cust_phone,
p_end_cust_fax => p_int_line_tbl(i).end_cust_fax,
p_bill_to_cust_account_id => p_int_line_tbl(i).bill_to_cust_account_id,
p_bill_to_site_use_id => NULL,
-- Bug 4469837 (+)
--p_bill_to_PARTY_NAME => NULL,
p_bill_to_party_name => p_int_line_tbl(i).bill_to_party_name,
-- Bug 4469837 (-)
-- [BEGIN OF BUG 4186465 FIXING]
p_bill_to_party_id => p_int_line_tbl(i).bill_to_party_id,
p_bill_to_party_site_id => p_int_line_tbl(i).bill_to_party_site_id,
-- [END OF BUG 4186465 FIXING]
p_bill_to_location => p_int_line_tbl(i).bill_to_location,
p_bill_to_duns_number => p_int_line_tbl(i).bill_to_duns_number,
p_bill_to_address => p_int_line_tbl(i).bill_to_address,
p_bill_to_city => p_int_line_tbl(i).bill_to_city,
p_bill_to_state => p_int_line_tbl(i).bill_to_state,
p_bill_to_postal_code => p_int_line_tbl(i).bill_to_postal_code,
p_bill_to_country => p_int_line_tbl(i).bill_to_country,
p_bill_to_contact_party_id => NULL,
p_bill_to_contact_name => p_int_line_tbl(i).bill_to_contact_name,
p_bill_to_email => p_int_line_tbl(i).bill_to_email,
p_bill_to_phone => p_int_line_tbl(i).bill_to_phone,
p_bill_to_fax => p_int_line_tbl(i).bill_to_fax,
p_ship_to_cust_account_id => p_int_line_tbl(i).ship_to_cust_account_id,
p_ship_to_site_use_id => NULL,
-- Bug 4469837 (+)
--p_ship_to_PARTY_NAME => NULL,
p_ship_to_party_name => p_int_line_tbl(i).ship_to_party_name,
-- Bug 4469837 (-)
-- [BEGIN OF BUG 4186465 FIXING]
p_ship_to_party_id => p_int_line_tbl(i).ship_to_party_id,
p_ship_to_party_site_id => p_int_line_tbl(i).ship_to_party_site_id,
-- [END OF BUG 4186465 FIXING]
p_ship_to_duns_number => p_int_line_tbl(i).ship_to_duns_number,
p_ship_to_location => p_int_line_tbl(i).ship_to_location,
p_ship_to_address => p_int_line_tbl(i).ship_to_address,
p_ship_to_city => p_int_line_tbl(i).ship_to_city,
p_ship_to_state => p_int_line_tbl(i).ship_to_state,
p_ship_to_postal_code => p_int_line_tbl(i).ship_to_postal_code,
p_ship_to_country => p_int_line_tbl(i).ship_to_country,
p_ship_to_contact_party_id => NULL,
p_ship_to_contact_name => p_int_line_tbl(i).ship_to_contact_name,
p_ship_to_email => p_int_line_tbl(i).ship_to_email,
p_ship_to_phone => p_int_line_tbl(i).ship_to_phone,
p_ship_to_fax => p_int_line_tbl(i).ship_to_fax,
p_ship_from_cust_account_id => p_int_line_tbl(i).ship_from_cust_account_id,
p_ship_from_site_id => NULL,
p_ship_from_PARTY_NAME => NULL,
p_ship_from_location => p_int_line_tbl(i).ship_from_location,
p_ship_from_address => p_int_line_tbl(i).ship_from_address,
p_ship_from_city => p_int_line_tbl(i).ship_from_city,
p_ship_from_state => p_int_line_tbl(i).ship_from_state,
p_ship_from_postal_code => p_int_line_tbl(i).ship_from_postal_code,
p_ship_from_country => p_int_line_tbl(i).ship_from_country,
p_ship_from_contact_party_id => NULL,
p_ship_from_contact_name => p_int_line_tbl(i).ship_from_contact_name,
p_ship_from_email => p_int_line_tbl(i).ship_from_email,
p_ship_from_phone => p_int_line_tbl(i).ship_from_phone,
p_ship_from_fax => p_int_line_tbl(i).ship_from_fax,
p_sold_from_cust_account_id => p_int_line_tbl(i).sold_from_cust_account_id,
p_sold_from_site_id => NULL,
p_sold_from_PARTY_NAME => NULL,
p_sold_from_location => p_int_line_tbl(i).sold_from_location,
p_sold_from_address => p_int_line_tbl(i).sold_from_address,
p_sold_from_city => p_int_line_tbl(i).sold_from_city,
p_sold_from_state => p_int_line_tbl(i).sold_from_state,
p_sold_from_postal_code => p_int_line_tbl(i).sold_from_postal_code,
p_sold_from_country => p_int_line_tbl(i).sold_from_country,
p_sold_from_contact_party_id => NULL,
p_sold_from_contact_name => p_int_line_tbl(i).sold_from_contact_name,
p_sold_from_email => p_int_line_tbl(i).sold_from_email,
p_sold_from_phone => p_int_line_tbl(i).sold_from_phone,
p_sold_from_fax => p_int_line_tbl(i).sold_from_fax,
p_order_number => p_int_line_tbl(i).order_number,
p_date_ordered => p_int_line_tbl(i).date_ordered,
p_po_number => p_int_line_tbl(i).po_number,
p_po_release_number => p_int_line_tbl(i).po_release_number,
p_po_type => p_int_line_tbl(i).po_type,
p_agreement_id => NULL,
p_agreement_name => p_int_line_tbl(i).agreement_name,
p_agreement_type => p_int_line_tbl(i).agreement_type,
p_agreement_price => p_int_line_tbl(i).agreement_price,
p_agreement_uom_code => p_int_line_tbl(i).agreement_uom_code,
p_corrected_agreement_id => NULL,
p_corrected_agreement_name => NULL,
p_price_list_id => NULL,
p_price_list_name => NULL,
p_orig_system_quantity => p_int_line_tbl(i).orig_system_quantity,
p_orig_system_uom => p_int_line_tbl(i).orig_system_uom,
p_orig_system_currency_code => p_int_line_tbl(i).orig_system_currency_code,
p_orig_system_selling_price => p_int_line_tbl(i).orig_system_selling_price,
p_orig_system_reference => p_int_line_tbl(i).orig_system_reference,
p_orig_system_line_reference => p_int_line_tbl(i).orig_system_line_reference,
p_orig_system_purchase_uom => p_int_line_tbl(i).orig_system_purchase_uom,
p_orig_system_purchase_curr => p_int_line_tbl(i).orig_system_purchase_curr,
p_orig_system_purchase_price => p_int_line_tbl(i).orig_system_purchase_price,
p_orig_system_purchase_quant => p_int_line_tbl(i).orig_system_purchase_quantity,
p_orig_system_agreement_uom => p_int_line_tbl(i).orig_system_agreement_uom,
p_ORIG_SYSTEM_AGREEMENT_name => p_int_line_tbl(i).orig_system_agreement_name,
p_orig_system_agreement_type => p_int_line_tbl(i).orig_system_agreement_type,
p_orig_system_agreement_status => p_int_line_tbl(i).orig_system_agreement_status,
p_orig_system_agreement_curr => p_int_line_tbl(i).orig_system_agreement_curr,
p_orig_system_agreement_price => p_int_line_tbl(i).orig_system_agreement_price,
p_orig_system_agreement_quant => p_int_line_tbl(i).orig_system_agreement_quantity,
p_orig_system_item_number => p_int_line_tbl(i).orig_system_item_number,
p_quantity => p_int_line_tbl(i).quantity,
p_uom_code => p_int_line_tbl(i).uom_code,
p_currency_code => p_int_line_tbl(i).currency_code,
p_exchange_rate => p_int_line_tbl(i).exchange_rate,
p_exchange_rate_type => p_int_line_tbl(i).exchange_rate_type,
p_exchange_rate_date => p_int_line_tbl(i).exchange_rate_date,
p_selling_price => p_int_line_tbl(i).selling_price,
p_purchase_uom_code => p_int_line_tbl(i).purchase_uom_code,
p_invoice_number => p_int_line_tbl(i).invoice_number,
p_date_invoiced => p_int_line_tbl(i).date_invoiced,
p_date_shipped => p_int_line_tbl(i).date_shipped,
p_credit_advice_date => p_int_line_tbl(i).credit_advice_date,
p_product_category_id => NULL,
p_category_name => NULL,
p_inventory_item_segment1 => p_int_line_tbl(i).inventory_item_segment1,
p_inventory_item_segment2 => p_int_line_tbl(i).inventory_item_segment2,
p_inventory_item_segment3 => p_int_line_tbl(i).inventory_item_segment3,
p_inventory_item_segment4 => p_int_line_tbl(i).inventory_item_segment4,
p_inventory_item_segment5 => p_int_line_tbl(i).inventory_item_segment5,
p_inventory_item_segment6 => p_int_line_tbl(i).inventory_item_segment6,
p_inventory_item_segment7 => p_int_line_tbl(i).inventory_item_segment7,
p_inventory_item_segment8 => p_int_line_tbl(i).inventory_item_segment8,
p_inventory_item_segment9 => p_int_line_tbl(i).inventory_item_segment9,
p_inventory_item_segment10 => p_int_line_tbl(i).inventory_item_segment10,
p_inventory_item_segment11 => p_int_line_tbl(i).inventory_item_segment11,
p_inventory_item_segment12 => p_int_line_tbl(i).inventory_item_segment12,
p_inventory_item_segment13 => p_int_line_tbl(i).inventory_item_segment13,
p_inventory_item_segment14 => p_int_line_tbl(i).inventory_item_segment14,
p_inventory_item_segment15 => p_int_line_tbl(i).inventory_item_segment15,
p_inventory_item_segment16 => p_int_line_tbl(i).inventory_item_segment16,
p_inventory_item_segment17 => p_int_line_tbl(i).inventory_item_segment17,
p_inventory_item_segment18 => p_int_line_tbl(i).inventory_item_segment18,
p_inventory_item_segment19 => p_int_line_tbl(i).inventory_item_segment19,
p_inventory_item_segment20 => p_int_line_tbl(i).inventory_item_segment20,
p_inventory_item_id => p_int_line_tbl(i).inventory_item_id,
p_item_description => NULL,
p_upc_code => p_int_line_tbl(i).upc_code,
p_item_number => NULL,
p_claimed_amount => p_int_line_tbl(i).claimed_amount,
p_purchase_price => p_int_line_tbl(i).purchase_price,
p_acctd_purchase_price => NULL,
p_net_adjusted_amount => NULL,
p_accepted_amount => l_amount,
p_total_accepted_amount => l_amount,
p_allowed_amount => l_amount,
p_total_allowed_amount => l_amount,
p_calculated_price => l_amount,
p_acctd_calculated_price => l_amount,
p_calculated_amount => l_amount,
p_line_tolerance_amount => NULL,
p_total_claimed_amount => p_int_line_tbl(i).total_claimed_amount,
p_credit_code => p_int_line_tbl(i).credit_code,
p_direct_customer_flag => NULL,
p_duplicated_line_id => NULL,
p_duplicated_adjustment_id => NULL,
p_order_type_id => NULL,
p_order_type => p_int_line_tbl(i).order_type,
p_order_category => p_int_line_tbl(i).order_category,
p_dispute_code => NULL,
p_data_source_code => p_int_line_tbl(i).data_source_code,
p_tracing_flag => p_int_line_tbl(i).tracing_flag,
p_header_attribute_category => p_int_line_tbl(i).header_attribute_category,
p_header_attribute1 => p_int_line_tbl(i).header_attribute1,
p_header_attribute2 => p_int_line_tbl(i).header_attribute2,
p_header_attribute3 => p_int_line_tbl(i).header_attribute3,
p_header_attribute4 => p_int_line_tbl(i).header_attribute4,
p_header_attribute5 => p_int_line_tbl(i).header_attribute5,
p_header_attribute6 => p_int_line_tbl(i).header_attribute6,
p_header_attribute7 => p_int_line_tbl(i).header_attribute7,
p_header_attribute8 => p_int_line_tbl(i).header_attribute8,
p_header_attribute9 => p_int_line_tbl(i).header_attribute9,
p_header_attribute10 => p_int_line_tbl(i).header_attribute10,
p_header_attribute11 => p_int_line_tbl(i).header_attribute11,
p_header_attribute12 => p_int_line_tbl(i).header_attribute12,
p_header_attribute13 => p_int_line_tbl(i).header_attribute13,
p_header_attribute14 => p_int_line_tbl(i).header_attribute14,
p_header_attribute15 => p_int_line_tbl(i).header_attribute15,
p_line_attribute_category => p_int_line_tbl(i).line_attribute_category,
p_line_attribute1 => p_int_line_tbl(i).line_attribute1,
p_line_attribute2 => p_int_line_tbl(i).line_attribute2,
p_line_attribute3 => p_int_line_tbl(i).line_attribute3,
p_line_attribute4 => p_int_line_tbl(i).line_attribute4,
p_line_attribute5 => p_int_line_tbl(i).line_attribute5,
p_line_attribute6 => p_int_line_tbl(i).line_attribute6,
p_line_attribute7 => p_int_line_tbl(i).line_attribute7,
p_line_attribute8 => p_int_line_tbl(i).line_attribute8,
p_line_attribute9 => p_int_line_tbl(i).line_attribute9,
p_line_attribute10 => p_int_line_tbl(i).line_attribute10,
p_line_attribute11 => p_int_line_tbl(i).line_attribute11,
p_line_attribute12 => p_int_line_tbl(i).line_attribute12,
p_line_attribute13 => p_int_line_tbl(i).line_attribute13,
p_line_attribute14 => p_int_line_tbl(i).line_attribute14,
p_line_attribute15 => p_int_line_tbl(i).line_attribute15,
px_org_id => l_org_id,
-- For Bug#9447673 SSD IDSM ER(+)
p_invoice_line_number => p_int_line_tbl(i).invoice_line_number,
p_order_line_number => p_int_line_tbl(i).order_line_number,
p_supplier_item_cost => p_int_line_tbl(i).supplier_item_cost,
p_supplier_item_uom => p_int_line_tbl(i).supplier_item_uom);
END insert_resale_int_line;