DBA Data[Home] [Help]

APPS.OKL_LA_TRADEIN_PVT dependencies on OKL_K_HEADERS

Line 581: p_chr_id IN okl_k_headers.id%TYPE,

577: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
578: x_return_status OUT NOCOPY VARCHAR2,
579: x_msg_count OUT NOCOPY NUMBER,
580: x_msg_data OUT NOCOPY VARCHAR2,
581: p_chr_id IN okl_k_headers.id%TYPE,
582: p_tradein_date IN okl_k_headers.date_tradein%TYPE,
583: p_tradein_amount IN okl_k_headers.tradein_amount%TYPE,
584: p_tradein_desc IN okl_k_headers.tradein_description%TYPE
585: )IS

Line 582: p_tradein_date IN okl_k_headers.date_tradein%TYPE,

578: x_return_status OUT NOCOPY VARCHAR2,
579: x_msg_count OUT NOCOPY NUMBER,
580: x_msg_data OUT NOCOPY VARCHAR2,
581: p_chr_id IN okl_k_headers.id%TYPE,
582: p_tradein_date IN okl_k_headers.date_tradein%TYPE,
583: p_tradein_amount IN okl_k_headers.tradein_amount%TYPE,
584: p_tradein_desc IN okl_k_headers.tradein_description%TYPE
585: )IS
586:

Line 583: p_tradein_amount IN okl_k_headers.tradein_amount%TYPE,

579: x_msg_count OUT NOCOPY NUMBER,
580: x_msg_data OUT NOCOPY VARCHAR2,
581: p_chr_id IN okl_k_headers.id%TYPE,
582: p_tradein_date IN okl_k_headers.date_tradein%TYPE,
583: p_tradein_amount IN okl_k_headers.tradein_amount%TYPE,
584: p_tradein_desc IN okl_k_headers.tradein_description%TYPE
585: )IS
586:
587: lp_chrv_rec okl_okc_migration_pvt.chrv_rec_type;

Line 584: p_tradein_desc IN okl_k_headers.tradein_description%TYPE

580: x_msg_data OUT NOCOPY VARCHAR2,
581: p_chr_id IN okl_k_headers.id%TYPE,
582: p_tradein_date IN okl_k_headers.date_tradein%TYPE,
583: p_tradein_amount IN okl_k_headers.tradein_amount%TYPE,
584: p_tradein_desc IN okl_k_headers.tradein_description%TYPE
585: )IS
586:
587: lp_chrv_rec okl_okc_migration_pvt.chrv_rec_type;
588: lp_khrv_rec okl_khr_pvt.khrv_rec_type;

Line 594: l_tradein_date okl_k_headers.date_tradein%TYPE := p_tradein_date;

590: lx_chrv_rec okl_okc_migration_pvt.chrv_rec_type;
591: lx_khrv_rec okl_khr_pvt.khrv_rec_type;
592:
593: l_chr_id okc_k_headers_b.id%type := p_chr_id;
594: l_tradein_date okl_k_headers.date_tradein%TYPE := p_tradein_date;
595: l_tradein_amount okl_k_headers.tradein_amount%TYPE := p_tradein_amount;
596: l_tradein_desc okl_k_headers.tradein_description%TYPE := p_tradein_desc;
597:
598: l_api_name CONSTANT VARCHAR2(30) := 'update_contract';

Line 595: l_tradein_amount okl_k_headers.tradein_amount%TYPE := p_tradein_amount;

591: lx_khrv_rec okl_khr_pvt.khrv_rec_type;
592:
593: l_chr_id okc_k_headers_b.id%type := p_chr_id;
594: l_tradein_date okl_k_headers.date_tradein%TYPE := p_tradein_date;
595: l_tradein_amount okl_k_headers.tradein_amount%TYPE := p_tradein_amount;
596: l_tradein_desc okl_k_headers.tradein_description%TYPE := p_tradein_desc;
597:
598: l_api_name CONSTANT VARCHAR2(30) := 'update_contract';
599: l_api_version CONSTANT NUMBER := 1.0;

Line 596: l_tradein_desc okl_k_headers.tradein_description%TYPE := p_tradein_desc;

592:
593: l_chr_id okc_k_headers_b.id%type := p_chr_id;
594: l_tradein_date okl_k_headers.date_tradein%TYPE := p_tradein_date;
595: l_tradein_amount okl_k_headers.tradein_amount%TYPE := p_tradein_amount;
596: l_tradein_desc okl_k_headers.tradein_description%TYPE := p_tradein_desc;
597:
598: l_api_name CONSTANT VARCHAR2(30) := 'update_contract';
599: l_api_version CONSTANT NUMBER := 1.0;
600: l_ak_prompt AK_ATTRIBUTES_VL.attribute_label_long%type;

Line 729: p_chr_id IN OKL_K_HEADERS.id%TYPE,

725: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
726: x_return_status OUT NOCOPY VARCHAR2,
727: x_msg_count OUT NOCOPY NUMBER,
728: x_msg_data OUT NOCOPY VARCHAR2,
729: p_chr_id IN OKL_K_HEADERS.id%TYPE,
730: p_cle_id IN OKL_K_LINES.id%TYPE
731: )IS
732:
733: l_cap_amount NUMBER;

Line 863: p_chr_id IN okl_k_headers.id%TYPE,

859: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
860: x_return_status OUT NOCOPY VARCHAR2,
861: x_msg_count OUT NOCOPY NUMBER,
862: x_msg_data OUT NOCOPY VARCHAR2,
863: p_chr_id IN okl_k_headers.id%TYPE,
864: p_tradein_rec IN tradein_rec_type,
865: x_tradein_rec OUT NOCOPY tradein_rec_type
866: )IS
867:

Line 1036: p_chr_id IN okl_k_headers.id%TYPE,

1032: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
1033: x_return_status OUT NOCOPY VARCHAR2,
1034: x_msg_count OUT NOCOPY NUMBER,
1035: x_msg_data OUT NOCOPY VARCHAR2,
1036: p_chr_id IN okl_k_headers.id%TYPE,
1037: p_tradein_tbl IN tradein_tbl_type,
1038: x_tradein_tbl OUT NOCOPY tradein_tbl_type
1039: )IS
1040:

Line 1183: p_chr_id IN okl_k_headers.id%TYPE,

1179: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
1180: x_return_status OUT NOCOPY VARCHAR2,
1181: x_msg_count OUT NOCOPY NUMBER,
1182: x_msg_data OUT NOCOPY VARCHAR2,
1183: p_chr_id IN okl_k_headers.id%TYPE,
1184: p_tradein_rec IN tradein_rec_type,
1185: x_tradein_rec OUT NOCOPY tradein_rec_type
1186: )IS
1187:

Line 1300: p_chr_id IN okl_k_headers.id%TYPE,

1296: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
1297: x_return_status OUT NOCOPY VARCHAR2,
1298: x_msg_count OUT NOCOPY NUMBER,
1299: x_msg_data OUT NOCOPY VARCHAR2,
1300: p_chr_id IN okl_k_headers.id%TYPE,
1301: p_tradein_tbl IN tradein_tbl_type,
1302: x_tradein_tbl OUT NOCOPY tradein_tbl_type
1303: )IS
1304:

Line 1593: FROM okl_k_headers

1589:
1590:
1591: SELECT nvl(tradein_amount,0)
1592: INTO l_tradein_amount
1593: FROM okl_k_headers
1594: WHERE id = p_chr_id;
1595:
1596: SELECT currency_code
1597: INTO l_currency_code

Line 1814: p_chr_id IN okl_k_headers.id%TYPE

1810: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
1811: x_return_status OUT NOCOPY VARCHAR2,
1812: x_msg_count OUT NOCOPY NUMBER,
1813: x_msg_data OUT NOCOPY VARCHAR2,
1814: p_chr_id IN okl_k_headers.id%TYPE
1815: )IS
1816:
1817: lp_chrv_rec okl_okc_migration_pvt.chrv_rec_type;
1818: lp_khrv_rec okl_khr_pvt.khrv_rec_type;