[Home] [Help]
PACKAGE: APPS.CSTPOYLD
Source
1 PACKAGE CSTPOYLD AUTHID CURRENT_USER AS
2 /* $Header: CSTOYLDS.pls 120.1 2006/08/28 05:47:25 rajagraw noship $ */
3
4 ----------------------------------------------------------------------------
5 -- PROCEDURE --
6 -- process_op_yield --
7 -- --
8 -- DESCRIPTION --
9 -- Use this procedure to calculate operation yield for lot based jobs. --
10 -- --
11 -- PURPOSE: --
12 -- Oracle Applications Rel 11i.1 --
13 -- --
14 -- PARAMETERS: --
15 -- i_entity_id : Wip entity id of lot based job --
16 -- i_run_option : 1 if it is called from standard cost --
17 -- processor and split merge cost processor --
18 -- for txn type Split or Merge --
19 -- 2 if is called from standard cost update --
20 -- 3 if it is called from split merge cost --
21 -- processor with txn type bonus and update --
22 -- quanitty. --
23 -- i_txn_op_seq_num :Operation sequence number for bonus and --
24 -- update quantity txn number. --
25 -- i_range_option : 1 if it is to run for an organization --
26 -- 2 if it is to run for a WIP entity --
27 -- --
28 -- HISTORY: --
29 -- 03/02/00 Sujit Dalai Created --
30 ----------------------------------------------------------------------------
31
32 PROCEDURE process_op_yield(ERRBUF OUT NOCOPY VARCHAR2,
33 RETCODE OUT NOCOPY VARCHAR2,
34 i_range_option NUMBER,
35 i_entity_id NUMBER,
36 i_run_option NUMBER,
37 i_txn_op_seq_num NUMBER,
38 i_organization_id NUMBER default NULL,
39 i_sm_txn_id NUMBER default NULL);
40
41 ---------------------------------------------------------------------------
42 -- FUNCTION --
43 -- transact_op_yield_var --
44 -- --
45 -- DESCRIPTION --
46 -- Use this function to calculate op yield reallocation and op yield --
47 -- variance. This function is to be called from discrete job close --
48 -- variance program cmlwjv() --
49 -- --
50 -- PURPOSE: --
51 -- Oracle Applications Rel 11i.1 --
52 -- --
53 -- PARAMETERS: --
54 -- i_group_id : Wip entity id of lot based job --
55 -- RETURNS --
56 -- 1 : Success --
57 -- 0 : Failure --
58 -- --
59 -- HISTORY: --
60 -- 03/02/00 Sujit Dalai Created --
61 ----------------------------------------------------------------------------
62 FUNCTION transact_op_yield_var( i_group_id IN NUMBER,
63 i_user_id IN NUMBER,
64 i_login_id IN NUMBER,
65 i_prg_appl_id IN NUMBER,
66 i_prg_id IN NUMBER,
67 i_req_id IN NUMBER,
68 o_err_num OUT NOCOPY NUMBER,
69 o_err_code OUT NOCOPY VARCHAR2,
70 o_err_msg OUT NOCOPY VARCHAR2)
71 return NUMBER;
72
73 ---------------------------------------------------------------------------
74 -- FUNCTION --
75 -- process_sm_op_yld --
76 -- --
77 -- DESCRIPTION --
78 -- Use this function to calculate op yield for jobs involved in split --
79 -- merge transaction. --
80 -- --
81 -- PURPOSE: --
82 -- Oracle Applications Rel 11i.1 --
83 -- --
84 -- PARAMETERS: --
85 -- i_txn_id : split merge txn id --
86 -- RETURNS --
87 -- 1 : Success --
88 -- 0 : Failure --
89 -- --
90 -- HISTORY: --
91 -- 02/12/00 Sujit Dalai Created --
92 ----------------------------------------------------------------------------
93 FUNCTION process_sm_op_yld ( i_txn_id IN NUMBER,
94 i_user_id IN NUMBER,
95 i_login_id IN NUMBER,
96 i_prg_appl_id IN NUMBER,
97 i_prg_id IN NUMBER,
98 i_req_id IN NUMBER,
99 o_err_num OUT NOCOPY NUMBER,
100 o_err_code OUT NOCOPY VARCHAR2,
101 o_err_msg OUT NOCOPY VARCHAR2)
102
103 return NUMBER;
104
105 -----------------------------------------------------------------------------
106 -- FUNCTION
107 -- cost_update_adjustment
108 --
109 -- DESCRIPTION
110 -- This function is used by the standard cost update program, to adjust the
111 -- operation cost by the change in unit costs due to cost update
112 --
113 -- PURPOSE:
114 -- Oracle Applications Rel 11i.1, to support WIP ShopFloor Management
115 --
116 -- PARAMETERS:
117 -- i_org_id : Organization ID
118 -- i_update_id : Cost Update ID
119 -- RETURNS
120 -- 1 : Success
121 -- 2 : Failure
122
123 --
124 -- HISTORY
125 -- 03/03/2000 Anitha Balasubramanian Creation
126 ------------------------------------------------------------------------------
127 Function cost_update_adjustment (i_org_id NUMBER,
128 i_update_id NUMBER,
129 i_user_id IN NUMBER,
130 i_login_id IN NUMBER,
131 i_prg_appl_id IN NUMBER,
132 i_prg_id IN NUMBER,
133 i_req_id IN NUMBER,
134 o_err_num OUT NOCOPY NUMBER,
135 o_err_code OUT NOCOPY VARCHAR2,
136 o_err_msg OUT NOCOPY VARCHAR2)
137 return NUMBER;
138 end CSTPOYLD;