APPS.AP_WEB_CREDIT_CARD_WF dependencies on ICX_SEC

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

1463: l_debugInfo := 'Get WF EMPLOYEE_ID Item Attribute';
1464: --------------------------------------------------------------
1465: l_employeeID := WF_ENGINE.GetItemAttrNumber(l_itemType, l_itemKey, 'EMPLOYEE_ID');
1466:
1467: l_dateFormat := icx_sec.getID(icx_sec.PV_DATE_FORMAT);
1468:
1469: l_debugInfo := 'Loop over all the Disputed charges';
1470:
1471: IF (NOT AP_WEB_DB_CCARD_PKG.GetDisputedCcardTrxnCursor(l_cardProgramId,

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

1675: --------------------------------------------------------------
1676: l_chargeType := WF_ENGINE.GetItemAttrText(l_itemType, l_itemKey, 'CHARGE_TYPE');
1677:
1678:
1679: l_dateFormat := icx_sec.getID(icx_sec.PV_DATE_FORMAT);
1680:
1681: l_debugInfo := 'Loop over all the Unsubmitted charges ';
1682:
1683: IF (NOT AP_WEB_DB_CCARD_PKG.GetUnsubmittedCcardTrxnCursor(l_cardProgramId,

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

1949: --------------------------------------------------------------
1950: l_debugInfo := 'Get WF EMPLOYEE_ID Item Attribute';
1951: --------------------------------------------------------------
1952: l_employeeId := WF_ENGINE.GetItemAttrNumber(l_itemType, l_itemKey, 'EMPLOYEE_ID');
1953: l_dateFormat := icx_sec.getID(icx_sec.PV_DATE_FORMAT);
1954:
1955: l_debugInfo := 'Loop over all the Dunning Charges ';
1956:
1957: IF (NOT AP_WEB_DB_CCARD_PKG.GetDunningCcardTrxnCursor(l_cardProgramId,

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

2250: l_debugInfo := 'Get Charge Type Item Attribute';
2251: --------------------------------------------------------------
2252: l_chargeType := WF_ENGINE.GetItemAttrText(l_itemType, l_itemKey, 'CHARGE_TYPE');
2253:
2254: l_dateFormat := icx_sec.getID(icx_sec.PV_DATE_FORMAT);
2255:
2256: IF (NOT AP_WEB_DB_CCARD_PKG.GetTotalUnsubmittedCCCursor(l_cardProgramId,
2257: l_employeeId, l_billedStartDate,
2258: l_billedEndDate, l_minimumAmount, l_chargeType, l_Total_cursor)) THEN

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

2370: else
2371: l_max_bucket := to_number(substr(l_max_bucket1,3));
2372: end if;
2373:
2374: l_dateFormat := icx_sec.getID(icx_sec.PV_DATE_FORMAT);
2375:
2376: IF (NOT AP_WEB_DB_CCARD_PKG.GetTotalCcardTrxnCursor(l_cardProgramId,
2377: l_employeeId, l_min_bucket, l_max_bucket,
2378: l_Total_cursor)) THEN

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

2547: --------------------------------------------------------------
2548: l_debugInfo := 'Get WF EMPLOYEE_ID Item Attribute';
2549: --------------------------------------------------------------
2550: l_employeeId := WF_ENGINE.GetItemAttrNumber(l_itemType, l_itemKey, 'EMPLOYEE_ID');
2551: l_dateFormat := icx_sec.getID(icx_sec.PV_DATE_FORMAT);
2552:
2553: l_debugInfo := 'Loop over all the Dunning Charges ';
2554:
2555: AP_WEB_EXPENSE_WF.GetManager(l_employeeId, l_supervisor_id);

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

2819: --------------------------------------------------------------
2820: l_debugInfo := 'Get WF EMPLOYEE_ID Item Attribute';
2821: --------------------------------------------------------------
2822: l_employeeId := WF_ENGINE.GetItemAttrNumber(l_itemType, l_itemKey, 'EMPLOYEE_ID');
2823: l_dateFormat := icx_sec.getID(icx_sec.PV_DATE_FORMAT);
2824:
2825: l_debugInfo := 'Loop over all the Dunning Charges ';
2826:
2827: l_dunning_number := WF_ENGINE.GetItemAttrNumber(l_itemType, l_itemKey, 'DUNNING_NUMBER'); --Bug 3337388

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

3482: --------------------------------------------------------------
3483: l_debugInfo := 'Get WF EMPLOYEE_ID Item Attribute';
3484: --------------------------------------------------------------
3485: l_employeeId := WF_ENGINE.GetItemAttrNumber(l_itemType, l_itemKey, 'EMPLOYEE_ID');
3486: l_dateFormat := icx_sec.getID(icx_sec.PV_DATE_FORMAT);
3487:
3488: l_debugInfo := 'Loop over all the Dunning Charges ';
3489:
3490: l_dunning_number := WF_ENGINE.GetItemAttrNumber(l_itemType, l_itemKey, 'DUNNING_NUMBER');

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

3663: --------------------------------------------------------------
3664: l_debugInfo := 'Get WF EMPLOYEE_ID Item Attribute';
3665: --------------------------------------------------------------
3666: l_employeeId := WF_ENGINE.GetItemAttrNumber(l_itemType, l_itemKey, 'EMPLOYEE_ID');
3667: l_dateFormat := icx_sec.getID(icx_sec.PV_DATE_FORMAT);
3668:
3669: l_debugInfo := 'Loop over all the Dunning Charges ';
3670:
3671: AP_WEB_EXPENSE_WF.GetManager(l_employeeId, l_supervisor_id);

Line 3792: nvl(icx_sec.g_date_format,

3788: WF_ENGINE.SetItemAttrText( l_itemType,
3789: l_itemKey,
3790: 'DATE2',
3791: FND_DATE.date_to_canonical(to_date(p_endDate,
3792: nvl(icx_sec.g_date_format,
3793: icx_sec.getNLS_PARAMETER('NLS_DATE_FORMAT')
3794: )
3795: )
3796: )

Line 3793: icx_sec.getNLS_PARAMETER('NLS_DATE_FORMAT')

3789: l_itemKey,
3790: 'DATE2',
3791: FND_DATE.date_to_canonical(to_date(p_endDate,
3792: nvl(icx_sec.g_date_format,
3793: icx_sec.getNLS_PARAMETER('NLS_DATE_FORMAT')
3794: )
3795: )
3796: )
3797: );