[Home] [Help]
PACKAGE: APPS.CSTPPWRO
Source
1 PACKAGE CSTPPWRO AUTHID CURRENT_USER AS
2 /* $Header: CSTPWROS.pls 120.1 2010/02/26 14:00:56 lchevala ship $*/
3
4 /*----------------------------------------------------------------------------*
5 | PUBLIC VARIABLES/TYPES |
6 *----------------------------------------------------------------------------*/
7 /*---------------------------------------------------------------------------*
8 | PUBLIC PROCEDURE |
9 | check_pacwip_bal_record |
10 *----------------------------------------------------------------------------*/
11 PROCEDURE check_pacwip_bal_record (
12 p_pac_period_id IN NUMBER,
13 p_cost_group_id IN NUMBER,
14 p_cost_type_id IN NUMBER,
15 p_org_id IN NUMBER,
16 p_entity_id IN NUMBER,
17 p_entity_type IN NUMBER,
18 p_line_id IN NUMBER DEFAULT NULL,
19 p_op_seq IN NUMBER,
20 p_user_id IN NUMBER,
21 p_request_id IN NUMBER,
22 p_prog_app_id IN NUMBER DEFAULT -1,
23 p_prog_id IN NUMBER DEFAULT -1,
24 p_login_id IN NUMBER DEFAULT -1,
25 x_err_num OUT NOCOPY NUMBER,
26 x_err_code OUT NOCOPY VARCHAR2,
27 x_err_msg OUT NOCOPY VARCHAR2
28 );
29
30
31 /*---------------------------------------------------------------------------*
32 | PUBLIC PROCEDURE |
33 | get_adj_operations |
34 *----------------------------------------------------------------------------*/
35
36 PROCEDURE get_adj_operations (
37 p_entity_id IN NUMBER,
38 p_line_id IN NUMBER DEFAULT NULL,
39 p_rep_sched_id IN NUMBER DEFAULT NULL,
40 p_op_seq IN NUMBER,
41 x_prev_op OUT NOCOPY NUMBER,
42 x_next_op OUT NOCOPY NUMBER,
43 x_err_num OUT NOCOPY NUMBER,
44 x_err_code OUT NOCOPY VARCHAR2,
45 x_err_msg OUT NOCOPY VARCHAR2);
46
47 /*---------------------------------------------------------------------------*
48 | PUBLIC PROCEDURE |
49 | build_wip_operation_qty |
50 *----------------------------------------------------------------------------*/
51
52 PROCEDURE build_wip_operation_qty(
53 p_pac_period_id IN NUMBER,
54 p_start_date IN DATE,
55 p_end_date IN DATE,
56 p_cost_group_id IN NUMBER,
57 p_cost_type_id IN NUMBER,
58 p_entity_id IN NUMBER,
59 p_entity_type IN NUMBER,
60 p_user_id IN NUMBER,
61 p_login_id IN NUMBER,
62 p_request_id IN NUMBER,
63 p_prog_id IN NUMBER DEFAULT -1,
64 p_prog_app_id IN NUMBER DEFAULT -1,
65 x_err_num OUT NOCOPY NUMBER,
66 x_err_code OUT NOCOPY VARCHAR2,
67 x_err_msg OUT NOCOPY VARCHAR2);
68
69 /*---------------------------------------------------------------------------*
70 | PUBLIC PROCEDURE |
71 | process_wip_resovhd_txns |
72 *----------------------------------------------------------------------------*/
73
74 PROCEDURE process_wip_resovhd_txns(
75 p_pac_period_id IN NUMBER,
76 p_start_date IN DATE,
77 p_end_date IN DATE,
78 p_cost_group_id IN NUMBER,
79 p_cost_type_id IN NUMBER,
80 p_item_id IN NUMBER DEFAULT NULL,
81 p_pac_ct_id IN NUMBER,
82 p_user_id IN NUMBER,
83 p_login_id IN NUMBER,
84 p_request_id IN NUMBER,
85 p_prog_id IN NUMBER,
86 p_prog_app_id IN NUMBER,
87 x_err_num OUT NOCOPY NUMBER,
88 x_err_code OUT NOCOPY VARCHAR2,
89 x_err_msg OUT NOCOPY VARCHAR2);
90
91 /*---------------------------------------------------------------------------*
92 | BUG 9342058 |
93 | PUBLIC PROCEDURE |
94 | process_unrelieved_scrap_qty |
95 *----------------------------------------------------------------------------*/
96 PROCEDURE process_unrelieved_scrap_qty (
97 p_pac_period_id IN NUMBER,
98 p_start_date IN DATE,
99 p_end_date IN DATE,
100 p_cost_group_id IN NUMBER,
101 p_cost_type_id IN NUMBER,
102 x_err_num OUT NOCOPY NUMBER,
103 x_err_code OUT NOCOPY VARCHAR2,
104 x_err_msg OUT NOCOPY VARCHAR2);
105
106 END CSTPPWRO;