eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PSB_WORKSHEET_CONSOLIDATE_PVT dependencies on FND_API

Line 8: -- Pre-reqs : FND_API, FND_MESSAGE, PSB_WORKSHEET_CONSOLIDATE

4: /* ----------------------------------------------------------------------- */
5:
6: -- API name : Consolidate_Worksheets
7: -- Type : Private
8: -- Pre-reqs : FND_API, FND_MESSAGE, PSB_WORKSHEET_CONSOLIDATE
9: -- Parameters :
10: -- IN : p_api_version IN NUMBER Required
11: -- p_init_msg_list IN VARCHAR2 Optional
12: -- Default = FND_API.G_FALSE

Line 12: -- Default = FND_API.G_FALSE

8: -- Pre-reqs : FND_API, FND_MESSAGE, PSB_WORKSHEET_CONSOLIDATE
9: -- Parameters :
10: -- IN : p_api_version IN NUMBER Required
11: -- p_init_msg_list IN VARCHAR2 Optional
12: -- Default = FND_API.G_FALSE
13: -- p_commit IN VARCHAR2 Optional
14: -- Default = FND_API.G_FALSE
15: -- p_validation_level IN NUMBER Optional
16: -- Default = FND_API.G_VALID_LEVEL_NONE

Line 14: -- Default = FND_API.G_FALSE

10: -- IN : p_api_version IN NUMBER Required
11: -- p_init_msg_list IN VARCHAR2 Optional
12: -- Default = FND_API.G_FALSE
13: -- p_commit IN VARCHAR2 Optional
14: -- Default = FND_API.G_FALSE
15: -- p_validation_level IN NUMBER Optional
16: -- Default = FND_API.G_VALID_LEVEL_NONE
17: -- p_global_worksheet_id IN NUMBER Required
18: -- .

Line 16: -- Default = FND_API.G_VALID_LEVEL_NONE

12: -- Default = FND_API.G_FALSE
13: -- p_commit IN VARCHAR2 Optional
14: -- Default = FND_API.G_FALSE
15: -- p_validation_level IN NUMBER Optional
16: -- Default = FND_API.G_VALID_LEVEL_NONE
17: -- p_global_worksheet_id IN NUMBER Required
18: -- .
19: -- OUT NOCOPY : p_return_status OUT NOCOPY VARCHAR2(1)
20: -- p_msg_count OUT NOCOPY NUMBER

Line 32: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

28: --
29:
30: PROCEDURE Consolidate_Worksheets
31: ( p_api_version IN NUMBER,
32: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
33: p_commit IN VARCHAR2 := FND_API.G_FALSE,
34: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_NONE,
35: p_return_status OUT NOCOPY VARCHAR2,
36: p_msg_count OUT NOCOPY NUMBER,

Line 33: p_commit IN VARCHAR2 := FND_API.G_FALSE,

29:
30: PROCEDURE Consolidate_Worksheets
31: ( p_api_version IN NUMBER,
32: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
33: p_commit IN VARCHAR2 := FND_API.G_FALSE,
34: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_NONE,
35: p_return_status OUT NOCOPY VARCHAR2,
36: p_msg_count OUT NOCOPY NUMBER,
37: p_msg_data OUT NOCOPY VARCHAR2,

Line 34: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_NONE,

30: PROCEDURE Consolidate_Worksheets
31: ( p_api_version IN NUMBER,
32: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
33: p_commit IN VARCHAR2 := FND_API.G_FALSE,
34: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_NONE,
35: p_return_status OUT NOCOPY VARCHAR2,
36: p_msg_count OUT NOCOPY NUMBER,
37: p_msg_data OUT NOCOPY VARCHAR2,
38: p_global_worksheet_id IN NUMBER

Line 45: -- Pre-reqs : FND_API, FND_MESSAGE, PSB_WORKSHEET_CONSOLIDATE

41: /* ----------------------------------------------------------------------- */
42:
43: -- API name : Validate_Consolidation
44: -- Type : Private
45: -- Pre-reqs : FND_API, FND_MESSAGE, PSB_WORKSHEET_CONSOLIDATE
46: -- Parameters :
47: -- IN : p_api_version IN NUMBER Required
48: -- p_init_msg_list IN VARCHAR2 Optional
49: -- Default = FND_API.G_FALSE

Line 49: -- Default = FND_API.G_FALSE

45: -- Pre-reqs : FND_API, FND_MESSAGE, PSB_WORKSHEET_CONSOLIDATE
46: -- Parameters :
47: -- IN : p_api_version IN NUMBER Required
48: -- p_init_msg_list IN VARCHAR2 Optional
49: -- Default = FND_API.G_FALSE
50: -- p_validation_level IN NUMBER Optional
51: -- Default = FND_API.G_VALID_LEVEL_NONE
52: -- p_global_worksheet_id IN NUMBER Required
53: -- .

Line 51: -- Default = FND_API.G_VALID_LEVEL_NONE

47: -- IN : p_api_version IN NUMBER Required
48: -- p_init_msg_list IN VARCHAR2 Optional
49: -- Default = FND_API.G_FALSE
50: -- p_validation_level IN NUMBER Optional
51: -- Default = FND_API.G_VALID_LEVEL_NONE
52: -- p_global_worksheet_id IN NUMBER Required
53: -- .
54: -- OUT NOCOPY : p_return_status OUT NOCOPY VARCHAR2(1)
55: -- p_msg_count OUT NOCOPY NUMBER

Line 67: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

63: --
64:
65: PROCEDURE Validate_Consolidation
66: ( p_api_version IN NUMBER,
67: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
68: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_NONE,
69: p_return_status OUT NOCOPY VARCHAR2,
70: p_msg_count OUT NOCOPY NUMBER,
71: p_msg_data OUT NOCOPY VARCHAR2,

Line 68: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_NONE,

64:
65: PROCEDURE Validate_Consolidation
66: ( p_api_version IN NUMBER,
67: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
68: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_NONE,
69: p_return_status OUT NOCOPY VARCHAR2,
70: p_msg_count OUT NOCOPY NUMBER,
71: p_msg_data OUT NOCOPY VARCHAR2,
72: p_global_worksheet_id IN NUMBER

Line 83: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

79:
80: PROCEDURE Insert_Row
81: (
82: p_api_version IN NUMBER,
83: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
84: p_commit IN VARCHAR2 := FND_API.G_FALSE,
85: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
86: p_return_status OUT NOCOPY VARCHAR2,
87: p_msg_count OUT NOCOPY NUMBER,

Line 84: p_commit IN VARCHAR2 := FND_API.G_FALSE,

80: PROCEDURE Insert_Row
81: (
82: p_api_version IN NUMBER,
83: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
84: p_commit IN VARCHAR2 := FND_API.G_FALSE,
85: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
86: p_return_status OUT NOCOPY VARCHAR2,
87: p_msg_count OUT NOCOPY NUMBER,
88: p_msg_data OUT NOCOPY VARCHAR2,

Line 85: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

81: (
82: p_api_version IN NUMBER,
83: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
84: p_commit IN VARCHAR2 := FND_API.G_FALSE,
85: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
86: p_return_status OUT NOCOPY VARCHAR2,
87: p_msg_count OUT NOCOPY NUMBER,
88: p_msg_data OUT NOCOPY VARCHAR2,
89:

Line 115: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

111:
112: PROCEDURE Lock_Row
113: (
114: p_api_version IN NUMBER,
115: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
116: p_commit IN VARCHAR2 := FND_API.G_FALSE,
117: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
118: p_return_status OUT NOCOPY VARCHAR2,
119: p_msg_count OUT NOCOPY NUMBER,

Line 116: p_commit IN VARCHAR2 := FND_API.G_FALSE,

112: PROCEDURE Lock_Row
113: (
114: p_api_version IN NUMBER,
115: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
116: p_commit IN VARCHAR2 := FND_API.G_FALSE,
117: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
118: p_return_status OUT NOCOPY VARCHAR2,
119: p_msg_count OUT NOCOPY NUMBER,
120: p_msg_data OUT NOCOPY VARCHAR2,

Line 117: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

113: (
114: p_api_version IN NUMBER,
115: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
116: p_commit IN VARCHAR2 := FND_API.G_FALSE,
117: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
118: p_return_status OUT NOCOPY VARCHAR2,
119: p_msg_count OUT NOCOPY NUMBER,
120: p_msg_data OUT NOCOPY VARCHAR2,
121:

Line 144: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

140:
141: PROCEDURE Update_Row
142: (
143: p_api_version IN NUMBER,
144: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
145: p_commit IN VARCHAR2 := FND_API.G_FALSE,
146: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
147: p_return_status OUT NOCOPY VARCHAR2,
148: p_msg_count OUT NOCOPY NUMBER,

Line 145: p_commit IN VARCHAR2 := FND_API.G_FALSE,

141: PROCEDURE Update_Row
142: (
143: p_api_version IN NUMBER,
144: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
145: p_commit IN VARCHAR2 := FND_API.G_FALSE,
146: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
147: p_return_status OUT NOCOPY VARCHAR2,
148: p_msg_count OUT NOCOPY NUMBER,
149: p_msg_data OUT NOCOPY VARCHAR2,

Line 146: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

142: (
143: p_api_version IN NUMBER,
144: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
145: p_commit IN VARCHAR2 := FND_API.G_FALSE,
146: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
147: p_return_status OUT NOCOPY VARCHAR2,
148: p_msg_count OUT NOCOPY NUMBER,
149: p_msg_data OUT NOCOPY VARCHAR2,
150:

Line 174: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

170:
171: PROCEDURE Delete_Row
172: (
173: p_api_version IN NUMBER,
174: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
175: p_commit IN VARCHAR2 := FND_API.G_FALSE,
176: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
177: p_return_status OUT NOCOPY VARCHAR2,
178: p_msg_count OUT NOCOPY NUMBER,

Line 175: p_commit IN VARCHAR2 := FND_API.G_FALSE,

171: PROCEDURE Delete_Row
172: (
173: p_api_version IN NUMBER,
174: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
175: p_commit IN VARCHAR2 := FND_API.G_FALSE,
176: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
177: p_return_status OUT NOCOPY VARCHAR2,
178: p_msg_count OUT NOCOPY NUMBER,
179: p_msg_data OUT NOCOPY VARCHAR2,

Line 176: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

172: (
173: p_api_version IN NUMBER,
174: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
175: p_commit IN VARCHAR2 := FND_API.G_FALSE,
176: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
177: p_return_status OUT NOCOPY VARCHAR2,
178: p_msg_count OUT NOCOPY NUMBER,
179: p_msg_data OUT NOCOPY VARCHAR2,
180:

Line 188: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

184:
185: PROCEDURE Check_Unique
186: (
187: p_api_version IN NUMBER,
188: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
189: p_commit IN VARCHAR2 := FND_API.G_FALSE,
190: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
191: p_return_status OUT NOCOPY VARCHAR2,
192: p_msg_count OUT NOCOPY NUMBER,

Line 189: p_commit IN VARCHAR2 := FND_API.G_FALSE,

185: PROCEDURE Check_Unique
186: (
187: p_api_version IN NUMBER,
188: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
189: p_commit IN VARCHAR2 := FND_API.G_FALSE,
190: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
191: p_return_status OUT NOCOPY VARCHAR2,
192: p_msg_count OUT NOCOPY NUMBER,
193: p_msg_data OUT NOCOPY VARCHAR2,

Line 190: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

186: (
187: p_api_version IN NUMBER,
188: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
189: p_commit IN VARCHAR2 := FND_API.G_FALSE,
190: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
191: p_return_status OUT NOCOPY VARCHAR2,
192: p_msg_count OUT NOCOPY NUMBER,
193: p_msg_data OUT NOCOPY VARCHAR2,
194: --