1 PACKAGE CSTPOYUT AUTHID CURRENT_USER AS
2 /* $Header: CSTOYUTS.pls 115.3 2002/11/08 23:23:26 awwang ship $ */
3
4 ----------------------------------------------------------------------------
5 -- FUNCTION --
6 -- update_mat_cost --
7 -- --
8 -- DESCRIPTION --
9 -- Use this function to update operation cost in WIP_OPERATION_YIELDS --
10 -- from material cost manager. --
11 -- PURPOSE: --
12 -- Oracle Applications Rel 11i.1 --
13 -- --
14 -- PARAMETERS: --
15 -- i_cost_type_id : Cost Type id --
16 -- i_txn_id : Material Transaction Id --
17 -- i_org_id : Organization Id --
18 -- i_op_seq_num : Operation Sequence Number --
19 -- i_item_id : Inventory Item id --
20 -- i_txn_qty : Transaction quanity --
21 -- i_entity_id : WIP Entity Id --
22 -- i_entity_type : WIP Entity Type --
23 -- --
24 -- HISTORY: --
25 -- 03/02/00 Sujit Dalai Created --
26 ----------------------------------------------------------------------------
27
28 Function update_mat_cost (i_cost_type_id IN NUMBER,
29 i_txn_id IN NUMBER,
30 i_org_id IN NUMBER,
31 i_op_seq_num IN NUMBER,
32 i_item_id IN NUMBER,
33 i_txn_qty IN NUMBER,
34 i_entity_id IN NUMBER,
35 i_entity_type IN NUMBER,
36 i_user_id IN NUMBER,
37 i_login_id IN NUMBER,
38 i_prg_appl_id IN NUMBER,
39 i_prg_id IN NUMBER,
40 i_req_id IN NUMBER)
41 RETURN Number;
42
43 ---------------------------------------------------------------------------
44 -- FUNCTION --
45 -- update_wip_cost --
46 -- --
47 -- DESCRIPTION --
48 -- Use this function to update operation cost in WIP_OPERATION_YIELDS --
49 -- from WIP cost manager. --
50 -- --
51 -- PURPOSE: --
52 -- Oracle Applications Rel 11i.1 --
53 -- --
54 -- PARAMETERS: --
55 -- i_group_id : group_id --
56 -- RETURNS --
57 -- 1 : Success --
58 -- 0 : Failure --
59 -- --
60 -- HISTORY: --
61 -- 03/02/00 Sujit Dalai Created --
62 ----------------------------------------------------------------------------
63 Function update_wip_cost (i_group_id IN NUMBER,
64 i_user_id IN NUMBER,
65 i_login_id IN NUMBER,
66 i_prg_appl_id IN NUMBER,
67 i_prg_id IN NUMBER,
68 i_req_id IN NUMBER,
69 o_err_msg OUT NOCOPY VARCHAR2)
70 return Number;
71
72 ---------------------------------------------------------------------------
73 -- FUNCTION --
74 -- update_woy_status --
75 -- --
76 -- DESCRIPTION --
77 -- Use this function to update status of WIP_OPERATION_YIELDS when --
78 -- scrap transaction takes place. --
79 -- --
80 -- PURPOSE: --
81 -- Oracle Applications Rel 11i.1 --
82 -- --
83 -- PARAMETERS: --
84 -- i_org_id : Organization Id --
85 -- i_wip_entity_id : WIP Entity Id --
86 -- i_op_seq_num : Operation Sequence Number --
87 -- RETURNS --
88 -- 1 : Success --
89 -- 0 : Failure --
90 -- --
91 -- HISTORY: --
92 -- 02/12/00 Sujit Dalai Created --
93 ----------------------------------------------------------------------------
94 Function update_woy_status (i_org_id NUMBER,
95 i_wip_entity_id NUMBER,
96 i_op_seq_num NUMBER,
97 i_user_id IN NUMBER,
98 i_login_id IN NUMBER,
99 i_prg_appl_id IN NUMBER,
100 i_prg_id IN NUMBER,
101 i_req_id IN NUMBER,
102 o_err_num OUT NOCOPY NUMBER,
103 o_err_code OUT NOCOPY VARCHAR2,
104 o_err_msg OUT NOCOPY VARCHAR2)
105 return NUMBER;
106
107
108 end CSTPOYUT;
|
|
|