APPS.AP_WEB_DISC_PKG dependencies on AP_WEB_DB_EXPTEMPLATE_PKG

Line 379: l_xtemplate_id AP_WEB_DB_EXPTEMPLATE_PKG.expTypes_reportID;

375: overrider_required_cc VARCHAR2(200) := 'You have changed cost center. Override approver required.';
376: line_not_found VARCHAR2(200) := 'Header Line is not found';
377: purpose_too_long VARCHAR2(200) := 'Purpose too long. Truncate to 240 character.';
378: costcenter_invalid VARCHAR2(255) := '';
379: l_xtemplate_id AP_WEB_DB_EXPTEMPLATE_PKG.expTypes_reportID;
380:
381: debug_info VARCHAR2(100) := '';
382: purpose_prompt VARCHAR2(50);
383: template_prompt VARCHAR2(50);

Line 641: p_xtemplateid in AP_WEB_DB_EXPTEMPLATE_PKG.expTempl_reportID

637:
638: PROCEDURE AP_WEB_DISC_GetExpType(
639: p_table in out nocopy disc_prompts_table,
640: xtypecomp_array out nocopy AP_WEB_PARENT_PKG.MiniString_Array,
641: p_xtemplateid in AP_WEB_DB_EXPTEMPLATE_PKG.expTempl_reportID
642: ) IS
643: /* xtypecomp_array is used later for populating xtypeindex_array. */
644: l_count number;
645: l_icount number := 1;

Line 646: l_exp_type_cursor AP_WEB_DB_EXPTEMPLATE_PKG.ExpTypesOfTemplateCursor;

642: ) IS
643: /* xtypecomp_array is used later for populating xtypeindex_array. */
644: l_count number;
645: l_icount number := 1;
646: l_exp_type_cursor AP_WEB_DB_EXPTEMPLATE_PKG.ExpTypesOfTemplateCursor;
647:
648: BEGIN
649:
650: IF ( AP_WEB_DB_EXPTEMPLATE_PKG.GetExpTypesOfTemplateCursor(

Line 650: IF ( AP_WEB_DB_EXPTEMPLATE_PKG.GetExpTypesOfTemplateCursor(

646: l_exp_type_cursor AP_WEB_DB_EXPTEMPLATE_PKG.ExpTypesOfTemplateCursor;
647:
648: BEGIN
649:
650: IF ( AP_WEB_DB_EXPTEMPLATE_PKG.GetExpTypesOfTemplateCursor(
651: p_xtemplateid,
652: l_exp_type_cursor ) = TRUE ) THEN
653: l_count := p_table.COUNT+1;
654:

Line 1579: IF (AP_WEB_DB_EXPTEMPLATE_PKG.GetExpTypePrompt(

1575: /*Bug 2758267:Passed correct prompt instead of Web Friendly Prompt
1576: to function so that correct DFF values will be retreived.
1577: */
1578:
1579: IF (AP_WEB_DB_EXPTEMPLATE_PKG.GetExpTypePrompt(
1580: to_number(p_receipts(rec_count).parameter_id), l_prompt)) THEN
1581: p_receipts(rec_count).expense_type := l_prompt;
1582: END IF;
1583:

Line 1932: l_just_required_cursor AP_WEB_DB_EXPTEMPLATE_PKG.JustificationExpTypeCursor;

1928:
1929: l_allow_credit_lines_profile VARCHAR2(1) := 'N';
1930: l_allow_credit_lines BOOLEAN;
1931:
1932: l_just_required_cursor AP_WEB_DB_EXPTEMPLATE_PKG.JustificationExpTypeCursor;
1933:
1934: l_curr_precision_cursor AP_WEB_DB_COUNTRY_PKG.CurrencyPrecisionCursor;
1935: l_justreq_array AP_WEB_PARENT_PKG.Number_Array;
1936: l_reimbcurr_precision AP_WEB_DB_COUNTRY_PKG.curr_precision;

Line 1988: IF (AP_WEB_DB_EXPTEMPLATE_PKG.GetJustifReqdExpTypesCursor(l_just_required_cursor)) THEN

1984: l_allow_credit_lines := FALSE;
1985: end if;
1986:
1987: l_debug_info := 'Fill justification required array';
1988: IF (AP_WEB_DB_EXPTEMPLATE_PKG.GetJustifReqdExpTypesCursor(l_just_required_cursor)) THEN
1989: i := 1;
1990: LOOP
1991: FETCH l_just_required_cursor INTO l_justreq_array(i);
1992: EXIT when l_just_required_cursor%NOTFOUND;

Line 2625: l_template_id AP_WEB_DB_EXPTEMPLATE_PKG.expTempl_reportID;

2621: l_curr_format VARCHAR2(80); /* reimbCurr format */
2622: l_terror_exists BOOLEAN;
2623: EndDate date;
2624:
2625: l_template_id AP_WEB_DB_EXPTEMPLATE_PKG.expTempl_reportID;
2626: l_xtypecomp_array AP_WEB_PARENT_PKG.MiniString_Array;
2627: l_last_receipt_date varchar2(25);
2628: l_dateformat varchar2(100);
2629: