DBA Data[Home] [Help]

APPS.OKL_ACCOUNT_GENERATOR_PVT dependencies on OKL_API

Line 29: (PRODUCT_ID NUMBER := OKL_API.G_MISS_NUM,

25:
26: TYPE primary_key_tbl IS TABLE OF primary_key_rec INDEX BY BINARY_INTEGER;
27:
28: TYPE acc_gen_wf_sources_rec IS RECORD
29: (PRODUCT_ID NUMBER := OKL_API.G_MISS_NUM,
30: TRANSACTION_TYPE_ID NUMBER := OKL_API.G_MISS_NUM,
31: STREAM_TYPE_ID NUMBER := OKL_API.G_MISS_NUM,
32: FACTORING_SYND_FLAG OKL_AE_TEMPLATES.FACTORING_SYND_FLAG%TYPE := OKL_API.G_MISS_CHAR,
33: SYNDICATION_CODE OKL_AE_TEMPLATES.SYT_CODE%TYPE := OKL_API.G_MISS_CHAR,

Line 30: TRANSACTION_TYPE_ID NUMBER := OKL_API.G_MISS_NUM,

26: TYPE primary_key_tbl IS TABLE OF primary_key_rec INDEX BY BINARY_INTEGER;
27:
28: TYPE acc_gen_wf_sources_rec IS RECORD
29: (PRODUCT_ID NUMBER := OKL_API.G_MISS_NUM,
30: TRANSACTION_TYPE_ID NUMBER := OKL_API.G_MISS_NUM,
31: STREAM_TYPE_ID NUMBER := OKL_API.G_MISS_NUM,
32: FACTORING_SYND_FLAG OKL_AE_TEMPLATES.FACTORING_SYND_FLAG%TYPE := OKL_API.G_MISS_CHAR,
33: SYNDICATION_CODE OKL_AE_TEMPLATES.SYT_CODE%TYPE := OKL_API.G_MISS_CHAR,
34: FACTORING_CODE OKL_AE_TEMPLATES.FAC_CODE%TYPE := OKL_API.G_MISS_CHAR,

Line 31: STREAM_TYPE_ID NUMBER := OKL_API.G_MISS_NUM,

27:
28: TYPE acc_gen_wf_sources_rec IS RECORD
29: (PRODUCT_ID NUMBER := OKL_API.G_MISS_NUM,
30: TRANSACTION_TYPE_ID NUMBER := OKL_API.G_MISS_NUM,
31: STREAM_TYPE_ID NUMBER := OKL_API.G_MISS_NUM,
32: FACTORING_SYND_FLAG OKL_AE_TEMPLATES.FACTORING_SYND_FLAG%TYPE := OKL_API.G_MISS_CHAR,
33: SYNDICATION_CODE OKL_AE_TEMPLATES.SYT_CODE%TYPE := OKL_API.G_MISS_CHAR,
34: FACTORING_CODE OKL_AE_TEMPLATES.FAC_CODE%TYPE := OKL_API.G_MISS_CHAR,
35: INVESTOR_CODE OKL_AE_TEMPLATES.INV_CODE%TYPE := OKL_API.G_MISS_CHAR,

Line 32: FACTORING_SYND_FLAG OKL_AE_TEMPLATES.FACTORING_SYND_FLAG%TYPE := OKL_API.G_MISS_CHAR,

28: TYPE acc_gen_wf_sources_rec IS RECORD
29: (PRODUCT_ID NUMBER := OKL_API.G_MISS_NUM,
30: TRANSACTION_TYPE_ID NUMBER := OKL_API.G_MISS_NUM,
31: STREAM_TYPE_ID NUMBER := OKL_API.G_MISS_NUM,
32: FACTORING_SYND_FLAG OKL_AE_TEMPLATES.FACTORING_SYND_FLAG%TYPE := OKL_API.G_MISS_CHAR,
33: SYNDICATION_CODE OKL_AE_TEMPLATES.SYT_CODE%TYPE := OKL_API.G_MISS_CHAR,
34: FACTORING_CODE OKL_AE_TEMPLATES.FAC_CODE%TYPE := OKL_API.G_MISS_CHAR,
35: INVESTOR_CODE OKL_AE_TEMPLATES.INV_CODE%TYPE := OKL_API.G_MISS_CHAR,
36: MEMO_YN OKL_AE_TEMPLATES.MEMO_YN%TYPE := OKL_API.G_MISS_CHAR,

Line 33: SYNDICATION_CODE OKL_AE_TEMPLATES.SYT_CODE%TYPE := OKL_API.G_MISS_CHAR,

29: (PRODUCT_ID NUMBER := OKL_API.G_MISS_NUM,
30: TRANSACTION_TYPE_ID NUMBER := OKL_API.G_MISS_NUM,
31: STREAM_TYPE_ID NUMBER := OKL_API.G_MISS_NUM,
32: FACTORING_SYND_FLAG OKL_AE_TEMPLATES.FACTORING_SYND_FLAG%TYPE := OKL_API.G_MISS_CHAR,
33: SYNDICATION_CODE OKL_AE_TEMPLATES.SYT_CODE%TYPE := OKL_API.G_MISS_CHAR,
34: FACTORING_CODE OKL_AE_TEMPLATES.FAC_CODE%TYPE := OKL_API.G_MISS_CHAR,
35: INVESTOR_CODE OKL_AE_TEMPLATES.INV_CODE%TYPE := OKL_API.G_MISS_CHAR,
36: MEMO_YN OKL_AE_TEMPLATES.MEMO_YN%TYPE := OKL_API.G_MISS_CHAR,
37: REV_REC_FLAG VARCHAR2(1) := 'N',

Line 34: FACTORING_CODE OKL_AE_TEMPLATES.FAC_CODE%TYPE := OKL_API.G_MISS_CHAR,

30: TRANSACTION_TYPE_ID NUMBER := OKL_API.G_MISS_NUM,
31: STREAM_TYPE_ID NUMBER := OKL_API.G_MISS_NUM,
32: FACTORING_SYND_FLAG OKL_AE_TEMPLATES.FACTORING_SYND_FLAG%TYPE := OKL_API.G_MISS_CHAR,
33: SYNDICATION_CODE OKL_AE_TEMPLATES.SYT_CODE%TYPE := OKL_API.G_MISS_CHAR,
34: FACTORING_CODE OKL_AE_TEMPLATES.FAC_CODE%TYPE := OKL_API.G_MISS_CHAR,
35: INVESTOR_CODE OKL_AE_TEMPLATES.INV_CODE%TYPE := OKL_API.G_MISS_CHAR,
36: MEMO_YN OKL_AE_TEMPLATES.MEMO_YN%TYPE := OKL_API.G_MISS_CHAR,
37: REV_REC_FLAG VARCHAR2(1) := 'N',
38: SOURCE_ID NUMBER := OKL_API.G_MISS_NUM,

Line 35: INVESTOR_CODE OKL_AE_TEMPLATES.INV_CODE%TYPE := OKL_API.G_MISS_CHAR,

31: STREAM_TYPE_ID NUMBER := OKL_API.G_MISS_NUM,
32: FACTORING_SYND_FLAG OKL_AE_TEMPLATES.FACTORING_SYND_FLAG%TYPE := OKL_API.G_MISS_CHAR,
33: SYNDICATION_CODE OKL_AE_TEMPLATES.SYT_CODE%TYPE := OKL_API.G_MISS_CHAR,
34: FACTORING_CODE OKL_AE_TEMPLATES.FAC_CODE%TYPE := OKL_API.G_MISS_CHAR,
35: INVESTOR_CODE OKL_AE_TEMPLATES.INV_CODE%TYPE := OKL_API.G_MISS_CHAR,
36: MEMO_YN OKL_AE_TEMPLATES.MEMO_YN%TYPE := OKL_API.G_MISS_CHAR,
37: REV_REC_FLAG VARCHAR2(1) := 'N',
38: SOURCE_ID NUMBER := OKL_API.G_MISS_NUM,
39: SOURCE_TABLE OKL_TRNS_ACC_DSTRS.SOURCE_TABLE%TYPE := OKL_API.G_MISS_CHAR,

Line 36: MEMO_YN OKL_AE_TEMPLATES.MEMO_YN%TYPE := OKL_API.G_MISS_CHAR,

32: FACTORING_SYND_FLAG OKL_AE_TEMPLATES.FACTORING_SYND_FLAG%TYPE := OKL_API.G_MISS_CHAR,
33: SYNDICATION_CODE OKL_AE_TEMPLATES.SYT_CODE%TYPE := OKL_API.G_MISS_CHAR,
34: FACTORING_CODE OKL_AE_TEMPLATES.FAC_CODE%TYPE := OKL_API.G_MISS_CHAR,
35: INVESTOR_CODE OKL_AE_TEMPLATES.INV_CODE%TYPE := OKL_API.G_MISS_CHAR,
36: MEMO_YN OKL_AE_TEMPLATES.MEMO_YN%TYPE := OKL_API.G_MISS_CHAR,
37: REV_REC_FLAG VARCHAR2(1) := 'N',
38: SOURCE_ID NUMBER := OKL_API.G_MISS_NUM,
39: SOURCE_TABLE OKL_TRNS_ACC_DSTRS.SOURCE_TABLE%TYPE := OKL_API.G_MISS_CHAR,
40: ACCOUNTING_DATE OKL_TRNS_ACC_DSTRS.GL_DATE%TYPE := OKL_API.G_MISS_DATE,

Line 38: SOURCE_ID NUMBER := OKL_API.G_MISS_NUM,

34: FACTORING_CODE OKL_AE_TEMPLATES.FAC_CODE%TYPE := OKL_API.G_MISS_CHAR,
35: INVESTOR_CODE OKL_AE_TEMPLATES.INV_CODE%TYPE := OKL_API.G_MISS_CHAR,
36: MEMO_YN OKL_AE_TEMPLATES.MEMO_YN%TYPE := OKL_API.G_MISS_CHAR,
37: REV_REC_FLAG VARCHAR2(1) := 'N',
38: SOURCE_ID NUMBER := OKL_API.G_MISS_NUM,
39: SOURCE_TABLE OKL_TRNS_ACC_DSTRS.SOURCE_TABLE%TYPE := OKL_API.G_MISS_CHAR,
40: ACCOUNTING_DATE OKL_TRNS_ACC_DSTRS.GL_DATE%TYPE := OKL_API.G_MISS_DATE,
41: CONTRACT_ID NUMBER := OKL_API.G_MISS_NUM,
42: CONTRACT_LINE_ID NUMBER := OKL_API.G_MISS_NUM);

Line 39: SOURCE_TABLE OKL_TRNS_ACC_DSTRS.SOURCE_TABLE%TYPE := OKL_API.G_MISS_CHAR,

35: INVESTOR_CODE OKL_AE_TEMPLATES.INV_CODE%TYPE := OKL_API.G_MISS_CHAR,
36: MEMO_YN OKL_AE_TEMPLATES.MEMO_YN%TYPE := OKL_API.G_MISS_CHAR,
37: REV_REC_FLAG VARCHAR2(1) := 'N',
38: SOURCE_ID NUMBER := OKL_API.G_MISS_NUM,
39: SOURCE_TABLE OKL_TRNS_ACC_DSTRS.SOURCE_TABLE%TYPE := OKL_API.G_MISS_CHAR,
40: ACCOUNTING_DATE OKL_TRNS_ACC_DSTRS.GL_DATE%TYPE := OKL_API.G_MISS_DATE,
41: CONTRACT_ID NUMBER := OKL_API.G_MISS_NUM,
42: CONTRACT_LINE_ID NUMBER := OKL_API.G_MISS_NUM);
43:

Line 40: ACCOUNTING_DATE OKL_TRNS_ACC_DSTRS.GL_DATE%TYPE := OKL_API.G_MISS_DATE,

36: MEMO_YN OKL_AE_TEMPLATES.MEMO_YN%TYPE := OKL_API.G_MISS_CHAR,
37: REV_REC_FLAG VARCHAR2(1) := 'N',
38: SOURCE_ID NUMBER := OKL_API.G_MISS_NUM,
39: SOURCE_TABLE OKL_TRNS_ACC_DSTRS.SOURCE_TABLE%TYPE := OKL_API.G_MISS_CHAR,
40: ACCOUNTING_DATE OKL_TRNS_ACC_DSTRS.GL_DATE%TYPE := OKL_API.G_MISS_DATE,
41: CONTRACT_ID NUMBER := OKL_API.G_MISS_NUM,
42: CONTRACT_LINE_ID NUMBER := OKL_API.G_MISS_NUM);
43:
44: SUBTYPE error_message_type IS okl_accounting_util.error_message_type;

Line 41: CONTRACT_ID NUMBER := OKL_API.G_MISS_NUM,

37: REV_REC_FLAG VARCHAR2(1) := 'N',
38: SOURCE_ID NUMBER := OKL_API.G_MISS_NUM,
39: SOURCE_TABLE OKL_TRNS_ACC_DSTRS.SOURCE_TABLE%TYPE := OKL_API.G_MISS_CHAR,
40: ACCOUNTING_DATE OKL_TRNS_ACC_DSTRS.GL_DATE%TYPE := OKL_API.G_MISS_DATE,
41: CONTRACT_ID NUMBER := OKL_API.G_MISS_NUM,
42: CONTRACT_LINE_ID NUMBER := OKL_API.G_MISS_NUM);
43:
44: SUBTYPE error_message_type IS okl_accounting_util.error_message_type;
45:

Line 42: CONTRACT_LINE_ID NUMBER := OKL_API.G_MISS_NUM);

38: SOURCE_ID NUMBER := OKL_API.G_MISS_NUM,
39: SOURCE_TABLE OKL_TRNS_ACC_DSTRS.SOURCE_TABLE%TYPE := OKL_API.G_MISS_CHAR,
40: ACCOUNTING_DATE OKL_TRNS_ACC_DSTRS.GL_DATE%TYPE := OKL_API.G_MISS_DATE,
41: CONTRACT_ID NUMBER := OKL_API.G_MISS_NUM,
42: CONTRACT_LINE_ID NUMBER := OKL_API.G_MISS_NUM);
43:
44: SUBTYPE error_message_type IS okl_accounting_util.error_message_type;
45:
46:

