[Home] [Help]
PACKAGE: APPS.ASO_PUBLISH_MISC_INT
Source
1 PACKAGE aso_publish_misc_int as
2 /* $Header: asoipmss.pls 120.3.12010000.2 2008/09/08 05:22:05 ajosephg ship $ */
3
4 -- API Name: NotifyUserForRegistration
5 -- Type : Public
6 -- Pre-Req : Workflow template for the notification should be there in the DB
7
8 PROCEDURE NotifyUserForRegistration(
9 p_api_version IN NUMBER,
10 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
11 p_quote_id IN NUMBER,
12 p_Send_Name IN Varchar2,
13 p_Store_Name IN Varchar2,
14 p_Store_Website IN Varchar2,
15 p_FND_Password IN Varchar2,
16 p_email_address IN varchar2 := null,
17 p_email_language IN varchar2 := null,
18 x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
19 x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
20 x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
21 );
22
23 -- API Name: NotifyForQuotePublish
24 -- Type : Public
25 -- Pre-Req : Workflow template for the notification should be there in the DB
26
27 PROCEDURE NotifyForQuotePublish(
28 p_api_version IN NUMBER,
29 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
30 p_quote_id IN NUMBER,
31 p_Send_Name IN Varchar2,
32 p_Comments IN Varchar2,
33 p_Store_Name IN Varchar2,
34 p_Store_Website IN Varchar2,
35 p_url IN Varchar2,
36 x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
37 x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
38 x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
39 );
40
41
42 -- API Name: getUserType
43 -- Type : Public
44 -- Pre-Req : No
45
46 Procedure getUserType(
47 pPartyId IN Varchar2,
48 pUserType OUT NOCOPY /* file.sql.39 change */ Varchar2
49 );
50
51 -- API Name: GetFirstName
52 -- Type : Public
53 -- Pre-Req : No
54
55 PROCEDURE GetFirstName(
56 document_id IN VARCHAR2,
57 display_type IN VARCHAR2,
58 document IN OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
59 document_type IN OUT NOCOPY /* file.sql.39 change */ VARCHAR2
60 );
61
62
63 -- API Name: GetLastName
64 -- Type : Public
65 -- Pre-Req : No
66
67 PROCEDURE GetLastName(
68 document_id IN VARCHAR2,
69 display_type IN VARCHAR2,
70 document IN OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
71 document_type IN OUT NOCOPY /* file.sql.39 change */ VARCHAR2
72 );
73
74
75 -- API Name: getUserType
76 -- Type : Public
77 -- Pre-Req : No
78
79 PROCEDURE GetTitle(
80 document_id IN VARCHAR2,
81 display_type IN VARCHAR2,
82 document IN OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
83 document_type IN OUT NOCOPY /* file.sql.39 change */ VARCHAR2
84 );
85
86 -- API Name: GetStoreName
87 -- Type : Public
88 -- Pre-Req : No
89
90 PROCEDURE GetStoreName(
91 document_id IN VARCHAR2,
92 display_type IN VARCHAR2,
93 document IN OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
94 document_type IN OUT NOCOPY /* file.sql.39 change */ VARCHAR2
95 );
96
97
98 /*
99 PROCEDURE PublishQuoteLocal(
100 p_quote_header_id IN NUMBER,
101 p_publish_flag IN VARCHAR2,
102 p_last_update_date IN DATE
103 );
104 */
105
106 procedure createStoreUser
107 (
108 p_api_version_number IN NUMBER,
109 p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
110 p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
111 p_user_name IN VARCHAR2,
112 p_user_password IN VARCHAR2,
113 p_email_address IN VARCHAR2 DEFAULT NULL, /* Add for Bug 7334453 */
114 p_email_language IN VARCHAR2,
115 p_party_id IN NUMBER,
116 p_party_type IN VARCHAR2,
117 x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
118 x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
119 x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
120 );
121
122
123
124 --sunder -- added wrapper for sso changes 7/21
125 --
126 PROCEDURE TestUserName(
127 p_user_name IN VARCHAR2,
128 x_test_user_status OUT NOCOPY VARCHAR2,
129 x_return_status OUT NOCOPY VARCHAR2,
130 x_msg_count OUT NOCOPY NUMBER,
131 x_msg_data OUT NOCOPY VARCHAR2
132 );
133
134 END aso_publish_misc_int;