[Home] [Help]
PACKAGE: APPS.CSTPPWAS
Source
1 PACKAGE CSTPPWAS AUTHID CURRENT_USER AS
2 /* $Header: CSTPWASS.pls 120.3 2005/11/29 00:39:21 skayitha noship $*/
3
4 /*----------------------------------------------------------------------------*
5 | PUBLIC VARIABLES/TYPES |
6 *----------------------------------------------------------------------------*/
7
8 /*---------------------------------------------------------------------------*
9 | PUBLIC PROCEDURE |
10 | process_nonreworkassembly_txns |
11 *----------------------------------------------------------------------------*/
12
13 PROCEDURE process_nonreworkassembly_txns(
14 p_pac_period_id IN NUMBER,
15 p_start_date IN DATE,
16 p_end_date IN DATE,
17 p_prior_period_id IN NUMBER,
18 p_item_id IN NUMBER,
19 p_cost_group_id IN NUMBER,
20 p_cost_type_id IN NUMBER,
21 p_legal_entity IN NUMBER,
22 p_cost_method IN NUMBER,
23 p_pac_rates_id IN NUMBER,
24 p_master_org_id IN NUMBER,
25 p_material_relief_algorithm IN NUMBER,
26 p_uom_control IN NUMBER,
27 p_low_level_code IN NUMBER,
28 p_user_id IN NUMBER,
29 p_login_id IN NUMBER,
30 p_request_id IN NUMBER,
31 p_prog_id IN NUMBER DEFAULT -1,
32 p_prog_app_id IN NUMBER DEFAULT -1,
33 x_err_num OUT NOCOPY NUMBER,
34 x_err_code OUT NOCOPY VARCHAR2,
35 x_err_msg OUT NOCOPY VARCHAR2);
36
37 /*---------------------------------------------------------------------------*
38 | PUBLIC PROCEDURE |
39 | process_reworkassembly_txns |
40 *----------------------------------------------------------------------------*/
41
42 PROCEDURE process_reworkassembly_txns(
43 p_pac_period_id IN NUMBER,
44 p_start_date IN DATE,
45 p_end_date IN DATE,
46 p_prior_period_id IN NUMBER,
47 p_item_id IN NUMBER,
48 p_cost_group_id IN NUMBER,
49 p_cost_type_id IN NUMBER,
50 p_legal_entity IN NUMBER,
51 p_cost_method IN NUMBER,
52 p_pac_rates_id IN NUMBER,
53 p_master_org_id IN NUMBER,
54 p_material_relief_algorithm IN NUMBER,
55 p_uom_control IN NUMBER,
56 p_low_level_code IN NUMBER,
57 p_user_id IN NUMBER,
58 p_login_id IN NUMBER,
59 p_request_id IN NUMBER,
60 p_prog_id IN NUMBER DEFAULT -1,
61 p_prog_app_id IN NUMBER DEFAULT -1,
62 x_err_num OUT NOCOPY NUMBER,
63 x_err_code OUT NOCOPY VARCHAR2,
64 x_err_msg OUT NOCOPY VARCHAR2);
65
66 /*---------------------------------------------------------------------------*
67 | PUBLIC PROCEDURE |
68 | check_expense_flags |
69 | utility procedure to return item and expense flags |
70 | |
71 *----------------------------------------------------------------------------*/
72
73 PROCEDURE check_expense_flags(
74 p_item_id IN NUMBER,
75 p_subinv IN VARCHAR2,
76 p_org_id IN NUMBER,
77 x_exp_item OUT NOCOPY NUMBER,
78 x_exp_flag OUT NOCOPY NUMBER,
79 x_err_num OUT NOCOPY NUMBER,
80 x_err_code OUT NOCOPY VARCHAR2,
81 x_err_msg OUT NOCOPY VARCHAR2);
82
83 END CSTPPWAS;
84