eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKL_COPY_CONTRACT_PVT dependencies on OKC_K_HEADERS_B

Line 2595: l_chr_id OKC_K_HEADERS_B.ID%TYPE;

2591: AND cle.dnz_chr_id = p_copied_chr_id;
2592:
2593: l_cle_id OKC_K_LINES_B.ID%TYPE;
2594: l_source_cle_id OKC_K_LINES_B.ID%TYPE;
2595: l_chr_id OKC_K_HEADERS_B.ID%TYPE;
2596:
2597: Begin
2598: x_return_status := OKL_API.G_RET_STS_SUCCESS;
2599: l_chr_id := p_chr_id;

Line 2693: l_chr_id OKC_K_HEADERS_B.ID%TYPE;

2689: AND cle.dnz_chr_id = p_copied_chr_id;
2690:
2691: l_cle_id OKC_K_LINES_B.ID%TYPE;
2692: l_source_cle_id OKC_K_LINES_B.ID%TYPE;
2693: l_chr_id OKC_K_HEADERS_B.ID%TYPE;
2694:
2695: Begin
2696: x_return_status := OKL_API.G_RET_STS_SUCCESS;
2697: l_chr_id := p_chr_id;

Line 3452: l_new_chr_id okc_k_headers_b.id%type;

3448:
3449: -- end furong 4350255
3450:
3451: --Bug# 4899328
3452: l_new_chr_id okc_k_headers_b.id%type;
3453:
3454: --Bug# 8677460
3455: CURSOR chr_csr(p_chr_id IN okc_k_headers_b.ID%TYPE) IS
3456: SELECT orig_system_source_code,

Line 3455: CURSOR chr_csr(p_chr_id IN okc_k_headers_b.ID%TYPE) IS

3451: --Bug# 4899328
3452: l_new_chr_id okc_k_headers_b.id%type;
3453:
3454: --Bug# 8677460
3455: CURSOR chr_csr(p_chr_id IN okc_k_headers_b.ID%TYPE) IS
3456: SELECT orig_system_source_code,
3457: orig_system_id1
3458: FROM okc_k_headers_b
3459: WHERE id = p_chr_id;

Line 3458: FROM okc_k_headers_b

3454: --Bug# 8677460
3455: CURSOR chr_csr(p_chr_id IN okc_k_headers_b.ID%TYPE) IS
3456: SELECT orig_system_source_code,
3457: orig_system_id1
3458: FROM okc_k_headers_b
3459: WHERE id = p_chr_id;
3460:
3461: l_rbk_chr_orig_source_code okc_k_headers_b.ORIG_SYSTEM_SOURCE_CODE%TYPE;
3462: l_rbk_chr_orig_system_id1 okc_k_headers_b.ORIG_SYSTEM_ID1%TYPE;

Line 3461: l_rbk_chr_orig_source_code okc_k_headers_b.ORIG_SYSTEM_SOURCE_CODE%TYPE;

3457: orig_system_id1
3458: FROM okc_k_headers_b
3459: WHERE id = p_chr_id;
3460:
3461: l_rbk_chr_orig_source_code okc_k_headers_b.ORIG_SYSTEM_SOURCE_CODE%TYPE;
3462: l_rbk_chr_orig_system_id1 okc_k_headers_b.ORIG_SYSTEM_ID1%TYPE;
3463: l_rebook_yn VARCHAR2(1);
3464: --Bug# 8677460
3465:

Line 3462: l_rbk_chr_orig_system_id1 okc_k_headers_b.ORIG_SYSTEM_ID1%TYPE;

3458: FROM okc_k_headers_b
3459: WHERE id = p_chr_id;
3460:
3461: l_rbk_chr_orig_source_code okc_k_headers_b.ORIG_SYSTEM_SOURCE_CODE%TYPE;
3462: l_rbk_chr_orig_system_id1 okc_k_headers_b.ORIG_SYSTEM_ID1%TYPE;
3463: l_rebook_yn VARCHAR2(1);
3464: --Bug# 8677460
3465:
3466: Begin

Line 5301: l_serv_contract_id okc_k_headers_b.id%TYPE;

5297: l_message VARCHAR2(30) ;
5298: l_new_mapping_id NUMBER;
5299: l_hstv_rec okc_k_history_pvt.hstv_rec_type;
5300: x_hstv_rec okc_k_history_pvt.hstv_rec_type;
5301: l_serv_contract_id okc_k_headers_b.id%TYPE;
5302: l_service_top_line_id okc_k_lines_b.id%TYPE;
5303: l_deal_type okl_k_headers.deal_type%TYPE;
5304: l_queried BOOLEAN := FALSE;
5305: l_line_style okc_k_lines_b.lse_id%TYPE;

Line 5316: l_contract_number okc_k_headers_b.contract_number%TYPE;

