APPS.JAI_EXCISE_SCRIPTS_PKG dependencies on JAI_TRX_GT

Line 2097: Column list and their related information for the table JAI_TRX_GT

2093:
2094: ------------------------------------ CAPTURE_ERROR ------------------------------------------------
2095: /*
2096:
2097: Column list and their related information for the table JAI_TRX_GT
2098:
2099: organization_id - JAI_INFO_N1
2100: location_id - JAI_INFO_N2
2101: register_type - JAI_INFO_V1

Line 2139: insert into JAI_TRX_GT

2135: )
2136: IS
2137: BEGIN
2138:
2139: insert into JAI_TRX_GT
2140: ( JAI_INFO_N1 ,
2141: JAI_INFO_N2 ,
2142: JAI_INFO_V1 ,
2143: JAI_INFO_N3 ,

Line 2322: from JAI_TRX_GT

2318: cp_register_type varchar2
2319: )
2320: is
2321: select count(1)
2322: from JAI_TRX_GT
2323: where
2324: JAI_INFO_N1 = cp_organization_id and
2325: JAI_INFO_N2 = cp_location_id and
2326: JAI_INFO_V1 = cp_register_type ;

Line 2335: from JAI_TRX_GT

2331: cp_tax_type VARCHAR2
2332: )
2333: is
2334: select count(1)
2335: from JAI_TRX_GT
2336: where
2337: JAI_INFO_N1 = cp_organization_id AND
2338: JAI_INFO_N2 = cp_location_id AND
2339: JAI_INFO_V1 = cp_register_type AND

Line 3591: for rec in ( select * from JAI_TRX_GT)

3587: FND_FILE.PUT_LINE(FND_FILE.LOG, '| --------------- |' || ' ----------- |' || ' ------------- |' || ' -------- |' || '----- |' || ' ------ |' || ' ----------- |'
3588: || ' -------- |' || ' -------- |' || ' -------- |' || ' ----- ' || ' ---- ' ) ;
3589:
3590:
3591: for rec in ( select * from JAI_TRX_GT)
3592: loop
3593:
3594: FND_FILE.PUT_LINE(FND_FILE.LOG, '|' || RPAD(nvl(to_char(rec.JAI_INFO_N1),' '), 17, ' ')|| '|' || RPAD(nvl(to_char(rec.JAI_INFO_N2),' '), 13, ' ') || '|'
3595: || RPAD(nvl(rec.JAI_INFO_V1,' '), 15, ' ') || '|' || RPAD(nvl(to_char(rec.JAI_INFO_N3),' '), 10, ' ') || '|' || RPAD(nvl(rec.JAI_INFO_V3,' '), 6, ' ') || '|' || RPAD(nvl(to_char(rec.JAI_INFO_N8),' '), 8, ' ')