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 1018: IF (AP_WEB_DB_CCARD_PKG.UserHasCreditCard(p_employee_id, l_has) AND

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

Line 1441: l_exp_amount AP_WEB_DB_CCARD_PKG.ccTrxn_expensedAmt;

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

Line 1442: l_trxn_id AP_WEB_DB_CCARD_PKG.ccTrxn_trxID;

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

Line 1470: IF ( NOT AP_WEB_DB_CCARD_PKG.UpdateExpensedAmount(

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

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

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