DBA Data[Home] [Help]

APPS.CN_REASONS_PVT dependencies on FND_API

Line 25: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,

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:

Line 26: p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL,

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,

Line 42: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,

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,

Line 43: p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL,

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,

Line 60: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,

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:

Line 61: p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL,

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,

Line 78: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,

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,

Line 79: p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL,

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,

Line 95: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,

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:

Line 96: p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL,

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,

Line 98: p_reason_id IN NUMBER := FND_API.G_MISS_NUM,

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,

Line 111: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,

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,

Line 112: p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL,

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,

Line 114: p_reason_id IN NUMBER := FND_API.G_MISS_NUM,

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);

Line 128: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,

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:

Line 129: p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL,

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,

Line 131: p_payment_worksheet_id IN NUMBER := FND_API.G_MISS_NUM,

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,

Line 143: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,

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,

Line 144: p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL,

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,

Line 146: p_payment_worksheet_id IN NUMBER := FND_API.G_MISS_NUM,

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);