APPS.PSB_POSITIONS_I_PVT dependencies on FND_API

Line 9: p_select_date IN DATE := fnd_api.g_miss_date);

5:
6: PROCEDURE Initialize_View ( p_worksheet_id IN NUMBER,
7: p_start_date IN DATE,
8: p_end_date IN DATE,
9: p_select_date IN DATE := fnd_api.g_miss_date);
10:
11: PROCEDURE Define_Worksheet_Values (
12: p_api_version in number,
13: p_init_msg_list in varchar2 := fnd_api.g_false,

Line 13: p_init_msg_list in varchar2 := fnd_api.g_false,

9: p_select_date IN DATE := fnd_api.g_miss_date);
10:
11: PROCEDURE Define_Worksheet_Values (
12: p_api_version in number,
13: p_init_msg_list in varchar2 := fnd_api.g_false,
14: p_commit in varchar2 := fnd_api.g_false,
15: p_validation_level in number := fnd_api.g_valid_level_full,
16: p_return_status OUT NOCOPY varchar2,
17: p_msg_count OUT NOCOPY number,

Line 14: p_commit in varchar2 := fnd_api.g_false,

10:
11: PROCEDURE Define_Worksheet_Values (
12: p_api_version in number,
13: p_init_msg_list in varchar2 := fnd_api.g_false,
14: p_commit in varchar2 := fnd_api.g_false,
15: p_validation_level in number := fnd_api.g_valid_level_full,
16: p_return_status OUT NOCOPY varchar2,
17: p_msg_count OUT NOCOPY number,
18: p_msg_data OUT NOCOPY varchar2,

Line 15: p_validation_level in number := fnd_api.g_valid_level_full,

11: PROCEDURE Define_Worksheet_Values (
12: p_api_version in number,
13: p_init_msg_list in varchar2 := fnd_api.g_false,
14: p_commit in varchar2 := fnd_api.g_false,
15: p_validation_level in number := fnd_api.g_valid_level_full,
16: p_return_status OUT NOCOPY varchar2,
17: p_msg_count OUT NOCOPY number,
18: p_msg_data OUT NOCOPY varchar2,
19: p_worksheet_id in number,

Line 21: p_pos_effective_start_date in date := FND_API.G_MISS_DATE,

17: p_msg_count OUT NOCOPY number,
18: p_msg_data OUT NOCOPY varchar2,
19: p_worksheet_id in number,
20: p_position_id in number,
21: p_pos_effective_start_date in date := FND_API.G_MISS_DATE,
22: p_pos_effective_end_date in date := FND_API.G_MISS_DATE,
23: p_budget_source in varchar2:= FND_API.G_MISS_CHAR,
24: p_out_worksheet_id OUT NOCOPY number,
25: p_out_start_date OUT NOCOPY date,

Line 22: p_pos_effective_end_date in date := FND_API.G_MISS_DATE,

18: p_msg_data OUT NOCOPY varchar2,
19: p_worksheet_id in number,
20: p_position_id in number,
21: p_pos_effective_start_date in date := FND_API.G_MISS_DATE,
22: p_pos_effective_end_date in date := FND_API.G_MISS_DATE,
23: p_budget_source in varchar2:= FND_API.G_MISS_CHAR,
24: p_out_worksheet_id OUT NOCOPY number,
25: p_out_start_date OUT NOCOPY date,
26: p_out_end_date OUT NOCOPY date);

Line 23: p_budget_source in varchar2:= FND_API.G_MISS_CHAR,

19: p_worksheet_id in number,
20: p_position_id in number,
21: p_pos_effective_start_date in date := FND_API.G_MISS_DATE,
22: p_pos_effective_end_date in date := FND_API.G_MISS_DATE,
23: p_budget_source in varchar2:= FND_API.G_MISS_CHAR,
24: p_out_worksheet_id OUT NOCOPY number,
25: p_out_start_date OUT NOCOPY date,
26: p_out_end_date OUT NOCOPY date);
27:

Line 32: p_init_msg_list in varchar2 := fnd_api.g_false,

28: -- modify_assignment used for insert/modify assignments
29:
30: PROCEDURE Modify_Assignment (
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_full,
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 Modify_Assignment (
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_full,
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_full,

30: PROCEDURE Modify_Assignment (
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_full,
35: p_return_status OUT NOCOPY varchar2,
36: p_msg_count OUT NOCOPY number,
37: p_msg_data OUT NOCOPY varchar2,
38: p_position_assignment_id in OUT NOCOPY number,

Line 66: p_init_msg_list in varchar2 := FND_API.G_FALSE,

62:
63:
64: PROCEDURE Create_Default_Assignments(
65: p_api_version in number,
66: p_init_msg_list in varchar2 := FND_API.G_FALSE,
67: p_commit in varchar2 := FND_API.G_FALSE,
68: p_validation_level in number := FND_API.G_VALID_LEVEL_FULL,
69: p_return_status OUT NOCOPY varchar2,
70: p_msg_count OUT NOCOPY number,

Line 67: p_commit in varchar2 := FND_API.G_FALSE,

63:
64: PROCEDURE Create_Default_Assignments(
65: p_api_version in number,
66: p_init_msg_list in varchar2 := FND_API.G_FALSE,
67: p_commit in varchar2 := FND_API.G_FALSE,
68: p_validation_level in number := FND_API.G_VALID_LEVEL_FULL,
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_FULL,

64: PROCEDURE Create_Default_Assignments(
65: p_api_version in number,
66: p_init_msg_list in varchar2 := FND_API.G_FALSE,
67: p_commit in varchar2 := FND_API.G_FALSE,
68: p_validation_level in number := FND_API.G_VALID_LEVEL_FULL,
69: p_return_status OUT NOCOPY varchar2,
70: p_msg_count OUT NOCOPY number,
71: p_msg_data OUT NOCOPY varchar2,
72: p_worksheet_id in number := FND_API.G_MISS_NUM,

Line 72: p_worksheet_id in number := FND_API.G_MISS_NUM,

68: p_validation_level in number := FND_API.G_VALID_LEVEL_FULL,
69: p_return_status OUT NOCOPY varchar2,
70: p_msg_count OUT NOCOPY number,
71: p_msg_data OUT NOCOPY varchar2,
72: p_worksheet_id in number := FND_API.G_MISS_NUM,
73: p_data_extract_id in number,
74: p_position_id in number := FND_API.G_MISS_NUM,
75: p_position_start_date in date := FND_API.G_MISS_DATE,
76: p_position_end_date in date := FND_API.G_MISS_DATE);

Line 74: p_position_id in number := FND_API.G_MISS_NUM,

70: p_msg_count OUT NOCOPY number,
71: p_msg_data OUT NOCOPY varchar2,
72: p_worksheet_id in number := FND_API.G_MISS_NUM,
73: p_data_extract_id in number,
74: p_position_id in number := FND_API.G_MISS_NUM,
75: p_position_start_date in date := FND_API.G_MISS_DATE,
76: p_position_end_date in date := FND_API.G_MISS_DATE);
77:
78: FUNCTION Get_Select_Date RETURN DATE;

Line 75: p_position_start_date in date := FND_API.G_MISS_DATE,

71: p_msg_data OUT NOCOPY varchar2,
72: p_worksheet_id in number := FND_API.G_MISS_NUM,
73: p_data_extract_id in number,
74: p_position_id in number := FND_API.G_MISS_NUM,
75: p_position_start_date in date := FND_API.G_MISS_DATE,
76: p_position_end_date in date := FND_API.G_MISS_DATE);
77:
78: FUNCTION Get_Select_Date RETURN DATE;
79: pragma RESTRICT_REFERENCES ( Get_SELECT_DATE, WNDS, WNPS );

Line 76: p_position_end_date in date := FND_API.G_MISS_DATE);

72: p_worksheet_id in number := FND_API.G_MISS_NUM,
73: p_data_extract_id in number,
74: p_position_id in number := FND_API.G_MISS_NUM,
75: p_position_start_date in date := FND_API.G_MISS_DATE,
76: p_position_end_date in date := FND_API.G_MISS_DATE);
77:
78: FUNCTION Get_Select_Date RETURN DATE;
79: pragma RESTRICT_REFERENCES ( Get_SELECT_DATE, WNDS, WNPS );
80:

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

79: pragma RESTRICT_REFERENCES ( Get_SELECT_DATE, WNDS, WNPS );
80:
81: FUNCTION Check_Allowed
82: ( p_api_version IN NUMBER,
83: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
84: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_NONE,
85: p_msg_count OUT NOCOPY NUMBER,
86: p_msg_data OUT NOCOPY VARCHAR2,
87: p_worksheet_id IN NUMBER,

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

80:
81: FUNCTION Check_Allowed
82: ( p_api_version IN NUMBER,
83: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
84: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_NONE,
85: p_msg_count OUT NOCOPY NUMBER,
86: p_msg_data OUT NOCOPY VARCHAR2,
87: p_worksheet_id IN NUMBER,
88: p_position_budget_group_id IN NUMBER

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

90:
91:
92: FUNCTION Rev_Check_Allowed
93: ( p_api_version IN NUMBER,
94: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
95: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_NONE,
96: p_msg_count OUT NOCOPY NUMBER,
97: p_msg_data OUT NOCOPY VARCHAR2,
98: p_startdate_pp IN DATE,

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

91:
92: FUNCTION Rev_Check_Allowed
93: ( p_api_version IN NUMBER,
94: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
95: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_NONE,
96: p_msg_count OUT NOCOPY NUMBER,
97: p_msg_data OUT NOCOPY VARCHAR2,
98: p_startdate_pp IN DATE,
99: p_enddate_cy IN DATE,

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

102: ) RETURN VARCHAR2;
103:
104: PROCEDURE Modify_Distribution_WS
105: ( p_api_version IN NUMBER,
106: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
107: p_commit IN VARCHAR2 := FND_API.G_FALSE,
108: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
109: p_return_status OUT NOCOPY VARCHAR2,
110: p_msg_count OUT NOCOPY NUMBER,

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

103:
104: PROCEDURE Modify_Distribution_WS
105: ( p_api_version IN NUMBER,
106: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
107: p_commit IN VARCHAR2 := FND_API.G_FALSE,
108: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
109: p_return_status OUT NOCOPY VARCHAR2,
110: p_msg_count OUT NOCOPY NUMBER,
111: p_msg_data OUT NOCOPY VARCHAR2,

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

104: PROCEDURE Modify_Distribution_WS
105: ( p_api_version IN NUMBER,
106: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
107: p_commit IN VARCHAR2 := FND_API.G_FALSE,
108: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
109: p_return_status OUT NOCOPY VARCHAR2,
110: p_msg_count OUT NOCOPY NUMBER,
111: p_msg_data OUT NOCOPY VARCHAR2,
112: p_distribution_id IN OUT NOCOPY NUMBER,

Line 113: p_worksheet_id IN NUMBER := FND_API.G_MISS_NUM,

109: p_return_status OUT NOCOPY VARCHAR2,
110: p_msg_count OUT NOCOPY NUMBER,
111: p_msg_data OUT NOCOPY VARCHAR2,
112: p_distribution_id IN OUT NOCOPY NUMBER,
113: p_worksheet_id IN NUMBER := FND_API.G_MISS_NUM,
114: p_position_id IN NUMBER,
115: p_data_extract_id IN NUMBER,
116: p_effective_start_date IN DATE,
117: p_effective_end_date IN DATE,

Line 124: p_budget_revision_pos_line_id IN NUMBER:= FND_API.G_MISS_NUM,

120: p_distribution_percent IN NUMBER,
121: p_global_default_flag IN VARCHAR2,
122: p_distribution_default_rule_id IN NUMBER,
123: p_rowid IN OUT NOCOPY VARCHAR2,
124: p_budget_revision_pos_line_id IN NUMBER:= FND_API.G_MISS_NUM,
125: p_mode IN VARCHAR2 default 'R'
126: );
127:
128: PROCEDURE DELETE_ROW (

Line 130: p_init_msg_list in varchar2 := fnd_api.g_false,

126: );
127:
128: PROCEDURE DELETE_ROW (
129: p_api_version in number,
130: p_init_msg_list in varchar2 := fnd_api.g_false,
131: p_commit in varchar2 := fnd_api.g_false,
132: p_validation_level in number := fnd_api.g_valid_level_full,
133: p_return_status OUT NOCOPY varchar2,
134: p_msg_count OUT NOCOPY number,

Line 131: p_commit in varchar2 := fnd_api.g_false,

127:
128: PROCEDURE DELETE_ROW (
129: p_api_version in number,
130: p_init_msg_list in varchar2 := fnd_api.g_false,
131: p_commit in varchar2 := fnd_api.g_false,
132: p_validation_level in number := fnd_api.g_valid_level_full,
133: p_return_status OUT NOCOPY varchar2,
134: p_msg_count OUT NOCOPY number,
135: p_msg_data OUT NOCOPY varchar2,

Line 132: p_validation_level in number := fnd_api.g_valid_level_full,

128: PROCEDURE DELETE_ROW (
129: p_api_version in number,
130: p_init_msg_list in varchar2 := fnd_api.g_false,
131: p_commit in varchar2 := fnd_api.g_false,
132: p_validation_level in number := fnd_api.g_valid_level_full,
133: p_return_status OUT NOCOPY varchar2,
134: p_msg_count OUT NOCOPY number,
135: p_msg_data OUT NOCOPY varchar2,
136: p_distribution_id in number

Line 142: p_init_msg_list in varchar2 := fnd_api.g_false,

138: --
139:
140: PROCEDURE LOCK_ROW (
141: p_api_version in number,
142: p_init_msg_list in varchar2 := fnd_api.g_false,
143: p_commit in varchar2 := fnd_api.g_false,
144: p_validation_level in number := fnd_api.g_valid_level_full,
145: p_return_status OUT NOCOPY varchar2,
146: p_msg_count OUT NOCOPY number,

Line 143: p_commit in varchar2 := fnd_api.g_false,

139:
140: PROCEDURE LOCK_ROW (
141: p_api_version in number,
142: p_init_msg_list in varchar2 := fnd_api.g_false,
143: p_commit in varchar2 := fnd_api.g_false,
144: p_validation_level in number := fnd_api.g_valid_level_full,
145: p_return_status OUT NOCOPY varchar2,
146: p_msg_count OUT NOCOPY number,
147: p_msg_data OUT NOCOPY varchar2,

Line 144: p_validation_level in number := fnd_api.g_valid_level_full,

140: PROCEDURE LOCK_ROW (
141: p_api_version in number,
142: p_init_msg_list in varchar2 := fnd_api.g_false,
143: p_commit in varchar2 := fnd_api.g_false,
144: p_validation_level in number := fnd_api.g_valid_level_full,
145: p_return_status OUT NOCOPY varchar2,
146: p_msg_count OUT NOCOPY number,
147: p_msg_data OUT NOCOPY varchar2,
148: p_row_locked OUT NOCOPY varchar2,