APPS.IBE_LEAD_IMPORT_PVT dependencies on IBE_LEAD_IMPORT_LOG

Line 50: select ibe_lead_import_log_s1.nextval

46: l_write_detail_profile VARCHAR2(255);
47: Begin
48: printDebug('Inside write_log', 'write_log');
49: BEGIN
50: select ibe_lead_import_log_s1.nextval
51: into l_log_id
52: From dual;
53: Exception
54: when NO_DATA_FOUND then

Line 55: printDebug('Failed to get nextval of ibe_lead_import_log_s', 'write_log');

51: into l_log_id
52: From dual;
53: Exception
54: when NO_DATA_FOUND then
55: printDebug('Failed to get nextval of ibe_lead_import_log_s', 'write_log');
56: return;
57: end;
58:
59: printDebug('Insert into ibe_lead_import_log', 'write_log');

Line 59: printDebug('Insert into ibe_lead_import_log', 'write_log');

55: printDebug('Failed to get nextval of ibe_lead_import_log_s', 'write_log');
56: return;
57: end;
58:
59: printDebug('Insert into ibe_lead_import_log', 'write_log');
60: printDebug('lead_type = ' || p_lead_type, 'write_log');
61: printDebug('p_begin_date = ' || p_begin_date, 'write_log');
62: printDebug('p_end_date = ' || p_end_date, 'write_log');
63: printDebug('p_status = ' || p_status, 'write_log');

Line 66: Insert into IBE_LEAD_IMPORT_LOG

62: printDebug('p_end_date = ' || p_end_date, 'write_log');
63: printDebug('p_status = ' || p_status, 'write_log');
64: printDebug('p_import_mode = ' || p_import_mode, 'Write_log');
65:
66: Insert into IBE_LEAD_IMPORT_LOG
67: (
68: Log_Id,
69: Begin_Date,
70: End_Date,

Line 122: update ibe_lead_import_log

118: p_elapsed_time IN NUMBER
119: ) IS
120: l_log_id NUMBER := p_log_id;
121: BEGIN
122: update ibe_lead_import_log
123: Set status = p_status,
124: num_success = p_num_success,
125: num_Failed = p_num_failed,
126: num_imported = p_num_total,

Line 634: From ibe_lead_import_log

630: if( p_begin_date is null and p_end_date is null ) then
631: BEGIN
632: select max(end_date )
633: into l_begin_date
634: From ibe_lead_import_log
635: where status = 1
636: And lead_type = p_lead_type;
637: l_import_mode := G_INCREMENTAL_IMPORT;
638: EXCEPTION

Line 656: From ibe_lead_import_log

652: l_end_date := p_end_date;
653: BEGIN
654: select max(end_date)
655: into l_begin_date
656: From ibe_lead_import_log
657: where status = 1
658: And lead_type = p_lead_type;
659: EXCEPTION
660: when NO_DATA_FOUND then

Line 802: From ibe_lead_import_log

798: if( p_purge_flag = 'Y' ) then
799: BEGIN
800: select max(log_id)
801: into G_LAST_LOG_ID
802: From ibe_lead_import_log
803: where lead_type = G_ORDER_LEAD;
804:
805:
806: delete From ibe_lead_import_details

Line 818: update ibe_lead_import_log

814: END;
815: end if;
816:
817: BEGIN
818: update ibe_lead_import_log
819: set status = 0
820: where status = 1
821: and lead_type = G_ORDER_LEAD;
822: EXCEPTION

Line 828: printDebug('Insert a new log record to IBE_LEAD_IMPORT_LOG', 'Create_Order_lead');

824: printDebug('This is the first time the lead import is run', 'Create_Order_lead');
825: null;
826: END;
827:
828: printDebug('Insert a new log record to IBE_LEAD_IMPORT_LOG', 'Create_Order_lead');
829:
830: write_log(
831: p_status => l_status,
832: p_lead_type => G_ORDER_LEAD,

Line 1094: From ibe_lead_import_log

1090: if( p_purge_flag = 'Y' ) then
1091: BEGIN
1092: select max(log_id)
1093: into G_LAST_LOG_ID
1094: From ibe_lead_import_log
1095: where lead_type = G_QUOTE_LEAD;
1096:
1097: delete From ibe_lead_import_details
1098: where log_id < G_LAST_LOG_ID;

Line 1107: update ibe_lead_import_log

1103: END;
1104: end if;
1105:
1106: BEGIN
1107: update ibe_lead_import_log
1108: set status = 0
1109: where status = 1
1110: and lead_type = G_QUOTE_LEAD;
1111: EXCEPTION

Line 1715: From ibe_lead_import_log

1711: l_msg_data VARCHAR2(2000);
1712:
1713: cursor quote_csr is
1714: select log_id, num_imported, Num_failed, Num_success
1715: From ibe_lead_import_log
1716: where lead_type = G_QUOTE_LEAD
1717: And status = 1 ;
1718: l_quote_total NUMBER := 0;
1719: l_quote_failed NUMBER := 0;