DBA Data[Home] [Help]

APPS.PA_PROJECT_SUBTEAM_PARTIES_PVT dependencies on FND_API

Line 4: g_error_exists VARCHAR2(1) := FND_API.G_FALSE;

1: PACKAGE pa_project_subteam_parties_pvt AUTHID CURRENT_USER AS
2: --$Header: PARTSPVS.pls 120.1 2005/08/19 17:01:49 mwasowic noship $
3:
4: g_error_exists VARCHAR2(1) := FND_API.G_FALSE;
5:
6: PROCEDURE Create_Subteam_Party
7: (
8: p_api_version IN NUMBER := 1.0,

Line 9: p_init_msg_list IN VARCHAR2 := fnd_api.g_true,

5:
6: PROCEDURE Create_Subteam_Party
7: (
8: p_api_version IN NUMBER := 1.0,
9: p_init_msg_list IN VARCHAR2 := fnd_api.g_true,
10: p_commit IN VARCHAR2 := FND_API.g_false,
11:
12: p_validate_only IN VARCHAR2 := FND_API.g_true,
13:

Line 10: p_commit IN VARCHAR2 := FND_API.g_false,

6: PROCEDURE Create_Subteam_Party
7: (
8: p_api_version IN NUMBER := 1.0,
9: p_init_msg_list IN VARCHAR2 := fnd_api.g_true,
10: p_commit IN VARCHAR2 := FND_API.g_false,
11:
12: p_validate_only IN VARCHAR2 := FND_API.g_true,
13:
14: p_validation_level IN NUMBER := FND_API.g_valid_level_full,

Line 12: p_validate_only IN VARCHAR2 := FND_API.g_true,

8: p_api_version IN NUMBER := 1.0,
9: p_init_msg_list IN VARCHAR2 := fnd_api.g_true,
10: p_commit IN VARCHAR2 := FND_API.g_false,
11:
12: p_validate_only IN VARCHAR2 := FND_API.g_true,
13:
14: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
15:
16: p_calling_module IN VARCHAR2

Line 14: p_validation_level IN NUMBER := FND_API.g_valid_level_full,

10: p_commit IN VARCHAR2 := FND_API.g_false,
11:
12: p_validate_only IN VARCHAR2 := FND_API.g_true,
13:
14: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
15:
16: p_calling_module IN VARCHAR2
17: := 'SELF_SERVICE',
18:

Line 21: p_max_msg_count IN NUMBER := FND_API.g_miss_num,

17: := 'SELF_SERVICE',
18:
19: p_debug_mode IN VARCHAR2 := 'N',
20:
21: p_max_msg_count IN NUMBER := FND_API.g_miss_num,
22:
23: p_project_subteam_id IN pa_project_subteams.Project_subteam_id%TYPE := FND_API.g_miss_num,
24:
25: p_object_type IN varchar2,

Line 23: p_project_subteam_id IN pa_project_subteams.Project_subteam_id%TYPE := FND_API.g_miss_num,

19: p_debug_mode IN VARCHAR2 := 'N',
20:
21: p_max_msg_count IN NUMBER := FND_API.g_miss_num,
22:
23: p_project_subteam_id IN pa_project_subteams.Project_subteam_id%TYPE := FND_API.g_miss_num,
24:
25: p_object_type IN varchar2,
26:
27: p_object_id IN NUMBER := fnd_api.g_miss_num,

Line 27: p_object_id IN NUMBER := fnd_api.g_miss_num,

23: p_project_subteam_id IN pa_project_subteams.Project_subteam_id%TYPE := FND_API.g_miss_num,
24:
25: p_object_type IN varchar2,
26:
27: p_object_id IN NUMBER := fnd_api.g_miss_num,
28:
29: p_primary_subteam_flag IN VARCHAR2 := 'Y',
30:
31: x_project_subteam_party_row_id OUT NOCOPY ROWID, --File.Sql.39 bug 4440895

Line 42: p_init_msg_list IN VARCHAR2 := fnd_api.g_true,

38:
39: PROCEDURE Update_Subteam_Party
40: (
41: p_api_version IN NUMBER := 1.0,
42: p_init_msg_list IN VARCHAR2 := fnd_api.g_true,
43: p_commit IN VARCHAR2 := FND_API.g_false,
44:
45: p_validate_only IN VARCHAR2 := FND_API.g_true,
46:

Line 43: p_commit IN VARCHAR2 := FND_API.g_false,

39: PROCEDURE Update_Subteam_Party
40: (
41: p_api_version IN NUMBER := 1.0,
42: p_init_msg_list IN VARCHAR2 := fnd_api.g_true,
43: p_commit IN VARCHAR2 := FND_API.g_false,
44:
45: p_validate_only IN VARCHAR2 := FND_API.g_true,
46:
47: p_validation_level IN NUMBER := FND_API.g_valid_level_full,

Line 45: p_validate_only IN VARCHAR2 := FND_API.g_true,

41: p_api_version IN NUMBER := 1.0,
42: p_init_msg_list IN VARCHAR2 := fnd_api.g_true,
43: p_commit IN VARCHAR2 := FND_API.g_false,
44:
45: p_validate_only IN VARCHAR2 := FND_API.g_true,
46:
47: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
48:
49: p_calling_module IN VARCHAR2

Line 47: p_validation_level IN NUMBER := FND_API.g_valid_level_full,

43: p_commit IN VARCHAR2 := FND_API.g_false,
44:
45: p_validate_only IN VARCHAR2 := FND_API.g_true,
46:
47: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
48:
49: p_calling_module IN VARCHAR2
50: := 'SELF_SERVICE',
51:

Line 54: p_max_msg_count IN NUMBER := FND_API.g_miss_num,

50: := 'SELF_SERVICE',
51:
52: p_debug_mode IN VARCHAR2 := 'N',
53:
54: p_max_msg_count IN NUMBER := FND_API.g_miss_num,
55:
56: p_project_subteam_party_row_id IN ROWID := null,
57:
58: p_project_subteam_party_id IN pa_project_subteam_parties.project_subteam_party_id%TYPE := FND_API.g_miss_num,

Line 58: p_project_subteam_party_id IN pa_project_subteam_parties.project_subteam_party_id%TYPE := FND_API.g_miss_num,

54: p_max_msg_count IN NUMBER := FND_API.g_miss_num,
55:
56: p_project_subteam_party_row_id IN ROWID := null,
57:
58: p_project_subteam_party_id IN pa_project_subteam_parties.project_subteam_party_id%TYPE := FND_API.g_miss_num,
59:
60: p_project_subteam_id IN pa_project_subteam_parties.project_subteam_id%TYPE := FND_API.g_miss_num,
61:
62: p_object_type IN varchar2,

Line 60: p_project_subteam_id IN pa_project_subteam_parties.project_subteam_id%TYPE := FND_API.g_miss_num,

56: p_project_subteam_party_row_id IN ROWID := null,
57:
58: p_project_subteam_party_id IN pa_project_subteam_parties.project_subteam_party_id%TYPE := FND_API.g_miss_num,
59:
60: p_project_subteam_id IN pa_project_subteam_parties.project_subteam_id%TYPE := FND_API.g_miss_num,
61:
62: p_object_type IN varchar2,
63:
64: p_object_id IN NUMBER := fnd_api.g_miss_num,

Line 64: p_object_id IN NUMBER := fnd_api.g_miss_num,

60: p_project_subteam_id IN pa_project_subteam_parties.project_subteam_id%TYPE := FND_API.g_miss_num,
61:
62: p_object_type IN varchar2,
63:
64: p_object_id IN NUMBER := fnd_api.g_miss_num,
65:
66: p_primary_subteam_flag IN VARCHAR2 := fnd_api.g_miss_char,
67:
68: p_record_version_number IN pa_project_subteams.record_version_number%TYPE := FND_API.g_miss_num,

Line 66: p_primary_subteam_flag IN VARCHAR2 := fnd_api.g_miss_char,

62: p_object_type IN varchar2,
63:
64: p_object_id IN NUMBER := fnd_api.g_miss_num,
65:
66: p_primary_subteam_flag IN VARCHAR2 := fnd_api.g_miss_char,
67:
68: p_record_version_number IN pa_project_subteams.record_version_number%TYPE := FND_API.g_miss_num,
69:
70: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895

Line 68: p_record_version_number IN pa_project_subteams.record_version_number%TYPE := FND_API.g_miss_num,

64: p_object_id IN NUMBER := fnd_api.g_miss_num,
65:
66: p_primary_subteam_flag IN VARCHAR2 := fnd_api.g_miss_char,
67:
68: p_record_version_number IN pa_project_subteams.record_version_number%TYPE := FND_API.g_miss_num,
69:
70: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
71: x_record_version_number OUT NOCOPY NUMBER , --File.Sql.39 bug 4440895
72: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895

Line 79: p_init_msg_list IN VARCHAR2 := fnd_api.g_true,

75:
76: PROCEDURE Update_SPT_Assgn
77: (
78: p_api_version IN NUMBER := 1.0,
79: p_init_msg_list IN VARCHAR2 := fnd_api.g_true,
80: p_commit IN VARCHAR2 := FND_API.g_false,
81:
82: p_validate_only IN VARCHAR2 := FND_API.g_true,
83:

Line 80: p_commit IN VARCHAR2 := FND_API.g_false,

76: PROCEDURE Update_SPT_Assgn
77: (
78: p_api_version IN NUMBER := 1.0,
79: p_init_msg_list IN VARCHAR2 := fnd_api.g_true,
80: p_commit IN VARCHAR2 := FND_API.g_false,
81:
82: p_validate_only IN VARCHAR2 := FND_API.g_true,
83:
84: p_validation_level IN NUMBER := FND_API.g_valid_level_full,

Line 82: p_validate_only IN VARCHAR2 := FND_API.g_true,

78: p_api_version IN NUMBER := 1.0,
79: p_init_msg_list IN VARCHAR2 := fnd_api.g_true,
80: p_commit IN VARCHAR2 := FND_API.g_false,
81:
82: p_validate_only IN VARCHAR2 := FND_API.g_true,
83:
84: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
85:
86: p_calling_module IN VARCHAR2

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

80: p_commit IN VARCHAR2 := FND_API.g_false,
81:
82: p_validate_only IN VARCHAR2 := FND_API.g_true,
83:
84: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
85:
86: p_calling_module IN VARCHAR2
87: := 'SELF_SERVICE',
88:

Line 91: p_max_msg_count IN NUMBER := FND_API.g_miss_num,

87: := 'SELF_SERVICE',
88:
89: p_debug_mode IN VARCHAR2 := 'N',
90:
91: p_max_msg_count IN NUMBER := FND_API.g_miss_num,
92:
93: p_project_subteam_party_row_id IN ROWID := null,
94:
95: p_project_subteam_party_id IN pa_project_subteam_parties.project_subteam_party_id%TYPE := NULL,

Line 101: p_object_id IN NUMBER := fnd_api.g_miss_num,

97: p_project_subteam_id IN pa_project_subteam_parties.project_subteam_id%TYPE := NULL,
98:
99: p_object_type IN varchar2,
100:
101: p_object_id IN NUMBER := fnd_api.g_miss_num,
102:
103: p_primary_subteam_flag IN VARCHAR2 := fnd_api.g_miss_char,
104:
105: p_record_version_number IN pa_project_subteams.record_version_number%TYPE := FND_API.g_miss_num,

Line 103: p_primary_subteam_flag IN VARCHAR2 := fnd_api.g_miss_char,

99: p_object_type IN varchar2,
100:
101: p_object_id IN NUMBER := fnd_api.g_miss_num,
102:
103: p_primary_subteam_flag IN VARCHAR2 := fnd_api.g_miss_char,
104:
105: p_record_version_number IN pa_project_subteams.record_version_number%TYPE := FND_API.g_miss_num,
106:
107: p_get_subteam_party_id_flag IN VARCHAR2 := 'N',

Line 105: p_record_version_number IN pa_project_subteams.record_version_number%TYPE := FND_API.g_miss_num,

101: p_object_id IN NUMBER := fnd_api.g_miss_num,
102:
103: p_primary_subteam_flag IN VARCHAR2 := fnd_api.g_miss_char,
104:
105: p_record_version_number IN pa_project_subteams.record_version_number%TYPE := FND_API.g_miss_num,
106:
107: p_get_subteam_party_id_flag IN VARCHAR2 := 'N',
108:
109: x_project_subteam_party_id OUT NOCOPY pa_project_subteam_parties.project_subteam_party_id%TYPE, --File.Sql.39 bug 4440895

Line 119: p_init_msg_list IN VARCHAR2 := fnd_api.g_true,

115:
116: PROCEDURE Delete_Subteam_Party
117: (
118: p_api_version IN NUMBER := 1.0,
119: p_init_msg_list IN VARCHAR2 := fnd_api.g_true,
120: p_commit IN VARCHAR2 := FND_API.g_false,
121:
122: p_validate_only IN VARCHAR2 := FND_API.g_true,
123:

Line 120: p_commit IN VARCHAR2 := FND_API.g_false,

116: PROCEDURE Delete_Subteam_Party
117: (
118: p_api_version IN NUMBER := 1.0,
119: p_init_msg_list IN VARCHAR2 := fnd_api.g_true,
120: p_commit IN VARCHAR2 := FND_API.g_false,
121:
122: p_validate_only IN VARCHAR2 := FND_API.g_true,
123:
124: p_validation_level IN NUMBER := FND_API.g_valid_level_full,

Line 122: p_validate_only IN VARCHAR2 := FND_API.g_true,

118: p_api_version IN NUMBER := 1.0,
119: p_init_msg_list IN VARCHAR2 := fnd_api.g_true,
120: p_commit IN VARCHAR2 := FND_API.g_false,
121:
122: p_validate_only IN VARCHAR2 := FND_API.g_true,
123:
124: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
125:
126: p_calling_module IN VARCHAR2

Line 124: p_validation_level IN NUMBER := FND_API.g_valid_level_full,

120: p_commit IN VARCHAR2 := FND_API.g_false,
121:
122: p_validate_only IN VARCHAR2 := FND_API.g_true,
123:
124: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
125:
126: p_calling_module IN VARCHAR2
127: := 'SELF_SERVICE',
128:

Line 131: p_max_msg_count IN NUMBER := FND_API.g_miss_num,

127: := 'SELF_SERVICE',
128:
129: p_debug_mode IN VARCHAR2 := 'N',
130:
131: p_max_msg_count IN NUMBER := FND_API.g_miss_num,
132:
133: p_project_subteam_party_row_id IN ROWID := NULL,
134:
135: p_project_subteam_party_id IN pa_project_subteams.project_subteam_id%TYPE := fnd_api.g_miss_num,

Line 135: p_project_subteam_party_id IN pa_project_subteams.project_subteam_id%TYPE := fnd_api.g_miss_num,

131: p_max_msg_count IN NUMBER := FND_API.g_miss_num,
132:
133: p_project_subteam_party_row_id IN ROWID := NULL,
134:
135: p_project_subteam_party_id IN pa_project_subteams.project_subteam_id%TYPE := fnd_api.g_miss_num,
136:
137: p_record_version_number IN NUMBER := FND_API.G_MISS_NUM,
138:
139: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895

Line 137: p_record_version_number IN NUMBER := FND_API.G_MISS_NUM,

133: p_project_subteam_party_row_id IN ROWID := NULL,
134:
135: p_project_subteam_party_id IN pa_project_subteams.project_subteam_id%TYPE := fnd_api.g_miss_num,
136:
137: p_record_version_number IN NUMBER := FND_API.G_MISS_NUM,
138:
139: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
140: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
141: x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 147: p_init_msg_list IN VARCHAR2 := fnd_api.g_true,

143:
144: PROCEDURE Delete_SubteamParty_By_Obj
145: (
146: p_api_version IN NUMBER := 1.0,
147: p_init_msg_list IN VARCHAR2 := fnd_api.g_true,
148: p_commit IN VARCHAR2 := FND_API.g_false,
149:
150: p_validate_only IN VARCHAR2 := FND_API.g_true,
151:

Line 148: p_commit IN VARCHAR2 := FND_API.g_false,

144: PROCEDURE Delete_SubteamParty_By_Obj
145: (
146: p_api_version IN NUMBER := 1.0,
147: p_init_msg_list IN VARCHAR2 := fnd_api.g_true,
148: p_commit IN VARCHAR2 := FND_API.g_false,
149:
150: p_validate_only IN VARCHAR2 := FND_API.g_true,
151:
152: p_validation_level IN NUMBER := FND_API.g_valid_level_full,

Line 150: p_validate_only IN VARCHAR2 := FND_API.g_true,

146: p_api_version IN NUMBER := 1.0,
147: p_init_msg_list IN VARCHAR2 := fnd_api.g_true,
148: p_commit IN VARCHAR2 := FND_API.g_false,
149:
150: p_validate_only IN VARCHAR2 := FND_API.g_true,
151:
152: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
153:
154: p_calling_module IN VARCHAR2

Line 152: p_validation_level IN NUMBER := FND_API.g_valid_level_full,

148: p_commit IN VARCHAR2 := FND_API.g_false,
149:
150: p_validate_only IN VARCHAR2 := FND_API.g_true,
151:
152: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
153:
154: p_calling_module IN VARCHAR2
155: := NULL,
156:

Line 159: p_max_msg_count IN NUMBER := FND_API.g_miss_num,

155: := NULL,
156:
157: p_debug_mode IN VARCHAR2 := 'N',
158:
159: p_max_msg_count IN NUMBER := FND_API.g_miss_num,
160:
161: p_object_type IN varchar2,
162:
163: p_object_id IN NUMBER := fnd_api.g_miss_num,

Line 163: p_object_id IN NUMBER := fnd_api.g_miss_num,

159: p_max_msg_count IN NUMBER := FND_API.g_miss_num,
160:
161: p_object_type IN varchar2,
162:
163: p_object_id IN NUMBER := fnd_api.g_miss_num,
164:
165: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
166: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
167: x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895