5312: l_event_name wf_events.name%TYPE := NULL;
5313: l_raise_business_event VARCHAR2(1) := OKL_API.G_FALSE;
5314: l_business_event_name wf_events.name%TYPE := NULL;
5315:
5316: l_contract_number okc_k_headers_b.contract_number%TYPE;
5317: l_copied_id NUMBER;
5318: l_gov_id NUMBER;
5319: l_capital_amount NUMBER;
5320: l_contract_currency okc_k_headers_b.currency_code%TYPE;

Line 5320: l_contract_currency okc_k_headers_b.currency_code%TYPE;

5316: l_contract_number okc_k_headers_b.contract_number%TYPE;
5317: l_copied_id NUMBER;
5318: l_gov_id NUMBER;
5319: l_capital_amount NUMBER;
5320: l_contract_currency okc_k_headers_b.currency_code%TYPE;
5321: l_contract_start_date okc_k_headers_b.start_date%TYPE;
5322: l_conversion_type okc_k_headers_b.CONVERSION_TYPE%TYPE;
5323: l_conversion_rate okc_k_headers_b.CONVERSION_RATE%TYPE;
5324: l_conversion_rate_date okc_k_headers_b.CONVERSION_RATE_DATE%TYPE;

Line 5321: l_contract_start_date okc_k_headers_b.start_date%TYPE;

5317: l_copied_id NUMBER;
5318: l_gov_id NUMBER;
5319: l_capital_amount NUMBER;
5320: l_contract_currency okc_k_headers_b.currency_code%TYPE;
5321: l_contract_start_date okc_k_headers_b.start_date%TYPE;
5322: l_conversion_type okc_k_headers_b.CONVERSION_TYPE%TYPE;
5323: l_conversion_rate okc_k_headers_b.CONVERSION_RATE%TYPE;
5324: l_conversion_rate_date okc_k_headers_b.CONVERSION_RATE_DATE%TYPE;
5325: l_template_yn okc_k_headers_b.TEMPLATE_YN%TYPE;

Line 5322: l_conversion_type okc_k_headers_b.CONVERSION_TYPE%TYPE;

5318: l_gov_id NUMBER;
5319: l_capital_amount NUMBER;
5320: l_contract_currency okc_k_headers_b.currency_code%TYPE;
5321: l_contract_start_date okc_k_headers_b.start_date%TYPE;
5322: l_conversion_type okc_k_headers_b.CONVERSION_TYPE%TYPE;
5323: l_conversion_rate okc_k_headers_b.CONVERSION_RATE%TYPE;
5324: l_conversion_rate_date okc_k_headers_b.CONVERSION_RATE_DATE%TYPE;
5325: l_template_yn okc_k_headers_b.TEMPLATE_YN%TYPE;
5326: l_trx_assets_counter4 NUMBER := 1;

Line 5323: l_conversion_rate okc_k_headers_b.CONVERSION_RATE%TYPE;

5319: l_capital_amount NUMBER;
5320: l_contract_currency okc_k_headers_b.currency_code%TYPE;
5321: l_contract_start_date okc_k_headers_b.start_date%TYPE;
5322: l_conversion_type okc_k_headers_b.CONVERSION_TYPE%TYPE;
5323: l_conversion_rate okc_k_headers_b.CONVERSION_RATE%TYPE;
5324: l_conversion_rate_date okc_k_headers_b.CONVERSION_RATE_DATE%TYPE;
5325: l_template_yn okc_k_headers_b.TEMPLATE_YN%TYPE;
5326: l_trx_assets_counter4 NUMBER := 1;
5327: l_tal_to_kle_counter NUMBER := 1;

Line 5324: l_conversion_rate_date okc_k_headers_b.CONVERSION_RATE_DATE%TYPE;

5320: l_contract_currency okc_k_headers_b.currency_code%TYPE;
5321: l_contract_start_date okc_k_headers_b.start_date%TYPE;
5322: l_conversion_type okc_k_headers_b.CONVERSION_TYPE%TYPE;
5323: l_conversion_rate okc_k_headers_b.CONVERSION_RATE%TYPE;
5324: l_conversion_rate_date okc_k_headers_b.CONVERSION_RATE_DATE%TYPE;
5325: l_template_yn okc_k_headers_b.TEMPLATE_YN%TYPE;
5326: l_trx_assets_counter4 NUMBER := 1;
5327: l_tal_to_kle_counter NUMBER := 1;
5328: l_trx_assets_counter6 NUMBER := 1;

Line 5325: l_template_yn okc_k_headers_b.TEMPLATE_YN%TYPE;

5321: l_contract_start_date okc_k_headers_b.start_date%TYPE;
5322: l_conversion_type okc_k_headers_b.CONVERSION_TYPE%TYPE;
5323: l_conversion_rate okc_k_headers_b.CONVERSION_RATE%TYPE;
5324: l_conversion_rate_date okc_k_headers_b.CONVERSION_RATE_DATE%TYPE;
5325: l_template_yn okc_k_headers_b.TEMPLATE_YN%TYPE;
5326: l_trx_assets_counter4 NUMBER := 1;
5327: l_tal_to_kle_counter NUMBER := 1;
5328: l_trx_assets_counter6 NUMBER := 1;
5329: l_okl_k_lines_counter NUMBER := 1;

