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_SUBSTITUTION_PUB dependencies on GMD_FORMULA_SUBSTITUTION

Line 83: FORMULA_ID gmd_formula_substitution.formula_id%TYPE

79: );
80:
81: TYPE gmd_fmsubstitution_rec_type IS RECORD
82: (
83: FORMULA_ID gmd_formula_substitution.formula_id%TYPE
84: , FORMULA_NO fm_form_mst_b.formula_no%TYPE
85: , FORMULA_VERS fm_form_mst_b.formula_vers%TYPE
86: , CREATION_DATE gmd_formula_substitution.creation_date%TYPE
87: , CREATED_BY gmd_formula_substitution.created_by%TYPE

Line 86: , CREATION_DATE gmd_formula_substitution.creation_date%TYPE

82: (
83: FORMULA_ID gmd_formula_substitution.formula_id%TYPE
84: , FORMULA_NO fm_form_mst_b.formula_no%TYPE
85: , FORMULA_VERS fm_form_mst_b.formula_vers%TYPE
86: , CREATION_DATE gmd_formula_substitution.creation_date%TYPE
87: , CREATED_BY gmd_formula_substitution.created_by%TYPE
88: , LAST_UPDATE_DATE gmd_formula_substitution.last_update_date%TYPE
89: , LAST_UPDATED_BY gmd_formula_substitution.last_updated_by%TYPE
90: , LAST_UPDATE_LOGIN gmd_formula_substitution.last_update_login%TYPE

Line 87: , CREATED_BY gmd_formula_substitution.created_by%TYPE

83: FORMULA_ID gmd_formula_substitution.formula_id%TYPE
84: , FORMULA_NO fm_form_mst_b.formula_no%TYPE
85: , FORMULA_VERS fm_form_mst_b.formula_vers%TYPE
86: , CREATION_DATE gmd_formula_substitution.creation_date%TYPE
87: , CREATED_BY gmd_formula_substitution.created_by%TYPE
88: , LAST_UPDATE_DATE gmd_formula_substitution.last_update_date%TYPE
89: , LAST_UPDATED_BY gmd_formula_substitution.last_updated_by%TYPE
90: , LAST_UPDATE_LOGIN gmd_formula_substitution.last_update_login%TYPE
91: );

Line 88: , LAST_UPDATE_DATE gmd_formula_substitution.last_update_date%TYPE

84: , FORMULA_NO fm_form_mst_b.formula_no%TYPE
85: , FORMULA_VERS fm_form_mst_b.formula_vers%TYPE
86: , CREATION_DATE gmd_formula_substitution.creation_date%TYPE
87: , CREATED_BY gmd_formula_substitution.created_by%TYPE
88: , LAST_UPDATE_DATE gmd_formula_substitution.last_update_date%TYPE
89: , LAST_UPDATED_BY gmd_formula_substitution.last_updated_by%TYPE
90: , LAST_UPDATE_LOGIN gmd_formula_substitution.last_update_login%TYPE
91: );
92:

Line 89: , LAST_UPDATED_BY gmd_formula_substitution.last_updated_by%TYPE

85: , FORMULA_VERS fm_form_mst_b.formula_vers%TYPE
86: , CREATION_DATE gmd_formula_substitution.creation_date%TYPE
87: , CREATED_BY gmd_formula_substitution.created_by%TYPE
88: , LAST_UPDATE_DATE gmd_formula_substitution.last_update_date%TYPE
89: , LAST_UPDATED_BY gmd_formula_substitution.last_updated_by%TYPE
90: , LAST_UPDATE_LOGIN gmd_formula_substitution.last_update_login%TYPE
91: );
92:
93: TYPE gmd_formula_substitution_tab IS TABLE OF gmd_fmsubstitution_rec_type

Line 90: , LAST_UPDATE_LOGIN gmd_formula_substitution.last_update_login%TYPE

86: , CREATION_DATE gmd_formula_substitution.creation_date%TYPE
87: , CREATED_BY gmd_formula_substitution.created_by%TYPE
88: , LAST_UPDATE_DATE gmd_formula_substitution.last_update_date%TYPE
89: , LAST_UPDATED_BY gmd_formula_substitution.last_updated_by%TYPE
90: , LAST_UPDATE_LOGIN gmd_formula_substitution.last_update_login%TYPE
91: );
92:
93: TYPE gmd_formula_substitution_tab IS TABLE OF gmd_fmsubstitution_rec_type
94: INDEX BY BINARY_INTEGER;

Line 93: TYPE gmd_formula_substitution_tab IS TABLE OF gmd_fmsubstitution_rec_type

89: , LAST_UPDATED_BY gmd_formula_substitution.last_updated_by%TYPE
90: , LAST_UPDATE_LOGIN gmd_formula_substitution.last_update_login%TYPE
91: );
92:
93: TYPE gmd_formula_substitution_tab IS TABLE OF gmd_fmsubstitution_rec_type
94: INDEX BY BINARY_INTEGER;
95:
96: -- Creation of substitution header, detail and formula association
97: PROCEDURE Create_substitution

Line 104: , p_formula_substitution_tbl IN gmd_formula_substitution_tab

100: , p_init_msg_list IN VARCHAR2
101: , p_commit IN VARCHAR2
102: , p_substitution_hdr_rec IN gmd_substitution_hdr_rec_type
103: , p_substitution_dtl_rec IN gmd_substitution_dtl_rec_type
104: , p_formula_substitution_tbl IN gmd_formula_substitution_tab
105: , x_message_count OUT NOCOPY NUMBER
106: , x_message_list OUT NOCOPY VARCHAR2
107: , x_return_status OUT NOCOPY VARCHAR2
108: );

Line 119: , p_formula_substitution_tbl IN gmd_formula_substitution_tab

115: , p_commit IN VARCHAR2
116: , p_substitution_id IN NUMBER Default NULL
117: , p_substitution_name IN VARCHAR2 Default NULL
118: , p_substitution_version IN NUMBER Default NULL
119: , p_formula_substitution_tbl IN gmd_formula_substitution_tab
120: , x_message_count OUT NOCOPY NUMBER
121: , x_message_list OUT NOCOPY VARCHAR2
122: , x_return_status OUT NOCOPY VARCHAR2
123: );