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.IBY_PAYMENT_FORMAT_VAL_PUB dependencies on FV_TP_TS_AMT_DATA

Line 103: -- delete from FV_TP_TS_AMT_DATA to refresh data

99:
100:
101: IF pay_instr_data_csr%FOUND THEN -- If Row Found Then Only Process Further
102:
103: -- delete from FV_TP_TS_AMT_DATA to refresh data
104: delete from FV_TP_TS_AMT_DATA where payment_instruction_id = p_instruction_id;
105:
106: -- Do validation of the Federal Identification Number
107: IBY_PAYMENT_FORMAT_VAL_PVT.FEDERAL_ID_NUMBER(

Line 104: delete from FV_TP_TS_AMT_DATA where payment_instruction_id = p_instruction_id;

100:
101: IF pay_instr_data_csr%FOUND THEN -- If Row Found Then Only Process Further
102:
103: -- delete from FV_TP_TS_AMT_DATA to refresh data
104: delete from FV_TP_TS_AMT_DATA where payment_instruction_id = p_instruction_id;
105:
106: -- Do validation of the Federal Identification Number
107: IBY_PAYMENT_FORMAT_VAL_PVT.FEDERAL_ID_NUMBER(
108: l_format_name,

Line 446: -- delete from FV_TP_TS_AMT_DATA to refresh data

442: FETCH pay_instr_data_csr INTO l_pay_instr_rec; -- Getting Instruction Data
443:
444: IF pay_instr_data_csr%FOUND THEN -- If Row Found Then Only Process Further
445:
446: -- delete from FV_TP_TS_AMT_DATA to refresh data
447: delete from FV_TP_TS_AMT_DATA where payment_instruction_id = p_instruction_id;
448:
449: l_org_id:=l_pay_instr_rec.org_id;-- Extracting Org_Id
450:

Line 447: delete from FV_TP_TS_AMT_DATA where payment_instruction_id = p_instruction_id;

443:
444: IF pay_instr_data_csr%FOUND THEN -- If Row Found Then Only Process Further
445:
446: -- delete from FV_TP_TS_AMT_DATA to refresh data
447: delete from FV_TP_TS_AMT_DATA where payment_instruction_id = p_instruction_id;
448:
449: l_org_id:=l_pay_instr_rec.org_id;-- Extracting Org_Id
450:
451: -- Do validation of Agency Id Abbreviation

Line 763: -- delete from FV_TP_TS_AMT_DATA to refresh data

759: FETCH pay_instr_data_csr INTO l_pay_instr_rec; -- Getting Instruction Data
760:
761: IF pay_instr_data_csr%FOUND THEN -- If Row Found Then Only Process Further
762:
763: -- delete from FV_TP_TS_AMT_DATA to refresh data
764: delete from FV_TP_TS_AMT_DATA where payment_instruction_id = p_instruction_id;
765:
766: -- Do validation of the Federal Identification Number
767: IBY_PAYMENT_FORMAT_VAL_PVT.FEDERAL_ID_NUMBER(

Line 764: delete from FV_TP_TS_AMT_DATA where payment_instruction_id = p_instruction_id;

760:
761: IF pay_instr_data_csr%FOUND THEN -- If Row Found Then Only Process Further
762:
763: -- delete from FV_TP_TS_AMT_DATA to refresh data
764: delete from FV_TP_TS_AMT_DATA where payment_instruction_id = p_instruction_id;
765:
766: -- Do validation of the Federal Identification Number
767: IBY_PAYMENT_FORMAT_VAL_PVT.FEDERAL_ID_NUMBER(
768: l_format_name,

Line 1130: -- delete from FV_TP_TS_AMT_DATA to refresh data

1126: FETCH pay_instr_data_csr INTO l_pay_instr_rec; -- Getting Instruction Data
1127:
1128: IF pay_instr_data_csr%FOUND THEN -- If Row Found Then Only Process Further
1129:
1130: -- delete from FV_TP_TS_AMT_DATA to refresh data
1131: delete from FV_TP_TS_AMT_DATA where payment_instruction_id = p_instruction_id;
1132:
1133: l_org_id:=l_pay_instr_rec.org_id;-- Extracting Org_ID
1134:

Line 1131: delete from FV_TP_TS_AMT_DATA where payment_instruction_id = p_instruction_id;

1127:
1128: IF pay_instr_data_csr%FOUND THEN -- If Row Found Then Only Process Further
1129:
1130: -- delete from FV_TP_TS_AMT_DATA to refresh data
1131: delete from FV_TP_TS_AMT_DATA where payment_instruction_id = p_instruction_id;
1132:
1133: l_org_id:=l_pay_instr_rec.org_id;-- Extracting Org_ID
1134:
1135: -- Do validation of Agency Id Abbreviation

Line 1429: -- delete from FV_TP_TS_AMT_DATA to refresh data

1425: FETCH pay_instr_data_csr INTO l_pay_instr_rec; -- Getting Instruction Data
1426:
1427: IF pay_instr_data_csr%FOUND THEN -- If Row Found Then Only Process Further
1428:
1429: -- delete from FV_TP_TS_AMT_DATA to refresh data
1430: delete from FV_TP_TS_AMT_DATA where payment_instruction_id = p_instruction_id;
1431:
1432: l_org_id:=l_pay_instr_rec.org_id;-- Extracting Org_ID
1433:

Line 1430: delete from FV_TP_TS_AMT_DATA where payment_instruction_id = p_instruction_id;

1426:
1427: IF pay_instr_data_csr%FOUND THEN -- If Row Found Then Only Process Further
1428:
1429: -- delete from FV_TP_TS_AMT_DATA to refresh data
1430: delete from FV_TP_TS_AMT_DATA where payment_instruction_id = p_instruction_id;
1431:
1432: l_org_id:=l_pay_instr_rec.org_id;-- Extracting Org_ID
1433:
1434: -- Do validation of Agency Id Abbreviation

Line 1772: -- delete from FV_TP_TS_AMT_DATA to refresh data

1768: FETCH pay_instr_data_csr INTO l_pay_instr_rec; -- Getting Instruction Data
1769:
1770: IF pay_instr_data_csr%FOUND THEN -- If Row Found Then Only Process Further
1771:
1772: -- delete from FV_TP_TS_AMT_DATA to refresh data
1773: delete from FV_TP_TS_AMT_DATA where payment_instruction_id = p_instruction_id;
1774:
1775: l_org_id:=l_pay_instr_rec.org_id;-- Extracting Org_ID
1776:

Line 1773: delete from FV_TP_TS_AMT_DATA where payment_instruction_id = p_instruction_id;

1769:
1770: IF pay_instr_data_csr%FOUND THEN -- If Row Found Then Only Process Further
1771:
1772: -- delete from FV_TP_TS_AMT_DATA to refresh data
1773: delete from FV_TP_TS_AMT_DATA where payment_instruction_id = p_instruction_id;
1774:
1775: l_org_id:=l_pay_instr_rec.org_id;-- Extracting Org_ID
1776:
1777: -- Do IBY_PAYMENT_FORMAT_VAL_PVT.SUPPLIER_TYPE at Payment Instruction Level

Line 2087: -- delete from FV_TP_TS_AMT_DATA to refresh data

2083: FETCH pay_instr_data_csr INTO l_pay_instr_rec; -- Getting Instruction Data
2084:
2085: IF pay_instr_data_csr%FOUND THEN -- If Row Found Then Only Process Further
2086:
2087: -- delete from FV_TP_TS_AMT_DATA to refresh data
2088: delete from FV_TP_TS_AMT_DATA where payment_instruction_id = p_instruction_id;
2089:
2090: l_org_id:=l_pay_instr_rec.org_id;-- Extracting Org_ID
2091:

Line 2088: delete from FV_TP_TS_AMT_DATA where payment_instruction_id = p_instruction_id;

2084:
2085: IF pay_instr_data_csr%FOUND THEN -- If Row Found Then Only Process Further
2086:
2087: -- delete from FV_TP_TS_AMT_DATA to refresh data
2088: delete from FV_TP_TS_AMT_DATA where payment_instruction_id = p_instruction_id;
2089:
2090: l_org_id:=l_pay_instr_rec.org_id;-- Extracting Org_ID
2091:
2092:

Line 2393: -- delete from FV_TP_TS_AMT_DATA to refresh data

2389: FETCH pay_instr_data_csr INTO l_pay_instr_rec; -- Getting Instruction Data
2390:
2391: IF pay_instr_data_csr%FOUND THEN -- If Row Found Then Only Process Further
2392:
2393: -- delete from FV_TP_TS_AMT_DATA to refresh data
2394: delete from FV_TP_TS_AMT_DATA where payment_instruction_id = p_instruction_id;
2395:
2396: l_org_id:=l_pay_instr_rec.org_id;-- Extracting Org_ID
2397:

Line 2394: delete from FV_TP_TS_AMT_DATA where payment_instruction_id = p_instruction_id;

2390:
2391: IF pay_instr_data_csr%FOUND THEN -- If Row Found Then Only Process Further
2392:
2393: -- delete from FV_TP_TS_AMT_DATA to refresh data
2394: delete from FV_TP_TS_AMT_DATA where payment_instruction_id = p_instruction_id;
2395:
2396: l_org_id:=l_pay_instr_rec.org_id;-- Extracting Org_ID
2397:
2398:

Line 2663: -- delete from FV_TP_TS_AMT_DATA to refresh data

2659: FETCH pay_instr_data_csr INTO l_pay_instr_rec; -- Getting Instruction Data
2660:
2661: IF pay_instr_data_csr%FOUND THEN -- If Row Found Then Only Process Further
2662:
2663: -- delete from FV_TP_TS_AMT_DATA to refresh data
2664: delete from FV_TP_TS_AMT_DATA where payment_instruction_id = p_instruction_id;
2665:
2666: l_org_id:=l_pay_instr_rec.org_id;-- Extracting Org_ID
2667:

Line 2664: delete from FV_TP_TS_AMT_DATA where payment_instruction_id = p_instruction_id;

2660:
2661: IF pay_instr_data_csr%FOUND THEN -- If Row Found Then Only Process Further
2662:
2663: -- delete from FV_TP_TS_AMT_DATA to refresh data
2664: delete from FV_TP_TS_AMT_DATA where payment_instruction_id = p_instruction_id;
2665:
2666: l_org_id:=l_pay_instr_rec.org_id;-- Extracting Org_ID
2667:
2668: -- Do IBY_PAYMENT_FORMAT_VAL_PVT.SUPPLIER_TYPE at Payment Instruction Level

Line 3012: -- delete from FV_TP_TS_AMT_DATA to refresh data

3008: FETCH pay_instr_data_csr INTO l_pay_instr_rec; -- Getting Instruction Data
3009:
3010: IF pay_instr_data_csr%FOUND THEN -- If Row Found Then Only Process Further
3011:
3012: -- delete from FV_TP_TS_AMT_DATA to refresh data
3013: delete from FV_TP_TS_AMT_DATA where payment_instruction_id = p_instruction_id;
3014:
3015: l_org_id:=l_pay_instr_rec.org_id;-- Extracting Org_ID
3016:

Line 3013: delete from FV_TP_TS_AMT_DATA where payment_instruction_id = p_instruction_id;

3009:
3010: IF pay_instr_data_csr%FOUND THEN -- If Row Found Then Only Process Further
3011:
3012: -- delete from FV_TP_TS_AMT_DATA to refresh data
3013: delete from FV_TP_TS_AMT_DATA where payment_instruction_id = p_instruction_id;
3014:
3015: l_org_id:=l_pay_instr_rec.org_id;-- Extracting Org_ID
3016:
3017:

Line 3356: -- delete from FV_TP_TS_AMT_DATA to refresh data

3352: FETCH pay_instr_data_csr INTO l_pay_instr_rec; -- Getting Instruction Data
3353:
3354: IF pay_instr_data_csr%FOUND THEN -- If Row Found Then Only Process Further
3355:
3356: -- delete from FV_TP_TS_AMT_DATA to refresh data
3357: delete from FV_TP_TS_AMT_DATA where payment_instruction_id = p_instruction_id;
3358:
3359: l_org_id:=l_pay_instr_rec.org_id;-- Extracting Org_ID
3360:

Line 3357: delete from FV_TP_TS_AMT_DATA where payment_instruction_id = p_instruction_id;

3353:
3354: IF pay_instr_data_csr%FOUND THEN -- If Row Found Then Only Process Further
3355:
3356: -- delete from FV_TP_TS_AMT_DATA to refresh data
3357: delete from FV_TP_TS_AMT_DATA where payment_instruction_id = p_instruction_id;
3358:
3359: l_org_id:=l_pay_instr_rec.org_id;-- Extracting Org_ID
3360:
3361: -- Do IBY_PAYMENT_FORMAT_VAL_PVT.SUPPLIER_TYPE at Payment Instruction Level

Line 3655: -- delete from FV_TP_TS_AMT_DATA to refresh data

3651: FETCH pay_instr_data_csr INTO l_pay_instr_rec; -- Getting Instruction Data
3652:
3653: IF pay_instr_data_csr%FOUND THEN -- If Row Found Then Only Process Further
3654:
3655: -- delete from FV_TP_TS_AMT_DATA to refresh data
3656: delete from FV_TP_TS_AMT_DATA where payment_instruction_id = p_instruction_id;
3657:
3658: l_org_id:=l_pay_instr_rec.org_id;-- Extracting Org_ID
3659:

Line 3656: delete from FV_TP_TS_AMT_DATA where payment_instruction_id = p_instruction_id;

3652:
3653: IF pay_instr_data_csr%FOUND THEN -- If Row Found Then Only Process Further
3654:
3655: -- delete from FV_TP_TS_AMT_DATA to refresh data
3656: delete from FV_TP_TS_AMT_DATA where payment_instruction_id = p_instruction_id;
3657:
3658: l_org_id:=l_pay_instr_rec.org_id;-- Extracting Org_ID
3659:
3660: -- Do IBY_PAYMENT_FORMAT_VAL_PVT.SUPPLIER_TYPE at Payment Instruction Level

Line 3952: -- delete from FV_TP_TS_AMT_DATA to refresh data

3948: FETCH pay_instr_data_csr INTO l_pay_instr_rec; -- Getting Instruction Data
3949:
3950: IF pay_instr_data_csr%FOUND THEN -- If Row Found Then Only Process Further
3951:
3952: -- delete from FV_TP_TS_AMT_DATA to refresh data
3953: delete from FV_TP_TS_AMT_DATA where payment_instruction_id = p_instruction_id;
3954:
3955: l_org_id:=l_pay_instr_rec.org_id;-- Extracting Org_ID
3956:

Line 3953: delete from FV_TP_TS_AMT_DATA where payment_instruction_id = p_instruction_id;

3949:
3950: IF pay_instr_data_csr%FOUND THEN -- If Row Found Then Only Process Further
3951:
3952: -- delete from FV_TP_TS_AMT_DATA to refresh data
3953: delete from FV_TP_TS_AMT_DATA where payment_instruction_id = p_instruction_id;
3954:
3955: l_org_id:=l_pay_instr_rec.org_id;-- Extracting Org_ID
3956:
3957: -- Do IBY_PAYMENT_FORMAT_VAL_PVT.SUPPLIER_TYPE at Payment Instruction Level

Line 4210: -- delete from FV_TP_TS_AMT_DATA to refresh data

4206: FETCH pay_instr_data_csr INTO l_pay_instr_rec; -- Getting Instruction Data
4207:
4208: IF pay_instr_data_csr%FOUND THEN -- If Row Found Then Only Process Further
4209:
4210: -- delete from FV_TP_TS_AMT_DATA to refresh data
4211: delete from FV_TP_TS_AMT_DATA where payment_instruction_id = p_instruction_id;
4212:
4213: l_org_id:=l_pay_instr_rec.org_id;-- Extracting Org_ID
4214:

Line 4211: delete from FV_TP_TS_AMT_DATA where payment_instruction_id = p_instruction_id;

4207:
4208: IF pay_instr_data_csr%FOUND THEN -- If Row Found Then Only Process Further
4209:
4210: -- delete from FV_TP_TS_AMT_DATA to refresh data
4211: delete from FV_TP_TS_AMT_DATA where payment_instruction_id = p_instruction_id;
4212:
4213: l_org_id:=l_pay_instr_rec.org_id;-- Extracting Org_ID
4214:
4215: -- Do IBY_PAYMENT_FORMAT_VAL_PVT.SUPPLIER_TYPE at Payment Instruction Level

Line 4535: -- delete from FV_TP_TS_AMT_DATA to refresh data

4531: FETCH pay_instr_data_csr INTO l_pay_instr_rec; -- Getting Instruction Data
4532:
4533: IF pay_instr_data_csr%FOUND THEN -- If Row Found Then Only Process Further
4534:
4535: -- delete from FV_TP_TS_AMT_DATA to refresh data
4536: delete from FV_TP_TS_AMT_DATA where payment_instruction_id = p_instruction_id;
4537:
4538: l_org_id:=l_pay_instr_rec.org_id;-- Extracting Org_ID
4539:

Line 4536: delete from FV_TP_TS_AMT_DATA where payment_instruction_id = p_instruction_id;

4532:
4533: IF pay_instr_data_csr%FOUND THEN -- If Row Found Then Only Process Further
4534:
4535: -- delete from FV_TP_TS_AMT_DATA to refresh data
4536: delete from FV_TP_TS_AMT_DATA where payment_instruction_id = p_instruction_id;
4537:
4538: l_org_id:=l_pay_instr_rec.org_id;-- Extracting Org_ID
4539:
4540: -- Do IBY_PAYMENT_FORMAT_VAL_PVT.SUPPLIER_TYPE at Payment Instruction Level