Line 5332: SELECT * FROM okc_k_headers_b

5328: l_trx_assets_counter6 NUMBER := 1;
5329: l_okl_k_lines_counter NUMBER := 1;
5330: l_try_id NUMBER;
5331: CURSOR c1(p_chr_id NUMBER) IS
5332: SELECT * FROM okc_k_headers_b
5333: WHERE id=p_chr_id;
5334:
5335: CURSOR c2(p_chr_id NUMBER) IS
5336: SELECT * FROM okc_governances

Line 5397: FROM OKC_K_HEADERS_B

5393:
5394: -- Bug 4738057
5395: CURSOR contract_exists_csr(p_contract_number IN VARCHAR2) IS
5396: SELECT ID
5397: FROM OKC_K_HEADERS_B
5398: WHERE CONTRACT_NUMBER = p_contract_number;
5399:
5400: TYPE l_subsidy_id_type IS TABLE OF okl_k_lines.subsidy_id%TYPE INDEX BY BINARY_INTEGER;
5401:

Line 7305: l_orig_system_source_code okc_k_headers_b.orig_system_source_code%TYPE;

7301: l_party_counter NUMBER := 1;
7302: l_prid_tab l_prid_type;
7303: l_probject1_id1_tab l_probject1_id1_type;
7304:
7305: l_orig_system_source_code okc_k_headers_b.orig_system_source_code%TYPE;
7306: l_sts_code okc_k_headers_b.sts_code%TYPE;
7307: l_sts_code_orig okc_k_headers_b.sts_code%TYPE;
7308:
7309: --Bug# 16425139: Changing the global variables to local variables

Line 7306: l_sts_code okc_k_headers_b.sts_code%TYPE;

7302: l_prid_tab l_prid_type;
7303: l_probject1_id1_tab l_probject1_id1_type;
7304:
7305: l_orig_system_source_code okc_k_headers_b.orig_system_source_code%TYPE;
7306: l_sts_code okc_k_headers_b.sts_code%TYPE;
7307: l_sts_code_orig okc_k_headers_b.sts_code%TYPE;
7308:
7309: --Bug# 16425139: Changing the global variables to local variables
7310: l_created_by NUMBER := fnd_global.user_id;

Line 7307: l_sts_code_orig okc_k_headers_b.sts_code%TYPE;

7303: l_probject1_id1_tab l_probject1_id1_type;
7304:
7305: l_orig_system_source_code okc_k_headers_b.orig_system_source_code%TYPE;
7306: l_sts_code okc_k_headers_b.sts_code%TYPE;
7307: l_sts_code_orig okc_k_headers_b.sts_code%TYPE;
7308:
7309: --Bug# 16425139: Changing the global variables to local variables
7310: l_created_by NUMBER := fnd_global.user_id;
7311: l_last_updated_by NUMBER := fnd_global.user_id;

Line 7316: p_ccy_code IN okc_k_headers_b.currency_code%TYPE) IS

7312: l_last_update_login NUMBER := fnd_global.login_id;
7313:
7314: PROCEDURE validate_currency_code(
7315: x_return_status OUT NOCOPY VARCHAR2,
7316: p_ccy_code IN okc_k_headers_b.currency_code%TYPE) IS
7317:
7318: l_dummy_var VARCHAR2(1) := '?';
7319: CURSOR l_fndv_csr IS
7320: SELECT 'x'

Line 7395: p_orig_system_source_code IN okc_k_headers_b.orig_system_source_code%TYPE

7391: END validate_currency_code;
7392:
7393: PROCEDURE validate_orig_sys_code
7394: (x_return_status OUT NOCOPY VARCHAR2,
7395: p_orig_system_source_code IN okc_k_headers_b.orig_system_source_code%TYPE
7396: ) IS
7397: BEGIN
7398:
7399:

Line 7442: p_currency_conversion_type IN okc_k_headers_b.conversion_type%TYPE) IS

7438: END validate_orig_sys_code;
7439:
7440: PROCEDURE validate_currency_conv_type
7441: (x_return_status OUT NOCOPY VARCHAR2,
7442: p_currency_conversion_type IN okc_k_headers_b.conversion_type%TYPE) IS
7443:
7444: --cursor to chk currency type fk
7445: CURSOR curr_conv_type_csr (p_curr_cotyp IN VARCHAR2) IS
7446: SELECT '!'

Line 12954: PROCEDURE insert_okc_k_party_roles(p_old_id IN okc_k_headers_b.id%TYPE,

12950: RAISE OKC_API.G_EXCEPTION_ERROR;
12951:
12952: END; /* sort_vid_mapping_tab */
12953:
12954: PROCEDURE insert_okc_k_party_roles(p_old_id IN okc_k_headers_b.id%TYPE,
12955: p_new_id IN okc_k_headers_b.id%TYPE) IS
12956: CURSOR c9(p_id okc_k_party_roles_b.dnz_chr_id%TYPE) IS
12957: SELECT
12958: id, chr_id, cle_id,

Line 12955: p_new_id IN okc_k_headers_b.id%TYPE) IS

12951:
12952: END; /* sort_vid_mapping_tab */
12953:
12954: PROCEDURE insert_okc_k_party_roles(p_old_id IN okc_k_headers_b.id%TYPE,
12955: p_new_id IN okc_k_headers_b.id%TYPE) IS
12956: CURSOR c9(p_id okc_k_party_roles_b.dnz_chr_id%TYPE) IS
12957: SELECT
12958: id, chr_id, cle_id,
12959: dnz_chr_id, rle_code, object1_id1,

Line 14592: PROCEDURE insert_okc_rule_groups (p_old_id IN okc_k_headers_b.id%TYPE,

14588: RAISE OKC_API.G_EXCEPTION_ERROR;
14589:
14590: END; /* sort_tid_mapping_tab */
14591:
14592: PROCEDURE insert_okc_rule_groups (p_old_id IN okc_k_headers_b.id%TYPE,
14593: p_new_id IN okc_k_headers_b.id%TYPE) IS
14594: CURSOR c12(p_id NUMBER) IS
14595: SELECT
14596: id, rgd_code, chr_id,

Line 14593: p_new_id IN okc_k_headers_b.id%TYPE) IS

14589:
14590: END; /* sort_tid_mapping_tab */
14591:
14592: PROCEDURE insert_okc_rule_groups (p_old_id IN okc_k_headers_b.id%TYPE,
14593: p_new_id IN okc_k_headers_b.id%TYPE) IS
14594: CURSOR c12(p_id NUMBER) IS
14595: SELECT
14596: id, rgd_code, chr_id,
14597: cle_id, dnz_chr_id, parent_rgp_id,

Line 15218: PROCEDURE insert_okc_k_items (p_old_id IN okc_k_headers_b.id%TYPE,

15214: END; /* sort_okc_k_items_rec */
15215:
15216:
15217:
15218: PROCEDURE insert_okc_k_items (p_old_id IN okc_k_headers_b.id%TYPE,
15219: p_new_id IN okc_k_headers_b.id%TYPE) IS
15220: CURSOR c16(p_id NUMBER) IS
15221: SELECT
15222: a.id, a.cle_id, a.chr_id,

Line 15219: p_new_id IN okc_k_headers_b.id%TYPE) IS

15215:
15216:
15217:
15218: PROCEDURE insert_okc_k_items (p_old_id IN okc_k_headers_b.id%TYPE,
15219: p_new_id IN okc_k_headers_b.id%TYPE) IS
15220: CURSOR c16(p_id NUMBER) IS
15221: SELECT
15222: a.id, a.cle_id, a.chr_id,
15223: a.cle_id_for, a.dnz_chr_id, a.object1_id1,

