[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT
ID,
DELINK_YN,
-- SECHAWLA 28-SEP-04 3924244: Added new columns - begin
REMK_SUBINVENTORY,
REMK_ORGANIZATION_ID,
REMK_PRICE_LIST_ID ,
REMK_PROCESS_CODE ,
REMK_ITEM_TEMPLATE_ID ,
REMK_ITEM_INVOICED_CODE ,
-- SECHAWLA 28-SEP-04 3924244: Added new columns - end
-- PAGARG 24-JAN-05 4044659: Added new columns - begin
LEASE_INV_ORG_YN,
-- PAGARG 24-JAN-05 4044659: Added new columns - end
--SECHAWLA 28-MAR-05 4274575 : Added new columns - begin
TAX_UPFRONT_YN,
TAX_INVOICE_YN,
TAX_SCHEDULE_YN,
--SECHAWLA 28-MAR-05 4274575 : Added new columns - end
-- SECHAWLA 26-AUG-05 : added new col begin
TAX_UPFRONT_STY_ID,
-- SECHAWLA 26-AUG-05 : added new col end
-- asawanka 24-MAY-05 : Added the new column CATEGORY_SET_ID for Pricing Enhancements : begin
CATEGORY_SET_ID,
-- asawanka 24-MAY-05 : Added the new column CATEGORY_SET_ID for Pricing Enhancements : end
-- ssdeshpa 2-SEP-05 : Added the new column VALIDATION_SET_ID for Sales Quote Enhancements :
VALIDATION_SET_ID,
-- ssdeshpa 2-SEP-05 : Added the new column VALIDATION_SET_ID for Sales Quote Enhancements :
CANCEL_QUOTES_YN, --RMUNJULU 4508497
CHK_ACCRUAL_PREVIOUS_MNTH_YN, --rmunjulu 4769094
-- gboomina 10-Apr-2005 - Added New Columns for Bug 5128517 - start
TASK_TEMPLATE_GROUP_ID,
OWNER_TYPE_CODE,
OWNER_ID,
-- gboomina Bug 5128517 - End
-- dcshanmu MOAC change start
ITEM_INV_ORG_ID,
RPT_PROD_BOOK_TYPE_CODE,
ASST_ADD_BOOK_TYPE_CODE,
CCARD_REMITTANCE_ID,
-- dcshanmu MOAC change end
-- DJANASWA Bug 6653304 start
CORPORATE_BOOK,
TAX_BOOK_1,
TAX_BOOK_2,
DEPRECIATE_YN,
FA_LOCATION_ID,
FORMULA_ID,
ASSET_KEY_ID,
-- DJANASWA Bug 6653304 end
-- Bug 5568328
PART_TRMNT_APPLY_ROUND_DIFF,
OBJECT_VERSION_NUMBER,
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,
--Bug 7022258-Added by kkorrapo
LSEAPP_SEQ_PREFIX_TXT,
LSEOPP_SEQ_PREFIX_TXT,
QCKQTE_SEQ_PREFIX_TXT,
LSEQTE_SEQ_PREFIX_TXT
--Bug 7022258--Addition end
FROM OKL_SYSTEM_PARAMS
WHERE OKL_SYSTEM_PARAMS.id = p_id;
l_sypv_rec.program_update_date,
l_sypv_rec.attribute_category,
l_sypv_rec.attribute1,
l_sypv_rec.attribute2,
l_sypv_rec.attribute3,
l_sypv_rec.attribute4,
l_sypv_rec.attribute5,
l_sypv_rec.attribute6,
l_sypv_rec.attribute7,
l_sypv_rec.attribute8,
l_sypv_rec.attribute9,
l_sypv_rec.attribute10,
l_sypv_rec.attribute11,
l_sypv_rec.attribute12,
l_sypv_rec.attribute13,
l_sypv_rec.attribute14,
l_sypv_rec.attribute15,
l_sypv_rec.created_by,
l_sypv_rec.creation_date,
l_sypv_rec.last_updated_by,
l_sypv_rec.last_update_date,
l_sypv_rec.last_update_login,
--Bug 7022258-Added by kkorrapo
l_sypv_rec.lseapp_seq_prefix_txt,
l_sypv_rec.lseopp_seq_prefix_txt,
l_sypv_rec.qckqte_seq_prefix_txt,
l_sypv_rec.lseqte_seq_prefix_txt;
SELECT
ID,
DELINK_YN,
-- SECHAWLA 28-SEP-04 3924244: Added new columns - begin
REMK_SUBINVENTORY,
REMK_ORGANIZATION_ID,
REMK_PRICE_LIST_ID ,
REMK_PROCESS_CODE ,
REMK_ITEM_TEMPLATE_ID ,
REMK_ITEM_INVOICED_CODE ,
-- SECHAWLA 28-SEP-04 3924244: Added new columns - end
-- PAGARG 24-JAN-05 4044659: Added new columns - begin
LEASE_INV_ORG_YN,
-- PAGARG 24-JAN-05 4044659: Added new columns - end
--SECHAWLA 28-MAR-05 4274575 : Added new columns - begin
TAX_UPFRONT_YN,
TAX_INVOICE_YN,
TAX_SCHEDULE_YN,
--SECHAWLA 28-MAR-05 4274575 : Added new columns - end
-- SECHAWLA 26-AUG-05 : added new col begin
TAX_UPFRONT_STY_ID,
-- SECHAWLA 26-AUG-05 : added new col end
-- asawanka 24-MAY-05 : Added the new column CATEGORY_SET_ID for Pricing Enhancements : begin
CATEGORY_SET_ID,
-- asawanka 24-MAY-05 : Added the new column CATEGORY_SET_ID for Pricing Enhancements : end
-- ssdeshpa 2-SEP-05 : Added the new column VALIDATION_SET_ID for Sales Quote Enhancements :
VALIDATION_SET_ID,
-- ssdeshpa 2-SEP-05 : Added the new column VALIDATION_SET_ID for Sales Quote Enhancements :
CANCEL_QUOTES_YN, --RMUNJULU 4508497
CHK_ACCRUAL_PREVIOUS_MNTH_YN, --rmunjulu 4769094
-- gboomina 10-Apr-2005 - Added New Columns for Bug 5128517 - start
TASK_TEMPLATE_GROUP_ID,
OWNER_TYPE_CODE,
OWNER_ID,
-- gboomina Bug 5128517 - End
-- dcshanmu MOAC Change starts
ITEM_INV_ORG_ID,
RPT_PROD_BOOK_TYPE_CODE,
ASST_ADD_BOOK_TYPE_CODE,
CCARD_REMITTANCE_ID,
-- dcshanmu MOAC Change end
-- DJANASWA Bug 6653304 start
CORPORATE_BOOK,
TAX_BOOK_1,
TAX_BOOK_2,
DEPRECIATE_YN,
FA_LOCATION_ID,
FORMULA_ID,
ASSET_KEY_ID,
-- DJANASWA Bug 6653304 end
--Bug 5568328
PART_TRMNT_APPLY_ROUND_DIFF,
OBJECT_VERSION_NUMBER,
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,
--Bug 7022258-Added by kkorrapo
LSEAPP_SEQ_PREFIX_TXT,
LSEOPP_SEQ_PREFIX_TXT,
QCKQTE_SEQ_PREFIX_TXT,
LSEQTE_SEQ_PREFIX_TXT
--Bug 7022258--Addition end
FROM OKL_SYSTEM_PARAMS_ALL
WHERE OKL_SYSTEM_PARAMS_ALL.id = p_id;
l_syp_rec.program_update_date,
l_syp_rec.attribute_category,
l_syp_rec.attribute1,
l_syp_rec.attribute2,
l_syp_rec.attribute3,
l_syp_rec.attribute4,
l_syp_rec.attribute5,
l_syp_rec.attribute6,
l_syp_rec.attribute7,
l_syp_rec.attribute8,
l_syp_rec.attribute9,
l_syp_rec.attribute10,
l_syp_rec.attribute11,
l_syp_rec.attribute12,
l_syp_rec.attribute13,
l_syp_rec.attribute14,
l_syp_rec.attribute15,
l_syp_rec.created_by,
l_syp_rec.creation_date,
l_syp_rec.last_updated_by,
l_syp_rec.last_update_date,
l_syp_rec.last_update_login,
--Bug 7022258-Added by kkorrapo
l_syp_rec.lseapp_seq_prefix_txt,
l_syp_rec.lseopp_seq_prefix_txt,
l_syp_rec.qckqte_seq_prefix_txt,
l_syp_rec.lseqte_seq_prefix_txt;
IF (l_sypv_rec.program_update_date = OKL_API.G_MISS_DATE ) THEN
l_sypv_rec.program_update_date := NULL;
IF (l_sypv_rec.last_updated_by = OKL_API.G_MISS_NUM ) THEN
l_sypv_rec.last_updated_by := NULL;
IF (l_sypv_rec.last_update_date = OKL_API.G_MISS_DATE ) THEN
l_sypv_rec.last_update_date := NULL;
IF (l_sypv_rec.last_update_login = OKL_API.G_MISS_NUM ) THEN
l_sypv_rec.last_update_login := NULL;
SELECT 'x'
FROM okl_strm_type_b
WHERE id = p_id;
SELECT 'x'
FROM ORG_ORGANIZATION_DEFINITIONS
WHERE ORGANIZATION_ID = cp_org_id
AND SYSDATE <= NVL( DISABLE_DATE, SYSDATE );
SELECT 'x'
FROM MTL_SECONDARY_INVENTORIES
WHERE SECONDARY_INVENTORY_NAME = cp_SECONDARY_INVENTORY_NAME
AND NVL(DISABLE_DATE, SYSDATE+1) > SYSDATE
AND LOCATOR_TYPE=1
AND ASSET_INVENTORY = 1
AND RESERVABLE_TYPE=1;
SELECT 'x'
FROM QP_LIST_HEADERS_TL
WHERE LIST_HEADER_ID = cp_LIST_HEADER_ID;
SELECT 'x'
FROM MTL_ITEM_TEMPLATES
WHERE TEMPLATE_ID = cp_TEMPLATE_ID;
SELECT 'x'
FROM Fnd_Lookup_Values
WHERE fnd_lookup_values.lookup_code = p_lookup_code
AND fnd_lookup_values.lookup_type = p_lookup_type;
SELECT 'x'
FROM Fnd_Lookup_Values
WHERE fnd_lookup_values.lookup_code = p_lookup_code
AND fnd_lookup_values.lookup_type = p_lookup_type;
SELECT 'X'
FROM MTL_ITEM_CATEGORIES MTLITMCATS,
MTL_CATEGORY_SETS MTLCATSETS
WHERE MTLITMCATS.CATEGORY_SET_ID = MTLCATSETS.CATEGORY_SET_ID
AND MTLITMCATS.ORGANIZATION_ID = OKL_SYSTEM_PARAMS_ALL_PUB.get_system_param_value(OKL_SYSTEM_PARAMS_ALL_PUB.G_ITEM_INV_ORG_ID)
AND MTLCATSETS.MULT_ITEM_CAT_ASSIGN_FLAG = 'N'
AND MTLITMCATS.CATEGORY_SET_ID = cp_cat_set_id;
SELECT 'X'
FROM OKL_VALIDATION_SETS_V
WHERE ID = cp_vld_set_id;
SELECT 'x'
FROM okl_formulae_b
WHERE ID = cp_FORMULA_ID;
SELECT 'x'
FROM fa_locations
WHERE LOCATION_ID = cp_LOCATION_ID;
SELECT 'x'
FROM fa_asset_keywords
WHERE CODE_COMBINATION_ID = cp_ASSET_KEY_ID;
SELECT 'x'
FROM fa_book_controls
WHERE BOOK_CLASS LIKE 'CORPORATE'
AND BOOK_TYPE_CODE = cp_CORPORATE_BOOK;
SELECT 'x'
FROM fa_book_controls
WHERE BOOK_CLASS LIKE 'TAX'
AND BOOK_TYPE_CODE = cp_TAX_BOOK_1;
SELECT 'x'
FROM fa_book_controls
WHERE BOOK_CLASS LIKE 'TAX'
AND BOOK_TYPE_CODE = cp_TAX_BOOK_2;
SELECT 'x'
FROM fnd_lookups
WHERE lookup_type = 'OKL_APPLY_ROUNDING_DIFF'
AND lookup_code = cp_part_trmnt_apply_round_diff
AND lookup_code IN ('ADD_TO_HIGH','ADD_TO_LOW');
SELECT SYP.id
FROM OKL_SYSTEM_PARAMS SYP;
SELECT 'x'
FROM MTL_ITEM_TEMPLATES
WHERE TEMPLATE_ID = cp_TEMPLATE_ID
AND (context_organization_id IS NULL OR context_organization_id = cp_context_organization_id);
SELECT 'x'
FROM mtl_secondary_inventories
WHERE organization_id = cp_inv_org_id
AND secondary_inventory_name = cp_subinv_code;
SELECT organization_name
FROM ORG_ORGANIZATION_DEFINITIONS
WHERE organization_id = cp_org_id;
p_to.program_update_date := p_from.program_update_date;
p_to.last_updated_by := p_from.last_updated_by;
p_to.last_update_date := p_from.last_update_date;
p_to.last_update_login := p_from.last_update_login;
p_to.program_update_date := p_from.program_update_date;
p_to.last_updated_by := p_from.last_updated_by;
p_to.last_update_date := p_from.last_update_date;
p_to.last_update_login := p_from.last_update_login;
PROCEDURE insert_row(
p_init_msg_list IN VARCHAR2,
x_return_status OUT NOCOPY VARCHAR2,
x_msg_count OUT NOCOPY NUMBER,
x_msg_data OUT NOCOPY VARCHAR2,
p_syp_rec IN syp_rec_type,
x_syp_rec OUT NOCOPY syp_rec_type) IS
l_api_version CONSTANT NUMBER := 1;
l_api_name CONSTANT VARCHAR2(30) := 'B_insert_row';
INSERT INTO OKL_SYSTEM_PARAMS_ALL(
id,
delink_yn,
-- SECHAWLA 28-SEP-04 3924244: Added new columns - begin
REMK_SUBINVENTORY ,
REMK_ORGANIZATION_ID ,
REMK_PRICE_LIST_ID,
REMK_PROCESS_CODE ,
REMK_ITEM_TEMPLATE_ID ,
REMK_ITEM_INVOICED_CODE ,
-- SECHAWLA 28-SEP-04 3924244: Added new columns - end
-- PAGARG 24-JAN-05 4044659: Added new columns - begin
LEASE_INV_ORG_YN,
-- PAGARG 24-JAN-05 4044659: Added new columns - end
--SECHAWLA 28-MAR-05 4274575 :Added new columns - begin
TAX_UPFRONT_YN ,
TAX_INVOICE_YN,
TAX_SCHEDULE_YN ,
--SECHAWLA 28-MAR-05 4274575 :Added new columns - end
-- SECHAWLA 26-AUG-05 4274575 : Added new column - begin
TAX_UPFRONT_STY_ID,
-- SECHAWLA 26-AUG-05 4274575 : Added new column - end
-- asawanka 24-MAY-05 : Added the new column CATEGORY_SET_ID for Pricing Enhancements : begin
CATEGORY_SET_ID,
-- asawanka 24-MAY-05 : Added the new column CATEGORY_SET_ID for Pricing Enhancements : end
-- ssdeshpa 2-SEP-05 : Added the new column VALIDATION_SET_ID for Sales Quote Enhancements :
VALIDATION_SET_ID,
-- ssdeshpa 2-SEP-05 : Added the new column VALIDATION_SET_ID for Sales Quote Enhancements :
-- rmunjulu 4508497
CANCEL_QUOTES_YN,
CHK_ACCRUAL_PREVIOUS_MNTH_YN, --rmunjulu 4769094
-- gboomina 10-Apr-2005 - Added New Columns for Bug 5128517 - start
TASK_TEMPLATE_GROUP_ID,
OWNER_TYPE_CODE,
OWNER_ID,
-- gboomina Bug 5128517 - End
object_version_number,
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,
item_inv_org_id,
rpt_prod_book_type_code,
asst_add_book_type_code,
ccard_remittance_id,
-- DJANASWA Bug 6653304 start
CORPORATE_BOOK,
TAX_BOOK_1,
TAX_BOOK_2,
DEPRECIATE_YN,
FA_LOCATION_ID,
FORMULA_ID,
ASSET_KEY_ID,
-- DJANASWA Bug 6653304 end
-- Bug 5568328
PART_TRMNT_APPLY_ROUND_DIFF,
--Bug 7022258-Added by kkorrapo
LSEAPP_SEQ_PREFIX_TXT,
LSEOPP_SEQ_PREFIX_TXT,
QCKQTE_SEQ_PREFIX_TXT,
LSEQTE_SEQ_PREFIX_TXT
--Bug 7022258--Addition end
)
VALUES (
l_syp_rec.id,
l_syp_rec.delink_yn,
-- SECHAWLA 28-SEP-04 3924244: Added new columns - begin
l_syp_rec.REMK_SUBINVENTORY ,
l_syp_rec.REMK_ORGANIZATION_ID ,
l_syp_rec.REMK_PRICE_LIST_ID ,
l_syp_rec.REMK_PROCESS_CODE ,
l_syp_rec.REMK_ITEM_TEMPLATE_ID ,
l_syp_rec.REMK_ITEM_INVOICED_CODE ,
-- SECHAWLA 28-SEP-04 3924244: Added new columns - end
-- PAGARG 24-JAN-05 4044659: Added new columns - begin
l_syp_rec.LEASE_INV_ORG_YN,
-- PAGARG 24-JAN-05 4044659: Added new columns - end
--SECHAWLA 28-MAR-05 4274575 :Added new columns - begin
l_syp_rec.TAX_UPFRONT_YN ,
l_syp_rec.TAX_INVOICE_YN,
l_syp_rec.TAX_SCHEDULE_YN ,
--SECHAWLA 28-MAR-05 4274575 :Added new columns - end
-- SECHAWLA 26-AUG-05 4274575 : Added new column - begin
l_syp_rec.TAX_UPFRONT_STY_ID,
-- SECHAWLA 26-AUG-05 4274575 : Added new column - end
-- asawanka 24-MAY-05 : Added the new column CATEGORY_SET_ID for Pricing Enhancements : begin
l_syp_rec.CATEGORY_SET_ID,
-- asawanka 24-MAY-05 : Added the new column CATEGORY_SET_ID for Pricing Enhancements : end
-- ssdeshpa 2-SEP-05 : Added the new column VALIDATION_SET_ID for Sales Quote Enhancements :
l_syp_rec.VALIDATION_SET_ID,
-- ssdeshpa 2-SEP-05 : Added the new column VALIDATION_SET_ID for Sales Quote Enhancements :
-- rmunjulu 4508497
l_syp_rec.CANCEL_QUOTES_YN,
l_syp_rec.CHK_ACCRUAL_PREVIOUS_MNTH_YN, --rmunjulu 4769094
-- gboomina 10-Apr-2005 - Added New Columns for Bug 5128517 - start
l_syp_rec.TASK_TEMPLATE_GROUP_ID,
l_syp_rec.OWNER_TYPE_CODE,
l_syp_rec.OWNER_ID,
-- gboomina Bug 5128517 - End
l_syp_rec.object_version_number,
l_syp_rec.org_id,
l_syp_rec.request_id,
l_syp_rec.program_application_id,
l_syp_rec.program_id,
l_syp_rec.program_update_date,
l_syp_rec.attribute_category,
l_syp_rec.attribute1,
l_syp_rec.attribute2,
l_syp_rec.attribute3,
l_syp_rec.attribute4,
l_syp_rec.attribute5,
l_syp_rec.attribute6,
l_syp_rec.attribute7,
l_syp_rec.attribute8,
l_syp_rec.attribute9,
l_syp_rec.attribute10,
l_syp_rec.attribute11,
l_syp_rec.attribute12,
l_syp_rec.attribute13,
l_syp_rec.attribute14,
l_syp_rec.attribute15,
l_syp_rec.created_by,
l_syp_rec.creation_date,
l_syp_rec.last_updated_by,
l_syp_rec.last_update_date,
l_syp_rec.last_update_login,
--added by akrangan on 28/07/2006 as a result of adding new columns to the table
l_syp_rec.item_inv_org_id ,
l_syp_rec.rpt_prod_book_type_code,
l_syp_rec.asst_add_book_type_code,
l_syp_rec.ccard_remittance_id,
-- DJANASWA Bug 6653304 start
l_syp_rec.CORPORATE_BOOK,
l_syp_rec.TAX_BOOK_1,
l_syp_rec.TAX_BOOK_2,
l_syp_rec.DEPRECIATE_YN,
l_syp_rec.FA_LOCATION_ID,
l_syp_rec.FORMULA_ID,
l_syp_rec.ASSET_KEY_ID,
-- DJANASWA Bug 6653304 end
-- Bug 5568328
l_syp_rec.part_trmnt_apply_round_diff,
--Bug 7022258-Added by kkorrapo
l_syp_rec.lseapp_seq_prefix_txt,
l_syp_rec.lseopp_seq_prefix_txt,
l_syp_rec.qckqte_seq_prefix_txt,
l_syp_rec.lseqte_seq_prefix_txt
--Bug 7022258--Addition end
);
END insert_row;
PROCEDURE insert_row(
p_api_version IN NUMBER,
p_init_msg_list IN VARCHAR2,
x_return_status OUT NOCOPY VARCHAR2,
x_msg_count OUT NOCOPY NUMBER,
x_msg_data OUT NOCOPY VARCHAR2,
p_sypv_rec IN sypv_rec_type,
x_sypv_rec OUT NOCOPY sypv_rec_type) IS
l_api_version CONSTANT NUMBER := 1;
l_api_name CONSTANT VARCHAR2(30) := 'V_insert_row';
l_sypv_rec.LAST_UPDATE_DATE := l_sypv_rec.CREATION_DATE;
l_sypv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
l_sypv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
insert_row(
p_init_msg_list,
l_return_status,
x_msg_count,
x_msg_data,
l_syp_rec,
lx_syp_rec
);
END insert_row;
PROCEDURE insert_row(
p_api_version IN NUMBER,
p_init_msg_list IN VARCHAR2,
x_return_status OUT NOCOPY VARCHAR2,
x_msg_count OUT NOCOPY NUMBER,
x_msg_data OUT NOCOPY VARCHAR2,
p_sypv_tbl IN sypv_tbl_type,
x_sypv_tbl OUT NOCOPY sypv_tbl_type,
px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE) IS
l_api_version CONSTANT NUMBER := 1;
l_api_name CONSTANT VARCHAR2(30) := 'V_error_tbl_insert_row';
insert_row (
p_api_version => p_api_version,
p_init_msg_list => OKL_API.G_FALSE,
x_return_status => l_error_rec.error_type,
x_msg_count => l_error_rec.msg_count,
x_msg_data => l_error_rec.msg_data,
p_sypv_rec => p_sypv_tbl(i),
x_sypv_rec => x_sypv_tbl(i));
END insert_row;
PROCEDURE insert_row(
p_api_version IN NUMBER,
p_init_msg_list IN VARCHAR2,
x_return_status OUT NOCOPY VARCHAR2,
x_msg_count OUT NOCOPY NUMBER,
x_msg_data OUT NOCOPY VARCHAR2,
p_sypv_tbl IN sypv_tbl_type,
x_sypv_tbl OUT NOCOPY sypv_tbl_type) IS
l_api_version CONSTANT NUMBER := 1;
l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_insert_row';
insert_row (
p_api_version => p_api_version,
p_init_msg_list => OKL_API.G_FALSE,
x_return_status => x_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data,
p_sypv_tbl => p_sypv_tbl,
x_sypv_tbl => x_sypv_tbl,
px_error_tbl => l_error_tbl);
END insert_row;
SELECT OBJECT_VERSION_NUMBER
FROM OKL_SYSTEM_PARAMS_ALL
WHERE ID = p_syp_rec.id
AND OBJECT_VERSION_NUMBER = p_syp_rec.object_version_number
FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
SELECT OBJECT_VERSION_NUMBER
FROM OKL_SYSTEM_PARAMS_ALL
WHERE ID = p_syp_rec.id;
OKL_API.set_message(G_FND_APP,G_FORM_RECORD_DELETED);
OKL_API.set_message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);
PROCEDURE update_row(
p_init_msg_list IN VARCHAR2,
x_return_status OUT NOCOPY VARCHAR2,
x_msg_count OUT NOCOPY NUMBER,
x_msg_data OUT NOCOPY VARCHAR2,
p_syp_rec IN syp_rec_type,
x_syp_rec OUT NOCOPY syp_rec_type) IS
l_api_version CONSTANT NUMBER := 1;
l_api_name CONSTANT VARCHAR2(30) := 'B_update_row';
IF (x_syp_rec.program_update_date = OKL_API.G_MISS_DATE)
THEN
x_syp_rec.program_update_date := l_syp_rec.program_update_date;
IF (x_syp_rec.last_updated_by = OKL_API.G_MISS_NUM)
THEN
x_syp_rec.last_updated_by := l_syp_rec.last_updated_by;
IF (x_syp_rec.last_update_date = OKL_API.G_MISS_DATE)
THEN
x_syp_rec.last_update_date := l_syp_rec.last_update_date;
IF (x_syp_rec.last_update_login = OKL_API.G_MISS_NUM)
THEN
x_syp_rec.last_update_login := l_syp_rec.last_update_login;
UPDATE OKL_SYSTEM_PARAMS_ALL
SET DELINK_YN = l_def_syp_rec.delink_yn,
-- SECHAWLA 28-SEP-04 3924244: Added new columns - begin
REMK_SUBINVENTORY = l_def_syp_rec.REMK_SUBINVENTORY ,
REMK_ORGANIZATION_ID = l_def_syp_rec.REMK_ORGANIZATION_ID,
REMK_PRICE_LIST_ID = l_def_syp_rec.REMK_PRICE_LIST_ID ,
REMK_PROCESS_CODE = l_def_syp_rec.REMK_PROCESS_CODE,
REMK_ITEM_TEMPLATE_ID = l_def_syp_rec.REMK_ITEM_TEMPLATE_ID ,
REMK_ITEM_INVOICED_CODE = l_def_syp_rec.REMK_ITEM_INVOICED_CODE ,
-- SECHAWLA 28-SEP-04 3924244: Added new columns - end
-- PAGARG 24-JAN-05 4044659: Added new columns - begin
LEASE_INV_ORG_YN = l_def_syp_rec.LEASE_INV_ORG_YN,
-- PAGARG 24-JAN-05 4044659: Added new columns - end
--SECHAWLA 28-MAR-05 4274575 Added new columns - begin
TAX_UPFRONT_YN = l_def_syp_rec.TAX_UPFRONT_YN,
TAX_INVOICE_YN = l_def_syp_rec.TAX_INVOICE_YN,
TAX_SCHEDULE_YN = l_def_syp_rec.TAX_SCHEDULE_YN,
--SECHAWLA 28-MAR-05 4274575 Added new columns - end
-- SECHAWLA 26-AUG-05 4274575 : Added new columns - begin
TAX_UPFRONT_STY_ID = l_def_syp_rec.TAX_UPFRONT_STY_ID,
-- SECHAWLA 26-AUG-05 4274575 : Added new columns - end
-- asawanka 24-MAY-05 : Added the new column CATEGORY_SET_ID for Pricing Enhancements : begin
CATEGORY_SET_ID = l_def_syp_rec.CATEGORY_SET_ID,
-- asawanka 24-MAY-05 : Added the new column CATEGORY_SET_ID for Pricing Enhancements : end
-- ssdeshpa 2-SEP-05 : Added the new column VALIDATION_SET_ID for Sales Quote Enhancements :
VALIDATION_SET_ID = l_def_syp_rec.VALIDATION_SET_ID,
-- ssdeshpa 2-SEP-05 : Added the new column VALIDATION_SET_ID for Sales Quote Enhancements :
-- rmunjulu 4508497
CANCEL_QUOTES_YN = l_def_syp_rec.CANCEL_QUOTES_YN,
CHK_ACCRUAL_PREVIOUS_MNTH_YN = l_def_syp_rec.CHK_ACCRUAL_PREVIOUS_MNTH_YN, --rmunjulu 4769094
-- gboomina 10-Apr-2005 - Added New Columns for Bug 5128517 - start
TASK_TEMPLATE_GROUP_ID = l_def_syp_rec.TASK_TEMPLATE_GROUP_ID,
OWNER_TYPE_CODE = l_def_syp_rec.OWNER_TYPE_CODE,
OWNER_ID = l_def_syp_rec.OWNER_ID,
-- gboomina Bug 5128517 - End
-- DJANASWA Bug 6653304 start
CORPORATE_BOOK = l_def_syp_rec.CORPORATE_BOOK,
TAX_BOOK_1 = l_def_syp_rec.TAX_BOOK_1,
TAX_BOOK_2 = l_def_syp_rec.TAX_BOOK_2,
DEPRECIATE_YN = l_def_syp_rec.DEPRECIATE_YN,
FA_LOCATION_ID = l_def_syp_rec.FA_LOCATION_ID,
FORMULA_ID = l_def_syp_rec.FORMULA_ID,
ASSET_KEY_ID = l_def_syp_rec.ASSET_KEY_ID,
-- DJANASWA Bug 6653304 end
-- Bug 5568328
part_trmnt_apply_round_diff = l_def_syp_rec.part_trmnt_apply_round_diff,
OBJECT_VERSION_NUMBER = l_def_syp_rec.object_version_number,
ORG_ID = l_def_syp_rec.org_id,
REQUEST_ID = l_def_syp_rec.request_id,
PROGRAM_APPLICATION_ID = l_def_syp_rec.program_application_id,
PROGRAM_ID = l_def_syp_rec.program_id,
PROGRAM_UPDATE_DATE = l_def_syp_rec.program_update_date,
ATTRIBUTE_CATEGORY = l_def_syp_rec.attribute_category,
ATTRIBUTE1 = l_def_syp_rec.attribute1,
ATTRIBUTE2 = l_def_syp_rec.attribute2,
ATTRIBUTE3 = l_def_syp_rec.attribute3,
ATTRIBUTE4 = l_def_syp_rec.attribute4,
ATTRIBUTE5 = l_def_syp_rec.attribute5,
ATTRIBUTE6 = l_def_syp_rec.attribute6,
ATTRIBUTE7 = l_def_syp_rec.attribute7,
ATTRIBUTE8 = l_def_syp_rec.attribute8,
ATTRIBUTE9 = l_def_syp_rec.attribute9,
ATTRIBUTE10 = l_def_syp_rec.attribute10,
ATTRIBUTE11 = l_def_syp_rec.attribute11,
ATTRIBUTE12 = l_def_syp_rec.attribute12,
ATTRIBUTE13 = l_def_syp_rec.attribute13,
ATTRIBUTE14 = l_def_syp_rec.attribute14,
ATTRIBUTE15 = l_def_syp_rec.attribute15,
CREATED_BY = l_def_syp_rec.created_by,
CREATION_DATE = l_def_syp_rec.creation_date,
LAST_UPDATED_BY = l_def_syp_rec.last_updated_by,
LAST_UPDATE_DATE = l_def_syp_rec.last_update_date,
LAST_UPDATE_LOGIN = l_def_syp_rec.last_update_login,
ITEM_INV_ORG_ID = l_def_syp_rec.item_inv_org_id ,
RPT_PROD_BOOK_TYPE_CODE = l_def_syp_rec.rpt_prod_book_type_code,
ASST_ADD_BOOK_TYPE_CODE = l_def_syp_rec.ASST_ADD_BOOK_TYPE_CODE,
CCARD_REMITTANCE_ID = l_def_syp_rec.CCARD_REMITTANCE_ID,
--Bug 7022258-Added by kkorrapo
LSEAPP_SEQ_PREFIX_TXT = l_def_syp_rec.lseapp_seq_prefix_txt,
LSEOPP_SEQ_PREFIX_TXT = l_def_syp_rec.lseopp_seq_prefix_txt,
QCKQTE_SEQ_PREFIX_TXT = l_def_syp_rec.qckqte_seq_prefix_txt,
LSEQTE_SEQ_PREFIX_TXT = l_def_syp_rec.lseqte_seq_prefix_txt
--Bug 7022258--Addition end
WHERE ID = l_def_syp_rec.id;
END update_row;
PROCEDURE update_row(
p_api_version IN NUMBER,
p_init_msg_list IN VARCHAR2,
x_return_status OUT NOCOPY VARCHAR2,
x_msg_count OUT NOCOPY NUMBER,
x_msg_data OUT NOCOPY VARCHAR2,
p_sypv_rec IN sypv_rec_type,
x_sypv_rec OUT NOCOPY sypv_rec_type) IS
l_api_version CONSTANT NUMBER := 1;
l_api_name CONSTANT VARCHAR2(30) := 'V_update_row';
l_sypv_rec.LAST_UPDATE_DATE := SYSDATE;
l_sypv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
l_sypv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
IF (x_sypv_rec.program_update_date = OKL_API.G_MISS_DATE)
THEN
x_sypv_rec.program_update_date := l_db_OklSystemParam2.program_update_date;
IF (x_sypv_rec.last_updated_by = OKL_API.G_MISS_NUM)
THEN
x_sypv_rec.last_updated_by := l_db_OklSystemParam2.last_updated_by;
IF (x_sypv_rec.last_update_date = OKL_API.G_MISS_DATE)
THEN
x_sypv_rec.last_update_date := l_db_OklSystemParam2.last_update_date;
IF (x_sypv_rec.last_update_login = OKL_API.G_MISS_NUM)
THEN
x_sypv_rec.last_update_login := l_db_OklSystemParam2.last_update_login;
update_row(
p_init_msg_list,
l_return_status,
x_msg_count,
x_msg_data,
l_syp_rec,
lx_syp_rec
);
END update_row;
PROCEDURE update_row(
p_api_version IN NUMBER,
p_init_msg_list IN VARCHAR2,
x_return_status OUT NOCOPY VARCHAR2,
x_msg_count OUT NOCOPY NUMBER,
x_msg_data OUT NOCOPY VARCHAR2,
p_sypv_tbl IN sypv_tbl_type,
x_sypv_tbl OUT NOCOPY sypv_tbl_type,
px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE) IS
l_api_version CONSTANT NUMBER := 1;
l_api_name CONSTANT VARCHAR2(30) := 'V_error_tbl_update_row';
update_row (
p_api_version => p_api_version,
p_init_msg_list => OKL_API.G_FALSE,
x_return_status => l_error_rec.error_type,
x_msg_count => l_error_rec.msg_count,
x_msg_data => l_error_rec.msg_data,
p_sypv_rec => p_sypv_tbl(i),
x_sypv_rec => x_sypv_tbl(i));
END update_row;
PROCEDURE update_row(
p_api_version IN NUMBER,
p_init_msg_list IN VARCHAR2,
x_return_status OUT NOCOPY VARCHAR2,
x_msg_count OUT NOCOPY NUMBER,
x_msg_data OUT NOCOPY VARCHAR2,
p_sypv_tbl IN sypv_tbl_type,
x_sypv_tbl OUT NOCOPY sypv_tbl_type) IS
l_api_version CONSTANT NUMBER := 1;
l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_update_row';
update_row (
p_api_version => p_api_version,
p_init_msg_list => OKL_API.G_FALSE,
x_return_status => x_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data,
p_sypv_tbl => p_sypv_tbl,
x_sypv_tbl => x_sypv_tbl,
px_error_tbl => l_error_tbl);
END update_row;
PROCEDURE delete_row(
p_init_msg_list IN VARCHAR2,
x_return_status OUT NOCOPY VARCHAR2,
x_msg_count OUT NOCOPY NUMBER,
x_msg_data OUT NOCOPY VARCHAR2,
p_syp_rec IN syp_rec_type) IS
l_api_version CONSTANT NUMBER := 1;
l_api_name CONSTANT VARCHAR2(30) := 'B_delete_row';
DELETE FROM OKL_SYSTEM_PARAMS_ALL
WHERE ID = p_syp_rec.id;
END delete_row;
PROCEDURE delete_row(
p_api_version IN NUMBER,
p_init_msg_list IN VARCHAR2,
x_return_status OUT NOCOPY VARCHAR2,
x_msg_count OUT NOCOPY NUMBER,
x_msg_data OUT NOCOPY VARCHAR2,
p_sypv_rec IN sypv_rec_type) IS
l_api_version CONSTANT NUMBER := 1;
l_api_name CONSTANT VARCHAR2(30) := 'V_delete_row';
delete_row(
p_init_msg_list,
l_return_status,
x_msg_count,
x_msg_data,
l_syp_rec
);
END delete_row;
PROCEDURE delete_row(
p_api_version IN NUMBER,
p_init_msg_list IN VARCHAR2,
x_return_status OUT NOCOPY VARCHAR2,
x_msg_count OUT NOCOPY NUMBER,
x_msg_data OUT NOCOPY VARCHAR2,
p_sypv_tbl IN sypv_tbl_type,
px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE) IS
l_api_version CONSTANT NUMBER := 1;
l_api_name CONSTANT VARCHAR2(30) := 'V_error_tbl_delete_row';
delete_row (
p_api_version => p_api_version,
p_init_msg_list => OKL_API.G_FALSE,
x_return_status => l_error_rec.error_type,
x_msg_count => l_error_rec.msg_count,
x_msg_data => l_error_rec.msg_data,
p_sypv_rec => p_sypv_tbl(i));
END delete_row;
PROCEDURE delete_row(
p_api_version IN NUMBER,
p_init_msg_list IN VARCHAR2,
x_return_status OUT NOCOPY VARCHAR2,
x_msg_count OUT NOCOPY NUMBER,
x_msg_data OUT NOCOPY VARCHAR2,
p_sypv_tbl IN sypv_tbl_type) IS
l_api_version CONSTANT NUMBER := 1;
l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_delete_row';
delete_row (
p_api_version => p_api_version,
p_init_msg_list => OKL_API.G_FALSE,
x_return_status => x_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data,
p_sypv_tbl => p_sypv_tbl,
px_error_tbl => l_error_tbl);
END delete_row;