APPS.AP_WEB_CREDIT_CARD_WF dependencies on AP_CARD_PROGRAMS

Line 539: p_cardProgramId IN AP_CARD_PROGRAMS.card_program_id%TYPE,

535: END IF;
536: END sendUnsubmittedChargesNote;
537:
538: PROCEDURE SendDunningNotifications(p_employeeId IN NUMBER,
539: p_cardProgramId IN AP_CARD_PROGRAMS.card_program_id%TYPE,
540: p_Amount IN NUMBER,
541: p_currency IN VARCHAR2,
542: p_min_bucket IN NUMBER,
543: p_max_bucket IN NUMBER,

Line 570: p_cardProgramId IN AP_CARD_PROGRAMS.card_program_id%TYPE,

566: Passed 4 new parameters from report.
567: */
568:
569: PROCEDURE SendDunningNotifications(p_employeeId IN NUMBER,
570: p_cardProgramId IN AP_CARD_PROGRAMS.card_program_id%TYPE,
571: p_Amount IN NUMBER,
572: p_currency IN VARCHAR2,
573: p_min_bucket IN NUMBER,
574: p_max_bucket IN NUMBER,

Line 1281: p_cardProgramId IN AP_CARD_PROGRAMS.card_program_id%TYPE,

1277:
1278:
1279:
1280: PROCEDURE sendDisputedChargesNote(p_employeeId IN NUMBER,
1281: p_cardProgramId IN AP_CARD_PROGRAMS.card_program_id%TYPE,
1282: p_billedStartDate in date,
1283: p_billedEndDate in date,
1284: p_minimumAmount IN NUMBER)
1285: IS

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

3927: -- This wf is called by multiple conc programs and some set
3928: -- CARD_PROG_ID and others set CARD_PROGRAM_ID
3929: -- p_s_item_key is a sequence value and not report_header_id
3930: -- hence remove the call GetOrgIdByReportHeaderId and instead
3931: -- get the org_id from card program(ap_card_programs).
3932: if (wf_core.error_name = 'WFENG_ITEM_ATTR') then
3933: begin
3934: l_card_prog_id := WF_ENGINE.GetItemAttrNumber(p_item_type,
3935: p_item_key,

Line 3956: from ap_card_programs_all

3952:
3953: if l_card_prog_id is not null then
3954: begin
3955: select org_id into l_org_id
3956: from ap_card_programs_all
3957: where card_program_id = l_card_prog_id;
3958: exception
3959: when others then
3960: l_org_id := NULL;