PACKAGE: APPS.OPIMPXWP

Source

1 PACKAGE OPIMPXWP AS
2 /*$Header: OPIMXWPS.pls 120.1 2005/06/08 18:32:28 appldev  $ */
3 
4 PROCEDURE calc_wip_balance(
5           I_ORG_ID                        IN   NUMBER,
6           I_PUSH_START_INV_TXN_DATE       IN   DATE,
7           I_PUSH_START_WIP_TXN_DATE       IN   DATE,
8           I_PUSH_LAST_INV_TXN_ID          IN   NUMBER,
9           I_PUSH_LAST_WIP_TXN_ID          IN   NUMBER,
10           I_PUSH_END_TXN_DATE             IN   DATE,
11           I_FIRST_PUSH                    IN   NUMBER,
12           O_ERR_NUM                      OUT  NOCOPY NUMBER,
13           O_ERR_CODE                     OUT  NOCOPY VARCHAR2,
14           O_ERR_MSG                      OUT  NOCOPY VARCHAR2
15          );
16 
17 PROCEDURE calc_beginning_wip(
18    i_org_id                    IN     NUMBER,
19    i_push_start_wip_txn_date   IN     DATE,
20    o_err_num                   OUT  NOCOPY  NUMBER,
21    o_err_code                  OUT  NOCOPY  VARCHAR2,
22    o_err_msg                   OUT  NOCOPY  VARCHAR2
23    );
24 
25 PROCEDURE upd_first_push_wip(
26       i_ids_key        IN  VARCHAR2,
27       i_org_id         IN  NUMBER,
28       i_item_id        IN  NUMBER,
29       i_revision       IN  VARCHAR2,
30       i_txn_date       IN  DATE,
31       i_wip_amount     IN  NUMBER,
32       i_update_flag    IN  NUMBER,    -- (1=update bal , 2=substract from bal)
33       o_err_num        OUT NOCOPY NUMBER,
34       o_err_code       OUT NOCOPY VARCHAR2,
35       o_err_msg        OUT NOCOPY VARCHAR2
36       );
37 
38 PROCEDURE update_daily_wip(
39       i_ids_key        IN  VARCHAR2,
40       i_org_id         IN  NUMBER,
41       i_item_id        IN  NUMBER,
42       i_revision       IN  VARCHAR2,
43       i_txn_date       IN  DATE,
44       i_wip_amount     IN  NUMBER,
45       o_err_num        OUT NOCOPY NUMBER,
46       o_err_code       OUT NOCOPY VARCHAR2,
47       o_err_msg        OUT NOCOPY VARCHAR2
48       );
49 
50 FUNCTION get_prev_end_bal(
51       i_ids_key        IN  VARCHAR2,
52       i_org_id         IN  NUMBER,
53       i_item_id        IN  NUMBER,
54       i_revision       IN  VARCHAR2,
55       i_txn_date       IN  DATE,
56       o_err_num        OUT NOCOPY NUMBER,
57       o_err_code       OUT NOCOPY VARCHAR2,
58       o_err_msg        OUT NOCOPY VARCHAR2
59       ) return number;
60 
61 END OPIMPXWP;