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 35: p_doc_class jai_rgm_doc_seq_dtls.document_class%Type ,

31: p_regime_id JAI_RGM_DEFINITIONS.regime_id%Type,
32: p_organization_id hr_all_organization_units.organization_id%Type,
33: p_location_id hr_locations.location_id%Type,
34: p_DATE DATE,
35: p_doc_class jai_rgm_doc_seq_dtls.document_class%Type ,
36: p_doc_type_id jai_rgm_doc_seq_dtls.document_class_type_id%Type,
37: p_invoice_number OUT NOCOPY VARCHAR2, /* caller should call with parameter of size VARCHAR2(100)*/
38: p_process_flag OUT NOCOPY VARCHAR2, /* caller should call with parameter of size VARCHAR2(2)*/
39: p_process_msg OUT NOCOPY VARCHAR2) /* caller should call with parameter of size VARCHAR2(1100) atleast*/

Line 36: p_doc_type_id jai_rgm_doc_seq_dtls.document_class_type_id%Type,

32: p_organization_id hr_all_organization_units.organization_id%Type,
33: p_location_id hr_locations.location_id%Type,
34: p_DATE DATE,
35: p_doc_class jai_rgm_doc_seq_dtls.document_class%Type ,
36: p_doc_type_id jai_rgm_doc_seq_dtls.document_class_type_id%Type,
37: p_invoice_number OUT NOCOPY VARCHAR2, /* caller should call with parameter of size VARCHAR2(100)*/
38: p_process_flag OUT NOCOPY VARCHAR2, /* caller should call with parameter of size VARCHAR2(2)*/
39: p_process_msg OUT NOCOPY VARCHAR2) /* caller should call with parameter of size VARCHAR2(1100) atleast*/
40: IS

Line 41: lv_prefix jai_rgm_doc_seq_dtls.prefix%Type ;

37: p_invoice_number OUT NOCOPY VARCHAR2, /* caller should call with parameter of size VARCHAR2(100)*/
38: p_process_flag OUT NOCOPY VARCHAR2, /* caller should call with parameter of size VARCHAR2(2)*/
39: p_process_msg OUT NOCOPY VARCHAR2) /* caller should call with parameter of size VARCHAR2(1100) atleast*/
40: IS
41: lv_prefix jai_rgm_doc_seq_dtls.prefix%Type ;
42: ln_current jai_rgm_doc_seq_dtls.current_number%Type ;
43: ln_end jai_rgm_doc_seq_dtls.end_number%Type ;
44: ln_seq_id jai_rgm_doc_seq_dtls.rgm_document_seq_id%Type ;
45: ln_seq_dtl_id jai_rgm_doc_seq_dtls.rgm_document_seq_dtl_id%Type ;

Line 42: ln_current jai_rgm_doc_seq_dtls.current_number%Type ;

38: p_process_flag OUT NOCOPY VARCHAR2, /* caller should call with parameter of size VARCHAR2(2)*/
39: p_process_msg OUT NOCOPY VARCHAR2) /* caller should call with parameter of size VARCHAR2(1100) atleast*/
40: IS
41: lv_prefix jai_rgm_doc_seq_dtls.prefix%Type ;
42: ln_current jai_rgm_doc_seq_dtls.current_number%Type ;
43: ln_end jai_rgm_doc_seq_dtls.end_number%Type ;
44: ln_seq_id jai_rgm_doc_seq_dtls.rgm_document_seq_id%Type ;
45: ln_seq_dtl_id jai_rgm_doc_seq_dtls.rgm_document_seq_dtl_id%Type ;
46: ln_regnum JAI_RGM_REGISTRATIONS.attribute_value%Type ;

Line 43: ln_end jai_rgm_doc_seq_dtls.end_number%Type ;