Line 16054: PROCEDURE insert_okl_txd_assets_tl(p_old_id IN okc_k_headers_b.id%TYPE,

16050: RAISE OKC_API.G_EXCEPTION_ERROR;
16051:
16052: END; /* insert_okl_txl_assets_tl */
16053:
16054: PROCEDURE insert_okl_txd_assets_tl(p_old_id IN okc_k_headers_b.id%TYPE,
16055: p_new_id IN okc_k_headers_b.id%TYPE,
16056: p_flush IN VARCHAR2) IS
16057: CURSOR c21(p_id NUMBER) IS
16058: SELECT

Line 16055: p_new_id IN okc_k_headers_b.id%TYPE,

16051:
16052: END; /* insert_okl_txl_assets_tl */
16053:
16054: PROCEDURE insert_okl_txd_assets_tl(p_old_id IN okc_k_headers_b.id%TYPE,
16055: p_new_id IN okc_k_headers_b.id%TYPE,
16056: p_flush IN VARCHAR2) IS
16057: CURSOR c21(p_id NUMBER) IS
16058: SELECT
16059: id, LANGUAGE, source_lang,

Line 16166: PROCEDURE insert_okl_txd_assets_b(p_old_id IN okc_k_headers_b.id%TYPE,

16162: RAISE OKC_API.G_EXCEPTION_ERROR;
16163:
16164: END; /* insert_okl_txd_assets_tl */
16165:
16166: PROCEDURE insert_okl_txd_assets_b(p_old_id IN okc_k_headers_b.id%TYPE,
16167: p_new_id IN okc_k_headers_b.id%TYPE) IS
16168: CURSOR c20(p_id NUMBER) IS
16169: SELECT
16170: id, object_version_number, tal_id,

Line 16167: p_new_id IN okc_k_headers_b.id%TYPE) IS

16163:
16164: END; /* insert_okl_txd_assets_tl */
16165:
16166: PROCEDURE insert_okl_txd_assets_b(p_old_id IN okc_k_headers_b.id%TYPE,
16167: p_new_id IN okc_k_headers_b.id%TYPE) IS
16168: CURSOR c20(p_id NUMBER) IS
16169: SELECT
16170: id, object_version_number, tal_id,
16171: target_kle_id, line_detail_number, asset_number,

Line 16603: PROCEDURE insert_okl_txl_assets_b(p_old_id IN okc_k_headers_b.id%TYPE,

16599: RAISE OKC_API.G_EXCEPTION_ERROR;
16600:
16601: END; /* sort_dbid_mapping_tab */
16602:
16603: PROCEDURE insert_okl_txl_assets_b(p_old_id IN okc_k_headers_b.id%TYPE,
16604: p_new_id IN okc_k_headers_b.id%TYPE) IS
16605: CURSOR c18(p_id NUMBER) IS
16606: SELECT
16607: a.id, a.object_version_number, a.tas_id,

Line 16604: p_new_id IN okc_k_headers_b.id%TYPE) IS

16600:
16601: END; /* sort_dbid_mapping_tab */
16602:
16603: PROCEDURE insert_okl_txl_assets_b(p_old_id IN okc_k_headers_b.id%TYPE,
16604: p_new_id IN okc_k_headers_b.id%TYPE) IS
16605: CURSOR c18(p_id NUMBER) IS
16606: SELECT
16607: a.id, a.object_version_number, a.tas_id,
16608: a.ilo_id, a.ilo_id_old, a.iay_id,

Line 17073: PROCEDURE insert_okl_trx_assets(p_old_id IN okc_k_headers_b.id%TYPE,

17069: RAISE OKC_API.G_EXCEPTION_ERROR;
17070:
17071: END; /* insert_okl_txl_assets_b */
17072:
17073: PROCEDURE insert_okl_trx_assets(p_old_id IN okc_k_headers_b.id%TYPE,
17074: p_new_id IN okc_k_headers_b.id%TYPE) IS
17075: CURSOR c17(p_id NUMBER) IS
17076: SELECT
17077: id, ica_id, tas_type,

Line 17074: p_new_id IN okc_k_headers_b.id%TYPE) IS

17070:
17071: END; /* insert_okl_txl_assets_b */
17072:
17073: PROCEDURE insert_okl_trx_assets(p_old_id IN okc_k_headers_b.id%TYPE,
17074: p_new_id IN okc_k_headers_b.id%TYPE) IS
17075: CURSOR c17(p_id NUMBER) IS
17076: SELECT
17077: id, ica_id, tas_type,
17078: object_version_number, attribute_category, attribute1,

Line 17295: PROCEDURE insert_okl_trx_assets_2(p_old_id IN okc_k_headers_b.id%TYPE,

17291: RAISE OKC_API.G_EXCEPTION_ERROR;
17292:
17293: END; /* insert_okl_trx_assets */
17294:
17295: PROCEDURE insert_okl_trx_assets_2(p_old_id IN okc_k_headers_b.id%TYPE,
17296: p_new_id IN okc_k_headers_b.id%TYPE) IS
17297: CURSOR c17_2(p_id NUMBER) IS
17298: SELECT
17299: id, ica_id, tas_type,

Line 17296: p_new_id IN okc_k_headers_b.id%TYPE) IS

17292:
17293: END; /* insert_okl_trx_assets */
17294:
17295: PROCEDURE insert_okl_trx_assets_2(p_old_id IN okc_k_headers_b.id%TYPE,
17296: p_new_id IN okc_k_headers_b.id%TYPE) IS
17297: CURSOR c17_2(p_id NUMBER) IS
17298: SELECT
17299: id, ica_id, tas_type,
17300: object_version_number, attribute_category, attribute1,

Line 17557: PROCEDURE insert_okl_txl_itm_insts(p_old_id IN okc_k_headers_b.id%TYPE,

17553: p_token2_value => SQLERRM);
17554: RETURN x_return_status;
17555: END generate_instance_number_ib;
17556:
17557: PROCEDURE insert_okl_txl_itm_insts(p_old_id IN okc_k_headers_b.id%TYPE,
17558: p_new_id IN okc_k_headers_b.id%TYPE) IS
17559: CURSOR c22(p_id NUMBER) IS
17560: SELECT
17561: p.id, p.object_version_number, p.tas_id,

Line 17558: p_new_id IN okc_k_headers_b.id%TYPE) IS

17554: RETURN x_return_status;
17555: END generate_instance_number_ib;
17556:
17557: PROCEDURE insert_okl_txl_itm_insts(p_old_id IN okc_k_headers_b.id%TYPE,
17558: p_new_id IN okc_k_headers_b.id%TYPE) IS
17559: CURSOR c22(p_id NUMBER) IS
17560: SELECT
17561: p.id, p.object_version_number, p.tas_id,
17562: p.tal_id, p.kle_id, p.tal_type,