Line 50: G_FND_APP CONSTANT VARCHAR2(200) := Okl_Api.G_FND_APP;

46:
47: ---------------------------------------------------------------------------
48: -- GLOBAL MESSAGE CONSTANTS
49: ---------------------------------------------------------------------------
50: G_FND_APP CONSTANT VARCHAR2(200) := Okl_Api.G_FND_APP;
51: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKL_CONTRACTS_UNEXPECTED_ERROR';
52: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'OKL_SQLERRM';
53: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'OKL_SQLCODE';
54: G_AE_LINE_TYPE_TOKEN CONSTANT VARCHAR2(200) := 'AE_LINE_TYPE';

Line 56: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;

52: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'OKL_SQLERRM';
53: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'OKL_SQLCODE';
54: G_AE_LINE_TYPE_TOKEN CONSTANT VARCHAR2(200) := 'AE_LINE_TYPE';
55: G_ACC_GEN_RULE_ID CONSTANT VARCHAR2(200) := 'ACC_GEN_ RULE_ID';
56: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;
57: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_INVALID_VALUE;
58: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_COL_NAME_TOKEN;
59: G_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
60: G_RET_STS_UNEXP_ERROR CONSTANT VARCHAR2(1) := OKL_API.G_RET_STS_UNEXP_ERROR;

