eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.GMD_ERES_POST_OPERATION dependencies on GMD_STATUS

Line 22: l_pending_status gmd_status.status_code%TYPE;

18: PROCEDURE set_formula_status(p_formula_id IN NUMBER,
19: p_from_status IN VARCHAR2,
20: p_to_status IN VARCHAR2) IS
21: l_signature_status VARCHAR2(40);
22: l_pending_status gmd_status.status_code%TYPE;
23: l_rework_status gmd_status.status_code%TYPE;
24: BEGIN
25: l_signature_status := EDR_PSIG_PAGE_FLOW.signature_status;
26: GMD_ERES_UTILS.set_formula_status (p_formula_id => p_formula_id

Line 23: l_rework_status gmd_status.status_code%TYPE;

19: p_from_status IN VARCHAR2,
20: p_to_status IN VARCHAR2) IS
21: l_signature_status VARCHAR2(40);
22: l_pending_status gmd_status.status_code%TYPE;
23: l_rework_status gmd_status.status_code%TYPE;
24: BEGIN
25: l_signature_status := EDR_PSIG_PAGE_FLOW.signature_status;
26: GMD_ERES_UTILS.set_formula_status (p_formula_id => p_formula_id
27: ,p_from_status => p_from_status

Line 50: l_pending_status gmd_status.status_code%TYPE;

46: PROCEDURE set_formulation_spec_status(p_formulation_spec_id IN NUMBER,
47: p_from_status IN VARCHAR2,
48: p_to_status IN VARCHAR2) IS
49: l_signature_status VARCHAR2(40);
50: l_pending_status gmd_status.status_code%TYPE;
51: l_rework_status gmd_status.status_code%TYPE;
52: BEGIN
53: l_signature_status := EDR_PSIG_PAGE_FLOW.signature_status;
54: GMD_ERES_UTILS.set_formulation_spec_status (p_formulation_spec_id => p_formulation_spec_id

Line 51: l_rework_status gmd_status.status_code%TYPE;

47: p_from_status IN VARCHAR2,
48: p_to_status IN VARCHAR2) IS
49: l_signature_status VARCHAR2(40);
50: l_pending_status gmd_status.status_code%TYPE;
51: l_rework_status gmd_status.status_code%TYPE;
52: BEGIN
53: l_signature_status := EDR_PSIG_PAGE_FLOW.signature_status;
54: GMD_ERES_UTILS.set_formulation_spec_status (p_formulation_spec_id => p_formulation_spec_id
55: ,p_from_status => p_from_status

Line 78: l_pending_status gmd_status.status_code%TYPE;

74: PROCEDURE set_operation_status(p_oprn_id IN NUMBER,
75: p_from_status IN VARCHAR2,
76: p_to_status IN VARCHAR2) IS
77: l_signature_status VARCHAR2(40);
78: l_pending_status gmd_status.status_code%TYPE;
79: l_rework_status gmd_status.status_code%TYPE;
80: BEGIN
81: l_signature_status := EDR_PSIG_PAGE_FLOW.signature_status;
82: GMD_ERES_UTILS.set_operation_status (p_oprn_id => p_oprn_id

Line 79: l_rework_status gmd_status.status_code%TYPE;

75: p_from_status IN VARCHAR2,
76: p_to_status IN VARCHAR2) IS
77: l_signature_status VARCHAR2(40);
78: l_pending_status gmd_status.status_code%TYPE;
79: l_rework_status gmd_status.status_code%TYPE;
80: BEGIN
81: l_signature_status := EDR_PSIG_PAGE_FLOW.signature_status;
82: GMD_ERES_UTILS.set_operation_status (p_oprn_id => p_oprn_id
83: ,p_from_status => p_from_status

Line 106: l_pending_status gmd_status.status_code%TYPE;

102: PROCEDURE set_routing_status(p_routing_id IN NUMBER,
103: p_from_status IN VARCHAR2,
104: p_to_status IN VARCHAR2) IS
105: l_signature_status VARCHAR2(40);
106: l_pending_status gmd_status.status_code%TYPE;
107: l_rework_status gmd_status.status_code%TYPE;
108: BEGIN
109: l_signature_status := EDR_PSIG_PAGE_FLOW.signature_status;
110: GMD_ERES_UTILS.set_routing_status (p_routing_id => p_routing_id

Line 107: l_rework_status gmd_status.status_code%TYPE;

103: p_from_status IN VARCHAR2,
104: p_to_status IN VARCHAR2) IS
105: l_signature_status VARCHAR2(40);
106: l_pending_status gmd_status.status_code%TYPE;
107: l_rework_status gmd_status.status_code%TYPE;
108: BEGIN
109: l_signature_status := EDR_PSIG_PAGE_FLOW.signature_status;
110: GMD_ERES_UTILS.set_routing_status (p_routing_id => p_routing_id
111: ,p_from_status => p_from_status

Line 135: l_pending_status gmd_status.status_code%TYPE;

131: p_from_status IN VARCHAR2,
132: p_to_status IN VARCHAR2,
133: p_create_validity IN NUMBER) IS
134: l_signature_status VARCHAR2(40);
135: l_pending_status gmd_status.status_code%TYPE;
136: l_rework_status gmd_status.status_code%TYPE;
137: BEGIN
138: l_signature_status := EDR_PSIG_PAGE_FLOW.signature_status;
139: GMD_ERES_UTILS.set_recipe_status (p_recipe_id => p_recipe_id

Line 136: l_rework_status gmd_status.status_code%TYPE;

132: p_to_status IN VARCHAR2,
133: p_create_validity IN NUMBER) IS
134: l_signature_status VARCHAR2(40);
135: l_pending_status gmd_status.status_code%TYPE;
136: l_rework_status gmd_status.status_code%TYPE;
137: BEGIN
138: l_signature_status := EDR_PSIG_PAGE_FLOW.signature_status;
139: GMD_ERES_UTILS.set_recipe_status (p_recipe_id => p_recipe_id
140: ,p_from_status => p_from_status

Line 164: l_pending_status gmd_status.status_code%TYPE;

160: PROCEDURE set_validity_status(p_validity_rule_id IN NUMBER,
161: p_from_status IN VARCHAR2,
162: p_to_status IN VARCHAR2) IS
163: l_signature_status VARCHAR2(40);
164: l_pending_status gmd_status.status_code%TYPE;
165: l_rework_status gmd_status.status_code%TYPE;
166: BEGIN
167: l_signature_status := EDR_PSIG_PAGE_FLOW.signature_status;
168: GMD_ERES_UTILS.set_validity_status (p_validity_rule_id => p_validity_rule_id

Line 165: l_rework_status gmd_status.status_code%TYPE;

161: p_from_status IN VARCHAR2,
162: p_to_status IN VARCHAR2) IS
163: l_signature_status VARCHAR2(40);
164: l_pending_status gmd_status.status_code%TYPE;
165: l_rework_status gmd_status.status_code%TYPE;
166: BEGIN
167: l_signature_status := EDR_PSIG_PAGE_FLOW.signature_status;
168: GMD_ERES_UTILS.set_validity_status (p_validity_rule_id => p_validity_rule_id
169: ,p_from_status => p_from_status

Line 193: l_pending_status gmd_status.status_code%TYPE;

189: p_orgn_id IN NUMBER,
190: p_from_status IN VARCHAR2,
191: p_to_status IN VARCHAR2) IS
192: l_signature_status VARCHAR2(40);
193: l_pending_status gmd_status.status_code%TYPE;
194: l_rework_status gmd_status.status_code%TYPE;
195: BEGIN
196: l_signature_status := EDR_PSIG_PAGE_FLOW.signature_status;
197: GMD_ERES_UTILS.set_auto_recipe_status (p_formula_id => p_formula_id

Line 194: l_rework_status gmd_status.status_code%TYPE;

190: p_from_status IN VARCHAR2,
191: p_to_status IN VARCHAR2) IS
192: l_signature_status VARCHAR2(40);
193: l_pending_status gmd_status.status_code%TYPE;
194: l_rework_status gmd_status.status_code%TYPE;
195: BEGIN
196: l_signature_status := EDR_PSIG_PAGE_FLOW.signature_status;
197: GMD_ERES_UTILS.set_auto_recipe_status (p_formula_id => p_formula_id
198: ,p_orgn_id => p_orgn_id