[Home] [Help]
PACKAGE: APPS.GMD_PARAMETERS_DTL_PKG
Source
1 PACKAGE GMD_PARAMETERS_DTL_PKG AS
2 /* $Header: GMDPRMDS.pls 120.6.12000000.2 2007/02/09 12:43:55 kmotupal ship $ */
3
4 /*======================================================================
5 -- PROCEDURE :
6 -- INSERT_ROW
7 --
8 -- DESCRIPTION:
9 -- This particular procedure is used to insert rows in detail table
10 --
11 -- HISTORY
12 -- Sriram.S 05-NOV-2004 Created
13 --===================================================================== */
14
15 PROCEDURE INSERT_ROW (
16 X_ROWID OUT NOCOPY VARCHAR2,
17 X_PARAMETER_LINE_ID IN NUMBER,
18 X_PARAMETER_ID IN NUMBER,
19 X_PARM_TYPE IN NUMBER,
20 X_PARAMETER_NAME IN VARCHAR2,
21 X_PARAMETER_VALUE IN VARCHAR2,
22 X_CREATION_DATE IN DATE,
23 X_CREATED_BY IN NUMBER,
24 X_LAST_UPDATE_DATE IN DATE,
25 X_LAST_UPDATED_BY IN NUMBER,
26 X_LAST_UPDATE_LOGIN IN NUMBER);
27
28 /*======================================================================
29 -- PROCEDURE :
30 -- LOCK_ROW
31 --
32 -- DESCRIPTION:
33 -- This particular procedure is used to lock rows in detail table
34 --
35 -- HISTORY
36 -- Sriram.S 05-NOV-2004 Created
37 --===================================================================== */
38
39 PROCEDURE LOCK_ROW (
40 X_PARAMETER_LINE_ID IN NUMBER,
41 X_PARAMETER_ID IN NUMBER,
42 X_PARM_TYPE IN NUMBER,
43 X_PARAMETER_NAME IN VARCHAR2,
44 X_PARAMETER_VALUE IN VARCHAR2,
45 X_LOOKUP_TYPE IN VARCHAR2
46 );
47
48 /*======================================================================
49 -- PROCEDURE :
50 -- UPDATE_ROW
51 --
52 -- DESCRIPTION:
53 -- This particular procedure is used to update rows in detail table
54 --
55 -- HISTORY
56 -- Sriram.S 05-NOV-2004 Created
57 --===================================================================== */
58
59 PROCEDURE UPDATE_ROW (
60 X_PARAMETER_LINE_ID IN NUMBER,
61 X_PARAMETER_ID IN NUMBER,
62 X_PARM_TYPE IN NUMBER,
63 X_PARAMETER_NAME IN VARCHAR2,
64 X_PARAMETER_VALUE IN VARCHAR2,
65 X_LAST_UPDATE_DATE IN DATE,
66 X_LAST_UPDATED_BY IN NUMBER,
67 X_LAST_UPDATE_LOGIN IN NUMBER
68 );
69
70 /*======================================================================
71 -- PROCEDURE :
72 -- DELETE_ROW
73 --
74 -- DESCRIPTION:
75 -- This particular procedureis used to delete rows in detail table
76 --
77 -- HISTORY
78 -- Sriram.S 05-NOV-2004 Created
79 --===================================================================== */
80
81 PROCEDURE DELETE_ROW (
82 X_PARAMETER_LINE_ID IN NUMBER
83 );
84
85
86 -- Declare this type record to use as one parameter in fetch procedure
87 TYPE parameter_rec_type IS RECORD
88 (
89 plant_ind gmd_parameters_hdr.plant_ind%TYPE,
90 lab_ind gmd_parameters_hdr.lab_ind%TYPE,
91 gmd_formula_version_control gmd_parameters_dtl.parameter_value%TYPE,
92 gmd_byproduct_active gmd_parameters_dtl.parameter_value%TYPE,
93 gmd_zero_ingredient_qty gmd_parameters_dtl.parameter_value%TYPE,
94 gmd_mass_um_type gmd_parameters_dtl.parameter_value%TYPE,
95 gmd_volume_um_type gmd_parameters_dtl.parameter_value%TYPE,
96 fm_yield_type gmd_parameters_dtl.parameter_value%TYPE,
97 gmd_default_form_status gmd_parameters_dtl.parameter_value%TYPE,
98 gmi_lotgene_enable_fmsec gmd_parameters_dtl.parameter_value%TYPE,
99 gmd_default_release_type gmd_parameters_dtl.parameter_value%TYPE,
100 gmd_operation_version_control gmd_parameters_dtl.parameter_value%TYPE,
101 gmd_default_oprn_status gmd_parameters_dtl.parameter_value%TYPE,
102 gmd_routing_version_control gmd_parameters_dtl.parameter_value%TYPE,
103 gmd_default_rout_status gmd_parameters_dtl.parameter_value%TYPE,
104 steprelease_type gmd_parameters_dtl.parameter_value%TYPE,
105 gmd_enforce_step_dependency gmd_parameters_dtl.parameter_value%TYPE,
106 gmd_recipe_version_control gmd_parameters_dtl.parameter_value%TYPE,
107 gmd_proc_instr_paragraph gmd_parameters_dtl.parameter_value%TYPE,
108 gmd_default_recp_status gmd_parameters_dtl.parameter_value%TYPE,
109 gmd_default_valr_status gmd_parameters_dtl.parameter_value%TYPE,
110 gmd_default_spec_status gmd_parameters_dtl.parameter_value%TYPE,
111 gmd_cost_source_orgn gmd_parameters_dtl.parameter_value%TYPE,
112 gmd_default_sub_status gmd_parameters_dtl.parameter_value%TYPE,
113 gmd_sub_version_control gmd_parameters_dtl.parameter_value%TYPE,
114 gmd_recipe_type gmd_parameters_dtl.parameter_value%TYPE,
115 fm$default_release_type gmd_parameters_dtl.parameter_value%TYPE,
116 -- Kapil ME Auto-prod :Bug# 5716318
117 gmd_auto_prod_calc gmd_parameters_dtl.parameter_value%TYPE );
118
119 TYPE out_parm_table IS TABLE OF GMD_PARAMETERS_DTL%ROWTYPE INDEX BY BINARY_INTEGER;
120
121 PROCEDURE GET_PARAMETER_LIST(pOrgn_id IN NUMBER,
122 V_block IN VARCHAR2,
123 Xparm_table IN OUT NOCOPY out_parm_table);
124
125
126 END GMD_PARAMETERS_DTL_PKG;
127