39: p_process_msg OUT NOCOPY VARCHAR2) /* caller should call with parameter of size VARCHAR2(1100) atleast*/
40: IS
41: lv_prefix jai_rgm_doc_seq_dtls.prefix%Type ;
42: ln_current jai_rgm_doc_seq_dtls.current_number%Type ;
43: ln_end jai_rgm_doc_seq_dtls.end_number%Type ;
44: ln_seq_id jai_rgm_doc_seq_dtls.rgm_document_seq_id%Type ;
45: ln_seq_dtl_id jai_rgm_doc_seq_dtls.rgm_document_seq_dtl_id%Type ;
46: ln_regnum JAI_RGM_REGISTRATIONS.attribute_value%Type ;
47:

Line 44: ln_seq_id jai_rgm_doc_seq_dtls.rgm_document_seq_id%Type ;

40: IS
41: lv_prefix jai_rgm_doc_seq_dtls.prefix%Type ;
42: ln_current jai_rgm_doc_seq_dtls.current_number%Type ;
43: ln_end jai_rgm_doc_seq_dtls.end_number%Type ;
44: ln_seq_id jai_rgm_doc_seq_dtls.rgm_document_seq_id%Type ;
45: ln_seq_dtl_id jai_rgm_doc_seq_dtls.rgm_document_seq_dtl_id%Type ;
46: ln_regnum JAI_RGM_REGISTRATIONS.attribute_value%Type ;
47:
48: CURSOR c_rgm_hdr(p_regime_id JAI_RGM_DEFINITIONS.regime_id%Type,

Line 45: ln_seq_dtl_id jai_rgm_doc_seq_dtls.rgm_document_seq_dtl_id%Type ;

41: lv_prefix jai_rgm_doc_seq_dtls.prefix%Type ;
42: ln_current jai_rgm_doc_seq_dtls.current_number%Type ;
43: ln_end jai_rgm_doc_seq_dtls.end_number%Type ;
44: ln_seq_id jai_rgm_doc_seq_dtls.rgm_document_seq_id%Type ;
45: ln_seq_dtl_id jai_rgm_doc_seq_dtls.rgm_document_seq_dtl_id%Type ;
46: ln_regnum JAI_RGM_REGISTRATIONS.attribute_value%Type ;
47:
48: CURSOR c_rgm_hdr(p_regime_id JAI_RGM_DEFINITIONS.regime_id%Type,
49: p_organization_id hr_all_organization_units.organization_id%Type,

Line 86: p_doc_class jai_rgm_doc_seq_dtls.document_class%Type,

82: and attribute_code = p_att_code ;
83:
84:
85: CURSOR c_rgm_dtl(ln_seq_id jai_rgm_doc_seq_hdrs.rgm_document_seq_id%Type,
86: p_doc_class jai_rgm_doc_seq_dtls.document_class%Type,
87: p_doc_type_id jai_rgm_doc_seq_dtls.document_class_Type_id%Type
88: ) IS
89: SELECT rgm_document_seq_dtl_id
90: FROM jai_rgm_doc_seq_dtls rdtl

Line 87: p_doc_type_id jai_rgm_doc_seq_dtls.document_class_Type_id%Type

83:
84:
85: CURSOR c_rgm_dtl(ln_seq_id jai_rgm_doc_seq_hdrs.rgm_document_seq_id%Type,
86: p_doc_class jai_rgm_doc_seq_dtls.document_class%Type,
87: p_doc_type_id jai_rgm_doc_seq_dtls.document_class_Type_id%Type
88: ) IS
89: SELECT rgm_document_seq_dtl_id
90: FROM jai_rgm_doc_seq_dtls rdtl
91: WHERE rdtl.rgm_document_seq_id = ln_seq_id

Line 90: FROM jai_rgm_doc_seq_dtls rdtl

86: p_doc_class jai_rgm_doc_seq_dtls.document_class%Type,
87: p_doc_type_id jai_rgm_doc_seq_dtls.document_class_Type_id%Type
88: ) IS
89: SELECT rgm_document_seq_dtl_id
90: FROM jai_rgm_doc_seq_dtls rdtl
91: WHERE rdtl.rgm_document_seq_id = ln_seq_id
92: AND rdtl.document_class = p_doc_class
93: AND rdtl.document_class_type_id = decode(p_doc_class, 'R', -8888, 'UR', -8888, --csahoo bug 5233925
94: p_doc_type_id) ;

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

92: AND rdtl.document_class = p_doc_class
93: AND rdtl.document_class_type_id = decode(p_doc_class, 'R', -8888, 'UR', -8888, --csahoo bug 5233925
94: p_doc_type_id) ;
95:
96: CURSOR c_default(ln_seq_id jai_rgm_doc_seq_dtls.rgm_document_seq_dtl_id%Type)
97: IS
98: SELECT rgm_document_seq_dtl_id
99: FROM jai_rgm_doc_seq_dtls
100: WHERE rgm_document_seq_id = ln_seq_id

Line 99: FROM jai_rgm_doc_seq_dtls

95:
96: CURSOR c_default(ln_seq_id jai_rgm_doc_seq_dtls.rgm_document_seq_dtl_id%Type)
97: IS
98: SELECT rgm_document_seq_dtl_id
99: FROM jai_rgm_doc_seq_dtls
100: WHERE rgm_document_seq_id = ln_seq_id
101: AND document_class = DECODE(p_doc_class,'O','D','UO','UD','UI','UD','I','D','R','D','UR','UD',p_doc_class);
102: /*added the p_doc_class in the end of the aboive decode statement for bug #5989740 */
103:

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

100: WHERE rgm_document_seq_id = ln_seq_id
101: AND document_class = DECODE(p_doc_class,'O','D','UO','UD','UI','UD','I','D','R','D','UR','UD',p_doc_class);
102: /*added the p_doc_class in the end of the aboive decode statement for bug #5989740 */
103:
104: CURSOR c_get_prefix_current(ln_seq_dtl_id jai_rgm_doc_seq_dtls.rgm_document_seq_dtl_id%Type)
105: IS
106: SELECT prefix,current_number,end_number
107: FROM jai_rgm_doc_seq_dtls
108: WHERE rgm_document_seq_dtl_id = ln_seq_dtl_id

Line 107: FROM jai_rgm_doc_seq_dtls

103:
104: CURSOR c_get_prefix_current(ln_seq_dtl_id jai_rgm_doc_seq_dtls.rgm_document_seq_dtl_id%Type)
105: IS
106: SELECT prefix,current_number,end_number
107: FROM jai_rgm_doc_seq_dtls
108: WHERE rgm_document_seq_dtl_id = ln_seq_dtl_id
109: FOR UPDATE of current_number ; /* Added 'FOR UPDATE OF current_number' by ssawant for bug#5603661 */
110:
111: BEGIN

Line 145: UPDATE jai_rgm_doc_seq_dtls

141: ELSE
142: p_invoice_number := lv_prefix || '/' || ln_current ;
143: END IF;
144:
145: UPDATE jai_rgm_doc_seq_dtls
146: SET current_number = ln_current
147: WHERE rgm_document_seq_dtl_id = ln_seq_dtl_id ;
148:
149: p_process_flag := jai_constants.successful ;

Line 181: UPDATE jai_rgm_doc_seq_dtls

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

Line 238: UPDATE jai_rgm_doc_seq_dtls

234: ELSE
235: p_invoice_number := lv_prefix || '/' || ln_current ;
236: END IF;
237:
238: UPDATE jai_rgm_doc_seq_dtls
239: SET current_number = ln_current
240: WHERE rgm_document_seq_dtl_id = ln_seq_dtl_id ;
241:
242: p_process_flag := jai_constants.successful ;

Line 272: UPDATE jai_rgm_doc_seq_dtls

268: ELSE
269: p_invoice_number := lv_prefix || '/' || ln_current ;
270: END IF;
271:
272: UPDATE jai_rgm_doc_seq_dtls
273: SET current_number = ln_current
274: WHERE rgm_document_seq_dtl_id = ln_seq_dtl_id ;
275:
276: p_process_flag := jai_constants.successful ;