[Home] [Help]
PACKAGE: APPS.GME_BATCHSTEP_RSRC_PVT
Source
1 PACKAGE gme_batchstep_rsrc_pvt AS
2 /* $Header: GMEVRSRS.pls 120.1 2005/06/03 14:16:02 appldev $
3 *****************************************************************
4 * *
5 * Package GME_BATCHSTEP_RSRC_PVT *
6 * *
7 * Contents INSERT RESOURCE *
8 * UPDATE RESOURCE *
9 * DELETE RESOURCE *
10 * *
11 * Use This is the private layer of the *
12 * GME Batch Step Resource *
13 * Process. *
14 * *
15 * History *
16 * Adapted for Inventory Convergence March 2005 *
17 * *
18 *****************************************************************
19 */
20 PROCEDURE validate_param (
21 p_org_code IN VARCHAR2 := NULL
22 ,p_batch_no IN VARCHAR2 := NULL
23 ,p_batchstep_no IN NUMBER := NULL
24 ,p_activity IN VARCHAR2 := NULL
25 ,p_resource IN VARCHAR2 := NULL
26 ,x_organization_id OUT NOCOPY NUMBER
27 ,x_batch_id OUT NOCOPY NUMBER
28 ,x_batchstep_id OUT NOCOPY NUMBER
29 ,x_activity_id OUT NOCOPY NUMBER
30 ,x_rsrc_id OUT NOCOPY NUMBER
31 ,x_step_status OUT NOCOPY NUMBER
32 ,x_return_status OUT NOCOPY VARCHAR2);
33
34 PROCEDURE validate_rsrc_param (
35 p_batchstep_resource_rec IN gme_batch_step_resources%ROWTYPE
36 ,p_activity_id IN NUMBER
37 ,p_ignore_qty_below_cap IN VARCHAR2
38 DEFAULT fnd_api.g_false
39 ,p_validate_flexfield IN VARCHAR2
40 DEFAULT fnd_api.g_false
41 ,p_action IN VARCHAR2
42 ,x_batchstep_resource_rec OUT NOCOPY gme_batch_step_resources%ROWTYPE
43 ,x_step_status OUT NOCOPY NUMBER
44 ,x_return_status OUT NOCOPY VARCHAR2);
45
46 PROCEDURE insert_batchstep_rsrc (
47 p_batchstep_resource_rec IN gme_batch_step_resources%ROWTYPE
48 ,x_batchstep_resource_rec OUT NOCOPY gme_batch_step_resources%ROWTYPE
49 ,x_return_status OUT NOCOPY VARCHAR2);
50
51 PROCEDURE update_batchstep_rsrc (
52 p_batchstep_resource_rec IN gme_batch_step_resources%ROWTYPE
53 ,x_batchstep_resource_rec OUT NOCOPY gme_batch_step_resources%ROWTYPE
54 ,x_return_status OUT NOCOPY VARCHAR2);
55
56 PROCEDURE delete_batchstep_rsrc (
57 p_batchstep_resource_rec IN gme_batch_step_resources%ROWTYPE
58 ,x_return_status OUT NOCOPY VARCHAR2);
59
60 FUNCTION date_within_activity_dates (
61 p_batchstep_activity_id NUMBER
62 ,p_step_status NUMBER
63 ,p_date DATE)
64 RETURN BOOLEAN;
65
66 FUNCTION lookup_code_valid (p_lookup_type VARCHAR2, p_lookup_code VARCHAR2)
67 RETURN BOOLEAN;
68
69 PROCEDURE consolidate_flexfields (
70 p_new_batchstep_resource_rec IN gme_batch_step_resources%ROWTYPE
71 ,p_old_batchstep_resource_rec IN gme_batch_step_resources%ROWTYPE
72 ,p_validate_flexfield IN VARCHAR2
73 DEFAULT fnd_api.g_false
74 ,x_batchstep_resource_rec OUT NOCOPY gme_batch_step_resources%ROWTYPE
75 ,x_return_status OUT NOCOPY VARCHAR2);
76 END gme_batchstep_rsrc_pvt;