Line 18039: PROCEDURE insert_okl_trx_assets_3(p_old_id IN okc_k_headers_b.id%TYPE,

18035: END IF;
18036:
18037: END; /* get_salvage_value */
18038:
18039: PROCEDURE insert_okl_trx_assets_3(p_old_id IN okc_k_headers_b.id%TYPE,
18040: p_new_id IN okc_k_headers_b.id%TYPE) IS
18041: CURSOR c27(p_id NUMBER) IS
18042: SELECT
18043: fa.asset_id ID1,

Line 18040: p_new_id IN okc_k_headers_b.id%TYPE) IS

18036:
18037: END; /* get_salvage_value */
18038:
18039: PROCEDURE insert_okl_trx_assets_3(p_old_id IN okc_k_headers_b.id%TYPE,
18040: p_new_id IN okc_k_headers_b.id%TYPE) IS
18041: CURSOR c27(p_id NUMBER) IS
18042: SELECT
18043: fa.asset_id ID1,
18044: '#' ID2,

Line 18355: FROM OKC_K_HEADERS_B

18351:
18352: --Added by dpsingh for LE Uptake
18353: CURSOR contract_num_csr (p_ctr_id1 NUMBER) IS
18354: SELECT contract_number
18355: FROM OKC_K_HEADERS_B
18356: WHERE id = p_ctr_id1;
18357:
18358: l_cntrct_number OKC_K_HEADERS_B.CONTRACT_NUMBER%TYPE;
18359: l_legal_entity_id NUMBER;

Line 18358: l_cntrct_number OKC_K_HEADERS_B.CONTRACT_NUMBER%TYPE;

18354: SELECT contract_number
18355: FROM OKC_K_HEADERS_B
18356: WHERE id = p_ctr_id1;
18357:
18358: l_cntrct_number OKC_K_HEADERS_B.CONTRACT_NUMBER%TYPE;
18359: l_legal_entity_id NUMBER;
18360:
18361: BEGIN
18362: OPEN c_try_id;

Line 19116: PROCEDURE insert_okc_rg_party_roles(p_old_id IN okc_k_headers_b.id%TYPE,

19112:
19113: RAISE OKC_API.G_EXCEPTION_ERROR;
19114: END; /* insert okl_trx_assets_3 */
19115:
19116: PROCEDURE insert_okc_rg_party_roles(p_old_id IN okc_k_headers_b.id%TYPE,
19117: p_new_id IN okc_k_headers_b.id%TYPE) IS
19118: CURSOR c25(p_id NUMBER) IS
19119: SELECT
19120: a.id, a.rgp_id, a.rrd_id,

Line 19117: p_new_id IN okc_k_headers_b.id%TYPE) IS

19113: RAISE OKC_API.G_EXCEPTION_ERROR;
19114: END; /* insert okl_trx_assets_3 */
19115:
19116: PROCEDURE insert_okc_rg_party_roles(p_old_id IN okc_k_headers_b.id%TYPE,
19117: p_new_id IN okc_k_headers_b.id%TYPE) IS
19118: CURSOR c25(p_id NUMBER) IS
19119: SELECT
19120: a.id, a.rgp_id, a.rrd_id,
19121: a.cpl_id, a.dnz_chr_id, a.object_version_number,

Line 19256: PROCEDURE insert_okl_supp_invoice_dtls(p_old_id IN okc_k_headers_b.id%TYPE)

19252: RAISE OKC_API.G_EXCEPTION_ERROR;
19253:
19254: END; /* insert_okc_rg_party_roles */
19255:
19256: PROCEDURE insert_okl_supp_invoice_dtls(p_old_id IN okc_k_headers_b.id%TYPE)
19257: IS
19258: CURSOR c26(p_id NUMBER) IS
19259: SELECT
19260: a.id, a.object_version_number, a.cle_id,

Line 19650: PROCEDURE insert_okl_txl_itm_insts2(p_old_id IN okc_k_headers_b.id%TYPE,

19646: END IF;
19647:
19648: END; /* get_object1_id1 */
19649:
19650: PROCEDURE insert_okl_txl_itm_insts2(p_old_id IN okc_k_headers_b.id%TYPE,
19651: p_new_id IN okc_k_headers_b.id%TYPE) IS
19652: CURSOR c28(p_id NUMBER) IS
19653: SELECT csi.inventory_item_id,
19654: csi.inv_master_organization_id,

Line 19651: p_new_id IN okc_k_headers_b.id%TYPE) IS

19647:
19648: END; /* get_object1_id1 */
19649:
19650: PROCEDURE insert_okl_txl_itm_insts2(p_old_id IN okc_k_headers_b.id%TYPE,
19651: p_new_id IN okc_k_headers_b.id%TYPE) IS
19652: CURSOR c28(p_id NUMBER) IS
19653: SELECT csi.inventory_item_id,
19654: csi.inv_master_organization_id,
19655: csi.instance_number,

Line 20180: l_chr_id okc_k_headers_b.id%TYPE;

