APPS.AP_WEB_OA_MAINFLOW_PKG dependencies on AP_WEB_DB_CCARD_PKG

Line 17: IF (AP_WEB_DB_CCARD_PKG.ResetCCLines(ReportID)) THEN

13:
14: DeleteReport(ReportID);
15:
16: --reset any remaining personal credit card lines
17: IF (AP_WEB_DB_CCARD_PKG.ResetCCLines(ReportID)) THEN
18: COMMIT;
19: END IF;
20:
21: AP_WEB_UTILITIES_PKG.LogProcedure('AP_WEB_OA_MAINFLOW_PKG',

Line 1016: IF (AP_WEB_DB_CCARD_PKG.UserHasCreditCard(p_employee_id, l_has) AND

1012: p_resp_id => null,
1013: p_apps_id => null);
1014:
1015:
1016: IF (AP_WEB_DB_CCARD_PKG.UserHasCreditCard(p_employee_id, l_has) AND
1017: AP_WEB_DB_HR_INT_PKG.IsPersonCwk(p_employee_id) = 'N' AND
1018: l_has = 'Y' AND l_cCardEnabled = 'Y') THEN
1019: p_is_cc_enabled := 'Y';
1020: ELSE

Line 1439: l_exp_amount AP_WEB_DB_CCARD_PKG.ccTrxn_expensedAmt;

1435: l_idArray AP_WEB_PARENT_PKG.Number_Array;
1436: l_amtArray AP_WEB_PARENT_PKG.number_array;
1437: l_foundArray AP_WEB_PARENT_PKG.boolean_array;
1438: l_debugInfo varchar2(240);
1439: l_exp_amount AP_WEB_DB_CCARD_PKG.ccTrxn_expensedAmt;
1440: l_trxn_id AP_WEB_DB_CCARD_PKG.ccTrxn_trxID;
1441:
1442: BEGIN
1443: l_debugInfo := 'Combine all receipts of the same charge';

Line 1440: l_trxn_id AP_WEB_DB_CCARD_PKG.ccTrxn_trxID;

1436: l_amtArray AP_WEB_PARENT_PKG.number_array;
1437: l_foundArray AP_WEB_PARENT_PKG.boolean_array;
1438: l_debugInfo varchar2(240);
1439: l_exp_amount AP_WEB_DB_CCARD_PKG.ccTrxn_expensedAmt;
1440: l_trxn_id AP_WEB_DB_CCARD_PKG.ccTrxn_trxID;
1441:
1442: BEGIN
1443: l_debugInfo := 'Combine all receipts of the same charge';
1444: for i in 1..p_trxIds.count loop

Line 1468: IF ( NOT AP_WEB_DB_CCARD_PKG.UpdateExpensedAmount(

1464: for i in 1..l_idArray.count loop
1465: l_trxn_id := l_idArray(i);
1466: l_exp_amount := l_amtArray(i);
1467:
1468: IF ( NOT AP_WEB_DB_CCARD_PKG.UpdateExpensedAmount(
1469: l_trxn_id,
1470: p_reportId,
1471: l_exp_amount) ) THEN
1472: NULL;

Line 1542: if (NOT AP_WEB_DB_CCARD_PKG.GetExpensedAmountForTrxnId(l_idArray(i), l_temp)) then

1538: end loop;
1539:
1540: for i in 1.. l_idArray.count loop
1541: l_debugInfo := 'Get the existing expensed amount';
1542: if (NOT AP_WEB_DB_CCARD_PKG.GetExpensedAmountForTrxnId(l_idArray(i), l_temp)) then
1543: raise NO_DATA_FOUND;
1544: end if;
1545: l_amtArray(i) := l_temp - l_amtArray(i);
1546: end loop;