DBA Data[Home] [Help]

APPS.IEX_PAYMENTS_PUB dependencies on FND_GLOBAL

Line 9: G_LOGIN_ID NUMBER; -- := FND_GLOBAL.Conc_Login_Id;

5:
6: G_APP_ID CONSTANT NUMBER := 695;
7: G_PKG_NAME CONSTANT VARCHAR2(30):= 'IEX_PAYMENTS_PUB';
8: G_FILE_NAME CONSTANT VARCHAR2(12) := 'iexpypyb.pls';
9: G_LOGIN_ID NUMBER; -- := FND_GLOBAL.Conc_Login_Id;
10: G_PROGRAM_ID NUMBER; -- := FND_GLOBAL.Conc_Program_Id;
11: G_USER_ID NUMBER; -- := FND_GLOBAL.User_Id;
12: G_REQUEST_ID NUMBER; -- := FND_GLOBAL.Conc_Request_Id;
13: G_ONLINE_CCPAY varchar2(5) := NVL(fnd_profile.value('IEX_ONLINE_CCPAY'),'N'); -- Fix a bug 5897567

Line 10: G_PROGRAM_ID NUMBER; -- := FND_GLOBAL.Conc_Program_Id;

6: G_APP_ID CONSTANT NUMBER := 695;
7: G_PKG_NAME CONSTANT VARCHAR2(30):= 'IEX_PAYMENTS_PUB';
8: G_FILE_NAME CONSTANT VARCHAR2(12) := 'iexpypyb.pls';
9: G_LOGIN_ID NUMBER; -- := FND_GLOBAL.Conc_Login_Id;
10: G_PROGRAM_ID NUMBER; -- := FND_GLOBAL.Conc_Program_Id;
11: G_USER_ID NUMBER; -- := FND_GLOBAL.User_Id;
12: G_REQUEST_ID NUMBER; -- := FND_GLOBAL.Conc_Request_Id;
13: G_ONLINE_CCPAY varchar2(5) := NVL(fnd_profile.value('IEX_ONLINE_CCPAY'),'N'); -- Fix a bug 5897567
14:

Line 11: G_USER_ID NUMBER; -- := FND_GLOBAL.User_Id;

7: G_PKG_NAME CONSTANT VARCHAR2(30):= 'IEX_PAYMENTS_PUB';
8: G_FILE_NAME CONSTANT VARCHAR2(12) := 'iexpypyb.pls';
9: G_LOGIN_ID NUMBER; -- := FND_GLOBAL.Conc_Login_Id;
10: G_PROGRAM_ID NUMBER; -- := FND_GLOBAL.Conc_Program_Id;
11: G_USER_ID NUMBER; -- := FND_GLOBAL.User_Id;
12: G_REQUEST_ID NUMBER; -- := FND_GLOBAL.Conc_Request_Id;
13: G_ONLINE_CCPAY varchar2(5) := NVL(fnd_profile.value('IEX_ONLINE_CCPAY'),'N'); -- Fix a bug 5897567
14:
15:

Line 12: G_REQUEST_ID NUMBER; -- := FND_GLOBAL.Conc_Request_Id;

