The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT name
FROM hr_operating_units
WHERE organization_id = l_org_id;
SELECT meaning
FROM FND_LOOKUPS
WHERE lookup_code = p_quote_type AND lookup_type = 'OKL_QUOTE_TYPE' AND enabled_flag = 'Y';
SELECT meaning
FROM FND_LOOKUPS
WHERE lookup_code = p_quote_reason AND lookup_type = 'OKL_QUOTE_REASON' AND enabled_flag = 'Y';
SELECT DISTINCT(quote_type_code) quote_type
FROM OKL_TERMNT_INTERFACE
WHERE status = 'ENTERED' AND quote_type_code IS NOT NULL;
SELECT COUNT(lookup_code) code
FROM FND_LOOKUPS
WHERE lookup_code = p_quote_type AND lookup_type = 'OKL_QUOTE_TYPE' AND enabled_flag = 'Y';
SELECT DISTINCT(quote_reason_code) quote_reason
FROM OKL_TERMNT_INTERFACE
WHERE status = 'ENTERED' AND quote_reason_code IS NOT NULL;
SELECT COUNT(lookup_code) code
FROM FND_LOOKUPS
WHERE lookup_code = p_quote_reason AND lookup_type = 'OKL_QUOTE_REASON' AND enabled_flag = 'Y';
SELECT id,sts_code,authoring_org_id
FROM okc_k_headers_b
WHERE contract_number=p_chr_no;
SELECT oklv.id id, oklv.name num, oklv.sts_code status, oklv.item_description description
FROM okc_k_lines_v oklv, okc_line_styles_v ols
WHERE oklv.chr_id= p_chr_id
AND ((oklv.name = p_ast_number)
OR (oklv.id = p_ast_id))
AND oklv.lse_id=ols.id
AND ols.lty_code = 'FREE_FORM1';
SELECT oklv.id id
FROM okc_k_lines_v oklv, okc_line_styles_v ols
WHERE oklv.cle_id = p_ast_id
AND oklv.lse_id=ols.id
AND ols.lty_code = 'FREE_FORM2';
SELECT oklv.id id
FROM okc_k_lines_v oklv, okc_line_styles_v ols
WHERE oklv.cle_id = p_instance_id
AND oklv.lse_id=ols.id
AND ols.lty_code = 'INST_ITEM';
SELECT oiiv.serial_number sno
FROM okc_k_items_v okiv,okx_install_items_v oiiv
WHERE okiv.cle_id = p_installbase_id
AND okiv.object1_id1=oiiv.instance_id;
SELECT current_units quantity
FROM OKX_ASSETS_V
WHERE asset_number = p_asset_number;
PROCEDURE update_row(p_api_version IN NUMBER,
p_init_msg_list IN VARCHAR2,
x_msg_count OUT NOCOPY NUMBER,
x_msg_data OUT NOCOPY VARCHAR2,
x_return_status OUT NOCOPY VARCHAR2,
p_tif_rec IN tif_rec_type) IS
l_api_version CONSTANT NUMBER := p_api_version;
UPDATE OKL_TERMNT_INTERFACE
SET
OKL_TERMNT_INTERFACE.TRANSACTION_NUMBER = p_tif_rec.transaction_number
,OKL_TERMNT_INTERFACE.BATCH_NUMBER = p_tif_rec.batch_number
,OKL_TERMNT_INTERFACE.CONTRACT_ID = p_tif_rec.contract_id
,OKL_TERMNT_INTERFACE.CONTRACT_NUMBER = p_tif_rec.contract_number
,OKL_TERMNT_INTERFACE.ASSET_ID = p_tif_rec.asset_id
,OKL_TERMNT_INTERFACE.ASSET_NUMBER = p_tif_rec.asset_number
,OKL_TERMNT_INTERFACE.ASSET_DESCRIPTION = p_tif_rec.asset_description
,OKL_TERMNT_INTERFACE.SERIAL_NUMBER = p_tif_rec.serial_number
,OKL_TERMNT_INTERFACE.ORIG_SYSTEM = p_tif_rec.orig_system
,OKL_TERMNT_INTERFACE.ORIG_SYSTEM_REFERENCE = p_tif_rec.orig_system_reference
,OKL_TERMNT_INTERFACE.UNITS_TO_TERMINATE = p_tif_rec.units_to_terminate
,OKL_TERMNT_INTERFACE.COMMENTS = p_tif_rec.comments
,OKL_TERMNT_INTERFACE.DATE_PROCESSED = p_tif_rec.date_processed
,OKL_TERMNT_INTERFACE.DATE_EFFECTIVE_FROM = p_tif_rec.date_effective_from
,OKL_TERMNT_INTERFACE.TERMINATION_NOTIFICATION_EMAIL = p_tif_rec.termination_notification_email
,OKL_TERMNT_INTERFACE.TERMINATION_NOTIFICATION_YN = p_tif_rec.termination_notification_yn
,OKL_TERMNT_INTERFACE.AUTO_ACCEPT_YN = p_tif_rec.auto_accept_yn
,OKL_TERMNT_INTERFACE.QUOTE_TYPE_CODE = p_tif_rec.quote_type_code
,OKL_TERMNT_INTERFACE.QUOTE_REASON_CODE = p_tif_rec.quote_reason_code
,OKL_TERMNT_INTERFACE.QTE_ID = p_tif_rec.qte_id
,OKL_TERMNT_INTERFACE.STATUS = p_tif_rec.status
,OKL_TERMNT_INTERFACE.ORG_ID = p_tif_rec.org_id
,OKL_TERMNT_INTERFACE.REQUEST_ID = NVL(decode(FND_GLOBAL.CONC_REQUEST_ID,-1, NULL,FND_GLOBAL.CONC_REQUEST_ID),p_tif_rec.request_id)
,OKL_TERMNT_INTERFACE.PROGRAM_APPLICATION_ID = NVL(decode(FND_GLOBAL.PROG_APPL_ID,-1,NULL,FND_GLOBAL.PROG_APPL_ID),p_tif_rec.program_application_id)
,OKL_TERMNT_INTERFACE.PROGRAM_ID = NVL(decode(FND_GLOBAL.CONC_PROGRAM_ID,-1,NULL,FND_GLOBAL.CONC_PROGRAM_ID),p_tif_rec.program_id)
,OKL_TERMNT_INTERFACE.PROGRAM_UPDATE_DATE = decode(decode(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,SYSDATE),NULL,p_tif_rec.program_update_date,SYSDATE)
,OKL_TERMNT_INTERFACE.ATTRIBUTE_CATEGORY = p_tif_rec.attribute_category
,OKL_TERMNT_INTERFACE.ATTRIBUTE1 = p_tif_rec.attribute1
,OKL_TERMNT_INTERFACE.ATTRIBUTE2 = p_tif_rec.attribute2
,OKL_TERMNT_INTERFACE.ATTRIBUTE3 = p_tif_rec.attribute3
,OKL_TERMNT_INTERFACE.ATTRIBUTE4 = p_tif_rec.attribute4
,OKL_TERMNT_INTERFACE.ATTRIBUTE5 = p_tif_rec.attribute5
,OKL_TERMNT_INTERFACE.ATTRIBUTE6 = p_tif_rec.attribute6
,OKL_TERMNT_INTERFACE.ATTRIBUTE7 = p_tif_rec.attribute7
,OKL_TERMNT_INTERFACE.ATTRIBUTE8 = p_tif_rec.attribute8
,OKL_TERMNT_INTERFACE.ATTRIBUTE9 = p_tif_rec.attribute9
,OKL_TERMNT_INTERFACE.ATTRIBUTE10 = p_tif_rec.attribute10
,OKL_TERMNT_INTERFACE.ATTRIBUTE11 = p_tif_rec.attribute11
,OKL_TERMNT_INTERFACE.ATTRIBUTE12 = p_tif_rec.attribute12
,OKL_TERMNT_INTERFACE.ATTRIBUTE13 = p_tif_rec.attribute13
,OKL_TERMNT_INTERFACE.ATTRIBUTE14 = p_tif_rec.attribute14
,OKL_TERMNT_INTERFACE.ATTRIBUTE15 = p_tif_rec.attribute15
,OKL_TERMNT_INTERFACE.CREATED_BY = p_tif_rec.created_by
,OKL_TERMNT_INTERFACE.CREATION_DATE = p_tif_rec.creation_date
,OKL_TERMNT_INTERFACE.LAST_UPDATED_BY = FND_GLOBAL.USER_ID
,OKL_TERMNT_INTERFACE.LAST_UPDATE_DATE = SYSDATE
,OKL_TERMNT_INTERFACE.LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID
,OKL_TERMNT_INTERFACE.GROUP_NUMBER = p_tif_rec.group_number
WHERE
OKL_TERMNT_INTERFACE.ROWID =p_tif_rec.row_id;
l_msg_tbl(0).msg_text := 'update_row:ended with unexpected error sqlcode: '||sqlcode||' sqlerrm: '||sqlerrm;
END update_row;
SELECT
ROWID
,TRANSACTION_NUMBER
,BATCH_NUMBER
,CONTRACT_ID
,CONTRACT_NUMBER
,ASSET_ID
,ASSET_NUMBER
,ASSET_DESCRIPTION
,SERIAL_NUMBER
,ORIG_SYSTEM
,ORIG_SYSTEM_REFERENCE
,UNITS_TO_TERMINATE
,COMMENTS
,DATE_PROCESSED
,DATE_EFFECTIVE_FROM
,TERMINATION_NOTIFICATION_EMAIL
,TERMINATION_NOTIFICATION_YN
,AUTO_ACCEPT_YN
,QUOTE_TYPE_CODE
,QUOTE_REASON_CODE
,QTE_ID
,STATUS
,ORG_ID
,REQUEST_ID
,PROGRAM_APPLICATION_ID
,PROGRAM_ID
,PROGRAM_UPDATE_DATE
,ATTRIBUTE_CATEGORY
,ATTRIBUTE1
,ATTRIBUTE2
,ATTRIBUTE3
,ATTRIBUTE4
,ATTRIBUTE5
,ATTRIBUTE6
,ATTRIBUTE7
,ATTRIBUTE8
,ATTRIBUTE9
,ATTRIBUTE10
,ATTRIBUTE11
,ATTRIBUTE12
,ATTRIBUTE13
,ATTRIBUTE14
,ATTRIBUTE15
,CREATED_BY
,CREATION_DATE
,LAST_UPDATED_BY
,LAST_UPDATE_DATE
,LAST_UPDATE_LOGIN
,GROUP_NUMBER
FROM OKL_TERMNT_INTERFACE
WHERE status = p_status
ORDER BY CONTRACT_NUMBER,QUOTE_TYPE_CODE,DATE_EFFECTIVE_FROM,QUOTE_REASON_CODE,ASSET_ID;
update_row(p_api_version => p_api_version
,p_init_msg_list => OKC_API.G_FALSE
,x_msg_data => x_msg_data
,x_msg_count => x_msg_count
,x_return_status => x_return_status
,p_tif_rec => p_tif_tbl(record_number));
'update_row for : '||record_number||':'||x_return_status);
x_tif_tbl.DELETE;
x_tif_tbl(record_number).program_update_date := termnt_rec.program_update_date;
x_tif_tbl(record_number).last_updated_by := termnt_rec.last_updated_by;
x_tif_tbl(record_number).last_update_date := termnt_rec.last_update_date;
x_tif_tbl(record_number).last_update_login := termnt_rec.last_update_login;
SELECT current_units quantity
FROM OKX_ASSETS_V
WHERE asset_number = p_asset_number;
SELECT oklv.id id
FROM okc_k_lines_v oklv, okc_line_styles_v ols
WHERE oklv.cle_id = p_ast_id
AND oklv.lse_id=ols.id
AND ols.lty_code = 'FREE_FORM2';
SELECT oklv.id id
FROM okc_k_lines_v oklv, okc_line_styles_v ols
WHERE oklv.cle_id = p_instance_id
AND oklv.lse_id=ols.id
AND ols.lty_code = 'INST_ITEM';
SELECT oiiv.serial_number sno,oiiv.quantity qty
FROM okc_k_items_v okiv,okx_install_items_v oiiv
WHERE okiv.cle_id = p_installbase_id
AND okiv.object1_id1=oiiv.instance_id;
SELECT trunc(SYSDATE) INTO l_sys_date FROM DUAL;
lp_qld_tbl(qdt_counter).SELECT_YN := 'Y';
lp_qld_tbl.DELETE;
lp_assn_tbl.DELETE;
lp_tif_tbl.DELETE;
lx_tif_tbl.DELETE;
x_tif_tbl.DELETE;
update_row(p_api_version => p_api_version
,p_init_msg_list => OKC_API.G_FALSE
,x_msg_data => x_msg_data
,x_msg_count => x_msg_count
,x_return_status => x_return_status
,p_tif_rec => x_tif_tbl(record_number));
SELECT contract_id,status
FROM OKL_TERMNT_INTERFACE
WHERE transaction_number = p_transaction_number;
SELECT id,object1_id1,object1_id2,jtot_object1_code
FROM OKC_K_PARTY_ROLES_B
WHERE dnz_chr_id = p_chr_id
AND chr_id = dnz_chr_id
AND rle_code = p_role_code;
SELECT party_number,name
FROM OKX_VENDORS_V
WHERE id1 = p_object1_id1 AND id2 = p_object1_id2;
SELECT party_name,party_number,email_address
FROM HZ_PARTIES
WHERE ((party_id = p_object1_id1) AND party_type IN ( 'PERSON','ORGANIZATION'));
select count(*) from OKL_TERMNT_INTERFACE
where transaction_number = p_transaction_number;
PROCEDURE update_party(p_api_version IN NUMBER,
p_init_msg_list IN VARCHAR2,
x_msg_count OUT NOCOPY NUMBER,
x_msg_data OUT NOCOPY VARCHAR2,
x_return_status OUT NOCOPY VARCHAR2,
p_tip_rec IN tip_rec_type) IS
l_api_version CONSTANT NUMBER := p_api_version;
UPDATE OKL_TERMNT_INTF_PTY
SET
OKL_TERMNT_INTF_PTY.CONTRACT_PARTY_ID = p_tip_rec.contract_party_id,
OKL_TERMNT_INTF_PTY.CONTRACT_PARTY_ROLE = p_tip_rec.contract_party_role,
OKL_TERMNT_INTF_PTY.CONTRACT_PARTY_NAME = p_tip_rec.contract_party_name,
OKL_TERMNT_INTF_PTY.CONTRACT_PARTY_NUMBER = p_tip_rec.contract_party_number,
OKL_TERMNT_INTF_PTY.PARTY_OBJECT_CODE = p_tip_rec.party_object_code,
OKL_TERMNT_INTF_PTY.PARTY_OBJECT_ID1 = p_tip_rec.party_object_id1,
OKL_TERMNT_INTF_PTY.PARTY_OBJECT_ID2 = p_tip_rec.party_object_id2,
OKL_TERMNT_INTF_PTY.EMAIL_ADDRESS = p_tip_rec.email_address,
OKL_TERMNT_INTF_PTY.ALLOCATION_PERCENTAGE = p_tip_rec.allocation_percentage,
OKL_TERMNT_INTF_PTY.DELAY_DAYS = p_tip_rec.delay_days,
OKL_TERMNT_INTF_PTY.QPY_ID = p_tip_rec.qpy_id,
OKL_TERMNT_INTF_PTY.TRANSACTION_NUMBER = p_tip_rec.transaction_number,
OKL_TERMNT_INTF_PTY.STATUS = p_tip_rec.status,
OKL_TERMNT_INTF_PTY.REQUEST_ID = NVL(decode(FND_GLOBAL.CONC_REQUEST_ID,-1, NULL,FND_GLOBAL.CONC_REQUEST_ID),p_tip_rec.request_id),
OKL_TERMNT_INTF_PTY.PROGRAM_APPLICATION_ID = NVL(decode(FND_GLOBAL.PROG_APPL_ID,-1,NULL,FND_GLOBAL.PROG_APPL_ID),p_tip_rec.program_application_id),
OKL_TERMNT_INTF_PTY.PROGRAM_ID = NVL(decode(FND_GLOBAL.CONC_PROGRAM_ID,-1,NULL,FND_GLOBAL.CONC_PROGRAM_ID),p_tip_rec.program_id),
OKL_TERMNT_INTF_PTY.PROGRAM_UPDATE_DATE = decode(decode(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,SYSDATE),NULL,p_tip_rec.program_update_date,SYSDATE),
OKL_TERMNT_INTF_PTY.ATTRIBUTE_CATEGORY = p_tip_rec.attribute_category,
OKL_TERMNT_INTF_PTY.ATTRIBUTE1 = p_tip_rec.attribute1,
OKL_TERMNT_INTF_PTY.ATTRIBUTE2 = p_tip_rec.attribute2,
OKL_TERMNT_INTF_PTY.ATTRIBUTE3 = p_tip_rec.attribute3,
OKL_TERMNT_INTF_PTY.ATTRIBUTE4 = p_tip_rec.attribute4,
OKL_TERMNT_INTF_PTY.ATTRIBUTE5 = p_tip_rec.attribute5,
OKL_TERMNT_INTF_PTY.ATTRIBUTE6 = p_tip_rec.attribute6,
OKL_TERMNT_INTF_PTY.ATTRIBUTE7 = p_tip_rec.attribute7,
OKL_TERMNT_INTF_PTY.ATTRIBUTE8 = p_tip_rec.attribute8,
OKL_TERMNT_INTF_PTY.ATTRIBUTE9 = p_tip_rec.attribute9,
OKL_TERMNT_INTF_PTY.ATTRIBUTE10 = p_tip_rec.attribute10,
OKL_TERMNT_INTF_PTY.ATTRIBUTE11 = p_tip_rec.attribute11,
OKL_TERMNT_INTF_PTY.ATTRIBUTE12 = p_tip_rec.attribute12,
OKL_TERMNT_INTF_PTY.ATTRIBUTE13 = p_tip_rec.attribute13,
OKL_TERMNT_INTF_PTY.ATTRIBUTE14 = p_tip_rec.attribute14,
OKL_TERMNT_INTF_PTY.ATTRIBUTE15 = p_tip_rec.attribute15,
OKL_TERMNT_INTF_PTY.CREATED_BY = p_tip_rec.created_by,
OKL_TERMNT_INTF_PTY.CREATION_DATE = p_tip_rec.creation_date,
OKL_TERMNT_INTF_PTY.LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
OKL_TERMNT_INTF_PTY.LAST_UPDATE_DATE = SYSDATE,
OKL_TERMNT_INTF_PTY.LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID,
OKL_TERMNT_INTF_PTY.QUOTE_ROLE_CODE = p_tip_rec.quote_role_code
WHERE
OKL_TERMNT_INTF_PTY.ROWID =p_tip_rec.row_id;
l_msg_tbl(0).msg_text := 'update_party:ended with unexpected error sqlcode: '||sqlcode||' sqlerrm: '||sqlerrm;
END update_party;
PROCEDURE select_party_info(
p_api_version IN NUMBER,
p_init_msg_list IN VARCHAR2,
x_msg_count OUT NOCOPY NUMBER,
x_msg_data OUT NOCOPY VARCHAR2,
x_return_status OUT NOCOPY VARCHAR2,
p_tip_tbl IN tip_tbl_type,
x_tip_tbl OUT NOCOPY tip_tbl_type,
p_pty_status IN VARCHAR2
) IS
record_number NUMBER;
SELECT
ROWID
,CONTRACT_PARTY_ID
,CONTRACT_PARTY_ROLE
,CONTRACT_PARTY_NAME
,CONTRACT_PARTY_NUMBER
,PARTY_OBJECT_CODE
,PARTY_OBJECT_ID1
,PARTY_OBJECT_ID2
,EMAIL_ADDRESS
,ALLOCATION_PERCENTAGE
,DELAY_DAYS
,QPY_ID
,TRANSACTION_NUMBER
,STATUS
,REQUEST_ID
,PROGRAM_APPLICATION_ID
,PROGRAM_ID
,PROGRAM_UPDATE_DATE
,ATTRIBUTE_CATEGORY
,ATTRIBUTE1
,ATTRIBUTE2
,ATTRIBUTE3
,ATTRIBUTE4
,ATTRIBUTE5
,ATTRIBUTE6
,ATTRIBUTE7
,ATTRIBUTE8
,ATTRIBUTE9
,ATTRIBUTE10
,ATTRIBUTE11
,ATTRIBUTE12
,ATTRIBUTE13
,ATTRIBUTE14
,ATTRIBUTE15
,CREATED_BY
,CREATION_DATE
,LAST_UPDATED_BY
,LAST_UPDATE_DATE
,LAST_UPDATE_LOGIN
,QUOTE_ROLE_CODE
FROM OKL_TERMNT_INTF_PTY
WHERE STATUS = P_STATUS
ORDER BY TRANSACTION_NUMBER;
FND_LOG.STRING(G_DEBUG_LEVEL_PROCEDURE,'OKL_AM_TERMNT_INTERFACE_PVT.select_party_info','Begin(+)');
FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,'OKL_AM_TERMNT_INTERFACE_PVT.select_party_info.',
'p_tip_tbl.COUNT : '||p_tip_tbl.COUNT);
FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,'OKL_AM_TERMNT_INTERFACE_PVT.select_party_info.',
'record_number : '||record_number);
FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,'OKL_AM_TERMNT_INTERFACE_PVT.select_party_info.',
'inside p_tip_tbl.COUNT > 0 LOOP : '||record_number
|| 'transaction number' || p_tip_tbl(record_number).transaction_number
|| 'email address ' || p_tip_tbl(record_number).email_address);
update_party(p_api_version => p_api_version
,p_init_msg_list => OKC_API.G_FALSE
,x_msg_data => x_msg_data
,x_msg_count => x_msg_count
,x_return_status => x_return_status
,p_tip_rec => p_tip_tbl(record_number));
x_tip_tbl.DELETE;
FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,'OKL_AM_TERMNT_INTERFACE_PVT.select_party_info.',
' p_pty_status = ' || p_pty_status );
x_tip_tbl(record_number).program_update_date := party_rec.program_update_date;
x_tip_tbl(record_number).last_updated_by := party_rec.last_updated_by;
x_tip_tbl(record_number).last_update_date := party_rec.last_update_date;
x_tip_tbl(record_number).last_update_login := party_rec.last_update_login;
FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,'OKL_AM_TERMNT_INTERFACE_PVT.select_party_info.',
' inside party loop : '||record_number||
' transaction_number :'||x_tip_tbl(record_number).transaction_number ||
' email address : '||x_tip_tbl(record_number).email_address);
FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,'OKL_AM_TERMNT_INTERFACE_PVT.select_party_info.',
' total records = ' || record_number );
FND_LOG.STRING(G_DEBUG_LEVEL_PROCEDURE,'OKL_AM_TERMNT_INTERFACE_PVT.select_party_info','End(+)');
l_msg_tbl(0).msg_text := 'select_party_info:ended with unexpected error sqlcode: '||sqlcode||' sqlerrm: '||sqlerrm;
END select_party_info;
lx_tif_tbl.DELETE;
l_lessee_tif_tbl.delete;
lx_tif_tbl.delete;
'Update Party to Processed = ' || l_lessee_tip_tbl(i).transaction_number );
update_party(
p_api_version => p_api_version ,
p_init_msg_list => OKC_API.G_FALSE ,
x_msg_data => x_msg_data ,
x_msg_count => x_msg_count ,
x_return_status => x_return_status ,
p_tip_rec => l_lessee_tip_tbl(i));
'Update interface record group number for :' || l_lessee_tif_tbl(i).transaction_number ||
' group number = ' ||group_number );
update_row(
p_api_version => p_api_version ,
p_init_msg_list => OKC_API.G_FALSE ,
x_msg_data => x_msg_data ,
x_msg_count => x_msg_count ,
x_return_status => x_return_status ,
p_tif_rec => l_lessee_tif_tbl(i));
'Update Party to Errored = ' || l_lessee_tip_tbl(i).transaction_number );
update_party(
p_api_version => p_api_version ,
p_init_msg_list => OKC_API.G_FALSE ,
x_msg_data => x_msg_data ,
x_msg_count => x_msg_count ,
x_return_status => x_return_status ,
p_tip_rec => l_lessee_tip_tbl(i));
l_lessee_tif_tbl.delete;
'Update Party to Errored = ' || l_lessee_tip_tbl(i).transaction_number );
update_party(
p_api_version => p_api_version ,
p_init_msg_list => OKC_API.G_FALSE ,
x_msg_data => x_msg_data ,
x_msg_count => x_msg_count ,
x_return_status => x_return_status ,
p_tip_rec => l_lessee_tip_tbl(i));
lx_tif_tbl.DELETE;
l_vendor_tif_tbl.delete;
lx_tif_tbl.delete;
'Update Party to processed = ' || l_vendor_tip_tbl(i).transaction_number );
update_party(
p_api_version => p_api_version ,
p_init_msg_list => OKC_API.G_FALSE ,
x_msg_data => x_msg_data ,
x_msg_count => x_msg_count ,
x_return_status => x_return_status ,
p_tip_rec => l_vendor_tip_tbl(i));
'Update interface record group number for ' || l_vendor_tif_tbl(i).transaction_number ||
'group number = ' ||group_number );
update_row(
p_api_version => p_api_version ,
p_init_msg_list => OKC_API.G_FALSE ,
x_msg_data => x_msg_data ,
x_msg_count => x_msg_count ,
x_return_status => x_return_status ,
p_tif_rec => l_vendor_tif_tbl(i));
'Update Party to Error = ' || l_vendor_tip_tbl(i).transaction_number );
update_party(
p_api_version => p_api_version ,
p_init_msg_list => OKC_API.G_FALSE ,
x_msg_data => x_msg_data ,
x_msg_count => x_msg_count ,
x_return_status => x_return_status ,
p_tip_rec => l_vendor_tip_tbl(i));
l_vendor_tif_tbl.delete;
'Update Party to Error = ' || l_vendor_tip_tbl(i).transaction_number);
update_party(
p_api_version => p_api_version ,
p_init_msg_list => OKC_API.G_FALSE ,
x_msg_data => x_msg_data ,
x_msg_count => x_msg_count ,
x_return_status => x_return_status ,
p_tip_rec => l_vendor_tip_tbl(i));
lp_assn_tbl.DELETE;
lx_tif_tbl.DELETE;
l_lessee_tip_tbl.DELETE;
l_vendor_tip_tbl.DELETE;
lp_lessee_assn_tbl.DELETE;
lp_vendor_assn_tbl.DELETE;
l_lessee_tif_tbl.DELETE;
l_vendor_tif_tbl.DELETE;
lx_tif_tbl.DELETE;
l_lessee_tif_tbl.DELETE;
lx_tif_tbl.DELETE;
'Update Party to processed = ' || l_lessee_tip_tbl(i).transaction_number );
update_party(
p_api_version => p_api_version ,
p_init_msg_list => OKC_API.G_FALSE ,
x_msg_data => x_msg_data ,
x_msg_count => x_msg_count ,
x_return_status => x_return_status ,
p_tip_rec => l_lessee_tip_tbl(i));
'Update interface record group number for ' || l_lessee_tip_tbl(i).transaction_number ||
' group number = ' ||group_number );
update_row(
p_api_version => p_api_version ,
p_init_msg_list => OKC_API.G_FALSE ,
x_msg_data => x_msg_data ,
x_msg_count => x_msg_count ,
x_return_status => x_return_status ,
p_tif_rec => l_lessee_tif_tbl(i));
'Update Party to Error = ' || l_lessee_tip_tbl(i).transaction_number);
update_party(
p_api_version => p_api_version ,
p_init_msg_list => OKC_API.G_FALSE ,
x_msg_data => x_msg_data ,
x_msg_count => x_msg_count ,
x_return_status => x_return_status ,
p_tip_rec => l_lessee_tip_tbl(i));
l_lessee_tif_tbl.delete;
'Update Party to Error = ' || l_lessee_tip_tbl(i).transaction_number );
update_party(
p_api_version => p_api_version ,
p_init_msg_list => OKC_API.G_FALSE ,
x_msg_data => x_msg_data ,
x_msg_count => x_msg_count ,
x_return_status => x_return_status ,
p_tip_rec => l_lessee_tip_tbl(i));
lx_tif_tbl.DELETE;
l_vendor_tif_tbl.DELETE;
lx_tif_tbl.DELETE;
'Update Party to processed = ' || l_vendor_tip_tbl(i).transaction_number );
update_party(
p_api_version => p_api_version ,
p_init_msg_list => OKC_API.G_FALSE ,
x_msg_data => x_msg_data ,
x_msg_count => x_msg_count ,
x_return_status => x_return_status ,
p_tip_rec => l_vendor_tip_tbl(i));
'Update interface record group number = ' || l_vendor_tip_tbl(i).transaction_number ||
'group number = ' ||group_number );
update_row(
p_api_version => p_api_version ,
p_init_msg_list => OKC_API.G_FALSE ,
x_msg_data => x_msg_data ,
x_msg_count => x_msg_count ,
x_return_status => x_return_status ,
p_tif_rec => l_vendor_tif_tbl(i));
'Update Party to Error = ' || l_vendor_tip_tbl(i).transaction_number );
update_party(
p_api_version => p_api_version ,
p_init_msg_list => OKC_API.G_FALSE ,
x_msg_data => x_msg_data ,
x_msg_count => x_msg_count ,
x_return_status => x_return_status ,
p_tip_rec => l_vendor_tip_tbl(i));
l_vendor_tif_tbl.delete;
'Update Party to Error = ' || l_vendor_tip_tbl(i).transaction_number );
update_party(
p_api_version => p_api_version ,
p_init_msg_list => OKC_API.G_FALSE ,
x_msg_data => x_msg_data ,
x_msg_count => x_msg_count ,
x_return_status => x_return_status ,
p_tip_rec => l_vendor_tip_tbl(i));
l_tip_tbl.DELETE;
x_tif_tbl.DELETE;
x_out_tif_tbl.DELETE;
SELECT
ROWID
,TRANSACTION_NUMBER
,BATCH_NUMBER
,CONTRACT_ID
,CONTRACT_NUMBER
,ASSET_ID
,ASSET_NUMBER
,ASSET_DESCRIPTION
,SERIAL_NUMBER
,ORIG_SYSTEM
,ORIG_SYSTEM_REFERENCE
,UNITS_TO_TERMINATE
,COMMENTS
,DATE_PROCESSED
,DATE_EFFECTIVE_FROM
,TERMINATION_NOTIFICATION_EMAIL
,TERMINATION_NOTIFICATION_YN
,AUTO_ACCEPT_YN
,QUOTE_TYPE_CODE
,QUOTE_REASON_CODE
,QTE_ID
,STATUS
,ORG_ID
,REQUEST_ID
,PROGRAM_APPLICATION_ID
,PROGRAM_ID
,PROGRAM_UPDATE_DATE
,ATTRIBUTE_CATEGORY
,ATTRIBUTE1
,ATTRIBUTE2
,ATTRIBUTE3
,ATTRIBUTE4
,ATTRIBUTE5
,ATTRIBUTE6
,ATTRIBUTE7
,ATTRIBUTE8
,ATTRIBUTE9
,ATTRIBUTE10
,ATTRIBUTE11
,ATTRIBUTE12
,ATTRIBUTE13
,ATTRIBUTE14
,ATTRIBUTE15
,CREATED_BY
,CREATION_DATE
,LAST_UPDATED_BY
,LAST_UPDATE_DATE
,LAST_UPDATE_LOGIN
,GROUP_NUMBER
FROM OKL_TERMNT_INTERFACE
WHERE status = p_status
ORDER BY CONTRACT_NUMBER,TRANSACTION_NUMBER; --sechawla 02-Aug-2011 12745559 : added transaction_number
SELECT trunc(SYSDATE) INTO l_sys_date FROM DUAL;
l_tif_tbl(record_number).program_update_date := termnt_rec.program_update_date;
l_tif_tbl(record_number).last_updated_by := termnt_rec.last_updated_by;
l_tif_tbl(record_number).last_update_date := termnt_rec.last_update_date;
l_tif_tbl(record_number).last_update_login := termnt_rec.last_update_login;
l_tif_tbl.DELETE;
lx_tif_tbl.DELETE;
l_tif_tbl.DELETE;
lx_tif_tbl.DELETE;
l_tif_tbl.DELETE;
lx_tif_tbl.DELETE;
'Before select_party_info : '||l_tip_tbl.count || 'l_tif_tbl count'|| l_tif_tbl.count);
select_party_info(p_api_version => l_api_version,
p_init_msg_list => OKC_API.G_FALSE,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data,
x_return_status => x_return_status,
p_tip_tbl => l_tip_tbl,
x_tip_tbl => lx_tip_tbl,
p_pty_status => 'ENTERED');
'after select_party_info : '||x_return_status);
'after select_party_info : party 0 '||lx_tip_tbl(0).transaction_number);
'after select_party_info : party 1 '||lx_tip_tbl(1).transaction_number);
'After select_party_info : '||lx_tip_tbl.count);
l_tip_tbl.DELETE;
lx_tip_tbl.DELETE;
l_tip_tbl.DELETE;
lx_tip_tbl.DELETE;
l_tif_tbl.DELETE;
lx_tif_tbl.DELETE;
select_party_info(p_api_version => l_api_version,
p_init_msg_list => OKC_API.G_FALSE,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data,
x_return_status => x_return_status,
p_tip_tbl => l_tip_tbl,
x_tip_tbl => lx_tip_tbl,
p_pty_status => 'WORKING');
'after select_party_info : '||x_return_status);
'after select_party_info : party 0 '||lx_tip_tbl(0).transaction_number);
'after select_party_info : party 1 '||lx_tip_tbl(1).transaction_number);
l_tip_tbl.DELETE;
lx_tip_tbl.DELETE;
l_tif_tbl.DELETE;
lx_tif_tbl.DELETE;
l_tif_tbl.DELETE;
lx_tif_tbl.DELETE;