DBA Data[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;