4: ---------------------------------------------------------------------------
5: -- GLOBAL CONSTANTS
6: ---------------------------------------------------------------------------
7: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_AM_SEND_FULFILLMENT_PVT';
8: G_APP_NAME CONSTANT VARCHAR2(3) := OKL_API.G_APP_NAME;
9: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKL_CONTRACTS_UNEXPECTED_ERROR';
10: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';
11: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
12: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;
8: G_APP_NAME CONSTANT VARCHAR2(3) := OKL_API.G_APP_NAME;
9: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKL_CONTRACTS_UNEXPECTED_ERROR';
10: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';
11: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
12: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;
13: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_INVALID_VALUE;
14: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_COL_NAME_TOKEN;
15:
16: -- p_ptm_code : From OKL_PROCESS_TMPLTS_V
9: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKL_CONTRACTS_UNEXPECTED_ERROR';
10: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';
11: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
12: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;
13: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_INVALID_VALUE;
14: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_COL_NAME_TOKEN;
15:
16: -- p_ptm_code : From OKL_PROCESS_TMPLTS_V
17: -- p_agent_id : Created by
10: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';
11: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
12: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;
13: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_INVALID_VALUE;
14: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_COL_NAME_TOKEN;
15:
16: -- p_ptm_code : From OKL_PROCESS_TMPLTS_V
17: -- p_agent_id : Created by
18: -- p_transaction_id : Quote_Id, Rmk_Id etc
25: -- p_recipient_id :
26:
27:
28: TYPE full_rec_type IS RECORD (
29: p_ptm_code VARCHAR2(200) := OKL_API.G_MISS_CHAR,
30: p_agent_id NUMBER := OKL_API.G_MISS_NUM,
31: p_transaction_id NUMBER := OKL_API.G_MISS_NUM,
32: p_recipient_type VARCHAR2(200) := OKL_API.G_MISS_CHAR,
33: p_recipient_id VARCHAR2(200) := OKL_API.G_MISS_CHAR,
26:
27:
28: TYPE full_rec_type IS RECORD (
29: p_ptm_code VARCHAR2(200) := OKL_API.G_MISS_CHAR,
30: p_agent_id NUMBER := OKL_API.G_MISS_NUM,
31: p_transaction_id NUMBER := OKL_API.G_MISS_NUM,
32: p_recipient_type VARCHAR2(200) := OKL_API.G_MISS_CHAR,
33: p_recipient_id VARCHAR2(200) := OKL_API.G_MISS_CHAR,
34: p_expand_roles VARCHAR2(200) := OKL_API.G_MISS_CHAR,
27:
28: TYPE full_rec_type IS RECORD (
29: p_ptm_code VARCHAR2(200) := OKL_API.G_MISS_CHAR,
30: p_agent_id NUMBER := OKL_API.G_MISS_NUM,
31: p_transaction_id NUMBER := OKL_API.G_MISS_NUM,
32: p_recipient_type VARCHAR2(200) := OKL_API.G_MISS_CHAR,
33: p_recipient_id VARCHAR2(200) := OKL_API.G_MISS_CHAR,
34: p_expand_roles VARCHAR2(200) := OKL_API.G_MISS_CHAR,
35: p_subject_line VARCHAR2(200) := OKL_API.G_MISS_CHAR,
28: TYPE full_rec_type IS RECORD (
29: p_ptm_code VARCHAR2(200) := OKL_API.G_MISS_CHAR,
30: p_agent_id NUMBER := OKL_API.G_MISS_NUM,
31: p_transaction_id NUMBER := OKL_API.G_MISS_NUM,
32: p_recipient_type VARCHAR2(200) := OKL_API.G_MISS_CHAR,
33: p_recipient_id VARCHAR2(200) := OKL_API.G_MISS_CHAR,
34: p_expand_roles VARCHAR2(200) := OKL_API.G_MISS_CHAR,
35: p_subject_line VARCHAR2(200) := OKL_API.G_MISS_CHAR,
36: p_sender_email VARCHAR2(200) := OKL_API.G_MISS_CHAR,
29: p_ptm_code VARCHAR2(200) := OKL_API.G_MISS_CHAR,
30: p_agent_id NUMBER := OKL_API.G_MISS_NUM,
31: p_transaction_id NUMBER := OKL_API.G_MISS_NUM,
32: p_recipient_type VARCHAR2(200) := OKL_API.G_MISS_CHAR,
33: p_recipient_id VARCHAR2(200) := OKL_API.G_MISS_CHAR,
34: p_expand_roles VARCHAR2(200) := OKL_API.G_MISS_CHAR,
35: p_subject_line VARCHAR2(200) := OKL_API.G_MISS_CHAR,
36: p_sender_email VARCHAR2(200) := OKL_API.G_MISS_CHAR,
37: p_recipient_email VARCHAR2(200) := OKL_API.G_MISS_CHAR);
30: p_agent_id NUMBER := OKL_API.G_MISS_NUM,
31: p_transaction_id NUMBER := OKL_API.G_MISS_NUM,
32: p_recipient_type VARCHAR2(200) := OKL_API.G_MISS_CHAR,
33: p_recipient_id VARCHAR2(200) := OKL_API.G_MISS_CHAR,
34: p_expand_roles VARCHAR2(200) := OKL_API.G_MISS_CHAR,
35: p_subject_line VARCHAR2(200) := OKL_API.G_MISS_CHAR,
36: p_sender_email VARCHAR2(200) := OKL_API.G_MISS_CHAR,
37: p_recipient_email VARCHAR2(200) := OKL_API.G_MISS_CHAR);
38:
31: p_transaction_id NUMBER := OKL_API.G_MISS_NUM,
32: p_recipient_type VARCHAR2(200) := OKL_API.G_MISS_CHAR,
33: p_recipient_id VARCHAR2(200) := OKL_API.G_MISS_CHAR,
34: p_expand_roles VARCHAR2(200) := OKL_API.G_MISS_CHAR,
35: p_subject_line VARCHAR2(200) := OKL_API.G_MISS_CHAR,
36: p_sender_email VARCHAR2(200) := OKL_API.G_MISS_CHAR,
37: p_recipient_email VARCHAR2(200) := OKL_API.G_MISS_CHAR);
38:
39: TYPE full_tbl_type IS TABLE OF full_rec_type INDEX BY BINARY_INTEGER;
32: p_recipient_type VARCHAR2(200) := OKL_API.G_MISS_CHAR,
33: p_recipient_id VARCHAR2(200) := OKL_API.G_MISS_CHAR,
34: p_expand_roles VARCHAR2(200) := OKL_API.G_MISS_CHAR,
35: p_subject_line VARCHAR2(200) := OKL_API.G_MISS_CHAR,
36: p_sender_email VARCHAR2(200) := OKL_API.G_MISS_CHAR,
37: p_recipient_email VARCHAR2(200) := OKL_API.G_MISS_CHAR);
38:
39: TYPE full_tbl_type IS TABLE OF full_rec_type INDEX BY BINARY_INTEGER;
40:
33: p_recipient_id VARCHAR2(200) := OKL_API.G_MISS_CHAR,
34: p_expand_roles VARCHAR2(200) := OKL_API.G_MISS_CHAR,
35: p_subject_line VARCHAR2(200) := OKL_API.G_MISS_CHAR,
36: p_sender_email VARCHAR2(200) := OKL_API.G_MISS_CHAR,
37: p_recipient_email VARCHAR2(200) := OKL_API.G_MISS_CHAR);
38:
39: TYPE full_tbl_type IS TABLE OF full_rec_type INDEX BY BINARY_INTEGER;
40:
41: SUBTYPE qtev_rec_type IS OKL_TRX_QUOTES_PUB.qtev_rec_type;