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.

[Home] [Help]

APPS.IBY_PAYMENT_FORMAT_VAL_PUB dependencies on FV_TP_TS_AMT_DATA

Line 116: -- delete from FV_TP_TS_AMT_DATA to refresh data

112:
113:
114: IF pay_instr_data_csr%FOUND THEN -- If Row Found Then Only Process Further
115:
116: -- delete from FV_TP_TS_AMT_DATA to refresh data
117: delete from FV_TP_TS_AMT_DATA where payment_instruction_id = p_instruction_id;
118:
119: -- Do validation of the Federal Identification Number
120: IBY_PAYMENT_FORMAT_VAL_PVT.FEDERAL_ID_NUMBER(

Line 117: delete from FV_TP_TS_AMT_DATA where payment_instruction_id = p_instruction_id;

113:
114: IF pay_instr_data_csr%FOUND THEN -- If Row Found Then Only Process Further
115:
116: -- delete from FV_TP_TS_AMT_DATA to refresh data
117: delete from FV_TP_TS_AMT_DATA where payment_instruction_id = p_instruction_id;
118:
119: -- Do validation of the Federal Identification Number
120: IBY_PAYMENT_FORMAT_VAL_PVT.FEDERAL_ID_NUMBER(
121: l_format_name,

Line 462: -- delete from FV_TP_TS_AMT_DATA to refresh data

458: FETCH pay_instr_data_csr INTO l_pay_instr_rec; -- Getting Instruction Data
459:
460: IF pay_instr_data_csr%FOUND THEN -- If Row Found Then Only Process Further
461:
462: -- delete from FV_TP_TS_AMT_DATA to refresh data
463: delete from FV_TP_TS_AMT_DATA where payment_instruction_id = p_instruction_id;
464:
465: l_org_id:=l_pay_instr_rec.org_id;-- Extracting Org_Id
466:

Line 463: delete from FV_TP_TS_AMT_DATA where payment_instruction_id = p_instruction_id;

459:
460: IF pay_instr_data_csr%FOUND THEN -- If Row Found Then Only Process Further
461:
462: -- delete from FV_TP_TS_AMT_DATA to refresh data
463: delete from FV_TP_TS_AMT_DATA where payment_instruction_id = p_instruction_id;
464:
465: l_org_id:=l_pay_instr_rec.org_id;-- Extracting Org_Id
466:
467: -- Do validation of Agency Id Abbreviation

Line 800: -- delete from FV_TP_TS_AMT_DATA to refresh data

796: FETCH pay_instr_data_csr INTO l_pay_instr_rec; -- Getting Instruction Data
797:
798: IF pay_instr_data_csr%FOUND THEN -- If Row Found Then Only Process Further
799:
800: -- delete from FV_TP_TS_AMT_DATA to refresh data
801: delete from FV_TP_TS_AMT_DATA where payment_instruction_id = p_instruction_id;
802:
803: -- Do validation of the Federal Identification Number
804: IBY_PAYMENT_FORMAT_VAL_PVT.FEDERAL_ID_NUMBER(

Line 801: delete from FV_TP_TS_AMT_DATA where payment_instruction_id = p_instruction_id;

797:
798: IF pay_instr_data_csr%FOUND THEN -- If Row Found Then Only Process Further
799:
800: -- delete from FV_TP_TS_AMT_DATA to refresh data
801: delete from FV_TP_TS_AMT_DATA where payment_instruction_id = p_instruction_id;
802:
803: -- Do validation of the Federal Identification Number
804: IBY_PAYMENT_FORMAT_VAL_PVT.FEDERAL_ID_NUMBER(
805: l_format_name,

Line 1169: -- delete from FV_TP_TS_AMT_DATA to refresh data

1165: FETCH pay_instr_data_csr INTO l_pay_instr_rec; -- Getting Instruction Data
1166:
1167: IF pay_instr_data_csr%FOUND THEN -- If Row Found Then Only Process Further
1168:
1169: -- delete from FV_TP_TS_AMT_DATA to refresh data
1170: delete from FV_TP_TS_AMT_DATA where payment_instruction_id = p_instruction_id;
1171:
1172: l_org_id:=l_pay_instr_rec.org_id;-- Extracting Org_ID
1173:

Line 1170: delete from FV_TP_TS_AMT_DATA where payment_instruction_id = p_instruction_id;

1166:
1167: IF pay_instr_data_csr%FOUND THEN -- If Row Found Then Only Process Further
1168:
1169: -- delete from FV_TP_TS_AMT_DATA to refresh data
1170: delete from FV_TP_TS_AMT_DATA where payment_instruction_id = p_instruction_id;
1171:
1172: l_org_id:=l_pay_instr_rec.org_id;-- Extracting Org_ID
1173:
1174: -- Do validation of Agency Id Abbreviation

Line 1481: -- delete from FV_TP_TS_AMT_DATA to refresh data

1477: FETCH pay_instr_data_csr INTO l_pay_instr_rec; -- Getting Instruction Data
1478:
1479: IF pay_instr_data_csr%FOUND THEN -- If Row Found Then Only Process Further
1480:
1481: -- delete from FV_TP_TS_AMT_DATA to refresh data
1482: delete from FV_TP_TS_AMT_DATA where payment_instruction_id = p_instruction_id;
1483:
1484: l_org_id:=l_pay_instr_rec.org_id;-- Extracting Org_ID
1485:

Line 1482: delete from FV_TP_TS_AMT_DATA where payment_instruction_id = p_instruction_id;

1478:
1479: IF pay_instr_data_csr%FOUND THEN -- If Row Found Then Only Process Further
1480:
1481: -- delete from FV_TP_TS_AMT_DATA to refresh data
1482: delete from FV_TP_TS_AMT_DATA where payment_instruction_id = p_instruction_id;
1483:
1484: l_org_id:=l_pay_instr_rec.org_id;-- Extracting Org_ID
1485:
1486: -- Do validation of Agency Id Abbreviation

Line 1840: -- delete from FV_TP_TS_AMT_DATA to refresh data

1836: FETCH pay_instr_data_csr INTO l_pay_instr_rec; -- Getting Instruction Data
1837:
1838: IF pay_instr_data_csr%FOUND THEN -- If Row Found Then Only Process Further
1839:
1840: -- delete from FV_TP_TS_AMT_DATA to refresh data
1841: delete from FV_TP_TS_AMT_DATA where payment_instruction_id = p_instruction_id;
1842:
1843: l_org_id:=l_pay_instr_rec.org_id;-- Extracting Org_ID
1844:

Line 1841: delete from FV_TP_TS_AMT_DATA where payment_instruction_id = p_instruction_id;

1837:
1838: IF pay_instr_data_csr%FOUND THEN -- If Row Found Then Only Process Further
1839:
1840: -- delete from FV_TP_TS_AMT_DATA to refresh data
1841: delete from FV_TP_TS_AMT_DATA where payment_instruction_id = p_instruction_id;
1842:
1843: l_org_id:=l_pay_instr_rec.org_id;-- Extracting Org_ID
1844:
1845: -- Do IBY_PAYMENT_FORMAT_VAL_PVT.SUPPLIER_TYPE at Payment Instruction Level

Line 2170: -- delete from FV_TP_TS_AMT_DATA to refresh data

2166: FETCH pay_instr_data_csr INTO l_pay_instr_rec; -- Getting Instruction Data
2167:
2168: IF pay_instr_data_csr%FOUND THEN -- If Row Found Then Only Process Further
2169:
2170: -- delete from FV_TP_TS_AMT_DATA to refresh data
2171: delete from FV_TP_TS_AMT_DATA where payment_instruction_id = p_instruction_id;
2172:
2173: l_org_id:=l_pay_instr_rec.org_id;-- Extracting Org_ID
2174:

Line 2171: delete from FV_TP_TS_AMT_DATA where payment_instruction_id = p_instruction_id;

2167:
2168: IF pay_instr_data_csr%FOUND THEN -- If Row Found Then Only Process Further
2169:
2170: -- delete from FV_TP_TS_AMT_DATA to refresh data
2171: delete from FV_TP_TS_AMT_DATA where payment_instruction_id = p_instruction_id;
2172:
2173: l_org_id:=l_pay_instr_rec.org_id;-- Extracting Org_ID
2174:
2175:

Line 2479: -- delete from FV_TP_TS_AMT_DATA to refresh data

2475: FETCH pay_instr_data_csr INTO l_pay_instr_rec; -- Getting Instruction Data
2476:
2477: IF pay_instr_data_csr%FOUND THEN -- If Row Found Then Only Process Further
2478:
2479: -- delete from FV_TP_TS_AMT_DATA to refresh data
2480: delete from FV_TP_TS_AMT_DATA where payment_instruction_id = p_instruction_id;
2481:
2482: l_org_id:=l_pay_instr_rec.org_id;-- Extracting Org_ID
2483:

Line 2480: delete from FV_TP_TS_AMT_DATA where payment_instruction_id = p_instruction_id;

2476:
2477: IF pay_instr_data_csr%FOUND THEN -- If Row Found Then Only Process Further
2478:
2479: -- delete from FV_TP_TS_AMT_DATA to refresh data
2480: delete from FV_TP_TS_AMT_DATA where payment_instruction_id = p_instruction_id;
2481:
2482: l_org_id:=l_pay_instr_rec.org_id;-- Extracting Org_ID
2483:
2484:

Line 2771: -- delete from FV_TP_TS_AMT_DATA to refresh data

2767: FETCH pay_instr_data_csr INTO l_pay_instr_rec; -- Getting Instruction Data
2768:
2769: IF pay_instr_data_csr%FOUND THEN -- If Row Found Then Only Process Further
2770:
2771: -- delete from FV_TP_TS_AMT_DATA to refresh data
2772: delete from FV_TP_TS_AMT_DATA where payment_instruction_id = p_instruction_id;
2773:
2774: l_org_id:=l_pay_instr_rec.org_id;-- Extracting Org_ID
2775:

Line 2772: delete from FV_TP_TS_AMT_DATA where payment_instruction_id = p_instruction_id;

2768:
2769: IF pay_instr_data_csr%FOUND THEN -- If Row Found Then Only Process Further
2770:
2771: -- delete from FV_TP_TS_AMT_DATA to refresh data
2772: delete from FV_TP_TS_AMT_DATA where payment_instruction_id = p_instruction_id;
2773:
2774: l_org_id:=l_pay_instr_rec.org_id;-- Extracting Org_ID
2775:
2776: -- Do IBY_PAYMENT_FORMAT_VAL_PVT.SUPPLIER_TYPE at Payment Instruction Level

Line 3135: -- delete from FV_TP_TS_AMT_DATA to refresh data

3131: FETCH pay_instr_data_csr INTO l_pay_instr_rec; -- Getting Instruction Data
3132:
3133: IF pay_instr_data_csr%FOUND THEN -- If Row Found Then Only Process Further
3134:
3135: -- delete from FV_TP_TS_AMT_DATA to refresh data
3136: delete from FV_TP_TS_AMT_DATA where payment_instruction_id = p_instruction_id;
3137:
3138: l_org_id:=l_pay_instr_rec.org_id;-- Extracting Org_ID
3139:

Line 3136: delete from FV_TP_TS_AMT_DATA where payment_instruction_id = p_instruction_id;

3132:
3133: IF pay_instr_data_csr%FOUND THEN -- If Row Found Then Only Process Further
3134:
3135: -- delete from FV_TP_TS_AMT_DATA to refresh data
3136: delete from FV_TP_TS_AMT_DATA where payment_instruction_id = p_instruction_id;
3137:
3138: l_org_id:=l_pay_instr_rec.org_id;-- Extracting Org_ID
3139:
3140:

Line 3494: -- delete from FV_TP_TS_AMT_DATA to refresh data

3490: FETCH pay_instr_data_csr INTO l_pay_instr_rec; -- Getting Instruction Data
3491:
3492: IF pay_instr_data_csr%FOUND THEN -- If Row Found Then Only Process Further
3493:
3494: -- delete from FV_TP_TS_AMT_DATA to refresh data
3495: delete from FV_TP_TS_AMT_DATA where payment_instruction_id = p_instruction_id;
3496:
3497: l_org_id:=l_pay_instr_rec.org_id;-- Extracting Org_ID
3498:

Line 3495: delete from FV_TP_TS_AMT_DATA where payment_instruction_id = p_instruction_id;

3491:
3492: IF pay_instr_data_csr%FOUND THEN -- If Row Found Then Only Process Further
3493:
3494: -- delete from FV_TP_TS_AMT_DATA to refresh data
3495: delete from FV_TP_TS_AMT_DATA where payment_instruction_id = p_instruction_id;
3496:
3497: l_org_id:=l_pay_instr_rec.org_id;-- Extracting Org_ID
3498:
3499: -- Do IBY_PAYMENT_FORMAT_VAL_PVT.SUPPLIER_TYPE at Payment Instruction Level

Line 3808: -- delete from FV_TP_TS_AMT_DATA to refresh data

3804: FETCH pay_instr_data_csr INTO l_pay_instr_rec; -- Getting Instruction Data
3805:
3806: IF pay_instr_data_csr%FOUND THEN -- If Row Found Then Only Process Further
3807:
3808: -- delete from FV_TP_TS_AMT_DATA to refresh data
3809: delete from FV_TP_TS_AMT_DATA where payment_instruction_id = p_instruction_id;
3810:
3811: l_org_id:=l_pay_instr_rec.org_id;-- Extracting Org_ID
3812:

Line 3809: delete from FV_TP_TS_AMT_DATA where payment_instruction_id = p_instruction_id;

3805:
3806: IF pay_instr_data_csr%FOUND THEN -- If Row Found Then Only Process Further
3807:
3808: -- delete from FV_TP_TS_AMT_DATA to refresh data
3809: delete from FV_TP_TS_AMT_DATA where payment_instruction_id = p_instruction_id;
3810:
3811: l_org_id:=l_pay_instr_rec.org_id;-- Extracting Org_ID
3812:
3813: -- Do IBY_PAYMENT_FORMAT_VAL_PVT.SUPPLIER_TYPE at Payment Instruction Level

Line 4108: -- delete from FV_TP_TS_AMT_DATA to refresh data

4104: FETCH pay_instr_data_csr INTO l_pay_instr_rec; -- Getting Instruction Data
4105:
4106: IF pay_instr_data_csr%FOUND THEN -- If Row Found Then Only Process Further
4107:
4108: -- delete from FV_TP_TS_AMT_DATA to refresh data
4109: delete from FV_TP_TS_AMT_DATA where payment_instruction_id = p_instruction_id;
4110:
4111: l_org_id:=l_pay_instr_rec.org_id;-- Extracting Org_ID
4112:

Line 4109: delete from FV_TP_TS_AMT_DATA where payment_instruction_id = p_instruction_id;

4105:
4106: IF pay_instr_data_csr%FOUND THEN -- If Row Found Then Only Process Further
4107:
4108: -- delete from FV_TP_TS_AMT_DATA to refresh data
4109: delete from FV_TP_TS_AMT_DATA where payment_instruction_id = p_instruction_id;
4110:
4111: l_org_id:=l_pay_instr_rec.org_id;-- Extracting Org_ID
4112:
4113: -- Do IBY_PAYMENT_FORMAT_VAL_PVT.SUPPLIER_TYPE at Payment Instruction Level

Line 4389: -- delete from FV_TP_TS_AMT_DATA to refresh data

4385: FETCH pay_instr_data_csr INTO l_pay_instr_rec; -- Getting Instruction Data
4386:
4387: IF pay_instr_data_csr%FOUND THEN -- If Row Found Then Only Process Further
4388:
4389: -- delete from FV_TP_TS_AMT_DATA to refresh data
4390: delete from FV_TP_TS_AMT_DATA where payment_instruction_id = p_instruction_id;
4391:
4392: l_org_id:=l_pay_instr_rec.org_id;-- Extracting Org_ID
4393:

Line 4390: delete from FV_TP_TS_AMT_DATA where payment_instruction_id = p_instruction_id;

4386:
4387: IF pay_instr_data_csr%FOUND THEN -- If Row Found Then Only Process Further
4388:
4389: -- delete from FV_TP_TS_AMT_DATA to refresh data
4390: delete from FV_TP_TS_AMT_DATA where payment_instruction_id = p_instruction_id;
4391:
4392: l_org_id:=l_pay_instr_rec.org_id;-- Extracting Org_ID
4393:
4394: -- Do IBY_PAYMENT_FORMAT_VAL_PVT.SUPPLIER_TYPE at Payment Instruction Level

Line 4729: -- delete from FV_TP_TS_AMT_DATA to refresh data

4725: FETCH pay_instr_data_csr INTO l_pay_instr_rec; -- Getting Instruction Data
4726:
4727: IF pay_instr_data_csr%FOUND THEN -- If Row Found Then Only Process Further
4728:
4729: -- delete from FV_TP_TS_AMT_DATA to refresh data
4730: delete from FV_TP_TS_AMT_DATA where payment_instruction_id = p_instruction_id;
4731:
4732: l_org_id:=l_pay_instr_rec.org_id;-- Extracting Org_ID
4733:

Line 4730: delete from FV_TP_TS_AMT_DATA where payment_instruction_id = p_instruction_id;

4726:
4727: IF pay_instr_data_csr%FOUND THEN -- If Row Found Then Only Process Further
4728:
4729: -- delete from FV_TP_TS_AMT_DATA to refresh data
4730: delete from FV_TP_TS_AMT_DATA where payment_instruction_id = p_instruction_id;
4731:
4732: l_org_id:=l_pay_instr_rec.org_id;-- Extracting Org_ID
4733:
4734: -- Do IBY_PAYMENT_FORMAT_VAL_PVT.SUPPLIER_TYPE at Payment Instruction Level