PACKAGE: APPS.MRP_PO_RESCHEDULE

Source

1 PACKAGE MRP_PO_RESCHEDULE AUTHID CURRENT_USER AS
2 /* $Header: MRPPORES.pls 120.6.12020000.3 2012/09/04 06:54:22 neelredd 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;