APPS.AP_WEB_CREDIT_CARD_WF dependencies on ICX_SEC

Line 1541: l_dateFormat := icx_sec.getID(icx_sec.PV_DATE_FORMAT);

1537: l_debugInfo := 'Get WF EMPLOYEE_ID Item Attribute';
1538: --------------------------------------------------------------
1539: l_employeeID := WF_ENGINE.GetItemAttrNumber(l_itemType, l_itemKey, 'EMPLOYEE_ID');
1540:
1541: l_dateFormat := icx_sec.getID(icx_sec.PV_DATE_FORMAT);
1542:
1543: l_debugInfo := 'Loop over all the Disputed charges';
1544:
1545: IF (NOT AP_WEB_DB_CCARD_PKG.GetDisputedCcardTrxnCursor(l_cardProgramId,

Line 1753: l_dateFormat := icx_sec.getID(icx_sec.PV_DATE_FORMAT);

1749: --------------------------------------------------------------
1750: l_chargeType := WF_ENGINE.GetItemAttrText(l_itemType, l_itemKey, 'CHARGE_TYPE');
1751:
1752:
1753: l_dateFormat := icx_sec.getID(icx_sec.PV_DATE_FORMAT);
1754:
1755: l_debugInfo := 'Loop over all the Unsubmitted charges ';
1756:
1757: IF (NOT AP_WEB_DB_CCARD_PKG.GetUnsubmittedCcardTrxnCursor(l_cardProgramId,

Line 2027: l_dateFormat := icx_sec.getID(icx_sec.PV_DATE_FORMAT);

2023: --------------------------------------------------------------
2024: l_debugInfo := 'Get WF EMPLOYEE_ID Item Attribute';
2025: --------------------------------------------------------------
2026: l_employeeId := WF_ENGINE.GetItemAttrNumber(l_itemType, l_itemKey, 'EMPLOYEE_ID');
2027: l_dateFormat := icx_sec.getID(icx_sec.PV_DATE_FORMAT);
2028:
2029: l_debugInfo := 'Loop over all the Dunning Charges ';
2030:
2031: IF (NOT AP_WEB_DB_CCARD_PKG.GetDunningCcardTrxnCursor(l_cardProgramId,

Line 2328: l_dateFormat := icx_sec.getID(icx_sec.PV_DATE_FORMAT);

2324: l_debugInfo := 'Get Charge Type Item Attribute';
2325: --------------------------------------------------------------
2326: l_chargeType := WF_ENGINE.GetItemAttrText(l_itemType, l_itemKey, 'CHARGE_TYPE');
2327:
2328: l_dateFormat := icx_sec.getID(icx_sec.PV_DATE_FORMAT);
2329:
2330: IF (NOT AP_WEB_DB_CCARD_PKG.GetTotalUnsubmittedCCCursor(l_cardProgramId,
2331: l_employeeId, l_billedStartDate,
2332: l_billedEndDate, l_minimumAmount, l_chargeType, l_Total_cursor)) THEN

Line 2448: l_dateFormat := icx_sec.getID(icx_sec.PV_DATE_FORMAT);

2444: else
2445: l_max_bucket := to_number(substr(l_max_bucket1,3));
2446: end if;
2447:
2448: l_dateFormat := icx_sec.getID(icx_sec.PV_DATE_FORMAT);
2449:
2450: IF (NOT AP_WEB_DB_CCARD_PKG.GetTotalCcardTrxnCursor(l_cardProgramId,
2451: l_employeeId, l_min_bucket, l_max_bucket,
2452: l_Total_cursor)) THEN

Line 2625: l_dateFormat := icx_sec.getID(icx_sec.PV_DATE_FORMAT);

2621: --------------------------------------------------------------
2622: l_debugInfo := 'Get WF EMPLOYEE_ID Item Attribute';
2623: --------------------------------------------------------------
2624: l_employeeId := WF_ENGINE.GetItemAttrNumber(l_itemType, l_itemKey, 'EMPLOYEE_ID');
2625: l_dateFormat := icx_sec.getID(icx_sec.PV_DATE_FORMAT);
2626:
2627: l_debugInfo := 'Loop over all the Dunning Charges ';
2628:
2629: AP_WEB_EXPENSE_WF.GetManager(l_employeeId, l_supervisor_id);

Line 2897: l_dateFormat := icx_sec.getID(icx_sec.PV_DATE_FORMAT);

2893: --------------------------------------------------------------
2894: l_debugInfo := 'Get WF EMPLOYEE_ID Item Attribute';
2895: --------------------------------------------------------------
2896: l_employeeId := WF_ENGINE.GetItemAttrNumber(l_itemType, l_itemKey, 'EMPLOYEE_ID');
2897: l_dateFormat := icx_sec.getID(icx_sec.PV_DATE_FORMAT);
2898:
2899: l_debugInfo := 'Loop over all the Dunning Charges ';
2900:
2901: l_dunning_number := WF_ENGINE.GetItemAttrNumber(l_itemType, l_itemKey, 'DUNNING_NUMBER'); --Bug 3337388

Line 3559: l_dateFormat := icx_sec.getID(icx_sec.PV_DATE_FORMAT);

3555: --------------------------------------------------------------
3556: l_debugInfo := 'Get WF EMPLOYEE_ID Item Attribute';
3557: --------------------------------------------------------------
3558: l_employeeId := WF_ENGINE.GetItemAttrNumber(l_itemType, l_itemKey, 'EMPLOYEE_ID');
3559: l_dateFormat := icx_sec.getID(icx_sec.PV_DATE_FORMAT);
3560:
3561: l_debugInfo := 'Loop over all the Dunning Charges ';
3562:
3563: l_dunning_number := WF_ENGINE.GetItemAttrNumber(l_itemType, l_itemKey, 'DUNNING_NUMBER');

Line 3736: l_dateFormat := icx_sec.getID(icx_sec.PV_DATE_FORMAT);

3732: --------------------------------------------------------------
3733: l_debugInfo := 'Get WF EMPLOYEE_ID Item Attribute';
3734: --------------------------------------------------------------
3735: l_employeeId := WF_ENGINE.GetItemAttrNumber(l_itemType, l_itemKey, 'EMPLOYEE_ID');
3736: l_dateFormat := icx_sec.getID(icx_sec.PV_DATE_FORMAT);
3737:
3738: l_debugInfo := 'Loop over all the Dunning Charges ';
3739:
3740: AP_WEB_EXPENSE_WF.GetManager(l_employeeId, l_supervisor_id);

Line 3861: nvl(icx_sec.g_date_format,

3857: WF_ENGINE.SetItemAttrText( l_itemType,
3858: l_itemKey,
3859: 'DATE2',
3860: FND_DATE.date_to_canonical(to_date(p_endDate,
3861: nvl(icx_sec.g_date_format,
3862: icx_sec.getNLS_PARAMETER('NLS_DATE_FORMAT')
3863: )
3864: )
3865: )

Line 3862: icx_sec.getNLS_PARAMETER('NLS_DATE_FORMAT')

3858: l_itemKey,
3859: 'DATE2',
3860: FND_DATE.date_to_canonical(to_date(p_endDate,
3861: nvl(icx_sec.g_date_format,
3862: icx_sec.getNLS_PARAMETER('NLS_DATE_FORMAT')
3863: )
3864: )
3865: )
3866: );