[Home] [Help]
PACKAGE: APPS.GME_BATCH_STEP_CHG_PVT
Source
1 PACKAGE gme_batch_step_chg_pvt AS
2 /*$Header: GMEVCHGS.pls 120.1 2005/06/03 13:44:02 appldev $ */
3
4 /*
5 ===========================================================================
6 | FILENAME |
7 | GMEVCHGS.pls |
8 | |
9 | DESCRIPTION |
10 | |
11 | Spec of package gme_batch_Step_chg_pvt |
12 | |
13 | NOTES |
14 | |
15 | HISTORY |
16 | |
17 | 10-MAY-2004 Rishi Varma bug 3307549 |
18 | Created |
19 | |
20 | - insert_row |
21 | - fetch_row |
22 | - delete_row |
23 | |
24 | |
25 ===========================================================================
26 */
27 TYPE gme_batch_ids_tab IS TABLE OF NUMBER
28 INDEX BY BINARY_INTEGER;
29
30 TYPE gme_batchstep_ids_tab IS TABLE OF NUMBER
31 INDEX BY BINARY_INTEGER;
32
33 PROCEDURE set_activity_sequence_num (pbatch_id IN NUMBER);
34
35 PROCEDURE set_all_batch_activities;
36
37 PROCEDURE set_sequence_dependent_id (pbatch_id IN NUMBER);
38
39 PROCEDURE set_all_batch_sequences;
40
41 PROCEDURE clear_charge_dates (
42 p_batch_id IN NUMBER
43 ,p_batchstep_id IN NUMBER DEFAULT NULL
44 ,x_return_status OUT NOCOPY VARCHAR2);
45
46 PROCEDURE clear_charges (
47 p_batch_id IN NUMBER
48 ,p_batchstep_id IN NUMBER DEFAULT NULL
49 ,x_return_status OUT NOCOPY VARCHAR2);
50
51 --Rishi Varma B3718176 14-07-2004
52 /*Added new procedure to calcualate the activity_sequence_number
53 of gme_batch_step_charges table*/
54 PROCEDURE calc_activity_sequence_number (
55 p_batchstep_id IN gme_batch_steps.batchstep_id%TYPE
56 ,p_resources IN gme_batch_step_resources.resources%TYPE
57 ,x_act_seq_num OUT NOCOPY NUMBER
58 ,x_return_status OUT NOCOPY VARCHAR2);
59
60 --Rishi Varma B3718176 22-07-2004
61 /*Added new procedure to populate the gme_batch_step_charges table.*/
62 PROCEDURE populate_charges_table (
63 p_batchstep_charges_in IN gme_batch_step_charges%ROWTYPE
64 ,p_no_of_charges IN NUMBER
65 ,p_remaining_quantity IN NUMBER
66 ,x_return_status OUT NOCOPY VARCHAR2);
67 END;