21: Analyst Notes JSP.
22: Desc :
23: Parameters
24: IN : p_api_version IN NUMBER,
25: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
26: p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL,
27: p_commit IN VARCHAR2 := CN_API.G_FALSE,
28: p_reasons_all_rec IN CN_REASONS_PKG.REASONS_ALL_REC_TYPE,
29:
22: Desc :
23: Parameters
24: IN : p_api_version IN NUMBER,
25: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
26: p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL,
27: p_commit IN VARCHAR2 := CN_API.G_FALSE,
28: p_reasons_all_rec IN CN_REASONS_PKG.REASONS_ALL_REC_TYPE,
29:
30: OUT NOCOPY : x_return_status OUT NOCOPY VARCHAR2,
38: validates for the NOT NULL columns.
39: --------------------------------------------------------------------------*/
40: PROCEDURE insert_row(
41: p_api_version IN NUMBER,
42: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
43: p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL,
44: p_commit IN VARCHAR2 := CN_API.G_FALSE,
45: p_reasons_all_rec IN CN_REASONS_PKG.REASONS_ALL_REC_TYPE,
46: x_return_status OUT NOCOPY VARCHAR2,
39: --------------------------------------------------------------------------*/
40: PROCEDURE insert_row(
41: p_api_version IN NUMBER,
42: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
43: p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL,
44: p_commit IN VARCHAR2 := CN_API.G_FALSE,
45: p_reasons_all_rec IN CN_REASONS_PKG.REASONS_ALL_REC_TYPE,
46: x_return_status OUT NOCOPY VARCHAR2,
47: x_msg_count OUT NOCOPY NUMBER,
56: Analyst Notes JSP.
57: Desc :
58: Parameters
59: IN : p_api_version IN NUMBER,
60: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
61: p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL,
62: p_commit IN VARCHAR2 := CN_API.G_FALSE,
63: p_reasons_all_rec IN CN_REASONS_PKG.REASONS_ALL_REC_TYPE,
64:
57: Desc :
58: Parameters
59: IN : p_api_version IN NUMBER,
60: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
61: p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL,
62: p_commit IN VARCHAR2 := CN_API.G_FALSE,
63: p_reasons_all_rec IN CN_REASONS_PKG.REASONS_ALL_REC_TYPE,
64:
65: OUT NOCOPY : x_return_status OUT NOCOPY VARCHAR2,
74: --------------------------------------------------------------------------*/
75:
76: PROCEDURE update_row(
77: p_api_version IN NUMBER,
78: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
79: p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL,
80: p_commit IN VARCHAR2 := CN_API.G_FALSE,
81: p_reasons_all_rec IN CN_REASONS_PKG.REASONS_ALL_REC_TYPE,
82: x_return_status OUT NOCOPY VARCHAR2,
75:
76: PROCEDURE update_row(
77: p_api_version IN NUMBER,
78: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
79: p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL,
80: p_commit IN VARCHAR2 := CN_API.G_FALSE,
81: p_reasons_all_rec IN CN_REASONS_PKG.REASONS_ALL_REC_TYPE,
82: x_return_status OUT NOCOPY VARCHAR2,
83: x_msg_count OUT NOCOPY NUMBER,
91: corresponding to the checkboxes selected from the JSP.
92: Desc :
93: Parameters
94: IN : p_api_version IN NUMBER,
95: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
96: p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL,
97: p_commit IN VARCHAR2 := CN_API.G_FALSE,
98: p_reason_id IN NUMBER := FND_API.G_MISS_NUM,
99:
92: Desc :
93: Parameters
94: IN : p_api_version IN NUMBER,
95: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
96: p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL,
97: p_commit IN VARCHAR2 := CN_API.G_FALSE,
98: p_reason_id IN NUMBER := FND_API.G_MISS_NUM,
99:
100: OUT NOCOPY : x_return_status OUT NOCOPY VARCHAR2,
94: IN : p_api_version IN NUMBER,
95: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
96: p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL,
97: p_commit IN VARCHAR2 := CN_API.G_FALSE,
98: p_reason_id IN NUMBER := FND_API.G_MISS_NUM,
99:
100: OUT NOCOPY : x_return_status OUT NOCOPY VARCHAR2,
101: x_msg_count OUT NOCOPY NUMBER,
102: x_msg_data OUT NOCOPY VARCHAR2,
107: cn_reason_history table.
108: --------------------------------------------------------------------------*/
109: PROCEDURE delete_notes(
110: p_api_version IN NUMBER,
111: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
112: p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL,
113: p_commit IN VARCHAR2 := CN_API.G_FALSE,
114: p_reason_id IN NUMBER := FND_API.G_MISS_NUM,
115: x_return_status OUT NOCOPY VARCHAR2,
108: --------------------------------------------------------------------------*/
109: PROCEDURE delete_notes(
110: p_api_version IN NUMBER,
111: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
112: p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL,
113: p_commit IN VARCHAR2 := CN_API.G_FALSE,
114: p_reason_id IN NUMBER := FND_API.G_MISS_NUM,
115: x_return_status OUT NOCOPY VARCHAR2,
116: x_msg_count OUT NOCOPY NUMBER,
110: p_api_version IN NUMBER,
111: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
112: p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL,
113: p_commit IN VARCHAR2 := CN_API.G_FALSE,
114: p_reason_id IN NUMBER := FND_API.G_MISS_NUM,
115: x_return_status OUT NOCOPY VARCHAR2,
116: x_msg_count OUT NOCOPY NUMBER,
117: x_msg_data OUT NOCOPY VARCHAR2,
118: x_loading_status OUT NOCOPY VARCHAR2);
124: corresponding to a worksheet.
125: Desc :
126: Parameters
127: IN : p_api_version IN NUMBER,
128: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
129: p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL,
130: p_commit IN VARCHAR2 := CN_API.G_FALSE,
131: p_payment_worksheet_id IN NUMBER := FND_API.G_MISS_NUM,
132:
125: Desc :
126: Parameters
127: IN : p_api_version IN NUMBER,
128: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
129: p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL,
130: p_commit IN VARCHAR2 := CN_API.G_FALSE,
131: p_payment_worksheet_id IN NUMBER := FND_API.G_MISS_NUM,
132:
133: OUT NOCOPY : x_return_status OUT NOCOPY VARCHAR2,
127: IN : p_api_version IN NUMBER,
128: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
129: p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL,
130: p_commit IN VARCHAR2 := CN_API.G_FALSE,
131: p_payment_worksheet_id IN NUMBER := FND_API.G_MISS_NUM,
132:
133: OUT NOCOPY : x_return_status OUT NOCOPY VARCHAR2,
134: x_msg_count OUT NOCOPY NUMBER,
135: x_msg_data OUT NOCOPY VARCHAR2,
139: also deletes the records in the cn_reason_history table.
140: --------------------------------------------------------------------------*/
141: PROCEDURE delete_worksheet_notes(
142: p_api_version IN NUMBER,
143: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
144: p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL,
145: p_commit IN VARCHAR2 := CN_API.G_FALSE,
146: p_payment_worksheet_id IN NUMBER := FND_API.G_MISS_NUM,
147: x_return_status OUT NOCOPY VARCHAR2,
140: --------------------------------------------------------------------------*/
141: PROCEDURE delete_worksheet_notes(
142: p_api_version IN NUMBER,
143: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
144: p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL,
145: p_commit IN VARCHAR2 := CN_API.G_FALSE,
146: p_payment_worksheet_id IN NUMBER := FND_API.G_MISS_NUM,
147: x_return_status OUT NOCOPY VARCHAR2,
148: x_msg_count OUT NOCOPY NUMBER,
142: p_api_version IN NUMBER,
143: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
144: p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL,
145: p_commit IN VARCHAR2 := CN_API.G_FALSE,
146: p_payment_worksheet_id IN NUMBER := FND_API.G_MISS_NUM,
147: x_return_status OUT NOCOPY VARCHAR2,
148: x_msg_count OUT NOCOPY NUMBER,
149: x_msg_data OUT NOCOPY VARCHAR2,
150: x_loading_status OUT NOCOPY VARCHAR2);