20176: p_event_name IN wf_events.name%TYPE,
20177: p_parameter_list IN wf_parameter_list_t,
20178: p_contract_process IN VARCHAR2) IS
20179:
20180: l_chr_id okc_k_headers_b.id%TYPE;
20181: --l_contract_process VARCHAR2(30);
20182: l_parameter_list WF_PARAMETER_LIST_T := p_parameter_list;
20183:
20184: BEGIN

Line 20212: p_chr_id IN okc_k_headers_b.id%TYPE,

20208: END raise_business_event;
20209:
20210: PROCEDURE raise_business_event_subsidy(p_api_version IN NUMBER,
20211: p_init_msg_list IN VARCHAR2,
20212: p_chr_id IN okc_k_headers_b.id%TYPE,
20213: p_asset_id IN okc_k_lines_b.id%TYPE,
20214: p_subsidy_id IN okl_subsidies_b.id%TYPE,
20215: p_event_name IN VARCHAR2,
20216: p_contract_process IN VARCHAR2,

Line 20257: --p_chr_id okc_k_headers_b.id%TYPE;

20253: ,p_event_param_list IN WF_PARAMETER_LIST_T
20254: ,p_contract_process IN VARCHAR2
20255: )IS
20256: --l_process VARCHAR2(20);
20257: --p_chr_id okc_k_headers_b.id%TYPE;
20258: l_parameter_list WF_PARAMETER_LIST_T := p_event_param_list;
20259: BEGIN
20260: --p_chr_id := wf_event.GetValueForParameter(G_WF_ITM_CONTRACT_ID,p_event_param_list);
20261: --l_process := Okl_Lla_Util_Pvt.get_contract_process(p_chr_id);

Line 20279: p_chr_id IN okc_k_headers_b.id%TYPE,

20275: END raise_business_event_itm;
20276:
20277: PROCEDURE raise_business_event_dep(p_api_version IN NUMBER,
20278: p_init_msg_list IN VARCHAR2,
20279: p_chr_id IN okc_k_headers_b.id%TYPE,
20280: p_asset_id IN okc_k_lines_b.id%TYPE,
20281: p_book_code IN okl_txl_assets_b.corporate_book%TYPE,
20282: p_event_name IN VARCHAR2,
20283: p_contract_process IN VARCHAR2,

Line 20316: p_chr_id IN okc_k_headers_b.id%TYPE,

20312:
20313:
20314: PROCEDURE raise_business_event_txd(p_api_version IN NUMBER,
20315: p_init_msg_list IN VARCHAR2,
20316: p_chr_id IN okc_k_headers_b.id%TYPE,
20317: p_asset_id IN okc_k_lines_b.id%TYPE,
20318: p_event_name IN VARCHAR2,
20319: p_contract_process IN VARCHAR2,
20320: x_return_status OUT NOCOPY VARCHAR2,

Line 20352: p_chr_id IN okc_k_headers_b.id%TYPE,

20348:
20349: PROCEDURE raise_business_event_itm
20350: (p_api_version IN NUMBER,
20351: p_init_msg_list IN VARCHAR2,
20352: p_chr_id IN okc_k_headers_b.id%TYPE,
20353: p_asset_id IN okc_k_lines_b.id%TYPE,
20354: p_ser_num IN okl_txl_itm_insts.serial_number%TYPE,
20355: p_event_name IN VARCHAR2,
20356: p_contract_process IN VARCHAR2,

Line 20386: p_chr_id IN okc_k_headers_b.id%TYPE,

20382:
20383: PROCEDURE raise_business_event_supp
20384: (p_api_version IN NUMBER,
20385: p_init_msg_list IN VARCHAR2,
20386: p_chr_id IN okc_k_headers_b.id%TYPE,
20387: p_asset_id IN okc_k_lines_b.id%TYPE,
20388: p_vendor_id IN po_vendors.vendor_id%TYPE,
20389: p_event_name IN VARCHAR2,
20390: p_contract_process IN VARCHAR2,

Line 20672: SELECT okc_k_headers_b_s.NEXTVAL INTO l_copied_id FROM dual;

20668: l_sts_code_orig := c1rec.sts_code;
20669:
20670: l_curr_pos := 'okl_copy_lease_contract:4';
20671: -- kmotepal populating contract id from sys guid instead of using OKC sequence which fixes the bug 4436545 (Reverted back for OKL.H)
20672: SELECT okc_k_headers_b_s.NEXTVAL INTO l_copied_id FROM dual;
20673: --l_copied_id := okc_p_util.raw_to_number(sys_guid());
20674:
20675: l_contract_currency := c1rec.currency_code;
20676: l_contract_start_date := c1rec.start_date;

Line 20758: INSERT INTO okc_k_headers_b (

20754: END IF;
20755:
20756: BEGIN
20757: l_curr_pos := 'okl_copy_lease_contract:10';
20758: INSERT INTO okc_k_headers_b (
20759: ID, CONTRACT_NUMBER, AUTHORING_ORG_ID,
20760: CONTRACT_NUMBER_MODIFIER, CHR_ID_RESPONSE, CHR_ID_AWARD,
20761: CHR_ID_RENEWED, INV_ORGANIZATION_ID, STS_CODE,
20762: QCL_ID, SCS_CODE, TRN_CODE,

Line 20836: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'ERROR during insert into okc_k_headers_b...');

20832:
20833: EXCEPTION WHEN OTHERS THEN
20834: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
20835: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'sqlcode=' || SQLCODE || ':sqlerrm=' || SQLERRM);
20836: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'ERROR during insert into okc_k_headers_b...');
20837: END IF;
20838: OKL_API.set_message(p_app_name => 'OKL',
20839: p_msg_name => l_message,
20840: p_token1 => 'CONTRACT_NUMBER',

Line 22297: From okc_k_headers_b chr

22293: Cursor l_date_sig_csr(p_chr_id IN NUMBER,
22294: p_chr_number IN VARCHAR2,
22295: p_chr_modifier IN VARCHAR2) is
22296: Select chr.date_signed
22297: From okc_k_headers_b chr
22298: where
22299: ( (chr.id = p_chr_id and p_chr_id is not null)
22300: or (p_chr_id is null and p_chr_modifier is null and p_chr_number is not null and chr.contract_number = p_chr_number )
22301: or (p_chr_id is null and p_chr_modifier is not null and p_chr_number is not null and chr.contract_number_modifier = p_chr_modifier and chr.contract_number = p_chr_number)

Line 22327: From okc_k_headers_b

22323: --Bug #2555692
22324: Cursor l_scs_csr (p_chr_id IN NUMBER) is
22325: Select scs_code,
22326: orig_system_id1
22327: From okc_k_headers_b
22328: where id = p_chr_id;
22329:
22330: l_scs_code okc_k_headers_b.SCS_CODE%TYPE;
22331: l_orig_chr_id okc_k_headers_b.ORIG_SYSTEM_ID1%TYPE;

Line 22330: l_scs_code okc_k_headers_b.SCS_CODE%TYPE;

22326: orig_system_id1
22327: From okc_k_headers_b
22328: where id = p_chr_id;
22329:
22330: l_scs_code okc_k_headers_b.SCS_CODE%TYPE;
22331: l_orig_chr_id okc_k_headers_b.ORIG_SYSTEM_ID1%TYPE;
22332:
22333: --Bug # 2792330 S and O
22334: --get the status of source contract

Line 22331: l_orig_chr_id okc_k_headers_b.ORIG_SYSTEM_ID1%TYPE;

22327: From okc_k_headers_b
22328: where id = p_chr_id;
22329:
22330: l_scs_code okc_k_headers_b.SCS_CODE%TYPE;
22331: l_orig_chr_id okc_k_headers_b.ORIG_SYSTEM_ID1%TYPE;
22332:
22333: --Bug # 2792330 S and O
22334: --get the status of source contract
22335: Cursor l_sts_csr (pchrid in number) is

Line 22337: From OKC_K_HEADERS_B

22333: --Bug # 2792330 S and O
22334: --get the status of source contract
22335: Cursor l_sts_csr (pchrid in number) is
22336: Select sts_code
22337: From OKC_K_HEADERS_B
22338: Where id = pchrid;
22339:
22340: l_sts_code okc_k_headers_b.STS_CODE%TYPE;
22341: l_quote_chr_id okc_k_headers_b.ID%TYPE;

Line 22340: l_sts_code okc_k_headers_b.STS_CODE%TYPE;

22336: Select sts_code
22337: From OKC_K_HEADERS_B
22338: Where id = pchrid;
22339:
22340: l_sts_code okc_k_headers_b.STS_CODE%TYPE;
22341: l_quote_chr_id okc_k_headers_b.ID%TYPE;
22342:
22343: --Bug# 3621663
22344: --cursor to get multi-gaap reporting book transaction

Line 22341: l_quote_chr_id okc_k_headers_b.ID%TYPE;

22337: From OKC_K_HEADERS_B
22338: Where id = pchrid;
22339:
22340: l_sts_code okc_k_headers_b.STS_CODE%TYPE;
22341: l_quote_chr_id okc_k_headers_b.ID%TYPE;
22342:
22343: --Bug# 3621663
22344: --cursor to get multi-gaap reporting book transaction
22345: cursor l_txd_csr (p_book_type_code in varchar2,

Line 22371: okc_k_headers_b parent_chrb

22367: cursor l_parent_sts_csr (p_chr_id in number) is
22368: select stsb.ste_code,
22369: parent_chrb.scs_code
22370: from okc_statuses_b stsb,
22371: okc_k_headers_b parent_chrb
22372: where stsb.code = parent_chrb.sts_code
22373: and parent_chrb.id = p_chr_id;
22374:
22375: l_parent_sts_rec l_parent_sts_csr%ROWTYPE;