DBA Data[Home] [Help]

PACKAGE: APPS.OPIMPDAT

Source


1 PACKAGE OPIMPDAT AS
2 /*$Header: OPIMDATS.pls 120.1 2005/06/10 17:31:28 appldev  $ */
3 
4 procedure get_push_dates(
5    I_ORG_ID                  IN    NUMBER,
6    I_FROM_DATE               IN    DATE,
7    I_TO_DATE                 IN    DATE,
8    I_LAST_PUSH_MIN_DATE      IN    DATE,
9    O_PUSH_START_INV_TXN_DATE OUT NOCOPY  DATE,
10    O_PUSH_START_WIP_TXN_DATE OUT NOCOPY  DATE,
11    O_PUSH_LAST_INV_TXN_ID    OUT NOCOPY  NUMBER,
12    O_PUSH_LAST_WIP_TXN_ID    OUT NOCOPY  NUMBER,
13    O_PUSH_LAST_INV_TXN_DATE  OUT NOCOPY  DATE,
14    O_PUSH_LAST_WIP_TXN_DATE  OUT NOCOPY  DATE,
15    O_PUSH_END_TXN_DATE       OUT NOCOPY  DATE,
16    O_FIRST_PUSH              OUT NOCOPY  NUMBER,
17    O_ERR_NUM                 OUT NOCOPY  NUMBER,
18    O_ERR_CODE                OUT NOCOPY  VARCHAR2,
19    O_ERR_MSG                 OUT NOCOPY  VARCHAR2,
20    O_TXN_FLAG                OUT NOCOPY  NUMBER
21 );
22 
23 procedure calc_from_date(
24    i_org_id                 IN   NUMBER,
25    i_from_date              IN   DATE,
26    i_txn_date               IN   DATE,
27    i_first_push             IN   NUMBER,
28    o_calc_from_date         OUT NOCOPY DATE,
29    o_err_num                OUT NOCOPY NUMBER,
30    o_err_code               OUT NOCOPY VARCHAR2,
31    o_err_msg                OUT NOCOPY VARCHAR2
32 );
33 
34 END OPIMPDAT;