APPS.POS_SBD_PKG dependencies on POS_ACNT_PAY_PREF

Line 2381: select payment_preference_id from pos_acnt_pay_pref

2377:
2378: l_step NUMBER;
2379:
2380: cursor l_current_payment_cur is
2381: select payment_preference_id from pos_acnt_pay_pref
2382: where party_id = p_party_id
2383: and party_site_id = p_party_site_id;
2384:
2385: l_payment_preference_id pos_acnt_pay_pref.payment_preference_id%TYPE;

Line 2385: l_payment_preference_id pos_acnt_pay_pref.payment_preference_id%TYPE;

2381: select payment_preference_id from pos_acnt_pay_pref
2382: where party_id = p_party_id
2383: and party_site_id = p_party_site_id;
2384:
2385: l_payment_preference_id pos_acnt_pay_pref.payment_preference_id%TYPE;
2386: l_notification_method POS_ACNT_PAY_PREF.notification_method%TYPE;
2387:
2388: BEGIN
2389:

Line 2386: l_notification_method POS_ACNT_PAY_PREF.notification_method%TYPE;

2382: where party_id = p_party_id
2383: and party_site_id = p_party_site_id;
2384:
2385: l_payment_preference_id pos_acnt_pay_pref.payment_preference_id%TYPE;
2386: l_notification_method POS_ACNT_PAY_PREF.notification_method%TYPE;
2387:
2388: BEGIN
2389:
2390: -- Change the notification preference method

Line 2414: select POS_ACNT_PAY_PREF_S.nextval into l_payment_preference_id from dual;

2410: if l_payment_preference_id is null then
2411:
2412: l_step := 2;
2413:
2414: select POS_ACNT_PAY_PREF_S.nextval into l_payment_preference_id from dual;
2415: -- Create a row
2416:
2417: l_step:= 3;
2418:

Line 2419: insert into POS_ACNT_PAY_PREF (

2415: -- Create a row
2416:
2417: l_step:= 3;
2418:
2419: insert into POS_ACNT_PAY_PREF (
2420: payment_preference_id
2421: , party_id
2422: , party_site_id
2423: , creation_date

Line 2455: update pos_acnt_pay_pref set

2451: else
2452:
2453: l_step := 4;
2454: -- Update the row
2455: update pos_acnt_pay_pref set
2456: last_update_date = sysdate
2457: , last_updated_by = fnd_global.user_id
2458: , last_update_login = fnd_global.login_id
2459: , payment_currency_code = p_payment_currency_code