Line 57: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_INVALID_VALUE;

53: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'OKL_SQLCODE';
54: G_AE_LINE_TYPE_TOKEN CONSTANT VARCHAR2(200) := 'AE_LINE_TYPE';
55: G_ACC_GEN_RULE_ID CONSTANT VARCHAR2(200) := 'ACC_GEN_ RULE_ID';
56: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;
57: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_INVALID_VALUE;
58: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_COL_NAME_TOKEN;
59: G_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
60: G_RET_STS_UNEXP_ERROR CONSTANT VARCHAR2(1) := OKL_API.G_RET_STS_UNEXP_ERROR;
61: G_RET_STS_ERROR CONSTANT VARCHAR2(1) := OKL_API.G_RET_STS_ERROR;

Line 58: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_COL_NAME_TOKEN;

54: G_AE_LINE_TYPE_TOKEN CONSTANT VARCHAR2(200) := 'AE_LINE_TYPE';
55: G_ACC_GEN_RULE_ID CONSTANT VARCHAR2(200) := 'ACC_GEN_ RULE_ID';
56: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;
57: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_INVALID_VALUE;
58: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_COL_NAME_TOKEN;
59: G_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
60: G_RET_STS_UNEXP_ERROR CONSTANT VARCHAR2(1) := OKL_API.G_RET_STS_UNEXP_ERROR;
61: G_RET_STS_ERROR CONSTANT VARCHAR2(1) := OKL_API.G_RET_STS_ERROR;
62: G_EXCEPTION_ERROR EXCEPTION;

Line 59: G_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

55: G_ACC_GEN_RULE_ID CONSTANT VARCHAR2(200) := 'ACC_GEN_ RULE_ID';
56: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;
57: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_INVALID_VALUE;
58: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_COL_NAME_TOKEN;
59: G_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
60: G_RET_STS_UNEXP_ERROR CONSTANT VARCHAR2(1) := OKL_API.G_RET_STS_UNEXP_ERROR;
61: G_RET_STS_ERROR CONSTANT VARCHAR2(1) := OKL_API.G_RET_STS_ERROR;
62: G_EXCEPTION_ERROR EXCEPTION;
63: G_EXCEPTION_UNEXPECTED_ERROR EXCEPTION;

Line 60: G_RET_STS_UNEXP_ERROR CONSTANT VARCHAR2(1) := OKL_API.G_RET_STS_UNEXP_ERROR;

56: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;
57: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_INVALID_VALUE;
58: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_COL_NAME_TOKEN;
59: G_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
60: G_RET_STS_UNEXP_ERROR CONSTANT VARCHAR2(1) := OKL_API.G_RET_STS_UNEXP_ERROR;
61: G_RET_STS_ERROR CONSTANT VARCHAR2(1) := OKL_API.G_RET_STS_ERROR;
62: G_EXCEPTION_ERROR EXCEPTION;
63: G_EXCEPTION_UNEXPECTED_ERROR EXCEPTION;
64:

Line 61: G_RET_STS_ERROR CONSTANT VARCHAR2(1) := OKL_API.G_RET_STS_ERROR;

57: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_INVALID_VALUE;
58: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_COL_NAME_TOKEN;
59: G_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
60: G_RET_STS_UNEXP_ERROR CONSTANT VARCHAR2(1) := OKL_API.G_RET_STS_UNEXP_ERROR;
61: G_RET_STS_ERROR CONSTANT VARCHAR2(1) := OKL_API.G_RET_STS_ERROR;
62: G_EXCEPTION_ERROR EXCEPTION;
63: G_EXCEPTION_UNEXPECTED_ERROR EXCEPTION;
64:
65:

Line 75: G_APP_NAME CONSTANT VARCHAR2(3) := Okl_Api.G_APP_NAME;

71: ---------------------------------------------------------------------------
72: -- GLOBAL VARIABLES
73: ---------------------------------------------------------------------------
74: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_ACCOUNT_GENERATOR_PVT';
75: G_APP_NAME CONSTANT VARCHAR2(3) := Okl_Api.G_APP_NAME;
76:
77: -------------------------------------------------------------------------------
78: -- PACKAGE LEVEL GLOBAL VARIABLES
79: -------------------------------------------------------------------------------