1 PACKAGE GR_RISK_SAFETY_PHRASES_PUB AUTHID CURRENT_USER AS
2 /* $Header: GRRISAPS.pls 120.2 2010/11/19 16:26:31 plowe noship $*/
3 /*#
4 * This interface is used to create, delete, and validate risk and safety phrases.
5 * This package defines and implements the procedures required
6 * to create, delete, and validate risk and safety phrases.
7 * @rep:scope public
8 * @rep:product GR
9 * @rep:lifecycle active
10 * @rep:displayname GR Risk Safety Phrases Package
11 * @rep:compatibility S
12 * @rep:category BUSINESS_ENTITY GR_RISK_SAFETY_PHRASES
13 */
14
15
16
17 /* Define Procedures And Functions : */
18
19 /*#
20 * Inserts Risk and Safety Phrases
21 * This is a PL/SQL procedure to create,update and delete risk and safety phrases.
22 * @param p_api_version API version field
23 * @param p_init_msg_list Flag to check if message list intialized
24 * @param p_commit Flag to check for commit
25 * @param p_action Actions are I(insert),U(update),D(delete)
26 * @param p_object Object types are C(code),L(language)
27 * @param p_phrase_type Prhase Types are S(Safety Phrase),R(Risk Phrase)
28 * @param p_phrase_code Risk or Safety phrase code
29 * @param p_language Language in which Phrase text is inserted/updated
30 * @param p_source_language Source language for Phrase text.
31 * @param p_phrase_text Description for safety and risk phrases.
32 * @param p_attribute1 to attribute30 Flexfield attributes
33 * @param p_attribute_category structure of flex field
34 * @param x_return_status 'S'-Success, 'E'-Error, 'U'-Unexpected Error
35 * @param x_msg_count Number of msg's on message stack
36 * @param x_msg_data Actual message data on message stack
37 * @rep:scope public
38 * @rep:lifecycle active
39 * @rep:displayname Create Risk and Safety Phrases procedure
40 * @rep:compatibility S */
41
42
43
44 PROCEDURE RISK_SAFETY_PHRASES
45 ( p_api_version IN NUMBER
46 , p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
47 , p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
48 , p_action IN VARCHAR2
49 , p_object IN VARCHAR2
50 , p_phrase_type IN VARCHAR2
51 , p_phrase_code IN VARCHAR2
52 , p_language IN VARCHAR2
53 , p_source_language IN VARCHAR2
54 , p_phrase_text IN VARCHAR2
55 , p_attribute_category IN VARCHAR2
56 , p_attribute1 IN VARCHAR2
57 , p_attribute2 IN VARCHAR2
58 , p_attribute3 IN VARCHAR2
59 , p_attribute4 IN VARCHAR2
60 , p_attribute5 IN VARCHAR2
61 , p_attribute6 IN VARCHAR2
62 , p_attribute7 IN VARCHAR2
63 , p_attribute8 IN VARCHAR2
64 , p_attribute9 IN VARCHAR2
65 , p_attribute10 IN VARCHAR2
66 , p_attribute11 IN VARCHAR2
67 , p_attribute12 IN VARCHAR2
68 , p_attribute13 IN VARCHAR2
69 , p_attribute14 IN VARCHAR2
70 , p_attribute15 IN VARCHAR2
71 , p_attribute16 IN VARCHAR2
72 , p_attribute17 IN VARCHAR2
73 , p_attribute18 IN VARCHAR2
74 , p_attribute19 IN VARCHAR2
75 , p_attribute20 IN VARCHAR2
76 , p_attribute21 IN VARCHAR2
77 , p_attribute22 IN VARCHAR2
78 , p_attribute23 IN VARCHAR2
79 , p_attribute24 IN VARCHAR2
80 , p_attribute25 IN VARCHAR2
81 , p_attribute26 IN VARCHAR2
82 , p_attribute27 IN VARCHAR2
83 , p_attribute28 IN VARCHAR2
84 , p_attribute29 IN VARCHAR2
85 , p_attribute30 IN VARCHAR2
86 , x_return_status OUT NOCOPY VARCHAR2
87 , x_msg_count OUT NOCOPY NUMBER
88 , x_msg_data OUT NOCOPY VARCHAR2);
89
90 END GR_RISK_SAFETY_PHRASES_PUB;
91