[Home] [Help]
PACKAGE: APPS.GME_BATCHSTEP_ACT_PVT
Source
1 PACKAGE gme_batchstep_act_pvt AS
2 /* $Header: GMEVACTS.pls 120.1 2005/06/06 12:03:36 appldev $ */
3
4 PROCEDURE validate_param (
5 p_org_code IN VARCHAR2 := NULL,
6 p_batch_no IN VARCHAR2 := NULL,
7 p_batchstep_no IN NUMBER := NULL,
8 p_activity IN VARCHAR2 := NULL,
9 x_batch_id OUT NOCOPY NUMBER,
10 x_batchstep_id OUT NOCOPY NUMBER,
11 x_activity_id OUT NOCOPY NUMBER,
12 x_batch_status OUT NOCOPY NUMBER,
13 x_step_status OUT NOCOPY NUMBER,
14 x_return_status OUT NOCOPY VARCHAR2
15 );
16
17 PROCEDURE validate_activity_param (
18 p_batchstep_activity_rec IN gme_batch_step_activities%ROWTYPE,
19 p_step_id IN NUMBER,
20 p_validate_flexfield IN VARCHAR2
21 DEFAULT fnd_api.g_false,
22 p_action IN VARCHAR2,
23 x_batchstep_activity_rec OUT NOCOPY gme_batch_step_activities%ROWTYPE,
24 x_step_status OUT NOCOPY NUMBER,
25 x_return_status OUT NOCOPY VARCHAR2
26 );
27
28 PROCEDURE insert_batchstep_activity (
29 p_batchstep_activity_rec IN gme_batch_step_activities%ROWTYPE,
30 p_batchstep_resource_tbl IN gme_create_step_pvt.resources_tab,
31 p_org_code IN VARCHAR2 := NULL,
32 p_batch_no IN VARCHAR2 := NULL,
33 p_batchstep_no IN NUMBER := NULL,
34 p_ignore_qty_below_cap IN VARCHAR2
35 DEFAULT fnd_api.g_false,
36 p_validate_flexfield IN VARCHAR2
37 DEFAULT fnd_api.g_false,
38 x_batchstep_activity_rec OUT NOCOPY gme_batch_step_activities%ROWTYPE,
39 x_return_status OUT NOCOPY VARCHAR2
40 );
41
42 PROCEDURE update_batchstep_activity (
43 p_batchstep_activity_rec IN gme_batch_step_activities%ROWTYPE,
44 p_org_code IN VARCHAR2 := NULL,
45 p_batch_no IN VARCHAR2 := NULL,
46 p_batchstep_no IN NUMBER := NULL,
47 p_validate_flexfield IN VARCHAR2
48 DEFAULT fnd_api.g_false,
49 x_batchstep_activity_rec OUT NOCOPY gme_batch_step_activities%ROWTYPE,
50 x_return_status OUT NOCOPY VARCHAR2
51 );
52
53 PROCEDURE delete_batchstep_activity (
54 p_batchstep_activity_id IN NUMBER := NULL,
55 p_org_code IN VARCHAR2 := NULL,
56 p_batch_no IN VARCHAR2 := NULL,
57 p_batchstep_no IN NUMBER := NULL,
58 p_activity IN VARCHAR2 := NULL,
59 x_return_status OUT NOCOPY VARCHAR2
60 );
61 END gme_batchstep_act_pvt;