44: ,last_updated_by NUMBER := OKL_API.G_MISS_NUM
45: ,last_update_date OKL_PRTFL_LINES_V.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
46: ,last_update_login NUMBER := OKL_API.G_MISS_NUM,
47: -- RABHUPAT - 2667636 - Start
48: currency_code OKL_PRTFL_LINES_V.CURRENCY_CODE%TYPE := OKC_API.G_MISS_CHAR,
49: currency_conversion_code OKL_PRTFL_LINES_V.CURRENCY_CONVERSION_CODE%TYPE := OKC_API.G_MISS_CHAR,
50: currency_conversion_type OKL_PRTFL_LINES_V.CURRENCY_CONVERSION_TYPE%TYPE := OKC_API.G_MISS_CHAR,
51: currency_conversion_rate OKL_PRTFL_LINES_V.CURRENCY_CONVERSION_RATE%TYPE := OKC_API.G_MISS_NUM,
52: currency_conversion_date OKL_PRTFL_LINES_V.CURRENCY_CONVERSION_DATE%TYPE := OKC_API.G_MISS_DATE);
45: ,last_update_date OKL_PRTFL_LINES_V.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
46: ,last_update_login NUMBER := OKL_API.G_MISS_NUM,
47: -- RABHUPAT - 2667636 - Start
48: currency_code OKL_PRTFL_LINES_V.CURRENCY_CODE%TYPE := OKC_API.G_MISS_CHAR,
49: currency_conversion_code OKL_PRTFL_LINES_V.CURRENCY_CONVERSION_CODE%TYPE := OKC_API.G_MISS_CHAR,
50: currency_conversion_type OKL_PRTFL_LINES_V.CURRENCY_CONVERSION_TYPE%TYPE := OKC_API.G_MISS_CHAR,
51: currency_conversion_rate OKL_PRTFL_LINES_V.CURRENCY_CONVERSION_RATE%TYPE := OKC_API.G_MISS_NUM,
52: currency_conversion_date OKL_PRTFL_LINES_V.CURRENCY_CONVERSION_DATE%TYPE := OKC_API.G_MISS_DATE);
53: -- RABHUPAT - 2667636 - End
46: ,last_update_login NUMBER := OKL_API.G_MISS_NUM,
47: -- RABHUPAT - 2667636 - Start
48: currency_code OKL_PRTFL_LINES_V.CURRENCY_CODE%TYPE := OKC_API.G_MISS_CHAR,
49: currency_conversion_code OKL_PRTFL_LINES_V.CURRENCY_CONVERSION_CODE%TYPE := OKC_API.G_MISS_CHAR,
50: currency_conversion_type OKL_PRTFL_LINES_V.CURRENCY_CONVERSION_TYPE%TYPE := OKC_API.G_MISS_CHAR,
51: currency_conversion_rate OKL_PRTFL_LINES_V.CURRENCY_CONVERSION_RATE%TYPE := OKC_API.G_MISS_NUM,
52: currency_conversion_date OKL_PRTFL_LINES_V.CURRENCY_CONVERSION_DATE%TYPE := OKC_API.G_MISS_DATE);
53: -- RABHUPAT - 2667636 - End
54: G_MISS_pflv_rec pflv_rec_type;
47: -- RABHUPAT - 2667636 - Start
48: currency_code OKL_PRTFL_LINES_V.CURRENCY_CODE%TYPE := OKC_API.G_MISS_CHAR,
49: currency_conversion_code OKL_PRTFL_LINES_V.CURRENCY_CONVERSION_CODE%TYPE := OKC_API.G_MISS_CHAR,
50: currency_conversion_type OKL_PRTFL_LINES_V.CURRENCY_CONVERSION_TYPE%TYPE := OKC_API.G_MISS_CHAR,
51: currency_conversion_rate OKL_PRTFL_LINES_V.CURRENCY_CONVERSION_RATE%TYPE := OKC_API.G_MISS_NUM,
52: currency_conversion_date OKL_PRTFL_LINES_V.CURRENCY_CONVERSION_DATE%TYPE := OKC_API.G_MISS_DATE);
53: -- RABHUPAT - 2667636 - End
54: G_MISS_pflv_rec pflv_rec_type;
55: TYPE pflv_tbl_type IS TABLE OF pflv_rec_type
48: currency_code OKL_PRTFL_LINES_V.CURRENCY_CODE%TYPE := OKC_API.G_MISS_CHAR,
49: currency_conversion_code OKL_PRTFL_LINES_V.CURRENCY_CONVERSION_CODE%TYPE := OKC_API.G_MISS_CHAR,
50: currency_conversion_type OKL_PRTFL_LINES_V.CURRENCY_CONVERSION_TYPE%TYPE := OKC_API.G_MISS_CHAR,
51: currency_conversion_rate OKL_PRTFL_LINES_V.CURRENCY_CONVERSION_RATE%TYPE := OKC_API.G_MISS_NUM,
52: currency_conversion_date OKL_PRTFL_LINES_V.CURRENCY_CONVERSION_DATE%TYPE := OKC_API.G_MISS_DATE);
53: -- RABHUPAT - 2667636 - End
54: G_MISS_pflv_rec pflv_rec_type;
55: TYPE pflv_tbl_type IS TABLE OF pflv_rec_type
56: INDEX BY BINARY_INTEGER;
93: ,last_updated_by NUMBER := OKL_API.G_MISS_NUM
94: ,last_update_date OKL_PRTFL_LINES_B.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
95: ,last_update_login NUMBER := OKL_API.G_MISS_NUM,
96: -- RABHUPAT - 2667636 - Start
97: currency_code OKL_PRTFL_LINES_B.CURRENCY_CODE%TYPE := OKC_API.G_MISS_CHAR,
98: currency_conversion_code OKL_PRTFL_LINES_B.CURRENCY_CONVERSION_CODE%TYPE := OKC_API.G_MISS_CHAR,
99: currency_conversion_type OKL_PRTFL_LINES_B.CURRENCY_CONVERSION_TYPE%TYPE := OKC_API.G_MISS_CHAR,
100: currency_conversion_rate OKL_PRTFL_LINES_B.CURRENCY_CONVERSION_RATE%TYPE := OKC_API.G_MISS_NUM,
101: currency_conversion_date OKL_PRTFL_LINES_B.CURRENCY_CONVERSION_DATE%TYPE := OKC_API.G_MISS_DATE);
94: ,last_update_date OKL_PRTFL_LINES_B.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
95: ,last_update_login NUMBER := OKL_API.G_MISS_NUM,
96: -- RABHUPAT - 2667636 - Start
97: currency_code OKL_PRTFL_LINES_B.CURRENCY_CODE%TYPE := OKC_API.G_MISS_CHAR,
98: currency_conversion_code OKL_PRTFL_LINES_B.CURRENCY_CONVERSION_CODE%TYPE := OKC_API.G_MISS_CHAR,
99: currency_conversion_type OKL_PRTFL_LINES_B.CURRENCY_CONVERSION_TYPE%TYPE := OKC_API.G_MISS_CHAR,
100: currency_conversion_rate OKL_PRTFL_LINES_B.CURRENCY_CONVERSION_RATE%TYPE := OKC_API.G_MISS_NUM,
101: currency_conversion_date OKL_PRTFL_LINES_B.CURRENCY_CONVERSION_DATE%TYPE := OKC_API.G_MISS_DATE);
102: --RABHUPAT - 2667636 - End
95: ,last_update_login NUMBER := OKL_API.G_MISS_NUM,
96: -- RABHUPAT - 2667636 - Start
97: currency_code OKL_PRTFL_LINES_B.CURRENCY_CODE%TYPE := OKC_API.G_MISS_CHAR,
98: currency_conversion_code OKL_PRTFL_LINES_B.CURRENCY_CONVERSION_CODE%TYPE := OKC_API.G_MISS_CHAR,
99: currency_conversion_type OKL_PRTFL_LINES_B.CURRENCY_CONVERSION_TYPE%TYPE := OKC_API.G_MISS_CHAR,
100: currency_conversion_rate OKL_PRTFL_LINES_B.CURRENCY_CONVERSION_RATE%TYPE := OKC_API.G_MISS_NUM,
101: currency_conversion_date OKL_PRTFL_LINES_B.CURRENCY_CONVERSION_DATE%TYPE := OKC_API.G_MISS_DATE);
102: --RABHUPAT - 2667636 - End
103: G_MISS_pfl_rec pfl_rec_type;
96: -- RABHUPAT - 2667636 - Start
97: currency_code OKL_PRTFL_LINES_B.CURRENCY_CODE%TYPE := OKC_API.G_MISS_CHAR,
98: currency_conversion_code OKL_PRTFL_LINES_B.CURRENCY_CONVERSION_CODE%TYPE := OKC_API.G_MISS_CHAR,
99: currency_conversion_type OKL_PRTFL_LINES_B.CURRENCY_CONVERSION_TYPE%TYPE := OKC_API.G_MISS_CHAR,
100: currency_conversion_rate OKL_PRTFL_LINES_B.CURRENCY_CONVERSION_RATE%TYPE := OKC_API.G_MISS_NUM,
101: currency_conversion_date OKL_PRTFL_LINES_B.CURRENCY_CONVERSION_DATE%TYPE := OKC_API.G_MISS_DATE);
102: --RABHUPAT - 2667636 - End
103: G_MISS_pfl_rec pfl_rec_type;
104: TYPE pfl_tbl_type IS TABLE OF pfl_rec_type
97: currency_code OKL_PRTFL_LINES_B.CURRENCY_CODE%TYPE := OKC_API.G_MISS_CHAR,
98: currency_conversion_code OKL_PRTFL_LINES_B.CURRENCY_CONVERSION_CODE%TYPE := OKC_API.G_MISS_CHAR,
99: currency_conversion_type OKL_PRTFL_LINES_B.CURRENCY_CONVERSION_TYPE%TYPE := OKC_API.G_MISS_CHAR,
100: currency_conversion_rate OKL_PRTFL_LINES_B.CURRENCY_CONVERSION_RATE%TYPE := OKC_API.G_MISS_NUM,
101: currency_conversion_date OKL_PRTFL_LINES_B.CURRENCY_CONVERSION_DATE%TYPE := OKC_API.G_MISS_DATE);
102: --RABHUPAT - 2667636 - End
103: G_MISS_pfl_rec pfl_rec_type;
104: TYPE pfl_tbl_type IS TABLE OF pfl_rec_type
105: INDEX BY BINARY_INTEGER;
120: INDEX BY BINARY_INTEGER;
121: ---------------------------------------------------------------------------
122: -- GLOBAL MESSAGE CONSTANTS
123: ---------------------------------------------------------------------------
124: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
125: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
126: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
127: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
128: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
121: ---------------------------------------------------------------------------
122: -- GLOBAL MESSAGE CONSTANTS
123: ---------------------------------------------------------------------------
124: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
125: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
126: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
127: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
128: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
129: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
122: -- GLOBAL MESSAGE CONSTANTS
123: ---------------------------------------------------------------------------
124: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
125: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
126: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
127: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
128: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
129: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
130: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
123: ---------------------------------------------------------------------------
124: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
125: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
126: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
127: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
128: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
129: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
130: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
131: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
124: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
125: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
126: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
127: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
128: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
129: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
130: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
131: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
132: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
125: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
126: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
127: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
128: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
129: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
130: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
131: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
132: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
133: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
126: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
127: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
128: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
129: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
130: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
131: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
132: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
133: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
134: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKS_SERVICE_AVAILABILITY_UNEXPECTED_ERROR';
127: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
128: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
129: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
130: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
131: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
132: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
133: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
134: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKS_SERVICE_AVAILABILITY_UNEXPECTED_ERROR';
135: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
128: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
129: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
130: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
131: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
132: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
133: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
134: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKS_SERVICE_AVAILABILITY_UNEXPECTED_ERROR';
135: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
136: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';
129: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
130: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
131: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
132: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
133: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
134: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKS_SERVICE_AVAILABILITY_UNEXPECTED_ERROR';
135: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
136: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';
137:
143: ---------------------------------------------------------------------------
144: -- GLOBAL VARIABLES
145: ---------------------------------------------------------------------------
146: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_PFL_PVT';
147: G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
148: ---------------------------------------------------------------------------
149: -- Procedures and Functions
150: ---------------------------------------------------------------------------
151: