[Home] [Help]
PACKAGE: APPS.MRP_PO_RESCHEDULE
Source
1 PACKAGE MRP_PO_RESCHEDULE AS
2 /* $Header: MRPPORES.pls 120.4.12010000.3 2008/10/17 12:12:30 lsindhur ship $ */
3
4 PROCEDURE log_message( p_user_info IN VARCHAR2);
5 PROCEDURE debug_message( p_user_info IN VARCHAR2);
6 PROCEDURE debug_number_tbl( p_msg IN VARCHAR2, p_tbl IN po_tbl_number );
7 PROCEDURE debug_date_tbl( p_msg IN VARCHAR2, p_tbl IN po_tbl_date );
8 PROCEDURE debug_varchar30_tbl( p_msg IN VARCHAR2, p_tbl IN po_tbl_varchar30 );
9
10 PROCEDURE transfer_to_temp_table (
11 p_dblink IN VARCHAR2,
12 p_instance_id IN NUMBER,
13 p_batch_id IN NUMBER
14 );
15
16 PROCEDURE init( p_batch_id IN NUMBER , p_instance_id IN NUMBER , p_instance_code IN varchar2 , p_dblink IN varchar2);
17 PROCEDURE init_instance(p_user_name IN VARCHAR2,
18 p_resp_name IN VARCHAR2);
19 PROCEDURE cleanup_destination( p_batch_id IN NUMBER,
20 p_dblink IN VARCHAR2 );
21
22 FUNCTION same_record(idx1 NUMBER, idx2 NUMBER) RETURN BOOLEAN;
23
24 FUNCTION get_next_record (
25 x_po_header_id OUT nocopy NUMBER,
26 x_po_number OUT nocopy VARCHAR2,
27 x_operating_unit OUT nocopy NUMBER,
28 x_po_line_ids OUT nocopy po_tbl_number,
29 x_line_location_ids OUT nocopy po_tbl_number,
30 x_distribution_ids OUT nocopy po_tbl_number,
31 x_qtys OUT nocopy po_tbl_number,
32 x_promise_dates OUT nocopy po_tbl_date,
33 x_uoms OUT nocopy po_tbl_varchar30
34 ) RETURN BOOLEAN;
35
36 PROCEDURE change_operating_unit( p_org_id NUMBER );
37
38 PROCEDURE msc_resched_po(
39 errbuf OUT NOCOPY VARCHAR2,
40 retcode OUT NOCOPY VARCHAR2,
41 p_batch_id IN NUMBER,
42 p_instance_id IN NUMBER,
43 p_instance_code IN varchar2,
44 p_dblink IN varchar2
45 );
46
47 PROCEDURE launch_reschedule_po(
48 p_user_name IN VARCHAR2,
49 p_resp_name IN VARCHAR2,
50 p_batch_id IN NUMBER,
51 p_instance_id IN NUMBER,
52 p_instance_code IN varchar2,
53 p_dblink IN varchar2,
54 x_req_id OUT NOCOPY NUMBER
55 );
56
57
58 END mrp_po_reschedule;