8: G_FILE_NAME CONSTANT VARCHAR2(12) := 'iexpypyb.pls';
9: G_LOGIN_ID NUMBER; -- := FND_GLOBAL.Conc_Login_Id;
10: G_PROGRAM_ID NUMBER; -- := FND_GLOBAL.Conc_Program_Id;
11: G_USER_ID NUMBER; -- := FND_GLOBAL.User_Id;
12: G_REQUEST_ID NUMBER; -- := FND_GLOBAL.Conc_Request_Id;
13: G_ONLINE_CCPAY varchar2(5) := NVL(fnd_profile.value('IEX_ONLINE_CCPAY'),'N'); -- Fix a bug 5897567
14:
15:
16: procedure validate_input(

Line 818: P_LAST_UPDATED_BY => FND_GLOBAL.User_Id,

814: P_PAYMENT_ID => l_payment_id,
815: P_OBJECT_VERSION_NUMBER => 1.0,
816: P_PROGRAM_ID => 695,
817: P_LAST_UPDATE_DATE => sysdate,
818: P_LAST_UPDATED_BY => FND_GLOBAL.User_Id,
819: P_LAST_UPDATE_LOGIN => G_LOGIN_ID,
820: P_CREATION_DATE => sysdate,
821: P_CREATED_BY => FND_GLOBAL.User_Id,
822: P_PAYMENT_METHOD_ID => null,

Line 821: P_CREATED_BY => FND_GLOBAL.User_Id,

817: P_LAST_UPDATE_DATE => sysdate,
818: P_LAST_UPDATED_BY => FND_GLOBAL.User_Id,
819: P_LAST_UPDATE_LOGIN => G_LOGIN_ID,
820: P_CREATION_DATE => sysdate,
821: P_CREATED_BY => FND_GLOBAL.User_Id,
822: P_PAYMENT_METHOD_ID => null,
823: P_PAYMENT_METHOD => P_PMTINSTR_REC.USE_INSTRUMENT,
824: P_IPAYMENT_TRANS_ID => null,
825: P_IPAYMENT_STATUS => null,

Line 1090: P_LAST_UPDATED_BY => FND_GLOBAL.User_Id,

1086: IEX_PAY_RECEIPT_XREF_PKG.INSERT_ROW(
1087: X_ROWID => l_rowid,
1088: P_PAY_RECEIPT_XREF_ID => l_pay_receipt_ref_id,
1089: P_LAST_UPDATE_DATE => sysdate,
1090: P_LAST_UPDATED_BY => FND_GLOBAL.User_Id,
1091: P_LAST_UPDATE_LOGIN => G_LOGIN_ID,
1092: P_CREATION_DATE => sysdate,
1093: P_CREATED_BY => FND_GLOBAL.User_Id,
1094: P_PROGRAM_ID => 695,

Line 1093: P_CREATED_BY => FND_GLOBAL.User_Id,

1089: P_LAST_UPDATE_DATE => sysdate,
1090: P_LAST_UPDATED_BY => FND_GLOBAL.User_Id,
1091: P_LAST_UPDATE_LOGIN => G_LOGIN_ID,
1092: P_CREATION_DATE => sysdate,
1093: P_CREATED_BY => FND_GLOBAL.User_Id,
1094: P_PROGRAM_ID => 695,
1095: P_OBJECT_VERSION_NUMBER => 1.0,
1096: P_PAYMENT_ID => l_payment_id,
1097: P_CASH_RECEIPT_ID => l_cr_id);

Line 1377: P_LAST_UPDATED_BY => FND_GLOBAL.User_Id,

1373: IEX_DEL_PAY_XREF_PKG.INSERT_ROW(
1374: X_ROWID => l_rowid,
1375: P_DEL_PAY_ID => l_del_pay_ref_id,
1376: P_LAST_UPDATE_DATE => sysdate,
1377: P_LAST_UPDATED_BY => FND_GLOBAL.User_Id,
1378: P_LAST_UPDATE_LOGIN => G_LOGIN_ID,
1379: P_CREATION_DATE => sysdate,
1380: P_CREATED_BY => FND_GLOBAL.User_Id,
1381: P_PROGRAM_ID => 695,

Line 1380: P_CREATED_BY => FND_GLOBAL.User_Id,

1376: P_LAST_UPDATE_DATE => sysdate,
1377: P_LAST_UPDATED_BY => FND_GLOBAL.User_Id,
1378: P_LAST_UPDATE_LOGIN => G_LOGIN_ID,
1379: P_CREATION_DATE => sysdate,
1380: P_CREATED_BY => FND_GLOBAL.User_Id,
1381: P_PROGRAM_ID => 695,
1382: P_OBJECT_VERSION_NUMBER => 1.0,
1383: P_DELINQUENCY_ID => l_del_id,
1384: P_PAYMENT_ID => l_payment_id);

Line 1409: P_LAST_UPDATED_BY => FND_GLOBAL.User_Id,

1405: IEX_PAY_RECEIPT_XREF_PKG.Insert_Row(
1406: X_ROWID => l_rowid,
1407: P_PAY_RECEIPT_XREF_ID => l_pay_receipt_ref_id,
1408: P_LAST_UPDATE_DATE => sysdate,
1409: P_LAST_UPDATED_BY => FND_GLOBAL.User_Id,
1410: P_LAST_UPDATE_LOGIN => G_LOGIN_ID,
1411: P_CREATION_DATE => sysdate,
1412: P_CREATED_BY => FND_GLOBAL.User_Id,
1413: P_PROGRAM_ID => 695,

Line 1412: P_CREATED_BY => FND_GLOBAL.User_Id,

1408: P_LAST_UPDATE_DATE => sysdate,
1409: P_LAST_UPDATED_BY => FND_GLOBAL.User_Id,
1410: P_LAST_UPDATE_LOGIN => G_LOGIN_ID,
1411: P_CREATION_DATE => sysdate,
1412: P_CREATED_BY => FND_GLOBAL.User_Id,
1413: P_PROGRAM_ID => 695,
1414: P_OBJECT_VERSION_NUMBER => 1.0,
1415: P_PAYMENT_ID => l_payment_id,
1416: P_CASH_RECEIPT_ID => l_cr_id);

Line 1525: P_LAST_UPDATED_BY => FND_GLOBAL.User_Id,

1521: IEX_DEL_PAY_XREF_PKG.INSERT_ROW(
1522: X_ROWID => l_rowid,
1523: P_DEL_PAY_ID => l_del_pay_ref_id,
1524: P_LAST_UPDATE_DATE => sysdate,
1525: P_LAST_UPDATED_BY => FND_GLOBAL.User_Id,
1526: P_LAST_UPDATE_LOGIN => G_LOGIN_ID,
1527: P_CREATION_DATE => sysdate,
1528: P_CREATED_BY => FND_GLOBAL.User_Id,
1529: P_PROGRAM_ID => 695,

Line 1528: P_CREATED_BY => FND_GLOBAL.User_Id,

1524: P_LAST_UPDATE_DATE => sysdate,
1525: P_LAST_UPDATED_BY => FND_GLOBAL.User_Id,
1526: P_LAST_UPDATE_LOGIN => G_LOGIN_ID,
1527: P_CREATION_DATE => sysdate,
1528: P_CREATED_BY => FND_GLOBAL.User_Id,
1529: P_PROGRAM_ID => 695,
1530: P_OBJECT_VERSION_NUMBER => 1.0,
1531: P_DELINQUENCY_ID => l_del_id,
1532: P_PAYMENT_ID => l_payment_id);

Line 1559: P_LAST_UPDATED_BY => FND_GLOBAL.User_Id,

1555: IEX_PAY_RECEIPT_XREF_PKG.Insert_Row(
1556: X_ROWID => l_rowid,
1557: P_PAY_RECEIPT_XREF_ID => l_pay_receipt_ref_id,
1558: P_LAST_UPDATE_DATE => sysdate,
1559: P_LAST_UPDATED_BY => FND_GLOBAL.User_Id,
1560: P_LAST_UPDATE_LOGIN => G_LOGIN_ID,
1561: P_CREATION_DATE => sysdate,
1562: P_CREATED_BY => FND_GLOBAL.User_Id,
1563: P_PROGRAM_ID => 695,

Line 1562: P_CREATED_BY => FND_GLOBAL.User_Id,

1558: P_LAST_UPDATE_DATE => sysdate,
1559: P_LAST_UPDATED_BY => FND_GLOBAL.User_Id,
1560: P_LAST_UPDATE_LOGIN => G_LOGIN_ID,
1561: P_CREATION_DATE => sysdate,
1562: P_CREATED_BY => FND_GLOBAL.User_Id,
1563: P_PROGRAM_ID => 695,
1564: P_OBJECT_VERSION_NUMBER => 1.0,
1565: P_PAYMENT_ID => l_payment_id,
1566: P_CASH_RECEIPT_ID => l_cr_id);

Line 2427: P_LAST_UPDATED_BY => FND_GLOBAL.User_Id,

2423: P_PAYMENT_ID => l_payment_id,
2424: P_OBJECT_VERSION_NUMBER => 1.0,
2425: P_PROGRAM_ID => 695,
2426: P_LAST_UPDATE_DATE => sysdate,
2427: P_LAST_UPDATED_BY => FND_GLOBAL.User_Id,
2428: P_LAST_UPDATE_LOGIN => G_LOGIN_ID,
2429: P_CREATION_DATE => sysdate,
2430: P_CREATED_BY => FND_GLOBAL.User_Id,
2431: P_PAYMENT_METHOD_ID => l_pmtinstr_rec.PmtInstr_ID,

Line 2430: P_CREATED_BY => FND_GLOBAL.User_Id,

2426: P_LAST_UPDATE_DATE => sysdate,
2427: P_LAST_UPDATED_BY => FND_GLOBAL.User_Id,
2428: P_LAST_UPDATE_LOGIN => G_LOGIN_ID,
2429: P_CREATION_DATE => sysdate,
2430: P_CREATED_BY => FND_GLOBAL.User_Id,
2431: P_PAYMENT_METHOD_ID => l_pmtinstr_rec.PmtInstr_ID,
2432: P_PAYMENT_METHOD => P_PMTINSTR_REC.USE_INSTRUMENT,
2433: P_IPAYMENT_TRANS_ID => l_reqresp_rec.trxn_id,
2434: P_IPAYMENT_STATUS => l_reqresp_rec.response.status,

Line 2565: P_LAST_UPDATED_BY => FND_GLOBAL.User_Id,

2561: IEX_PAY_OKL_XREF_PKG.Insert_Row(
2562: X_ROWID => l_rowid,
2563: P_PAY_OKL_XREF_ID => l_pay_okl_ref_id,
2564: P_LAST_UPDATE_DATE => sysdate,
2565: P_LAST_UPDATED_BY => FND_GLOBAL.User_Id,
2566: P_LAST_UPDATE_LOGIN => G_LOGIN_ID,
2567: P_CREATION_DATE => sysdate,
2568: P_CREATED_BY => FND_GLOBAL.User_Id,
2569: P_PROGRAM_ID => 695,

Line 2568: P_CREATED_BY => FND_GLOBAL.User_Id,

2564: P_LAST_UPDATE_DATE => sysdate,
2565: P_LAST_UPDATED_BY => FND_GLOBAL.User_Id,
2566: P_LAST_UPDATE_LOGIN => G_LOGIN_ID,
2567: P_CREATION_DATE => sysdate,
2568: P_CREATED_BY => FND_GLOBAL.User_Id,
2569: P_PROGRAM_ID => 695,
2570: P_OBJECT_VERSION_NUMBER => 1.0,
2571: P_PAYMENT_ID => l_payment_id,
2572: P_CNSLD_INVOICE_ID => P_PMTDTLS_TBL(i).CNSLD_INVOICE_ID,

Line 2639: P_LAST_UPDATED_BY => FND_GLOBAL.User_Id,

2635: IEX_PAY_OKL_XREF_PKG.Insert_Row(
2636: X_ROWID => l_rowid,
2637: P_PAY_OKL_XREF_ID => l_pay_okl_ref_id,
2638: P_LAST_UPDATE_DATE => sysdate,
2639: P_LAST_UPDATED_BY => FND_GLOBAL.User_Id,
2640: P_LAST_UPDATE_LOGIN => G_LOGIN_ID,
2641: P_CREATION_DATE => sysdate,
2642: P_CREATED_BY => FND_GLOBAL.User_Id,
2643: P_PROGRAM_ID => 695,

Line 2642: P_CREATED_BY => FND_GLOBAL.User_Id,

2638: P_LAST_UPDATE_DATE => sysdate,
2639: P_LAST_UPDATED_BY => FND_GLOBAL.User_Id,
2640: P_LAST_UPDATE_LOGIN => G_LOGIN_ID,
2641: P_CREATION_DATE => sysdate,
2642: P_CREATED_BY => FND_GLOBAL.User_Id,
2643: P_PROGRAM_ID => 695,
2644: P_OBJECT_VERSION_NUMBER => 1.0,
2645: P_PAYMENT_ID => l_payment_id,
2646: p_CNSLD_INVOICE_ID => null,

Line 2891: G_LOGIN_ID := FND_GLOBAL.Conc_Login_Id;

2887: END IF;
2888: END;
2889: begin
2890: PG_DEBUG := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
2891: G_LOGIN_ID := FND_GLOBAL.Conc_Login_Id;
2892: G_PROGRAM_ID := FND_GLOBAL.Conc_Program_Id;
2893: G_USER_ID := FND_GLOBAL.User_Id;
2894: G_REQUEST_ID := FND_GLOBAL.Conc_Request_Id;
2895: END ;

Line 2892: G_PROGRAM_ID := FND_GLOBAL.Conc_Program_Id;

2888: END;
2889: begin
2890: PG_DEBUG := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
2891: G_LOGIN_ID := FND_GLOBAL.Conc_Login_Id;
2892: G_PROGRAM_ID := FND_GLOBAL.Conc_Program_Id;
2893: G_USER_ID := FND_GLOBAL.User_Id;
2894: G_REQUEST_ID := FND_GLOBAL.Conc_Request_Id;
2895: END ;

Line 2893: G_USER_ID := FND_GLOBAL.User_Id;

2889: begin
2890: PG_DEBUG := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
2891: G_LOGIN_ID := FND_GLOBAL.Conc_Login_Id;
2892: G_PROGRAM_ID := FND_GLOBAL.Conc_Program_Id;
2893: G_USER_ID := FND_GLOBAL.User_Id;
2894: G_REQUEST_ID := FND_GLOBAL.Conc_Request_Id;
2895: END ;

Line 2894: G_REQUEST_ID := FND_GLOBAL.Conc_Request_Id;

2890: PG_DEBUG := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
2891: G_LOGIN_ID := FND_GLOBAL.Conc_Login_Id;
2892: G_PROGRAM_ID := FND_GLOBAL.Conc_Program_Id;
2893: G_USER_ID := FND_GLOBAL.User_Id;
2894: G_REQUEST_ID := FND_GLOBAL.Conc_Request_Id;
2895: END ;