DBA Data[Home] [Help]

APPS.OKL_AM_TERMNT_QUOTE_PVT dependencies on OKL_API

Line 8: G_APP_NAME CONSTANT VARCHAR2(3) := OKL_API.G_APP_NAME;

4: ---------------------------------------------------------------------------
5: -- GLOBAL CONSTANTS
6: ---------------------------------------------------------------------------
7: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_AM_TERMNT_QUOTE_PVT';
8: G_APP_NAME CONSTANT VARCHAR2(3) := OKL_API.G_APP_NAME;
9: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_CONTRACTS_UNEXPECTED_ERROR';
10: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';
11: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
12:

Line 25: TYPE qte_ln_dtl_rec IS RECORD (qst_code OKL_TRX_QUOTES_B.QST_CODE%TYPE := OKL_API.G_MISS_CHAR,

21:
22: ---------------------------------------------------------------------------
23: -- GLOBAL DATASTRUCTURES
24: ---------------------------------------------------------------------------
25: TYPE qte_ln_dtl_rec IS RECORD (qst_code OKL_TRX_QUOTES_B.QST_CODE%TYPE := OKL_API.G_MISS_CHAR,
26: qte_id OKL_TRX_QUOTES_B.ID%TYPE := OKL_API.G_MISS_NUM,
27: instance_quantity OKL_TXD_QUOTE_LINE_DTLS.NUMBER_OF_UNITS%TYPE,
28: tql_id OKL_TXL_QUOTE_LINES_B.ID%TYPE := OKL_API.G_MISS_NUM,
29: tqd_id OKL_TXD_QUOTE_LINE_DTLS.ID%TYPE := OKL_API.G_MISS_NUM,

Line 26: qte_id OKL_TRX_QUOTES_B.ID%TYPE := OKL_API.G_MISS_NUM,

22: ---------------------------------------------------------------------------
23: -- GLOBAL DATASTRUCTURES
24: ---------------------------------------------------------------------------
25: TYPE qte_ln_dtl_rec IS RECORD (qst_code OKL_TRX_QUOTES_B.QST_CODE%TYPE := OKL_API.G_MISS_CHAR,
26: qte_id OKL_TRX_QUOTES_B.ID%TYPE := OKL_API.G_MISS_NUM,
27: instance_quantity OKL_TXD_QUOTE_LINE_DTLS.NUMBER_OF_UNITS%TYPE,
28: tql_id OKL_TXL_QUOTE_LINES_B.ID%TYPE := OKL_API.G_MISS_NUM,
29: tqd_id OKL_TXD_QUOTE_LINE_DTLS.ID%TYPE := OKL_API.G_MISS_NUM,
30: select_yn VARCHAR2(3) := NULL,

Line 28: tql_id OKL_TXL_QUOTE_LINES_B.ID%TYPE := OKL_API.G_MISS_NUM,

24: ---------------------------------------------------------------------------
25: TYPE qte_ln_dtl_rec IS RECORD (qst_code OKL_TRX_QUOTES_B.QST_CODE%TYPE := OKL_API.G_MISS_CHAR,
26: qte_id OKL_TRX_QUOTES_B.ID%TYPE := OKL_API.G_MISS_NUM,
27: instance_quantity OKL_TXD_QUOTE_LINE_DTLS.NUMBER_OF_UNITS%TYPE,
28: tql_id OKL_TXL_QUOTE_LINES_B.ID%TYPE := OKL_API.G_MISS_NUM,
29: tqd_id OKL_TXD_QUOTE_LINE_DTLS.ID%TYPE := OKL_API.G_MISS_NUM,
30: select_yn VARCHAR2(3) := NULL,
31: ib_line_id OKC_K_LINES_B.ID%TYPE := OKL_API.G_MISS_NUM,
32: fin_line_id OKC_K_LINES_B.ID%TYPE := OKL_API.G_MISS_NUM,

Line 29: tqd_id OKL_TXD_QUOTE_LINE_DTLS.ID%TYPE := OKL_API.G_MISS_NUM,

25: TYPE qte_ln_dtl_rec IS RECORD (qst_code OKL_TRX_QUOTES_B.QST_CODE%TYPE := OKL_API.G_MISS_CHAR,
26: qte_id OKL_TRX_QUOTES_B.ID%TYPE := OKL_API.G_MISS_NUM,
27: instance_quantity OKL_TXD_QUOTE_LINE_DTLS.NUMBER_OF_UNITS%TYPE,
28: tql_id OKL_TXL_QUOTE_LINES_B.ID%TYPE := OKL_API.G_MISS_NUM,
29: tqd_id OKL_TXD_QUOTE_LINE_DTLS.ID%TYPE := OKL_API.G_MISS_NUM,
30: select_yn VARCHAR2(3) := NULL,
31: ib_line_id OKC_K_LINES_B.ID%TYPE := OKL_API.G_MISS_NUM,
32: fin_line_id OKC_K_LINES_B.ID%TYPE := OKL_API.G_MISS_NUM,
33: dnz_chr_id OKC_K_LINES_B.DNZ_CHR_ID%TYPE := OKL_API.G_MISS_NUM);

Line 31: ib_line_id OKC_K_LINES_B.ID%TYPE := OKL_API.G_MISS_NUM,

27: instance_quantity OKL_TXD_QUOTE_LINE_DTLS.NUMBER_OF_UNITS%TYPE,
28: tql_id OKL_TXL_QUOTE_LINES_B.ID%TYPE := OKL_API.G_MISS_NUM,
29: tqd_id OKL_TXD_QUOTE_LINE_DTLS.ID%TYPE := OKL_API.G_MISS_NUM,
30: select_yn VARCHAR2(3) := NULL,
31: ib_line_id OKC_K_LINES_B.ID%TYPE := OKL_API.G_MISS_NUM,
32: fin_line_id OKC_K_LINES_B.ID%TYPE := OKL_API.G_MISS_NUM,
33: dnz_chr_id OKC_K_LINES_B.DNZ_CHR_ID%TYPE := OKL_API.G_MISS_NUM);
34: TYPE qte_ln_dtl_tbl IS TABLE OF qte_ln_dtl_rec
35: INDEX BY BINARY_INTEGER;

Line 32: fin_line_id OKC_K_LINES_B.ID%TYPE := OKL_API.G_MISS_NUM,

28: tql_id OKL_TXL_QUOTE_LINES_B.ID%TYPE := OKL_API.G_MISS_NUM,
29: tqd_id OKL_TXD_QUOTE_LINE_DTLS.ID%TYPE := OKL_API.G_MISS_NUM,
30: select_yn VARCHAR2(3) := NULL,
31: ib_line_id OKC_K_LINES_B.ID%TYPE := OKL_API.G_MISS_NUM,
32: fin_line_id OKC_K_LINES_B.ID%TYPE := OKL_API.G_MISS_NUM,
33: dnz_chr_id OKC_K_LINES_B.DNZ_CHR_ID%TYPE := OKL_API.G_MISS_NUM);
34: TYPE qte_ln_dtl_tbl IS TABLE OF qte_ln_dtl_rec
35: INDEX BY BINARY_INTEGER;
36: SUBTYPE term_rec_type IS OKL_TRX_QUOTES_PUB.qtev_rec_type;

Line 33: dnz_chr_id OKC_K_LINES_B.DNZ_CHR_ID%TYPE := OKL_API.G_MISS_NUM);

29: tqd_id OKL_TXD_QUOTE_LINE_DTLS.ID%TYPE := OKL_API.G_MISS_NUM,
30: select_yn VARCHAR2(3) := NULL,
31: ib_line_id OKC_K_LINES_B.ID%TYPE := OKL_API.G_MISS_NUM,
32: fin_line_id OKC_K_LINES_B.ID%TYPE := OKL_API.G_MISS_NUM,
33: dnz_chr_id OKC_K_LINES_B.DNZ_CHR_ID%TYPE := OKL_API.G_MISS_NUM);
34: TYPE qte_ln_dtl_tbl IS TABLE OF qte_ln_dtl_rec
35: INDEX BY BINARY_INTEGER;
36: SUBTYPE term_rec_type IS OKL_TRX_QUOTES_PUB.qtev_rec_type;
37: SUBTYPE term_tbl_type IS OKL_TRX_QUOTES_PUB.qtev_tbl_type;

Line 92: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

88: x_clev_tbl OUT NOCOPY clev_tbl_type) RETURN VARCHAR2;
89:
90: -- Create records in Quote Line details after proper validation
91: PROCEDURE quote_line_dtls(p_api_version IN NUMBER,
92: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
93: x_return_status OUT NOCOPY VARCHAR2,
94: x_msg_count OUT NOCOPY NUMBER,
95: x_msg_data OUT NOCOPY VARCHAR2,
96: p_qld_tbl IN OUT NOCOPY qte_ln_dtl_tbl);