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.JAI_CMN_RGM_SETUP_PKG dependencies on JAI_RGM_DOC_SEQ_DTLS

Line 63: p_doc_class jai_rgm_doc_seq_dtls.document_class%Type ,

59: p_regime_id JAI_RGM_DEFINITIONS.regime_id%Type,
60: p_organization_id hr_all_organization_units.organization_id%Type,
61: p_location_id hr_locations.location_id%Type,
62: p_DATE DATE,
63: p_doc_class jai_rgm_doc_seq_dtls.document_class%Type ,
64: p_doc_type_id jai_rgm_doc_seq_dtls.document_class_type_id%Type,
65: p_invoice_number OUT NOCOPY VARCHAR2, /* caller should call with parameter of size VARCHAR2(100)*/
66: p_process_flag OUT NOCOPY VARCHAR2, /* caller should call with parameter of size VARCHAR2(2)*/
67: p_process_msg OUT NOCOPY VARCHAR2) /* caller should call with parameter of size VARCHAR2(1100) atleast*/

Line 64: p_doc_type_id jai_rgm_doc_seq_dtls.document_class_type_id%Type,

60: p_organization_id hr_all_organization_units.organization_id%Type,
61: p_location_id hr_locations.location_id%Type,
62: p_DATE DATE,
63: p_doc_class jai_rgm_doc_seq_dtls.document_class%Type ,
64: p_doc_type_id jai_rgm_doc_seq_dtls.document_class_type_id%Type,
65: p_invoice_number OUT NOCOPY VARCHAR2, /* caller should call with parameter of size VARCHAR2(100)*/
66: p_process_flag OUT NOCOPY VARCHAR2, /* caller should call with parameter of size VARCHAR2(2)*/
67: p_process_msg OUT NOCOPY VARCHAR2) /* caller should call with parameter of size VARCHAR2(1100) atleast*/
68: IS

Line 69: lv_prefix jai_rgm_doc_seq_dtls.prefix%Type ;

65: p_invoice_number OUT NOCOPY VARCHAR2, /* caller should call with parameter of size VARCHAR2(100)*/
66: p_process_flag OUT NOCOPY VARCHAR2, /* caller should call with parameter of size VARCHAR2(2)*/
67: p_process_msg OUT NOCOPY VARCHAR2) /* caller should call with parameter of size VARCHAR2(1100) atleast*/
68: IS
69: lv_prefix jai_rgm_doc_seq_dtls.prefix%Type ;
70: ln_current jai_rgm_doc_seq_dtls.current_number%Type ;
71: ln_end jai_rgm_doc_seq_dtls.end_number%Type ;
72: ln_seq_id jai_rgm_doc_seq_dtls.rgm_document_seq_id%Type ;
73: ln_seq_dtl_id jai_rgm_doc_seq_dtls.rgm_document_seq_dtl_id%Type ;

Line 70: ln_current jai_rgm_doc_seq_dtls.current_number%Type ;

66: p_process_flag OUT NOCOPY VARCHAR2, /* caller should call with parameter of size VARCHAR2(2)*/
67: p_process_msg OUT NOCOPY VARCHAR2) /* caller should call with parameter of size VARCHAR2(1100) atleast*/
68: IS
69: lv_prefix jai_rgm_doc_seq_dtls.prefix%Type ;
70: ln_current jai_rgm_doc_seq_dtls.current_number%Type ;
71: ln_end jai_rgm_doc_seq_dtls.end_number%Type ;
72: ln_seq_id jai_rgm_doc_seq_dtls.rgm_document_seq_id%Type ;
73: ln_seq_dtl_id jai_rgm_doc_seq_dtls.rgm_document_seq_dtl_id%Type ;
74: ln_regnum JAI_RGM_REGISTRATIONS.attribute_value%Type ;

Line 71: ln_end jai_rgm_doc_seq_dtls.end_number%Type ;

67: p_process_msg OUT NOCOPY VARCHAR2) /* caller should call with parameter of size VARCHAR2(1100) atleast*/
68: IS
69: lv_prefix jai_rgm_doc_seq_dtls.prefix%Type ;
70: ln_current jai_rgm_doc_seq_dtls.current_number%Type ;
71: ln_end jai_rgm_doc_seq_dtls.end_number%Type ;
72: ln_seq_id jai_rgm_doc_seq_dtls.rgm_document_seq_id%Type ;
73: ln_seq_dtl_id jai_rgm_doc_seq_dtls.rgm_document_seq_dtl_id%Type ;
74: ln_regnum JAI_RGM_REGISTRATIONS.attribute_value%Type ;
75:

Line 72: ln_seq_id jai_rgm_doc_seq_dtls.rgm_document_seq_id%Type ;

68: IS
69: lv_prefix jai_rgm_doc_seq_dtls.prefix%Type ;
70: ln_current jai_rgm_doc_seq_dtls.current_number%Type ;
71: ln_end jai_rgm_doc_seq_dtls.end_number%Type ;
72: ln_seq_id jai_rgm_doc_seq_dtls.rgm_document_seq_id%Type ;
73: ln_seq_dtl_id jai_rgm_doc_seq_dtls.rgm_document_seq_dtl_id%Type ;
74: ln_regnum JAI_RGM_REGISTRATIONS.attribute_value%Type ;
75:
76: CURSOR c_rgm_hdr(p_regime_id JAI_RGM_DEFINITIONS.regime_id%Type,

Line 73: ln_seq_dtl_id jai_rgm_doc_seq_dtls.rgm_document_seq_dtl_id%Type ;

69: lv_prefix jai_rgm_doc_seq_dtls.prefix%Type ;
70: ln_current jai_rgm_doc_seq_dtls.current_number%Type ;
71: ln_end jai_rgm_doc_seq_dtls.end_number%Type ;
72: ln_seq_id jai_rgm_doc_seq_dtls.rgm_document_seq_id%Type ;
73: ln_seq_dtl_id jai_rgm_doc_seq_dtls.rgm_document_seq_dtl_id%Type ;
74: ln_regnum JAI_RGM_REGISTRATIONS.attribute_value%Type ;
75:
76: CURSOR c_rgm_hdr(p_regime_id JAI_RGM_DEFINITIONS.regime_id%Type,
77: p_organization_id hr_all_organization_units.organization_id%Type,

Line 116: p_doc_class jai_rgm_doc_seq_dtls.document_class%Type,

112: and attribute_code = p_att_code ;
113:
114:
115: CURSOR c_rgm_dtl(ln_seq_id jai_rgm_doc_seq_hdrs.rgm_document_seq_id%Type,
116: p_doc_class jai_rgm_doc_seq_dtls.document_class%Type,
117: p_doc_type_id jai_rgm_doc_seq_dtls.document_class_Type_id%Type
118: ) IS
119: SELECT rgm_document_seq_dtl_id
120: FROM jai_rgm_doc_seq_dtls rdtl

Line 117: p_doc_type_id jai_rgm_doc_seq_dtls.document_class_Type_id%Type

113:
114:
115: CURSOR c_rgm_dtl(ln_seq_id jai_rgm_doc_seq_hdrs.rgm_document_seq_id%Type,
116: p_doc_class jai_rgm_doc_seq_dtls.document_class%Type,
117: p_doc_type_id jai_rgm_doc_seq_dtls.document_class_Type_id%Type
118: ) IS
119: SELECT rgm_document_seq_dtl_id
120: FROM jai_rgm_doc_seq_dtls rdtl
121: WHERE rdtl.rgm_document_seq_id = ln_seq_id

Line 120: FROM jai_rgm_doc_seq_dtls rdtl

116: p_doc_class jai_rgm_doc_seq_dtls.document_class%Type,
117: p_doc_type_id jai_rgm_doc_seq_dtls.document_class_Type_id%Type
118: ) IS
119: SELECT rgm_document_seq_dtl_id
120: FROM jai_rgm_doc_seq_dtls rdtl
121: WHERE rdtl.rgm_document_seq_id = ln_seq_id
122: AND rdtl.document_class = p_doc_class
123: AND rdtl.document_class_type_id = decode(p_doc_class, 'R', -8888, 'UR', -8888, --csahoo bug 5233925
124: p_doc_type_id) ;

Line 126: CURSOR c_default(ln_seq_id jai_rgm_doc_seq_dtls.rgm_document_seq_dtl_id%Type)

122: AND rdtl.document_class = p_doc_class
123: AND rdtl.document_class_type_id = decode(p_doc_class, 'R', -8888, 'UR', -8888, --csahoo bug 5233925
124: p_doc_type_id) ;
125:
126: CURSOR c_default(ln_seq_id jai_rgm_doc_seq_dtls.rgm_document_seq_dtl_id%Type)
127: IS
128: SELECT rgm_document_seq_dtl_id
129: FROM jai_rgm_doc_seq_dtls
130: WHERE rgm_document_seq_id = ln_seq_id

Line 129: FROM jai_rgm_doc_seq_dtls

125:
126: CURSOR c_default(ln_seq_id jai_rgm_doc_seq_dtls.rgm_document_seq_dtl_id%Type)
127: IS
128: SELECT rgm_document_seq_dtl_id
129: FROM jai_rgm_doc_seq_dtls
130: WHERE rgm_document_seq_id = ln_seq_id
131: AND document_class = DECODE(p_doc_class,'O','D','UO','UD','UI','UD','I','D','R','D','UR','UD',p_doc_class);
132: /*added the p_doc_class in the end of the aboive decode statement for bug #5989740 */
133:

Line 134: CURSOR c_get_prefix_current(ln_seq_dtl_id jai_rgm_doc_seq_dtls.rgm_document_seq_dtl_id%Type)

130: WHERE rgm_document_seq_id = ln_seq_id
131: AND document_class = DECODE(p_doc_class,'O','D','UO','UD','UI','UD','I','D','R','D','UR','UD',p_doc_class);
132: /*added the p_doc_class in the end of the aboive decode statement for bug #5989740 */
133:
134: CURSOR c_get_prefix_current(ln_seq_dtl_id jai_rgm_doc_seq_dtls.rgm_document_seq_dtl_id%Type)
135: IS
136: SELECT prefix,current_number,end_number
137: FROM jai_rgm_doc_seq_dtls
138: WHERE rgm_document_seq_dtl_id = ln_seq_dtl_id

Line 137: FROM jai_rgm_doc_seq_dtls

133:
134: CURSOR c_get_prefix_current(ln_seq_dtl_id jai_rgm_doc_seq_dtls.rgm_document_seq_dtl_id%Type)
135: IS
136: SELECT prefix,current_number,end_number
137: FROM jai_rgm_doc_seq_dtls
138: WHERE rgm_document_seq_dtl_id = ln_seq_dtl_id
139: FOR UPDATE of current_number ; /* Added 'FOR UPDATE OF current_number' by ssawant for bug#5603661 */
140:
141: CURSOR c_get_regime_code(ln_regime_id jai_rgm_definitions.REGIME_ID%TYPE)

Line 182: UPDATE jai_rgm_doc_seq_dtls

178: ELSE
179: p_invoice_number := lv_prefix || '/' || ln_current ;
180: END IF;
181:
182: UPDATE jai_rgm_doc_seq_dtls
183: SET current_number = ln_current
184: WHERE rgm_document_seq_dtl_id = ln_seq_dtl_id ;
185:
186: p_process_flag := jai_constants.successful ;

Line 218: UPDATE jai_rgm_doc_seq_dtls

214: ELSE
215: p_invoice_number := lv_prefix || '/' || ln_current ;
216: END IF;
217:
218: UPDATE jai_rgm_doc_seq_dtls
219: SET current_number = ln_current
220: WHERE rgm_document_seq_dtl_id = ln_seq_dtl_id ;
221:
222: p_process_flag := jai_constants.successful ;

Line 286: UPDATE jai_rgm_doc_seq_dtls

282: ELSE
283: p_invoice_number := lv_prefix || '/' || ln_current ;
284: END IF;
285:
286: UPDATE jai_rgm_doc_seq_dtls
287: SET current_number = ln_current
288: WHERE rgm_document_seq_dtl_id = ln_seq_dtl_id ;
289:
290: p_process_flag := jai_constants.successful ;

Line 320: UPDATE jai_rgm_doc_seq_dtls

316: ELSE
317: p_invoice_number := lv_prefix || '/' || ln_current ;
318: END IF;
319:
320: UPDATE jai_rgm_doc_seq_dtls
321: SET current_number = ln_current
322: WHERE rgm_document_seq_dtl_id = ln_seq_dtl_id ;
323:
324: p_process_flag := jai_constants.successful ;