2: /* $Header: astvpaus.pls 115.3 2002/02/06 11:44:11 pkm ship $ */
3:
4: PROCEDURE Insert_Phone_Assist_PRE(
5: p_api_version IN NUMBER,
6: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
7: p_commit IN VARCHAR2 := FND_API.G_FALSE,
8: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
9: x_return_status OUT VARCHAR2,
10: x_msg_count OUT NUMBER,
3:
4: PROCEDURE Insert_Phone_Assist_PRE(
5: p_api_version IN NUMBER,
6: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
7: p_commit IN VARCHAR2 := FND_API.G_FALSE,
8: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
9: x_return_status OUT VARCHAR2,
10: x_msg_count OUT NUMBER,
11: x_msg_data OUT VARCHAR2,
4: PROCEDURE Insert_Phone_Assist_PRE(
5: p_api_version IN NUMBER,
6: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
7: p_commit IN VARCHAR2 := FND_API.G_FALSE,
8: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
9: x_return_status OUT VARCHAR2,
10: x_msg_count OUT NUMBER,
11: x_msg_data OUT VARCHAR2,
12: p_name IN VARCHAR2,
18: p_phone_extension IN VARCHAR2);
19:
20: PROCEDURE Insert_Phone_Assist_POST(
21: p_api_version IN NUMBER,
22: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
23: p_commit IN VARCHAR2 := FND_API.G_FALSE,
24: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
25: x_return_status OUT VARCHAR2,
26: x_msg_count OUT NUMBER,
19:
20: PROCEDURE Insert_Phone_Assist_POST(
21: p_api_version IN NUMBER,
22: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
23: p_commit IN VARCHAR2 := FND_API.G_FALSE,
24: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
25: x_return_status OUT VARCHAR2,
26: x_msg_count OUT NUMBER,
27: x_msg_data OUT VARCHAR2,
20: PROCEDURE Insert_Phone_Assist_POST(
21: p_api_version IN NUMBER,
22: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
23: p_commit IN VARCHAR2 := FND_API.G_FALSE,
24: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
25: x_return_status OUT VARCHAR2,
26: x_msg_count OUT NUMBER,
27: x_msg_data OUT VARCHAR2,
28: p_name IN VARCHAR2,
34: p_phone_extension IN VARCHAR2);
35:
36: PROCEDURE Update_Phone_Assist_PRE(
37: p_api_version IN NUMBER,
38: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
39: p_commit IN VARCHAR2 := FND_API.G_FALSE,
40: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
41: x_return_status OUT VARCHAR2,
42: x_msg_count OUT NUMBER,
35:
36: PROCEDURE Update_Phone_Assist_PRE(
37: p_api_version IN NUMBER,
38: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
39: p_commit IN VARCHAR2 := FND_API.G_FALSE,
40: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
41: x_return_status OUT VARCHAR2,
42: x_msg_count OUT NUMBER,
43: x_msg_data OUT VARCHAR2,
36: PROCEDURE Update_Phone_Assist_PRE(
37: p_api_version IN NUMBER,
38: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
39: p_commit IN VARCHAR2 := FND_API.G_FALSE,
40: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
41: x_return_status OUT VARCHAR2,
42: x_msg_count OUT NUMBER,
43: x_msg_data OUT VARCHAR2,
44: p_phone_assist_id IN NUMBER,
52: p_phone_extension IN VARCHAR2);
53:
54: PROCEDURE Update_Phone_Assist_POST(
55: p_api_version IN NUMBER,
56: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
57: p_commit IN VARCHAR2 := FND_API.G_FALSE,
58: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
59: x_return_status OUT VARCHAR2,
60: x_msg_count OUT NUMBER,
53:
54: PROCEDURE Update_Phone_Assist_POST(
55: p_api_version IN NUMBER,
56: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
57: p_commit IN VARCHAR2 := FND_API.G_FALSE,
58: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
59: x_return_status OUT VARCHAR2,
60: x_msg_count OUT NUMBER,
61: x_msg_data OUT VARCHAR2,
54: PROCEDURE Update_Phone_Assist_POST(
55: p_api_version IN NUMBER,
56: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
57: p_commit IN VARCHAR2 := FND_API.G_FALSE,
58: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
59: x_return_status OUT VARCHAR2,
60: x_msg_count OUT NUMBER,
61: x_msg_data OUT VARCHAR2,
62: p_phone_assist_id IN NUMBER,
70: p_phone_extension IN VARCHAR2);
71:
72: PROCEDURE Delete_Phone_Assist_PRE(
73: p_api_version IN NUMBER,
74: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
75: p_commit IN VARCHAR2 := FND_API.G_FALSE,
76: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
77: x_return_status OUT VARCHAR2,
78: x_msg_count OUT NUMBER,
71:
72: PROCEDURE Delete_Phone_Assist_PRE(
73: p_api_version IN NUMBER,
74: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
75: p_commit IN VARCHAR2 := FND_API.G_FALSE,
76: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
77: x_return_status OUT VARCHAR2,
78: x_msg_count OUT NUMBER,
79: x_msg_data OUT VARCHAR2,
72: PROCEDURE Delete_Phone_Assist_PRE(
73: p_api_version IN NUMBER,
74: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
75: p_commit IN VARCHAR2 := FND_API.G_FALSE,
76: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
77: x_return_status OUT VARCHAR2,
78: x_msg_count OUT NUMBER,
79: x_msg_data OUT VARCHAR2,
80: p_phone_assist_id IN NUMBER,
83: p_assist_id IN NUMBER);
84:
85: PROCEDURE Delete_Phone_Assist_POST(
86: p_api_version IN NUMBER,
87: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
88: p_commit IN VARCHAR2 := FND_API.G_FALSE,
89: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
90: x_return_status OUT VARCHAR2,
91: x_msg_count OUT NUMBER,
84:
85: PROCEDURE Delete_Phone_Assist_POST(
86: p_api_version IN NUMBER,
87: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
88: p_commit IN VARCHAR2 := FND_API.G_FALSE,
89: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
90: x_return_status OUT VARCHAR2,
91: x_msg_count OUT NUMBER,
92: x_msg_data OUT VARCHAR2,
85: PROCEDURE Delete_Phone_Assist_POST(
86: p_api_version IN NUMBER,
87: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
88: p_commit IN VARCHAR2 := FND_API.G_FALSE,
89: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
90: x_return_status OUT VARCHAR2,
91: x_msg_count OUT NUMBER,
92: x_msg_data OUT VARCHAR2,
93: p_phone_assist_id IN NUMBER,
96: p_assist_id IN NUMBER);
97:
98: FUNCTION OK_TO_LAUNCH_WORKFLOW(
99: p_api_version IN NUMBER := 1.0,
100: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
101: p_commit IN VARCHAR2 := FND_API.G_FALSE,
102: p_validation_level IN NUMBER :=
103: FND_API.G_VALID_LEVEL_FULL,
104: x_return_status OUT VARCHAR2,
97:
98: FUNCTION OK_TO_LAUNCH_WORKFLOW(
99: p_api_version IN NUMBER := 1.0,
100: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
101: p_commit IN VARCHAR2 := FND_API.G_FALSE,
102: p_validation_level IN NUMBER :=
103: FND_API.G_VALID_LEVEL_FULL,
104: x_return_status OUT VARCHAR2,
105: x_msg_count OUT NUMBER,
99: p_api_version IN NUMBER := 1.0,
100: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
101: p_commit IN VARCHAR2 := FND_API.G_FALSE,
102: p_validation_level IN NUMBER :=
103: FND_API.G_VALID_LEVEL_FULL,
104: x_return_status OUT VARCHAR2,
105: x_msg_count OUT NUMBER,
106: x_msg_data OUT VARCHAR2) RETURN BOOLEAN;
107:
107:
108:
109: FUNCTION OK_TO_GENERATE_MSG(
110: p_api_version IN NUMBER := 1.0,
111: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
112: p_commit IN VARCHAR2 := FND_API.G_FALSE,
113: p_validation_level IN NUMBER :=
114: FND_API.G_VALID_LEVEL_FULL,
115: x_return_status OUT VARCHAR2,
108:
109: FUNCTION OK_TO_GENERATE_MSG(
110: p_api_version IN NUMBER := 1.0,
111: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
112: p_commit IN VARCHAR2 := FND_API.G_FALSE,
113: p_validation_level IN NUMBER :=
114: FND_API.G_VALID_LEVEL_FULL,
115: x_return_status OUT VARCHAR2,
116: x_msg_count OUT NUMBER,
110: p_api_version IN NUMBER := 1.0,
111: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
112: p_commit IN VARCHAR2 := FND_API.G_FALSE,
113: p_validation_level IN NUMBER :=
114: FND_API.G_VALID_LEVEL_FULL,
115: x_return_status OUT VARCHAR2,
116: x_msg_count OUT NUMBER,
117: x_msg_data OUT VARCHAR2) RETURN BOOLEAN;
118: