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.AR_GTA_TXT_OPERATOR_PROC dependencies on AR_GTA_IMPORT_REP_TEMP

Line 984: INSERT INTO AR_GTA_IMPORT_REP_TEMP( SEQ

980: , 'Assign value from TXT to record:'||SQLCODE||':'||SQLERRM);
981: END IF;
982:
983: ROLLBACK TO save_header_trans;
984: INSERT INTO AR_GTA_IMPORT_REP_TEMP( SEQ
985: , SUCCEEDED
986: , Customer_Name
987: , Taxpayer_ID
988: , Invoice_Num

Line 993: VALUES(AR_GTA_IMPORT_REP_TEMP_s.NEXTVAL

989: , Invoice_date
990: , Amount
991: , FailedReason
992: )
993: VALUES(AR_GTA_IMPORT_REP_TEMP_s.NEXTVAL
994: , 'N'
995: , l_Customer_Name
996: , l_TP_TAX_REG_NUMBER
997: , l_Invoice_Num

Line 1110: INSERT INTO AR_GTA_IMPORT_REP_TEMP( SEQ

1106: , 'Update original record:'||SQLCODE||':'||SQLERRM);
1107: END IF;
1108:
1109: ROLLBACK TO save_header_trans;
1110: INSERT INTO AR_GTA_IMPORT_REP_TEMP( SEQ
1111: , SUCCEEDED
1112: , Customer_Name
1113: , Taxpayer_ID
1114: , Invoice_Num

Line 1119: VALUES( AR_GTA_IMPORT_REP_TEMP_s.NEXTVAL

1115: , Invoice_date
1116: , Amount
1117: , FailedReason
1118: )
1119: VALUES( AR_GTA_IMPORT_REP_TEMP_s.NEXTVAL
1120: , 'N'
1121: , l_Customer_Name
1122: , l_TP_TAX_REG_NUMBER
1123: , l_Invoice_Num

Line 1142: INSERT INTO AR_GTA_IMPORT_REP_TEMP( SEQ

1138: --insert into GTA table
1139: BEGIN
1140: ar_gta_trx_util.create_Trx(P_GTA_Trx => l_trx_rec);
1141:
1142: INSERT INTO AR_GTA_IMPORT_REP_TEMP( SEQ
1143: , SUCCEEDED
1144: , Customer_Name
1145: , Taxpayer_ID
1146: , Invoice_Num

Line 1151: VALUES( AR_GTA_IMPORT_REP_TEMP_s.NEXTVAL

1147: , Invoice_date
1148: , Amount
1149: , STATUS
1150: )
1151: VALUES( AR_GTA_IMPORT_REP_TEMP_s.NEXTVAL
1152: , 'Y'
1153: , l_Customer_Name
1154: , l_TP_TAX_REG_NUMBER
1155: , l_Invoice_Num

Line 1176: INSERT INTO AR_GTA_IMPORT_REP_TEMP( SEQ

1172: , 'Insert into base table:'||SQLCODE||':'||SQLERRM);
1173: END IF;
1174:
1175: ROLLBACK TO save_header_trans;
1176: INSERT INTO AR_GTA_IMPORT_REP_TEMP( SEQ
1177: , SUCCEEDED
1178: , Customer_Name
1179: , Taxpayer_ID
1180: , Invoice_Num

Line 1185: VALUES( AR_GTA_IMPORT_REP_TEMP_s.NEXTVAL

1181: , Invoice_date
1182: , Amount
1183: , FailedReason
1184: )
1185: VALUES( AR_GTA_IMPORT_REP_TEMP_s.NEXTVAL
1186: , 'N'
1187: , l_Customer_Name
1188: , l_TP_TAX_REG_NUMBER
1189: , l_Invoice_Num

Line 1200: --delete the record in AR_GTA_IMPORT_REP_TEMP mis-inserted

1196: IF l_vat_tbl.EXISTS(l_GTA_Invoice_num)
1197: THEN
1198: IF l_vat_tbl(l_GTA_Invoice_num).cancel_flag = '1' AND l_values_VAT_Header(1) = '0'
1199: THEN
1200: --delete the record in AR_GTA_IMPORT_REP_TEMP mis-inserted
1201: DELETE FROM AR_GTA_IMPORT_REP_TEMP
1202: WHERE Invoice_Num = l_vat_tbl(l_GTA_Invoice_num).gt_invoice_number;
1203: --the VAT in VAT_Set is cancelled and this one is a completed invoice,overwrite the VAT_Set
1204: l_vat_tbl(l_GTA_Invoice_num):=l_trx_header_rec;

Line 1201: DELETE FROM AR_GTA_IMPORT_REP_TEMP

1197: THEN
1198: IF l_vat_tbl(l_GTA_Invoice_num).cancel_flag = '1' AND l_values_VAT_Header(1) = '0'
1199: THEN
1200: --delete the record in AR_GTA_IMPORT_REP_TEMP mis-inserted
1201: DELETE FROM AR_GTA_IMPORT_REP_TEMP
1202: WHERE Invoice_Num = l_vat_tbl(l_GTA_Invoice_num).gt_invoice_number;
1203: --the VAT in VAT_Set is cancelled and this one is a completed invoice,overwrite the VAT_Set
1204: l_vat_tbl(l_GTA_Invoice_num):=l_trx_header_rec;
1205: ELSE

Line 1244: INSERT INTO AR_GTA_IMPORT_REP_TEMP( SEQ

1240: );
1241:
1242: l_error_msg:=fnd_message.GET;
1243:
1244: INSERT INTO AR_GTA_IMPORT_REP_TEMP( SEQ
1245: , SUCCEEDED
1246: , Customer_Name
1247: , Taxpayer_ID
1248: , Invoice_Num

Line 1253: VALUES( AR_GTA_IMPORT_REP_TEMP_s.NEXTVAL

1249: , Invoice_date
1250: , Amount
1251: , FailedReason
1252: )
1253: VALUES( AR_GTA_IMPORT_REP_TEMP_s.NEXTVAL
1254: , 'N'
1255: , l_Customer_Name
1256: , l_TP_TAX_REG_NUMBER
1257: , l_Invoice_Num

Line 1282: INSERT INTO AR_GTA_IMPORT_REP_TEMP( SEQ

1278: );
1279:
1280: l_error_msg:=fnd_message.GET;
1281:
1282: INSERT INTO AR_GTA_IMPORT_REP_TEMP( SEQ
1283: , SUCCEEDED
1284: , Customer_Name
1285: , Taxpayer_ID
1286: , Invoice_Num

Line 1291: VALUES( AR_GTA_IMPORT_REP_TEMP_s.NEXTVAL

1287: , Invoice_date
1288: , Amount
1289: , FailedReason
1290: )
1291: VALUES( AR_GTA_IMPORT_REP_TEMP_s.NEXTVAL
1292: , 'N'
1293: , l_Customer_Name
1294: , l_TP_TAX_REG_NUMBER
1295: , l_Invoice_Num

Line 1313: INSERT INTO AR_GTA_IMPORT_REP_TEMP( SEQ

1309: ELSE --status error
1310: fnd_message.SET_NAME('AR','AR_GTA_WRONG_INV_STATUS');
1311: l_error_msg:=fnd_message.GET;
1312:
1313: INSERT INTO AR_GTA_IMPORT_REP_TEMP( SEQ
1314: , SUCCEEDED
1315: , Customer_Name
1316: , Taxpayer_ID
1317: , Invoice_Num

Line 1322: VALUES( AR_GTA_IMPORT_REP_TEMP_s.NEXTVAL

1318: , Invoice_date
1319: , Amount
1320: , FailedReason
1321: )
1322: VALUES( AR_GTA_IMPORT_REP_TEMP_s.NEXTVAL
1323: , 'N'
1324: , l_Customer_Name
1325: , l_TP_TAX_REG_NUMBER
1326: , l_Invoice_Num

Line 1344: INSERT INTO AR_GTA_IMPORT_REP_TEMP( SEQ

1340: --report AR_GTA_MOAC_ERROR;
1341: /*fnd_message.SET_NAME('AR','AR_GTA_MOAC_FORBID');
1342: l_error_msg:=fnd_message.GET;
1343:
1344: INSERT INTO AR_GTA_IMPORT_REP_TEMP( SEQ
1345: , SUCCEEDED
1346: , Customer_Name
1347: , Taxpayer_ID
1348: , Invoice_Num

Line 1353: VALUES( AR_GTA_IMPORT_REP_TEMP_s.NEXTVAL

1349: , Invoice_date
1350: , Amount
1351: , FailedReason
1352: )
1353: VALUES( AR_GTA_IMPORT_REP_TEMP_s.NEXTVAL
1354: , 'N'
1355: , l_Customer_Name
1356: , l_Taxpayer_ID
1357: , l_Invoice_Num

Line 1422: FROM AR_GTA_IMPORT_REP_TEMP

1418: )
1419: )
1420: )
1421: INTO l_succ_XML
1422: FROM AR_GTA_IMPORT_REP_TEMP
1423: WHERE SUCCEEDED='Y';
1424: EXCEPTION
1425: WHEN OTHERS THEN
1426: NULL;

Line 1449: FROM AR_GTA_IMPORT_REP_TEMP

1445: )
1446: )
1447: )
1448: INTO l_failed_XML
1449: FROM AR_GTA_IMPORT_REP_TEMP
1450: WHERE SUCCEEDED='N';
1451: EXCEPTION
1452: WHEN OTHERS THEN
1453: NULL;