[Home] [Help]
PACKAGE: APPS.CST_PRJMFG_COST_COLLECTOR
Source
1 PACKAGE CST_PRJMFG_COST_COLLECTOR AUTHID CURRENT_USER as
2 /* $Header: CSTPPCCS.pls 120.5 2010/09/01 05:55:37 ipineda ship $*/
3 /*----------------------------------------------------------------------------*
4 | PUBLIC VARIABLES/TYPES |
5 *----------------------------------------------------------------------------*/
6
7 /*----------------------------------------------------------------------------*
8 | PUBLIC FUNCTIONS/PROCEDURES |
9 *----------------------------------------------------------------------------*/
10
11 /*----------------------------------------------------------------------------*
12 | PUBLIC PROCEDURE |
13 | pm_mark_non_project_world_txns |
14 | |
15 | DESCRIPTION |
16 | |
17 | This procedure would mark all non-project world transactions as Cost |
18 | Collected for the Given Organization and Upto the Given Date. |
19 | |
20 | If user desires,this procedure could be invoked by the user independent |
21 | of the execution of the Cost Collector. This could be in order to get |
22 | done with the pre-processing needs much prior to the scheduled Cost | | Collector Execution. |
23 | |
24 | PARAMETERS |
25 | Organization_Id, UpToDate |
26 | |
27 | HISTORY |
28 | 07-SEP-96 Bhaskar Dasari Created. |
29 *----------------------------------------------------------------------------*/
30 PROCEDURE pm_mark_non_project_world_txns (
31 p_Org_Id NUMBER,
32 p_prior_days NUMBER,
33 p_user_id NUMBER,
34 p_login_id NUMBER,
35 p_req_id NUMBER,
36 p_prg_appl_id NUMBER,
37 p_prg_id NUMBER,
38 O_err_num OUT NOCOPY NUMBER,
39 O_err_code OUT NOCOPY VARCHAR2,
40 O_err_msg OUT NOCOPY VARCHAR2
41 );
42
43 PROCEDURE pm_cc_worker_mmt ( p_transaction_id NUMBER,
44 p_Org_Id NUMBER,
45 p_std_cg_acct NUMBER, -- Added for bug 3495967
46 p_inv_txn_source_literal VARCHAR2,
47 p_cap_txn_source_literal VARCHAR2,
48 p_inv_syslink_literal VARCHAR2,
49 p_bur_syslink_literal VARCHAR2,
50 p_wip_syslink_literal VARCHAR2,
51 p_denom_currency_code VARCHAR2,
52 p_user_def_exp_type NUMBER,
53 p_user_id NUMBER,
54 p_login_id NUMBER,
55 p_req_id NUMBER,
56 p_prg_appl_id NUMBER,
57 p_prg_id NUMBER,
58 O_err_num OUT NOCOPY NUMBER,
59 O_err_code OUT NOCOPY VARCHAR2,
60 O_err_msg OUT NOCOPY VARCHAR2);
61
62 PROCEDURE pm_cc_worker_wt ( p_transaction_id NUMBER,
63 p_Org_Id NUMBER,
64 p_wip_txn_source_literal VARCHAR2,
65 p_wip_straight_time_literal VARCHAR2,
66 p_wip_syslink_literal VARCHAR2,
67 p_bur_syslink_literal VARCHAR2,
68 p_denom_currency_code VARCHAR2,
69 p_user_id NUMBER,
70 p_login_id NUMBER,
71 p_req_id NUMBER,
72 p_prg_appl_id NUMBER,
73 p_prg_id NUMBER,
74 O_err_num OUT NOCOPY NUMBER,
75 O_err_code OUT NOCOPY VARCHAR2,
76 O_err_msg OUT NOCOPY VARCHAR2);
77
78 PROCEDURE assign_groups_to_mmt_txns ( p_Org_Id NUMBER,
79 p_prior_days NUMBER,
80 p_user_spec_group_size NUMBER,
81 p_rows_processed OUT NOCOPY NUMBER,
82 p_group_id OUT NOCOPY NUMBER,
83 p_user_id NUMBER,
84 p_login_id NUMBER,
85 p_req_id NUMBER,
86 p_prg_appl_id NUMBER,
87 p_prg_id NUMBER,
88 p_proj_misc_txn_only NUMBER,
89 O_err_num OUT NOCOPY NUMBER,
90 O_err_code OUT NOCOPY VARCHAR2,
91 O_err_msg OUT NOCOPY VARCHAR2);
92
93 PROCEDURE assign_groups_to_wt_txns ( p_Org_Id NUMBER,
94 p_prior_days NUMBER,
95 p_user_spec_group_size NUMBER,
96 p_rows_processed OUT NOCOPY NUMBER,
97 p_group_id OUT NOCOPY NUMBER,
98 p_user_id NUMBER,
99 p_login_id NUMBER,
100 p_req_id NUMBER,
101 p_prg_appl_id NUMBER,
102 p_prg_id NUMBER,
103 O_err_num OUT NOCOPY NUMBER,
104 O_err_code OUT NOCOPY VARCHAR2,
105 O_err_msg OUT NOCOPY VARCHAR2);
106
107 PROCEDURE pm_get_mta_accts ( p_transaction_id NUMBER,
108 p_cost_element_id NUMBER,
109 p_resource_id NUMBER DEFAULT NULL,
110 p_source_flag NUMBER DEFAULT -1,
111 p_variance_flag NUMBER DEFAULT -1,
112 O_dr_code_combination_id IN OUT NOCOPY NUMBER,
113 O_cr_code_combination_id IN OUT NOCOPY NUMBER,
114 O_inv_cr_sub_ledger_id OUT NOCOPY NUMBER,
115 O_inv_dr_sub_ledger_id OUT NOCOPY NUMBER,
116 O_cc_rate OUT NOCOPY NUMBER,
117 O_cc_type OUT NOCOPY VARCHAR2,
118 O_cc_date OUT NOCOPY DATE,
119 O_cc_foreign_currency OUT NOCOPY VARCHAR2,
120 O_cc_functional_currency OUT NOCOPY VARCHAR2,
121 O_err_num OUT NOCOPY NUMBER,
122 O_err_code OUT NOCOPY VARCHAR2,
123 O_err_msg OUT NOCOPY VARCHAR2);
124
125
126 FUNCTION get_group_size RETURN NUMBER;
127
128 /*----------------------------------------------------------------------------*
129 | PUBLIC PROCEDURE |
130 | get_last_cost_collection_date( Organization_Code ) |
131 *----------------------------------------------------------------------------*/
132
133 /*----------------------------------------------------------------------------*
134 | PUBLIC PROCEDURE |
135 | reset_error_transaction |
136 *----------------------------------------------------------------------------*/
137
138 END CST_PRJMFG_COST_COLLECTOR;