APPS.AP_WEB_CREDIT_CARD_WF dependencies on AP_CARD_PROGRAMS

Line 527: p_cardProgramId IN AP_CARD_PROGRAMS.card_program_id%TYPE,

523: Passed 4 new parameters from report.
524: */
525:
526: PROCEDURE SendDunningNotifications(p_employeeId IN NUMBER,
527: p_cardProgramId IN AP_CARD_PROGRAMS.card_program_id%TYPE,
528: p_Amount IN NUMBER,
529: p_currency IN VARCHAR2,
530: p_min_bucket IN NUMBER,
531: p_max_bucket IN NUMBER,

Line 1213: p_cardProgramId IN AP_CARD_PROGRAMS.card_program_id%TYPE,

1209:
1210:
1211:
1212: PROCEDURE sendDisputedChargesNote(p_employeeId IN NUMBER,
1213: p_cardProgramId IN AP_CARD_PROGRAMS.card_program_id%TYPE,
1214: p_billedStartDate in date,
1215: p_billedEndDate in date,
1216: p_minimumAmount IN NUMBER)
1217: IS

Line 3862: -- get the org_id from card program(ap_card_programs).

3858: -- This wf is called by multiple conc programs and some set
3859: -- CARD_PROG_ID and others set CARD_PROGRAM_ID
3860: -- p_s_item_key is a sequence value and not report_header_id
3861: -- hence remove the call GetOrgIdByReportHeaderId and instead
3862: -- get the org_id from card program(ap_card_programs).
3863: if (wf_core.error_name = 'WFENG_ITEM_ATTR') then
3864: begin
3865: l_card_prog_id := WF_ENGINE.GetItemAttrNumber(p_item_type,
3866: p_item_key,

Line 3887: from ap_card_programs_all

3883:
3884: if l_card_prog_id is not null then
3885: begin
3886: select org_id into l_org_id
3887: from ap_card_programs_all
3888: where card_program_id = l_card_prog_id;
3889: exception
3890: when others then
3891: l_org_id := NULL;