DBA Data[Home] [Help]

APPS.AP_WEB_OA_MAINFLOW_PKG dependencies on AP_WEB_PARENT_PKG

Line 438: CustomValuesArray AP_WEB_PARENT_PKG.BigString_Array;

434: current_calling_sequence varchar2(100) := 'ValidateReceiptLine';
435: l_expenditure_type AP_WEB_DB_EXPTEMPLATE_PKG.expTempl_paExpenditureType := NULL;
436:
437: ExpReportLinesInfo_A AP_WEB_DFLEX_PKG.ExpReportLines_A;
438: CustomValuesArray AP_WEB_PARENT_PKG.BigString_Array;
439: l_calculate_amt_index INTEGER := p_calculate_amt_index;
440:
441: BEGIN
442: AP_WEB_UTILITIES_PKG.LogProcedure('AP_WEB_OA_MAINFLOW_PKG',

Line 1432: p_trxIds IN AP_WEB_PARENT_PKG.Number_Array,

1428: END rebuildAccountSegments;
1429:
1430:
1431: PROCEDURE updateExpensedAmount(
1432: p_trxIds IN AP_WEB_PARENT_PKG.Number_Array,
1433: p_expensedAmt IN AP_WEB_PARENT_PKG.Number_Array,
1434: p_reportId IN AP_CREDIT_CARD_TRXNS.report_header_id%TYPE
1435: ) IS
1436: l_numCharges number := 0;

Line 1433: p_expensedAmt IN AP_WEB_PARENT_PKG.Number_Array,

1429:
1430:
1431: PROCEDURE updateExpensedAmount(
1432: p_trxIds IN AP_WEB_PARENT_PKG.Number_Array,
1433: p_expensedAmt IN AP_WEB_PARENT_PKG.Number_Array,
1434: p_reportId IN AP_CREDIT_CARD_TRXNS.report_header_id%TYPE
1435: ) IS
1436: l_numCharges number := 0;
1437: l_idArray AP_WEB_PARENT_PKG.Number_Array;

Line 1437: l_idArray AP_WEB_PARENT_PKG.Number_Array;

1433: p_expensedAmt IN AP_WEB_PARENT_PKG.Number_Array,
1434: p_reportId IN AP_CREDIT_CARD_TRXNS.report_header_id%TYPE
1435: ) IS
1436: l_numCharges number := 0;
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;

Line 1438: l_amtArray AP_WEB_PARENT_PKG.number_array;

1434: p_reportId IN AP_CREDIT_CARD_TRXNS.report_header_id%TYPE
1435: ) IS
1436: l_numCharges number := 0;
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;

Line 1439: l_foundArray AP_WEB_PARENT_PKG.boolean_array;

1435: ) IS
1436: l_numCharges number := 0;
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:

Line 1509: PROCEDURE updChargesFromDeletedReport(p_idArray in AP_WEB_PARENT_PKG.number_Array,

1505: None
1506: Date:
1507: 11/19/99
1508: */
1509: PROCEDURE updChargesFromDeletedReport(p_idArray in AP_WEB_PARENT_PKG.number_Array,
1510: p_amtArray in AP_WEB_PARENT_PKG.number_Array)
1511: IS
1512: l_idArray AP_WEB_PARENT_PKG.number_Array;
1513: l_amtArray AP_WEB_PARENT_PKG.number_Array;

Line 1510: p_amtArray in AP_WEB_PARENT_PKG.number_Array)

1506: Date:
1507: 11/19/99
1508: */
1509: PROCEDURE updChargesFromDeletedReport(p_idArray in AP_WEB_PARENT_PKG.number_Array,
1510: p_amtArray in AP_WEB_PARENT_PKG.number_Array)
1511: IS
1512: l_idArray AP_WEB_PARENT_PKG.number_Array;
1513: l_amtArray AP_WEB_PARENT_PKG.number_Array;
1514: l_foundArray AP_WEB_PARENT_PKG.boolean_Array;

Line 1512: l_idArray AP_WEB_PARENT_PKG.number_Array;

1508: */
1509: PROCEDURE updChargesFromDeletedReport(p_idArray in AP_WEB_PARENT_PKG.number_Array,
1510: p_amtArray in AP_WEB_PARENT_PKG.number_Array)
1511: IS
1512: l_idArray AP_WEB_PARENT_PKG.number_Array;
1513: l_amtArray AP_WEB_PARENT_PKG.number_Array;
1514: l_foundArray AP_WEB_PARENT_PKG.boolean_Array;
1515: l_id number;
1516: l_numCharges number := 0;

Line 1513: l_amtArray AP_WEB_PARENT_PKG.number_Array;

1509: PROCEDURE updChargesFromDeletedReport(p_idArray in AP_WEB_PARENT_PKG.number_Array,
1510: p_amtArray in AP_WEB_PARENT_PKG.number_Array)
1511: IS
1512: l_idArray AP_WEB_PARENT_PKG.number_Array;
1513: l_amtArray AP_WEB_PARENT_PKG.number_Array;
1514: l_foundArray AP_WEB_PARENT_PKG.boolean_Array;
1515: l_id number;
1516: l_numCharges number := 0;
1517: l_temp number;

Line 1514: l_foundArray AP_WEB_PARENT_PKG.boolean_Array;

1510: p_amtArray in AP_WEB_PARENT_PKG.number_Array)
1511: IS
1512: l_idArray AP_WEB_PARENT_PKG.number_Array;
1513: l_amtArray AP_WEB_PARENT_PKG.number_Array;
1514: l_foundArray AP_WEB_PARENT_PKG.boolean_Array;
1515: l_id number;
1516: l_numCharges number := 0;
1517: l_temp number;
1518: l_debugInfo varchar2(240);

Line 1568: l_idArray AP_WEB_PARENT_PKG.number_Array;

1564: ReportID IN AP_EXPENSE_REPORT_LINES.report_header_id%TYPE)
1565: IS
1566: l_DebugInfo VARCHAR2(200);
1567: l_count NUMBER;
1568: l_idArray AP_WEB_PARENT_PKG.number_Array;
1569: l_amtArray AP_WEB_PARENT_PKG.number_Array;
1570: l_ReportLines AP_WEB_DB_EXPLINE_PKG.CCTrxnCursor;
1571: l_WkflRec AP_WEB_DB_EXPRPT_PKG.ExpWorkflowRec;
1572: BEGIN

Line 1569: l_amtArray AP_WEB_PARENT_PKG.number_Array;

1565: IS
1566: l_DebugInfo VARCHAR2(200);
1567: l_count NUMBER;
1568: l_idArray AP_WEB_PARENT_PKG.number_Array;
1569: l_amtArray AP_WEB_PARENT_PKG.number_Array;
1570: l_ReportLines AP_WEB_DB_EXPLINE_PKG.CCTrxnCursor;
1571: l_WkflRec AP_WEB_DB_EXPRPT_PKG.ExpWorkflowRec;
1572: BEGIN
1573: l_DebugInfo := 'Get all the ids and amounts of credit card receipts';