APPS.IBE_PAYMENT_INT_PVT dependencies on IBE_ORD_ONECLICK

Line 72: from ibe_ord_oneclick

68: Cursor c_get_oneclick_settings(c_party_id IN NUMBER,
69: c_cust_id IN NUMBER) is
70:
71: select ord_oneclick_id, enabled_flag
72: from ibe_ord_oneclick
73: where party_id = c_party_id and cust_account_id = c_cust_id;
74:
75: rec_check_address_owner c_check_address_owner%rowtype;
76:

Line 435: IBE_UTIL.debug('call process_credit_card - Going to call ibe_ord_oneclick_pvt.Update_Settings()');

431: END IF;
432:
433: IF l_oneclick_id <> FND_API.g_miss_num and l_enabled_flag = 'Y' then
434: IF (l_debugon = l_true) THEN
435: IBE_UTIL.debug('call process_credit_card - Going to call ibe_ord_oneclick_pvt.Update_Settings()');
436: IBE_UTIL.debug('call process_credit_card - p_party_id ' ||p_party_id);
437: IBE_UTIL.debug('call process_credit_card - p_cust_id '||p_cust_id);
438: IBE_UTIL.debug('call process_credit_card - p_assignment_id'||l_assignment_attr.Assignment_Id);
439: END IF;

Line 441: ibe_ord_oneclick_pvt.Update_Settings(

437: IBE_UTIL.debug('call process_credit_card - p_cust_id '||p_cust_id);
438: IBE_UTIL.debug('call process_credit_card - p_assignment_id'||l_assignment_attr.Assignment_Id);
439: END IF;
440:
441: ibe_ord_oneclick_pvt.Update_Settings(
442: p_api_version => p_api_version
443: ,p_init_msg_list => p_init_msg_list
444: ,p_commit => p_commit
445: ,x_return_status => x_return_status

Line 693: FROM ibe_ord_oneclick_all;

689: l_oneclick_payment_id NUMBER(15);
690:
691: CURSOR c_oneclick_data is
692: SELECT payment_id, party_id, cust_account_id, org_id
693: FROM ibe_ord_oneclick_all;
694:
695: CURSOR c_assignment_data(c_pmt_id NUMBER,
696: c_party_id NUMBER,
697: c_org_id NUMBER,

Line 745: -- IBE_ORD_ONECLICK_ALL table currently stores the express checkout preferences. The preferred credit card is

741: print_debug_log(' start_time = ' ||to_char(sysdate,'DD-MON-RRRR HH24:MI:SS'));
742: END IF;
743: --l_msg_data populated with different event points
744:
745: -- IBE_ORD_ONECLICK_ALL table currently stores the express checkout preferences. The preferred credit card is
746: -- stored in the column payment_id. Going forward this column will store the assignment_id.
747: --1. Cursor query to retrive the records in the one click table
748:
749: FOR rec_oneclick_data in c_oneclick_data LOOP

Line 813: print_debug_log('Before updating IBE_ORD_ONECLICK_ALL');

809: -- because it might be assigned to the party or party-acct or party-org combinations.
810:
811: -- log old and new values before the update
812: IF l_iby_debug = 'T' THEN
813: print_debug_log('Before updating IBE_ORD_ONECLICK_ALL');
814: print_debug_log('Original payment id before update: '||l_oneclick_payment_id);
815: print_debug_log('New payment id(actually assignment_id) after update: '||l_instr_assignment_id);
816: END IF;
817:

Line 818: UPDATE IBE_ORD_ONECLICK_ALL

814: print_debug_log('Original payment id before update: '||l_oneclick_payment_id);
815: print_debug_log('New payment id(actually assignment_id) after update: '||l_instr_assignment_id);
816: END IF;
817:
818: UPDATE IBE_ORD_ONECLICK_ALL
819: SET PAYMENT_ID = l_instr_assignment_id
820: WHERE party_id = rec_oneclick_data.party_id
821: AND cust_account_id = rec_oneclick_data.cust_account_id
822: AND org_id = rec_oneclick_data.org_id;