APPS.OKE_PA_MDS_RELIEF_PKG dependencies on OKE_PA_MDS_RELIEF_PKG

Line 1: PACKAGE BODY OKE_PA_MDS_RELIEF_PKG AS

1: PACKAGE BODY OKE_PA_MDS_RELIEF_PKG AS
2: /* $Header: OKEVMDSB.pls 120.0 2005/05/25 17:34:01 appldev noship $ */
3:
4: Procedure write_log ( mesg IN VARCHAR2 ) IS
5: Begin

Line 10: Procedure Get_Record (x_mds_tbl IN OUT NOCOPY oke_pa_mds_relief_pkg.mds_tbl_type) Is

6: fnd_file.put_line( fnd_file.log , mesg );
7: End write_log;
8:
9:
10: Procedure Get_Record (x_mds_tbl IN OUT NOCOPY oke_pa_mds_relief_pkg.mds_tbl_type) Is
11:
12: Cursor Oke_C Is
13:
14: Select a.transaction_id

Line 55: l_mds_tbl oke_pa_mds_relief_pkg.mds_tbl_type;

51: And m.schedule_quantity > 0
52: And a.transaction_id > nvl( m.old_transaction_id , 0 )
53: Order by a.transaction_id asc;
54:
55: l_mds_tbl oke_pa_mds_relief_pkg.mds_tbl_type;
56: l_found Boolean := False;
57: i Number := 1;
58:
59: Begin

Line 100: l_mds_tbl oke_pa_mds_relief_pkg.mds_tbl_type;

96: ( ERRBUF OUT NOCOPY VARCHAR2
97: , RETCODE OUT NOCOPY NUMBER
98: ) Is
99:
100: l_mds_tbl oke_pa_mds_relief_pkg.mds_tbl_type;
101: l_transaction_id Number;
102: l_qty Number;
103: l_qty_old Number;
104: l_schedule_date Date;

Line 244: END OKE_PA_MDS_RELIEF_PKG;

240: RETCODE := 2;
241:
242: END Mds_Relief;
243:
244: END OKE_PA_MDS_RELIEF_PKG;