6: /*-- Function: Validate entities within a recipe */
7: /*-- Pre-reqs: none */
8: /*-- Common Parameters for procedures: */
9: /*-- IN: p_api_version IN NUMBER */
10: /*-- p_init_msg_list IN VARCHAR2 optional default = FND_API.G_FALSE */
11: /*-- p_commit IN VARCHAR2 optional default = FND_API.G_FALSE */
12: /*-- p_validation_level IN NUMBER optional */
13: /*-- default = FND_API.G_VALID_LEVEL_FULL */
14: /*-- (specific parameters) */
7: /*-- Pre-reqs: none */
8: /*-- Common Parameters for procedures: */
9: /*-- IN: p_api_version IN NUMBER */
10: /*-- p_init_msg_list IN VARCHAR2 optional default = FND_API.G_FALSE */
11: /*-- p_commit IN VARCHAR2 optional default = FND_API.G_FALSE */
12: /*-- p_validation_level IN NUMBER optional */
13: /*-- default = FND_API.G_VALID_LEVEL_FULL */
14: /*-- (specific parameters) */
15: /*-- OUT: x_return_status OUT VARCHAR2(1) */
9: /*-- IN: p_api_version IN NUMBER */
10: /*-- p_init_msg_list IN VARCHAR2 optional default = FND_API.G_FALSE */
11: /*-- p_commit IN VARCHAR2 optional default = FND_API.G_FALSE */
12: /*-- p_validation_level IN NUMBER optional */
13: /*-- default = FND_API.G_VALID_LEVEL_FULL */
14: /*-- (specific parameters) */
15: /*-- OUT: x_return_status OUT VARCHAR2(1) */
16: /*-- x_msg_count OUT NUMBER */
17: /*-- x_msg_data OUT VARCHAR2(2000) */
47:
48:
49: PROCEDURE recipe_exists
50: ( p_api_version IN NUMBER,
51: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
52: p_commit IN VARCHAR2 := FND_API.G_FALSE,
53: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_NONE,
54: p_recipe_id IN NUMBER,
55: p_recipe_no IN VARCHAR2,
48:
49: PROCEDURE recipe_exists
50: ( p_api_version IN NUMBER,
51: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
52: p_commit IN VARCHAR2 := FND_API.G_FALSE,
53: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_NONE,
54: p_recipe_id IN NUMBER,
55: p_recipe_no IN VARCHAR2,
56: p_recipe_version IN NUMBER,
49: PROCEDURE recipe_exists
50: ( p_api_version IN NUMBER,
51: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
52: p_commit IN VARCHAR2 := FND_API.G_FALSE,
53: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_NONE,
54: p_recipe_id IN NUMBER,
55: p_recipe_no IN VARCHAR2,
56: p_recipe_version IN NUMBER,
57: x_return_status OUT NOCOPY VARCHAR2,
62:
63:
64: PROCEDURE recipe_name
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_NONE,
69: p_recipe_no IN VARCHAR2,
70: p_recipe_version IN NUMBER,
63:
64: PROCEDURE recipe_name
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_NONE,
69: p_recipe_no IN VARCHAR2,
70: p_recipe_version IN NUMBER,
71: p_action_code IN VARCHAR2 := 'U',
64: PROCEDURE recipe_name
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_NONE,
69: p_recipe_no IN VARCHAR2,
70: p_recipe_version IN NUMBER,
71: p_action_code IN VARCHAR2 := 'U',
72: x_return_status OUT NOCOPY VARCHAR2,
76: x_recipe_id OUT NOCOPY NUMBER);
77:
78: PROCEDURE recipe_for_update
79: ( p_api_version IN NUMBER,
80: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
81: p_commit IN VARCHAR2 := FND_API.G_FALSE,
82: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_NONE,
83: p_recipe_id IN NUMBER,
84: p_last_update_date IN DATE,
77:
78: PROCEDURE recipe_for_update
79: ( p_api_version IN NUMBER,
80: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
81: p_commit IN VARCHAR2 := FND_API.G_FALSE,
82: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_NONE,
83: p_recipe_id IN NUMBER,
84: p_last_update_date IN DATE,
85: p_form_or_asynch IN VARCHAR2 := 'A',
78: PROCEDURE recipe_for_update
79: ( p_api_version IN NUMBER,
80: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
81: p_commit IN VARCHAR2 := FND_API.G_FALSE,
82: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_NONE,
83: p_recipe_id IN NUMBER,
84: p_last_update_date IN DATE,
85: p_form_or_asynch IN VARCHAR2 := 'A',
86: x_return_status OUT NOCOPY VARCHAR2,
90:
91:
92: PROCEDURE recipe_description
93: ( p_api_version IN NUMBER,
94: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
95: p_commit IN VARCHAR2 := FND_API.G_FALSE,
96: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_NONE,
97: p_recipe_description IN VARCHAR2,
98: x_return_status OUT NOCOPY VARCHAR2,
91:
92: PROCEDURE recipe_description
93: ( p_api_version IN NUMBER,
94: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
95: p_commit IN VARCHAR2 := FND_API.G_FALSE,
96: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_NONE,
97: p_recipe_description IN VARCHAR2,
98: x_return_status OUT NOCOPY VARCHAR2,
99: x_msg_count OUT NOCOPY NUMBER,
92: PROCEDURE recipe_description
93: ( p_api_version IN NUMBER,
94: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
95: p_commit IN VARCHAR2 := FND_API.G_FALSE,
96: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_NONE,
97: p_recipe_description IN VARCHAR2,
98: x_return_status OUT NOCOPY VARCHAR2,
99: x_msg_count OUT NOCOPY NUMBER,
100: x_msg_data OUT NOCOPY VARCHAR2,
102:
103:
104: PROCEDURE recipe_orgn_code
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_NONE,
109: g_orgn_id IN NUMBER,
110: g_user_id IN NUMBER,
103:
104: PROCEDURE recipe_orgn_code
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_NONE,
109: g_orgn_id IN NUMBER,
110: g_user_id IN NUMBER,
111: p_required_ind IN VARCHAR2 := 'N',
104: PROCEDURE recipe_orgn_code
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_NONE,
109: g_orgn_id IN NUMBER,
110: g_user_id IN NUMBER,
111: p_required_ind IN VARCHAR2 := 'N',
112: x_return_status OUT NOCOPY VARCHAR2,
117: x_lab_ind OUT NOCOPY NUMBER);
118:
119: PROCEDURE process_loss_for_update
120: ( p_api_version IN NUMBER,
121: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
122: p_commit IN VARCHAR2 := FND_API.G_FALSE,
123: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_NONE,
124: p_recipe_id IN NUMBER,
125: p_orgn_id IN NUMBER,
118:
119: PROCEDURE process_loss_for_update
120: ( p_api_version IN NUMBER,
121: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
122: p_commit IN VARCHAR2 := FND_API.G_FALSE,
123: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_NONE,
124: p_recipe_id IN NUMBER,
125: p_orgn_id IN NUMBER,
126: p_last_update_date IN DATE,
119: PROCEDURE process_loss_for_update
120: ( p_api_version IN NUMBER,
121: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
122: p_commit IN VARCHAR2 := FND_API.G_FALSE,
123: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_NONE,
124: p_recipe_id IN NUMBER,
125: p_orgn_id IN NUMBER,
126: p_last_update_date IN DATE,
127: p_form_or_asynch IN VARCHAR2 := 'A',
131: x_return_code OUT NOCOPY NUMBER);
132:
133: PROCEDURE recipe_cust_exists
134: ( p_api_version IN NUMBER,
135: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
136: p_commit IN VARCHAR2 := FND_API.G_FALSE,
137: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_NONE,
138: p_recipe_id IN NUMBER,
139: p_customer_id IN NUMBER,
132:
133: PROCEDURE recipe_cust_exists
134: ( p_api_version IN NUMBER,
135: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
136: p_commit IN VARCHAR2 := FND_API.G_FALSE,
137: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_NONE,
138: p_recipe_id IN NUMBER,
139: p_customer_id IN NUMBER,
140: x_return_status OUT NOCOPY VARCHAR2,
133: PROCEDURE recipe_cust_exists
134: ( p_api_version IN NUMBER,
135: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
136: p_commit IN VARCHAR2 := FND_API.G_FALSE,
137: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_NONE,
138: p_recipe_id IN NUMBER,
139: p_customer_id IN NUMBER,
140: x_return_status OUT NOCOPY VARCHAR2,
141: x_msg_count OUT NOCOPY NUMBER,