eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.MSC_X_USER_EXCEP_GEN dependencies on DBMS_SQL

Line 36: v_Number1 DBMS_SQL.Number_Table;

32: v_returnCode INTEGER;
33: v_exception_id NUMBER;
34: v_debug BOOLEAN;
35:
36: v_Number1 DBMS_SQL.Number_Table;
37: v_Number2 DBMS_SQL.Number_Table;
38: v_Number3 DBMS_SQL.Number_Table;
39: v_Number4 DBMS_SQL.Number_Table;
40: v_Number5 DBMS_SQL.Number_Table;

Line 37: v_Number2 DBMS_SQL.Number_Table;

33: v_exception_id NUMBER;
34: v_debug BOOLEAN;
35:
36: v_Number1 DBMS_SQL.Number_Table;
37: v_Number2 DBMS_SQL.Number_Table;
38: v_Number3 DBMS_SQL.Number_Table;
39: v_Number4 DBMS_SQL.Number_Table;
40: v_Number5 DBMS_SQL.Number_Table;
41: v_Number6 DBMS_SQL.Number_Table;

Line 38: v_Number3 DBMS_SQL.Number_Table;

34: v_debug BOOLEAN;
35:
36: v_Number1 DBMS_SQL.Number_Table;
37: v_Number2 DBMS_SQL.Number_Table;
38: v_Number3 DBMS_SQL.Number_Table;
39: v_Number4 DBMS_SQL.Number_Table;
40: v_Number5 DBMS_SQL.Number_Table;
41: v_Number6 DBMS_SQL.Number_Table;
42: v_Number7 DBMS_SQL.Number_Table;

Line 39: v_Number4 DBMS_SQL.Number_Table;

35:
36: v_Number1 DBMS_SQL.Number_Table;
37: v_Number2 DBMS_SQL.Number_Table;
38: v_Number3 DBMS_SQL.Number_Table;
39: v_Number4 DBMS_SQL.Number_Table;
40: v_Number5 DBMS_SQL.Number_Table;
41: v_Number6 DBMS_SQL.Number_Table;
42: v_Number7 DBMS_SQL.Number_Table;
43: v_Number8 DBMS_SQL.Number_Table;

Line 40: v_Number5 DBMS_SQL.Number_Table;

36: v_Number1 DBMS_SQL.Number_Table;
37: v_Number2 DBMS_SQL.Number_Table;
38: v_Number3 DBMS_SQL.Number_Table;
39: v_Number4 DBMS_SQL.Number_Table;
40: v_Number5 DBMS_SQL.Number_Table;
41: v_Number6 DBMS_SQL.Number_Table;
42: v_Number7 DBMS_SQL.Number_Table;
43: v_Number8 DBMS_SQL.Number_Table;
44: v_Number9 DBMS_SQL.Number_Table;

Line 41: v_Number6 DBMS_SQL.Number_Table;

37: v_Number2 DBMS_SQL.Number_Table;
38: v_Number3 DBMS_SQL.Number_Table;
39: v_Number4 DBMS_SQL.Number_Table;
40: v_Number5 DBMS_SQL.Number_Table;
41: v_Number6 DBMS_SQL.Number_Table;
42: v_Number7 DBMS_SQL.Number_Table;
43: v_Number8 DBMS_SQL.Number_Table;
44: v_Number9 DBMS_SQL.Number_Table;
45: v_Number10 DBMS_SQL.Number_Table;

Line 42: v_Number7 DBMS_SQL.Number_Table;

38: v_Number3 DBMS_SQL.Number_Table;
39: v_Number4 DBMS_SQL.Number_Table;
40: v_Number5 DBMS_SQL.Number_Table;
41: v_Number6 DBMS_SQL.Number_Table;
42: v_Number7 DBMS_SQL.Number_Table;
43: v_Number8 DBMS_SQL.Number_Table;
44: v_Number9 DBMS_SQL.Number_Table;
45: v_Number10 DBMS_SQL.Number_Table;
46: vTransactionId1 DBMS_SQL.Number_Table;

Line 43: v_Number8 DBMS_SQL.Number_Table;

39: v_Number4 DBMS_SQL.Number_Table;
40: v_Number5 DBMS_SQL.Number_Table;
41: v_Number6 DBMS_SQL.Number_Table;
42: v_Number7 DBMS_SQL.Number_Table;
43: v_Number8 DBMS_SQL.Number_Table;
44: v_Number9 DBMS_SQL.Number_Table;
45: v_Number10 DBMS_SQL.Number_Table;
46: vTransactionId1 DBMS_SQL.Number_Table;
47: vTransactionId2 DBMS_SQL.Number_Table;

Line 44: v_Number9 DBMS_SQL.Number_Table;

40: v_Number5 DBMS_SQL.Number_Table;
41: v_Number6 DBMS_SQL.Number_Table;
42: v_Number7 DBMS_SQL.Number_Table;
43: v_Number8 DBMS_SQL.Number_Table;
44: v_Number9 DBMS_SQL.Number_Table;
45: v_Number10 DBMS_SQL.Number_Table;
46: vTransactionId1 DBMS_SQL.Number_Table;
47: vTransactionId2 DBMS_SQL.Number_Table;
48: vTransactionId3 DBMS_SQL.Number_Table;

Line 45: v_Number10 DBMS_SQL.Number_Table;

41: v_Number6 DBMS_SQL.Number_Table;
42: v_Number7 DBMS_SQL.Number_Table;
43: v_Number8 DBMS_SQL.Number_Table;
44: v_Number9 DBMS_SQL.Number_Table;
45: v_Number10 DBMS_SQL.Number_Table;
46: vTransactionId1 DBMS_SQL.Number_Table;
47: vTransactionId2 DBMS_SQL.Number_Table;
48: vTransactionId3 DBMS_SQL.Number_Table;
49:

Line 46: vTransactionId1 DBMS_SQL.Number_Table;

42: v_Number7 DBMS_SQL.Number_Table;
43: v_Number8 DBMS_SQL.Number_Table;
44: v_Number9 DBMS_SQL.Number_Table;
45: v_Number10 DBMS_SQL.Number_Table;
46: vTransactionId1 DBMS_SQL.Number_Table;
47: vTransactionId2 DBMS_SQL.Number_Table;
48: vTransactionId3 DBMS_SQL.Number_Table;
49:
50: v_Date1 DBMS_SQL.Date_Table;

Line 47: vTransactionId2 DBMS_SQL.Number_Table;

43: v_Number8 DBMS_SQL.Number_Table;
44: v_Number9 DBMS_SQL.Number_Table;
45: v_Number10 DBMS_SQL.Number_Table;
46: vTransactionId1 DBMS_SQL.Number_Table;
47: vTransactionId2 DBMS_SQL.Number_Table;
48: vTransactionId3 DBMS_SQL.Number_Table;
49:
50: v_Date1 DBMS_SQL.Date_Table;
51: v_Date2 DBMS_SQL.Date_Table;

Line 48: vTransactionId3 DBMS_SQL.Number_Table;

44: v_Number9 DBMS_SQL.Number_Table;
45: v_Number10 DBMS_SQL.Number_Table;
46: vTransactionId1 DBMS_SQL.Number_Table;
47: vTransactionId2 DBMS_SQL.Number_Table;
48: vTransactionId3 DBMS_SQL.Number_Table;
49:
50: v_Date1 DBMS_SQL.Date_Table;
51: v_Date2 DBMS_SQL.Date_Table;
52: v_Date3 DBMS_SQL.Date_Table;

Line 50: v_Date1 DBMS_SQL.Date_Table;

46: vTransactionId1 DBMS_SQL.Number_Table;
47: vTransactionId2 DBMS_SQL.Number_Table;
48: vTransactionId3 DBMS_SQL.Number_Table;
49:
50: v_Date1 DBMS_SQL.Date_Table;
51: v_Date2 DBMS_SQL.Date_Table;
52: v_Date3 DBMS_SQL.Date_Table;
53: v_Date4 DBMS_SQL.Date_Table;
54: v_Date5 DBMS_SQL.Date_Table;

Line 51: v_Date2 DBMS_SQL.Date_Table;

47: vTransactionId2 DBMS_SQL.Number_Table;
48: vTransactionId3 DBMS_SQL.Number_Table;
49:
50: v_Date1 DBMS_SQL.Date_Table;
51: v_Date2 DBMS_SQL.Date_Table;
52: v_Date3 DBMS_SQL.Date_Table;
53: v_Date4 DBMS_SQL.Date_Table;
54: v_Date5 DBMS_SQL.Date_Table;
55: v_Date6 DBMS_SQL.Date_Table;

Line 52: v_Date3 DBMS_SQL.Date_Table;

48: vTransactionId3 DBMS_SQL.Number_Table;
49:
50: v_Date1 DBMS_SQL.Date_Table;
51: v_Date2 DBMS_SQL.Date_Table;
52: v_Date3 DBMS_SQL.Date_Table;
53: v_Date4 DBMS_SQL.Date_Table;
54: v_Date5 DBMS_SQL.Date_Table;
55: v_Date6 DBMS_SQL.Date_Table;
56: v_Date7 DBMS_SQL.Date_Table;

Line 53: v_Date4 DBMS_SQL.Date_Table;

49:
50: v_Date1 DBMS_SQL.Date_Table;
51: v_Date2 DBMS_SQL.Date_Table;
52: v_Date3 DBMS_SQL.Date_Table;
53: v_Date4 DBMS_SQL.Date_Table;
54: v_Date5 DBMS_SQL.Date_Table;
55: v_Date6 DBMS_SQL.Date_Table;
56: v_Date7 DBMS_SQL.Date_Table;
57:

Line 54: v_Date5 DBMS_SQL.Date_Table;

50: v_Date1 DBMS_SQL.Date_Table;
51: v_Date2 DBMS_SQL.Date_Table;
52: v_Date3 DBMS_SQL.Date_Table;
53: v_Date4 DBMS_SQL.Date_Table;
54: v_Date5 DBMS_SQL.Date_Table;
55: v_Date6 DBMS_SQL.Date_Table;
56: v_Date7 DBMS_SQL.Date_Table;
57:
58: v_varchar1 DBMS_SQL.VARCHAR2_TABLE;

Line 55: v_Date6 DBMS_SQL.Date_Table;

51: v_Date2 DBMS_SQL.Date_Table;
52: v_Date3 DBMS_SQL.Date_Table;
53: v_Date4 DBMS_SQL.Date_Table;
54: v_Date5 DBMS_SQL.Date_Table;
55: v_Date6 DBMS_SQL.Date_Table;
56: v_Date7 DBMS_SQL.Date_Table;
57:
58: v_varchar1 DBMS_SQL.VARCHAR2_TABLE;
59: v_varchar2 DBMS_SQL.VARCHAR2_TABLE;

Line 56: v_Date7 DBMS_SQL.Date_Table;

52: v_Date3 DBMS_SQL.Date_Table;
53: v_Date4 DBMS_SQL.Date_Table;
54: v_Date5 DBMS_SQL.Date_Table;
55: v_Date6 DBMS_SQL.Date_Table;
56: v_Date7 DBMS_SQL.Date_Table;
57:
58: v_varchar1 DBMS_SQL.VARCHAR2_TABLE;
59: v_varchar2 DBMS_SQL.VARCHAR2_TABLE;
60: v_varchar3 DBMS_SQL.VARCHAR2_TABLE;

Line 58: v_varchar1 DBMS_SQL.VARCHAR2_TABLE;

54: v_Date5 DBMS_SQL.Date_Table;
55: v_Date6 DBMS_SQL.Date_Table;
56: v_Date7 DBMS_SQL.Date_Table;
57:
58: v_varchar1 DBMS_SQL.VARCHAR2_TABLE;
59: v_varchar2 DBMS_SQL.VARCHAR2_TABLE;
60: v_varchar3 DBMS_SQL.VARCHAR2_TABLE;
61: v_varchar4 DBMS_SQL.VARCHAR2_TABLE;
62: v_varchar5 DBMS_SQL.VARCHAR2_TABLE;

Line 59: v_varchar2 DBMS_SQL.VARCHAR2_TABLE;

55: v_Date6 DBMS_SQL.Date_Table;
56: v_Date7 DBMS_SQL.Date_Table;
57:
58: v_varchar1 DBMS_SQL.VARCHAR2_TABLE;
59: v_varchar2 DBMS_SQL.VARCHAR2_TABLE;
60: v_varchar3 DBMS_SQL.VARCHAR2_TABLE;
61: v_varchar4 DBMS_SQL.VARCHAR2_TABLE;
62: v_varchar5 DBMS_SQL.VARCHAR2_TABLE;
63: v_varchar6 DBMS_SQL.VARCHAR2_TABLE;

Line 60: v_varchar3 DBMS_SQL.VARCHAR2_TABLE;

56: v_Date7 DBMS_SQL.Date_Table;
57:
58: v_varchar1 DBMS_SQL.VARCHAR2_TABLE;
59: v_varchar2 DBMS_SQL.VARCHAR2_TABLE;
60: v_varchar3 DBMS_SQL.VARCHAR2_TABLE;
61: v_varchar4 DBMS_SQL.VARCHAR2_TABLE;
62: v_varchar5 DBMS_SQL.VARCHAR2_TABLE;
63: v_varchar6 DBMS_SQL.VARCHAR2_TABLE;
64: v_varchar7 DBMS_SQL.VARCHAR2_TABLE;

Line 61: v_varchar4 DBMS_SQL.VARCHAR2_TABLE;

57:
58: v_varchar1 DBMS_SQL.VARCHAR2_TABLE;
59: v_varchar2 DBMS_SQL.VARCHAR2_TABLE;
60: v_varchar3 DBMS_SQL.VARCHAR2_TABLE;
61: v_varchar4 DBMS_SQL.VARCHAR2_TABLE;
62: v_varchar5 DBMS_SQL.VARCHAR2_TABLE;
63: v_varchar6 DBMS_SQL.VARCHAR2_TABLE;
64: v_varchar7 DBMS_SQL.VARCHAR2_TABLE;
65: v_varchar8 DBMS_SQL.VARCHAR2_TABLE;

Line 62: v_varchar5 DBMS_SQL.VARCHAR2_TABLE;

58: v_varchar1 DBMS_SQL.VARCHAR2_TABLE;
59: v_varchar2 DBMS_SQL.VARCHAR2_TABLE;
60: v_varchar3 DBMS_SQL.VARCHAR2_TABLE;
61: v_varchar4 DBMS_SQL.VARCHAR2_TABLE;
62: v_varchar5 DBMS_SQL.VARCHAR2_TABLE;
63: v_varchar6 DBMS_SQL.VARCHAR2_TABLE;
64: v_varchar7 DBMS_SQL.VARCHAR2_TABLE;
65: v_varchar8 DBMS_SQL.VARCHAR2_TABLE;
66: v_varchar9 DBMS_SQL.VARCHAR2_TABLE;

Line 63: v_varchar6 DBMS_SQL.VARCHAR2_TABLE;

59: v_varchar2 DBMS_SQL.VARCHAR2_TABLE;
60: v_varchar3 DBMS_SQL.VARCHAR2_TABLE;
61: v_varchar4 DBMS_SQL.VARCHAR2_TABLE;
62: v_varchar5 DBMS_SQL.VARCHAR2_TABLE;
63: v_varchar6 DBMS_SQL.VARCHAR2_TABLE;
64: v_varchar7 DBMS_SQL.VARCHAR2_TABLE;
65: v_varchar8 DBMS_SQL.VARCHAR2_TABLE;
66: v_varchar9 DBMS_SQL.VARCHAR2_TABLE;
67: v_varchar10 DBMS_SQL.VARCHAR2_TABLE;

Line 64: v_varchar7 DBMS_SQL.VARCHAR2_TABLE;

60: v_varchar3 DBMS_SQL.VARCHAR2_TABLE;
61: v_varchar4 DBMS_SQL.VARCHAR2_TABLE;
62: v_varchar5 DBMS_SQL.VARCHAR2_TABLE;
63: v_varchar6 DBMS_SQL.VARCHAR2_TABLE;
64: v_varchar7 DBMS_SQL.VARCHAR2_TABLE;
65: v_varchar8 DBMS_SQL.VARCHAR2_TABLE;
66: v_varchar9 DBMS_SQL.VARCHAR2_TABLE;
67: v_varchar10 DBMS_SQL.VARCHAR2_TABLE;
68: v_varchar11 DBMS_SQL.VARCHAR2_TABLE;

Line 65: v_varchar8 DBMS_SQL.VARCHAR2_TABLE;

61: v_varchar4 DBMS_SQL.VARCHAR2_TABLE;
62: v_varchar5 DBMS_SQL.VARCHAR2_TABLE;
63: v_varchar6 DBMS_SQL.VARCHAR2_TABLE;
64: v_varchar7 DBMS_SQL.VARCHAR2_TABLE;
65: v_varchar8 DBMS_SQL.VARCHAR2_TABLE;
66: v_varchar9 DBMS_SQL.VARCHAR2_TABLE;
67: v_varchar10 DBMS_SQL.VARCHAR2_TABLE;
68: v_varchar11 DBMS_SQL.VARCHAR2_TABLE;
69: v_varchar12 DBMS_SQL.VARCHAR2_TABLE;

Line 66: v_varchar9 DBMS_SQL.VARCHAR2_TABLE;

62: v_varchar5 DBMS_SQL.VARCHAR2_TABLE;
63: v_varchar6 DBMS_SQL.VARCHAR2_TABLE;
64: v_varchar7 DBMS_SQL.VARCHAR2_TABLE;
65: v_varchar8 DBMS_SQL.VARCHAR2_TABLE;
66: v_varchar9 DBMS_SQL.VARCHAR2_TABLE;
67: v_varchar10 DBMS_SQL.VARCHAR2_TABLE;
68: v_varchar11 DBMS_SQL.VARCHAR2_TABLE;
69: v_varchar12 DBMS_SQL.VARCHAR2_TABLE;
70: v_varchar13 DBMS_SQL.VARCHAR2_TABLE;

Line 67: v_varchar10 DBMS_SQL.VARCHAR2_TABLE;

63: v_varchar6 DBMS_SQL.VARCHAR2_TABLE;
64: v_varchar7 DBMS_SQL.VARCHAR2_TABLE;
65: v_varchar8 DBMS_SQL.VARCHAR2_TABLE;
66: v_varchar9 DBMS_SQL.VARCHAR2_TABLE;
67: v_varchar10 DBMS_SQL.VARCHAR2_TABLE;
68: v_varchar11 DBMS_SQL.VARCHAR2_TABLE;
69: v_varchar12 DBMS_SQL.VARCHAR2_TABLE;
70: v_varchar13 DBMS_SQL.VARCHAR2_TABLE;
71: v_varchar14 DBMS_SQL.VARCHAR2_TABLE;

Line 68: v_varchar11 DBMS_SQL.VARCHAR2_TABLE;

64: v_varchar7 DBMS_SQL.VARCHAR2_TABLE;
65: v_varchar8 DBMS_SQL.VARCHAR2_TABLE;
66: v_varchar9 DBMS_SQL.VARCHAR2_TABLE;
67: v_varchar10 DBMS_SQL.VARCHAR2_TABLE;
68: v_varchar11 DBMS_SQL.VARCHAR2_TABLE;
69: v_varchar12 DBMS_SQL.VARCHAR2_TABLE;
70: v_varchar13 DBMS_SQL.VARCHAR2_TABLE;
71: v_varchar14 DBMS_SQL.VARCHAR2_TABLE;
72: v_varchar15 DBMS_SQL.VARCHAR2_TABLE;

Line 69: v_varchar12 DBMS_SQL.VARCHAR2_TABLE;

65: v_varchar8 DBMS_SQL.VARCHAR2_TABLE;
66: v_varchar9 DBMS_SQL.VARCHAR2_TABLE;
67: v_varchar10 DBMS_SQL.VARCHAR2_TABLE;
68: v_varchar11 DBMS_SQL.VARCHAR2_TABLE;
69: v_varchar12 DBMS_SQL.VARCHAR2_TABLE;
70: v_varchar13 DBMS_SQL.VARCHAR2_TABLE;
71: v_varchar14 DBMS_SQL.VARCHAR2_TABLE;
72: v_varchar15 DBMS_SQL.VARCHAR2_TABLE;
73: v_varchar16 DBMS_SQL.VARCHAR2_TABLE;

Line 70: v_varchar13 DBMS_SQL.VARCHAR2_TABLE;

66: v_varchar9 DBMS_SQL.VARCHAR2_TABLE;
67: v_varchar10 DBMS_SQL.VARCHAR2_TABLE;
68: v_varchar11 DBMS_SQL.VARCHAR2_TABLE;
69: v_varchar12 DBMS_SQL.VARCHAR2_TABLE;
70: v_varchar13 DBMS_SQL.VARCHAR2_TABLE;
71: v_varchar14 DBMS_SQL.VARCHAR2_TABLE;
72: v_varchar15 DBMS_SQL.VARCHAR2_TABLE;
73: v_varchar16 DBMS_SQL.VARCHAR2_TABLE;
74: v_varchar17 DBMS_SQL.VARCHAR2_TABLE;

Line 71: v_varchar14 DBMS_SQL.VARCHAR2_TABLE;

67: v_varchar10 DBMS_SQL.VARCHAR2_TABLE;
68: v_varchar11 DBMS_SQL.VARCHAR2_TABLE;
69: v_varchar12 DBMS_SQL.VARCHAR2_TABLE;
70: v_varchar13 DBMS_SQL.VARCHAR2_TABLE;
71: v_varchar14 DBMS_SQL.VARCHAR2_TABLE;
72: v_varchar15 DBMS_SQL.VARCHAR2_TABLE;
73: v_varchar16 DBMS_SQL.VARCHAR2_TABLE;
74: v_varchar17 DBMS_SQL.VARCHAR2_TABLE;
75: v_varchar18 DBMS_SQL.VARCHAR2_TABLE;

Line 72: v_varchar15 DBMS_SQL.VARCHAR2_TABLE;

68: v_varchar11 DBMS_SQL.VARCHAR2_TABLE;
69: v_varchar12 DBMS_SQL.VARCHAR2_TABLE;
70: v_varchar13 DBMS_SQL.VARCHAR2_TABLE;
71: v_varchar14 DBMS_SQL.VARCHAR2_TABLE;
72: v_varchar15 DBMS_SQL.VARCHAR2_TABLE;
73: v_varchar16 DBMS_SQL.VARCHAR2_TABLE;
74: v_varchar17 DBMS_SQL.VARCHAR2_TABLE;
75: v_varchar18 DBMS_SQL.VARCHAR2_TABLE;
76: v_varchar19 DBMS_SQL.VARCHAR2_TABLE;

Line 73: v_varchar16 DBMS_SQL.VARCHAR2_TABLE;

69: v_varchar12 DBMS_SQL.VARCHAR2_TABLE;
70: v_varchar13 DBMS_SQL.VARCHAR2_TABLE;
71: v_varchar14 DBMS_SQL.VARCHAR2_TABLE;
72: v_varchar15 DBMS_SQL.VARCHAR2_TABLE;
73: v_varchar16 DBMS_SQL.VARCHAR2_TABLE;
74: v_varchar17 DBMS_SQL.VARCHAR2_TABLE;
75: v_varchar18 DBMS_SQL.VARCHAR2_TABLE;
76: v_varchar19 DBMS_SQL.VARCHAR2_TABLE;
77: v_varchar20 DBMS_SQL.VARCHAR2_TABLE;

Line 74: v_varchar17 DBMS_SQL.VARCHAR2_TABLE;

70: v_varchar13 DBMS_SQL.VARCHAR2_TABLE;
71: v_varchar14 DBMS_SQL.VARCHAR2_TABLE;
72: v_varchar15 DBMS_SQL.VARCHAR2_TABLE;
73: v_varchar16 DBMS_SQL.VARCHAR2_TABLE;
74: v_varchar17 DBMS_SQL.VARCHAR2_TABLE;
75: v_varchar18 DBMS_SQL.VARCHAR2_TABLE;
76: v_varchar19 DBMS_SQL.VARCHAR2_TABLE;
77: v_varchar20 DBMS_SQL.VARCHAR2_TABLE;
78:

Line 75: v_varchar18 DBMS_SQL.VARCHAR2_TABLE;

71: v_varchar14 DBMS_SQL.VARCHAR2_TABLE;
72: v_varchar15 DBMS_SQL.VARCHAR2_TABLE;
73: v_varchar16 DBMS_SQL.VARCHAR2_TABLE;
74: v_varchar17 DBMS_SQL.VARCHAR2_TABLE;
75: v_varchar18 DBMS_SQL.VARCHAR2_TABLE;
76: v_varchar19 DBMS_SQL.VARCHAR2_TABLE;
77: v_varchar20 DBMS_SQL.VARCHAR2_TABLE;
78:
79: v_CREATED_BY DBMS_SQL.Number_Table;

Line 76: v_varchar19 DBMS_SQL.VARCHAR2_TABLE;

72: v_varchar15 DBMS_SQL.VARCHAR2_TABLE;
73: v_varchar16 DBMS_SQL.VARCHAR2_TABLE;
74: v_varchar17 DBMS_SQL.VARCHAR2_TABLE;
75: v_varchar18 DBMS_SQL.VARCHAR2_TABLE;
76: v_varchar19 DBMS_SQL.VARCHAR2_TABLE;
77: v_varchar20 DBMS_SQL.VARCHAR2_TABLE;
78:
79: v_CREATED_BY DBMS_SQL.Number_Table;
80: v_CREATION_DATE DBMS_SQL.Date_Table;

Line 77: v_varchar20 DBMS_SQL.VARCHAR2_TABLE;

73: v_varchar16 DBMS_SQL.VARCHAR2_TABLE;
74: v_varchar17 DBMS_SQL.VARCHAR2_TABLE;
75: v_varchar18 DBMS_SQL.VARCHAR2_TABLE;
76: v_varchar19 DBMS_SQL.VARCHAR2_TABLE;
77: v_varchar20 DBMS_SQL.VARCHAR2_TABLE;
78:
79: v_CREATED_BY DBMS_SQL.Number_Table;
80: v_CREATION_DATE DBMS_SQL.Date_Table;
81: v_LAST_UPDATED_BY DBMS_SQL.Number_Table;

Line 79: v_CREATED_BY DBMS_SQL.Number_Table;

75: v_varchar18 DBMS_SQL.VARCHAR2_TABLE;
76: v_varchar19 DBMS_SQL.VARCHAR2_TABLE;
77: v_varchar20 DBMS_SQL.VARCHAR2_TABLE;
78:
79: v_CREATED_BY DBMS_SQL.Number_Table;
80: v_CREATION_DATE DBMS_SQL.Date_Table;
81: v_LAST_UPDATED_BY DBMS_SQL.Number_Table;
82: v_LAST_UPDATE_DATE DBMS_SQL.Date_Table;
83: v_EXCEPTION_DETAIL_ID DBMS_SQL.Number_Table;

Line 80: v_CREATION_DATE DBMS_SQL.Date_Table;

76: v_varchar19 DBMS_SQL.VARCHAR2_TABLE;
77: v_varchar20 DBMS_SQL.VARCHAR2_TABLE;
78:
79: v_CREATED_BY DBMS_SQL.Number_Table;
80: v_CREATION_DATE DBMS_SQL.Date_Table;
81: v_LAST_UPDATED_BY DBMS_SQL.Number_Table;
82: v_LAST_UPDATE_DATE DBMS_SQL.Date_Table;
83: v_EXCEPTION_DETAIL_ID DBMS_SQL.Number_Table;
84: vExceptionTypeArray DBMS_SQL.Number_Table;

Line 81: v_LAST_UPDATED_BY DBMS_SQL.Number_Table;

77: v_varchar20 DBMS_SQL.VARCHAR2_TABLE;
78:
79: v_CREATED_BY DBMS_SQL.Number_Table;
80: v_CREATION_DATE DBMS_SQL.Date_Table;
81: v_LAST_UPDATED_BY DBMS_SQL.Number_Table;
82: v_LAST_UPDATE_DATE DBMS_SQL.Date_Table;
83: v_EXCEPTION_DETAIL_ID DBMS_SQL.Number_Table;
84: vExceptionTypeArray DBMS_SQL.Number_Table;
85: vExceptionTypeNameArray DBMS_SQL.VARCHAR2_TABLE;

Line 82: v_LAST_UPDATE_DATE DBMS_SQL.Date_Table;

78:
79: v_CREATED_BY DBMS_SQL.Number_Table;
80: v_CREATION_DATE DBMS_SQL.Date_Table;
81: v_LAST_UPDATED_BY DBMS_SQL.Number_Table;
82: v_LAST_UPDATE_DATE DBMS_SQL.Date_Table;
83: v_EXCEPTION_DETAIL_ID DBMS_SQL.Number_Table;
84: vExceptionTypeArray DBMS_SQL.Number_Table;
85: vExceptionTypeNameArray DBMS_SQL.VARCHAR2_TABLE;
86: vExceptionGroupArray DBMS_SQL.Number_Table;

Line 83: v_EXCEPTION_DETAIL_ID DBMS_SQL.Number_Table;

79: v_CREATED_BY DBMS_SQL.Number_Table;
80: v_CREATION_DATE DBMS_SQL.Date_Table;
81: v_LAST_UPDATED_BY DBMS_SQL.Number_Table;
82: v_LAST_UPDATE_DATE DBMS_SQL.Date_Table;
83: v_EXCEPTION_DETAIL_ID DBMS_SQL.Number_Table;
84: vExceptionTypeArray DBMS_SQL.Number_Table;
85: vExceptionTypeNameArray DBMS_SQL.VARCHAR2_TABLE;
86: vExceptionGroupArray DBMS_SQL.Number_Table;
87: vOwningCompanyIdArray DBMS_SQL.Number_Table;

Line 84: vExceptionTypeArray DBMS_SQL.Number_Table;

80: v_CREATION_DATE DBMS_SQL.Date_Table;
81: v_LAST_UPDATED_BY DBMS_SQL.Number_Table;
82: v_LAST_UPDATE_DATE DBMS_SQL.Date_Table;
83: v_EXCEPTION_DETAIL_ID DBMS_SQL.Number_Table;
84: vExceptionTypeArray DBMS_SQL.Number_Table;
85: vExceptionTypeNameArray DBMS_SQL.VARCHAR2_TABLE;
86: vExceptionGroupArray DBMS_SQL.Number_Table;
87: vOwningCompanyIdArray DBMS_SQL.Number_Table;
88: vExceptionGroupNameArray DBMS_SQL.VARCHAR2_TABLE;

Line 85: vExceptionTypeNameArray DBMS_SQL.VARCHAR2_TABLE;

81: v_LAST_UPDATED_BY DBMS_SQL.Number_Table;
82: v_LAST_UPDATE_DATE DBMS_SQL.Date_Table;
83: v_EXCEPTION_DETAIL_ID DBMS_SQL.Number_Table;
84: vExceptionTypeArray DBMS_SQL.Number_Table;
85: vExceptionTypeNameArray DBMS_SQL.VARCHAR2_TABLE;
86: vExceptionGroupArray DBMS_SQL.Number_Table;
87: vOwningCompanyIdArray DBMS_SQL.Number_Table;
88: vExceptionGroupNameArray DBMS_SQL.VARCHAR2_TABLE;
89: vExRefreshNumber NUMBER;

Line 86: vExceptionGroupArray DBMS_SQL.Number_Table;

82: v_LAST_UPDATE_DATE DBMS_SQL.Date_Table;
83: v_EXCEPTION_DETAIL_ID DBMS_SQL.Number_Table;
84: vExceptionTypeArray DBMS_SQL.Number_Table;
85: vExceptionTypeNameArray DBMS_SQL.VARCHAR2_TABLE;
86: vExceptionGroupArray DBMS_SQL.Number_Table;
87: vOwningCompanyIdArray DBMS_SQL.Number_Table;
88: vExceptionGroupNameArray DBMS_SQL.VARCHAR2_TABLE;
89: vExRefreshNumber NUMBER;
90: vNewExRefreshNumber NUMBER;

Line 87: vOwningCompanyIdArray DBMS_SQL.Number_Table;

83: v_EXCEPTION_DETAIL_ID DBMS_SQL.Number_Table;
84: vExceptionTypeArray DBMS_SQL.Number_Table;
85: vExceptionTypeNameArray DBMS_SQL.VARCHAR2_TABLE;
86: vExceptionGroupArray DBMS_SQL.Number_Table;
87: vOwningCompanyIdArray DBMS_SQL.Number_Table;
88: vExceptionGroupNameArray DBMS_SQL.VARCHAR2_TABLE;
89: vExRefreshNumber NUMBER;
90: vNewExRefreshNumber NUMBER;
91:

Line 88: vExceptionGroupNameArray DBMS_SQL.VARCHAR2_TABLE;

84: vExceptionTypeArray DBMS_SQL.Number_Table;
85: vExceptionTypeNameArray DBMS_SQL.VARCHAR2_TABLE;
86: vExceptionGroupArray DBMS_SQL.Number_Table;
87: vOwningCompanyIdArray DBMS_SQL.Number_Table;
88: vExceptionGroupNameArray DBMS_SQL.VARCHAR2_TABLE;
89: vExRefreshNumber NUMBER;
90: vNewExRefreshNumber NUMBER;
91:
92: vSelectStmt VARCHAR2(8000);

Line 147: Function getVarcharArray(arrayIndex in number ) return DBMS_SQL.VARCHAR2_TABLE ;

143: ExTerminateProgram EXCEPTION;
144:
145:
146: -- ========== Declare Local Procedures ==============
147: Function getVarcharArray(arrayIndex in number ) return DBMS_SQL.VARCHAR2_TABLE ;
148: Function VarcharValue(varcharCounter in number,
149: rowCounter in Number) return varchar2 ;
150: Function NumberValue(NumberCounter in number,
151: rowCounter in Number) return Number ;

Line 503: v_fetch_cursor := DBMS_SQL.OPEN_CURSOR;

499: pException_Id In NUMBER,
500: pFullLoad In VARCHAR2 default NULL ) is
501: begin
502: v_exception_id := pException_Id;
503: v_fetch_cursor := DBMS_SQL.OPEN_CURSOR;
504: v_insert_cursor := DBMS_SQL.OPEN_CURSOR;
505:
506: if pFullLoad = '1' then
507: vFullDataFlag := 'Y';

Line 504: v_insert_cursor := DBMS_SQL.OPEN_CURSOR;

500: pFullLoad In VARCHAR2 default NULL ) is
501: begin
502: v_exception_id := pException_Id;
503: v_fetch_cursor := DBMS_SQL.OPEN_CURSOR;
504: v_insert_cursor := DBMS_SQL.OPEN_CURSOR;
505:
506: if pFullLoad = '1' then
507: vFullDataFlag := 'Y';
508: if v_debug then

Line 629: if dbms_sql.is_open(v_fetch_cursor) THEN

625: end if;
626:
627: exception
628: when ExTerminateProgram then
629: if dbms_sql.is_open(v_fetch_cursor) THEN
630: dbms_sql.close_cursor(v_fetch_cursor);
631: end if;
632:
633: if dbms_sql.is_open(v_insert_cursor) THEN

Line 630: dbms_sql.close_cursor(v_fetch_cursor);

626:
627: exception
628: when ExTerminateProgram then
629: if dbms_sql.is_open(v_fetch_cursor) THEN
630: dbms_sql.close_cursor(v_fetch_cursor);
631: end if;
632:
633: if dbms_sql.is_open(v_insert_cursor) THEN
634: dbms_sql.close_cursor(v_insert_cursor);

Line 633: if dbms_sql.is_open(v_insert_cursor) THEN

629: if dbms_sql.is_open(v_fetch_cursor) THEN
630: dbms_sql.close_cursor(v_fetch_cursor);
631: end if;
632:
633: if dbms_sql.is_open(v_insert_cursor) THEN
634: dbms_sql.close_cursor(v_insert_cursor);
635: end if;
636: ERRBUF := FND_MESSAGE.GET;
637: RETCODE := G_ERROR;

Line 634: dbms_sql.close_cursor(v_insert_cursor);

630: dbms_sql.close_cursor(v_fetch_cursor);
631: end if;
632:
633: if dbms_sql.is_open(v_insert_cursor) THEN
634: dbms_sql.close_cursor(v_insert_cursor);
635: end if;
636: ERRBUF := FND_MESSAGE.GET;
637: RETCODE := G_ERROR;
638: log_message(ERRBUF);

Line 641: if dbms_sql.is_open(v_fetch_cursor) THEN

637: RETCODE := G_ERROR;
638: log_message(ERRBUF);
639:
640: when others then
641: if dbms_sql.is_open(v_fetch_cursor) THEN
642: dbms_sql.close_cursor(v_fetch_cursor);
643: end if;
644:
645: if dbms_sql.is_open(v_insert_cursor) THEN

Line 642: dbms_sql.close_cursor(v_fetch_cursor);

638: log_message(ERRBUF);
639:
640: when others then
641: if dbms_sql.is_open(v_fetch_cursor) THEN
642: dbms_sql.close_cursor(v_fetch_cursor);
643: end if;
644:
645: if dbms_sql.is_open(v_insert_cursor) THEN
646: dbms_sql.close_cursor(v_insert_cursor);

Line 645: if dbms_sql.is_open(v_insert_cursor) THEN

641: if dbms_sql.is_open(v_fetch_cursor) THEN
642: dbms_sql.close_cursor(v_fetch_cursor);
643: end if;
644:
645: if dbms_sql.is_open(v_insert_cursor) THEN
646: dbms_sql.close_cursor(v_insert_cursor);
647: end if;
648:
649: ERRBUF := SQLERRM;

Line 646: dbms_sql.close_cursor(v_insert_cursor);

642: dbms_sql.close_cursor(v_fetch_cursor);
643: end if;
644:
645: if dbms_sql.is_open(v_insert_cursor) THEN
646: dbms_sql.close_cursor(v_insert_cursor);
647: end if;
648:
649: ERRBUF := SQLERRM;
650: RETCODE := G_ERROR;

Line 1474: dbms_sql.bind_variable(v_fetch_cursor,':company_id',v_company_id);

1470:
1471: if v_debug then
1472: log_message('binding company id= '||v_company_id);
1473: end if;
1474: dbms_sql.bind_variable(v_fetch_cursor,':company_id',v_company_id);
1475:
1476:
1477: if v_debug then
1478: log_message('Before DEFINE_ARRAY');

Line 1524: DBMS_SQL.DEFINE_ARRAY(v_fetch_cursor,lCounterTemp,vTransactionId1,vBatchSize,1);

1520:
1521: -- define array for transaction ids which are added due to transaction exceptions
1522: if vCompanyIdIncluded then
1523: log_message('Before binding vTransactionId1. lCounterTemp='||lCounterTemp);
1524: DBMS_SQL.DEFINE_ARRAY(v_fetch_cursor,lCounterTemp,vTransactionId1,vBatchSize,1);
1525: lCounterTemp := lCounterTemp +1;
1526: end if;
1527: if vCustomerIdIncluded then
1528: log_message('Before binding vTransactionId2');

Line 1529: DBMS_SQL.DEFINE_ARRAY(v_fetch_cursor,lCounterTemp,vTransactionId2,vBatchSize,1);

1525: lCounterTemp := lCounterTemp +1;
1526: end if;
1527: if vCustomerIdIncluded then
1528: log_message('Before binding vTransactionId2');
1529: DBMS_SQL.DEFINE_ARRAY(v_fetch_cursor,lCounterTemp,vTransactionId2,vBatchSize,1);
1530: lCounterTemp := lCounterTemp +1;
1531: end if;
1532: if vSupplierIdIncluded then
1533: log_message('Before binding vTransactionId3');

Line 1534: DBMS_SQL.DEFINE_ARRAY(v_fetch_cursor,lCounterTemp,vTransactionId3,vBatchSize,1);

1530: lCounterTemp := lCounterTemp +1;
1531: end if;
1532: if vSupplierIdIncluded then
1533: log_message('Before binding vTransactionId3');
1534: DBMS_SQL.DEFINE_ARRAY(v_fetch_cursor,lCounterTemp,vTransactionId3,vBatchSize,1);
1535: end if;
1536:
1537: log_message('Before executing sql');
1538: v_ReturnCode := DBMS_SQL.EXECUTE(v_fetch_cursor);

Line 1538: v_ReturnCode := DBMS_SQL.EXECUTE(v_fetch_cursor);

1534: DBMS_SQL.DEFINE_ARRAY(v_fetch_cursor,lCounterTemp,vTransactionId3,vBatchSize,1);
1535: end if;
1536:
1537: log_message('Before executing sql');
1538: v_ReturnCode := DBMS_SQL.EXECUTE(v_fetch_cursor);
1539:
1540: end executeSQL ;
1541:
1542: Procedure DeletePreviousData( l_exception_id in number) is

Line 1672: v_NumRows := DBMS_SQL.FETCH_ROWS(v_fetch_cursor);

1668: end if;
1669:
1670: LOOP
1671: lCounterTemp := 1;
1672: v_NumRows := DBMS_SQL.FETCH_ROWS(v_fetch_cursor);
1673: if v_debug then
1674: log_message('after fetch' );
1675: end if;
1676: vTotalFetchedRows := dbms_sql.last_row_count;

Line 1676: vTotalFetchedRows := dbms_sql.last_row_count;

1672: v_NumRows := DBMS_SQL.FETCH_ROWS(v_fetch_cursor);
1673: if v_debug then
1674: log_message('after fetch' );
1675: end if;
1676: vTotalFetchedRows := dbms_sql.last_row_count;
1677: vTotalNumberOfFetches := vTotalNumberOfFetches + 1;
1678:
1679: if vTotalFetchedRows > 0 then
1680: v_exception_exist := 1;

Line 1717: --DBMS_SQL.COLUMN_VALUE(v_fetch_cursor,columnCounter,getVarcharArray(varchar2Counter) );

1713: varchar2Counter := varchar2Counter + 1;
1714: DBMSSQLStep(varchar2Counter, 'VARCHAR2' , 'COLUMN_VALUE',lCounterTemp);
1715: DBMSSQLStep(varchar2Counter, 'VARCHAR2' , 'BIND_ARRAY',lCounterTemp);
1716: --this doesn't work
1717: --DBMS_SQL.COLUMN_VALUE(v_fetch_cursor,columnCounter,getVarcharArray(varchar2Counter) );
1718: else
1719: --Datatype not correct
1720: FND_MESSAGE.SET_NAME('MSC', 'MSC_UDE_INCORRECT_DATA_TYPE');
1721: raise ExTerminateProgram;

Line 1731: DBMS_SQL.COLUMN_VALUE(v_fetch_cursor,lCounterTemp,vTransactionId1);

1727:
1728: --bind for transactions ids which are included by code
1729: if vCompanyIdIncluded then
1730: log_message('before COLUMN_VALUE for id. lCounterTemp='||lCounterTemp);
1731: DBMS_SQL.COLUMN_VALUE(v_fetch_cursor,lCounterTemp,vTransactionId1);
1732: log_message('after COLUMN_VALUE for id. lCounterTemp='||lCounterTemp);
1733: DBMS_SQL.BIND_ARRAY(v_insert_cursor,':TRANSACTION_ID1',vTransactionId1,vTotalFetchedRows-v_NumRows+1,vTotalFetchedRows);
1734: log_message('after BIND_ARRAY for id. ');
1735: lCounterTemp := lCounterTemp + 1;

Line 1733: DBMS_SQL.BIND_ARRAY(v_insert_cursor,':TRANSACTION_ID1',vTransactionId1,vTotalFetchedRows-v_NumRows+1,vTotalFetchedRows);

1729: if vCompanyIdIncluded then
1730: log_message('before COLUMN_VALUE for id. lCounterTemp='||lCounterTemp);
1731: DBMS_SQL.COLUMN_VALUE(v_fetch_cursor,lCounterTemp,vTransactionId1);
1732: log_message('after COLUMN_VALUE for id. lCounterTemp='||lCounterTemp);
1733: DBMS_SQL.BIND_ARRAY(v_insert_cursor,':TRANSACTION_ID1',vTransactionId1,vTotalFetchedRows-v_NumRows+1,vTotalFetchedRows);
1734: log_message('after BIND_ARRAY for id. ');
1735: lCounterTemp := lCounterTemp + 1;
1736: end if;
1737: if vCustomerIdIncluded then

Line 1738: DBMS_SQL.COLUMN_VALUE(v_fetch_cursor,lCounterTemp,vTransactionId2);

1734: log_message('after BIND_ARRAY for id. ');
1735: lCounterTemp := lCounterTemp + 1;
1736: end if;
1737: if vCustomerIdIncluded then
1738: DBMS_SQL.COLUMN_VALUE(v_fetch_cursor,lCounterTemp,vTransactionId2);
1739: DBMS_SQL.BIND_ARRAY(v_insert_cursor,':TRANSACTION_ID2',vTransactionId2,vTotalFetchedRows-v_NumRows+1,vTotalFetchedRows);
1740: lCounterTemp := lCounterTemp + 1;
1741: end if;
1742: if vSupplierIdIncluded then

Line 1739: DBMS_SQL.BIND_ARRAY(v_insert_cursor,':TRANSACTION_ID2',vTransactionId2,vTotalFetchedRows-v_NumRows+1,vTotalFetchedRows);

1735: lCounterTemp := lCounterTemp + 1;
1736: end if;
1737: if vCustomerIdIncluded then
1738: DBMS_SQL.COLUMN_VALUE(v_fetch_cursor,lCounterTemp,vTransactionId2);
1739: DBMS_SQL.BIND_ARRAY(v_insert_cursor,':TRANSACTION_ID2',vTransactionId2,vTotalFetchedRows-v_NumRows+1,vTotalFetchedRows);
1740: lCounterTemp := lCounterTemp + 1;
1741: end if;
1742: if vSupplierIdIncluded then
1743: DBMS_SQL.COLUMN_VALUE(v_fetch_cursor,lCounterTemp,vTransactionId3);

Line 1743: DBMS_SQL.COLUMN_VALUE(v_fetch_cursor,lCounterTemp,vTransactionId3);

1739: DBMS_SQL.BIND_ARRAY(v_insert_cursor,':TRANSACTION_ID2',vTransactionId2,vTotalFetchedRows-v_NumRows+1,vTotalFetchedRows);
1740: lCounterTemp := lCounterTemp + 1;
1741: end if;
1742: if vSupplierIdIncluded then
1743: DBMS_SQL.COLUMN_VALUE(v_fetch_cursor,lCounterTemp,vTransactionId3);
1744: DBMS_SQL.BIND_ARRAY(v_insert_cursor,':TRANSACTION_ID3',vTransactionId3,vTotalFetchedRows-v_NumRows+1,vTotalFetchedRows);
1745: end if;
1746:
1747: -- other variables are binded. now bind who columns

Line 1744: DBMS_SQL.BIND_ARRAY(v_insert_cursor,':TRANSACTION_ID3',vTransactionId3,vTotalFetchedRows-v_NumRows+1,vTotalFetchedRows);

1740: lCounterTemp := lCounterTemp + 1;
1741: end if;
1742: if vSupplierIdIncluded then
1743: DBMS_SQL.COLUMN_VALUE(v_fetch_cursor,lCounterTemp,vTransactionId3);
1744: DBMS_SQL.BIND_ARRAY(v_insert_cursor,':TRANSACTION_ID3',vTransactionId3,vTotalFetchedRows-v_NumRows+1,vTotalFetchedRows);
1745: end if;
1746:
1747: -- other variables are binded. now bind who columns
1748:

Line 1762: DBMS_SQL.BIND_ARRAY(v_insert_cursor,':CREATED_BY',v_CREATED_BY,1,v_NumRows);

1758: vExceptionGroupNameArray(i) := vExceptionGroupName;
1759: vOwningCompanyIdArray(i) := v_company_id;
1760: end loop;
1761:
1762: DBMS_SQL.BIND_ARRAY(v_insert_cursor,':CREATED_BY',v_CREATED_BY,1,v_NumRows);
1763: DBMS_SQL.BIND_ARRAY(v_insert_cursor,':CREATION_DATE',v_CREATION_DATE,1,v_NumRows);
1764: DBMS_SQL.BIND_ARRAY(v_insert_cursor,':LAST_UPDATED_BY',v_LAST_UPDATED_BY,1,v_NumRows);
1765: DBMS_SQL.BIND_ARRAY(v_insert_cursor,':LAST_UPDATE_DATE',v_LAST_UPDATE_DATE,1,v_NumRows);
1766: DBMS_SQL.BIND_ARRAY(v_insert_cursor,':EXCEPTION_DETAIL_ID',v_EXCEPTION_DETAIL_ID,1,v_NumRows);

Line 1763: DBMS_SQL.BIND_ARRAY(v_insert_cursor,':CREATION_DATE',v_CREATION_DATE,1,v_NumRows);

1759: vOwningCompanyIdArray(i) := v_company_id;
1760: end loop;
1761:
1762: DBMS_SQL.BIND_ARRAY(v_insert_cursor,':CREATED_BY',v_CREATED_BY,1,v_NumRows);
1763: DBMS_SQL.BIND_ARRAY(v_insert_cursor,':CREATION_DATE',v_CREATION_DATE,1,v_NumRows);
1764: DBMS_SQL.BIND_ARRAY(v_insert_cursor,':LAST_UPDATED_BY',v_LAST_UPDATED_BY,1,v_NumRows);
1765: DBMS_SQL.BIND_ARRAY(v_insert_cursor,':LAST_UPDATE_DATE',v_LAST_UPDATE_DATE,1,v_NumRows);
1766: DBMS_SQL.BIND_ARRAY(v_insert_cursor,':EXCEPTION_DETAIL_ID',v_EXCEPTION_DETAIL_ID,1,v_NumRows);
1767: DBMS_SQL.BIND_ARRAY(v_insert_cursor,':EXCEPTION_TYPE',vExceptionTypeArray,1,v_NumRows);

Line 1764: DBMS_SQL.BIND_ARRAY(v_insert_cursor,':LAST_UPDATED_BY',v_LAST_UPDATED_BY,1,v_NumRows);

1760: end loop;
1761:
1762: DBMS_SQL.BIND_ARRAY(v_insert_cursor,':CREATED_BY',v_CREATED_BY,1,v_NumRows);
1763: DBMS_SQL.BIND_ARRAY(v_insert_cursor,':CREATION_DATE',v_CREATION_DATE,1,v_NumRows);
1764: DBMS_SQL.BIND_ARRAY(v_insert_cursor,':LAST_UPDATED_BY',v_LAST_UPDATED_BY,1,v_NumRows);
1765: DBMS_SQL.BIND_ARRAY(v_insert_cursor,':LAST_UPDATE_DATE',v_LAST_UPDATE_DATE,1,v_NumRows);
1766: DBMS_SQL.BIND_ARRAY(v_insert_cursor,':EXCEPTION_DETAIL_ID',v_EXCEPTION_DETAIL_ID,1,v_NumRows);
1767: DBMS_SQL.BIND_ARRAY(v_insert_cursor,':EXCEPTION_TYPE',vExceptionTypeArray,1,v_NumRows);
1768: DBMS_SQL.BIND_ARRAY(v_insert_cursor,':EXCEPTION_TYPE_NAME',vExceptionTypeNameArray,1,v_NumRows);

Line 1765: DBMS_SQL.BIND_ARRAY(v_insert_cursor,':LAST_UPDATE_DATE',v_LAST_UPDATE_DATE,1,v_NumRows);

1761:
1762: DBMS_SQL.BIND_ARRAY(v_insert_cursor,':CREATED_BY',v_CREATED_BY,1,v_NumRows);
1763: DBMS_SQL.BIND_ARRAY(v_insert_cursor,':CREATION_DATE',v_CREATION_DATE,1,v_NumRows);
1764: DBMS_SQL.BIND_ARRAY(v_insert_cursor,':LAST_UPDATED_BY',v_LAST_UPDATED_BY,1,v_NumRows);
1765: DBMS_SQL.BIND_ARRAY(v_insert_cursor,':LAST_UPDATE_DATE',v_LAST_UPDATE_DATE,1,v_NumRows);
1766: DBMS_SQL.BIND_ARRAY(v_insert_cursor,':EXCEPTION_DETAIL_ID',v_EXCEPTION_DETAIL_ID,1,v_NumRows);
1767: DBMS_SQL.BIND_ARRAY(v_insert_cursor,':EXCEPTION_TYPE',vExceptionTypeArray,1,v_NumRows);
1768: DBMS_SQL.BIND_ARRAY(v_insert_cursor,':EXCEPTION_TYPE_NAME',vExceptionTypeNameArray,1,v_NumRows);
1769: DBMS_SQL.BIND_ARRAY(v_insert_cursor,':EXCEPTION_GROUP',vExceptionGroupArray,1,v_NumRows);

Line 1766: DBMS_SQL.BIND_ARRAY(v_insert_cursor,':EXCEPTION_DETAIL_ID',v_EXCEPTION_DETAIL_ID,1,v_NumRows);

1762: DBMS_SQL.BIND_ARRAY(v_insert_cursor,':CREATED_BY',v_CREATED_BY,1,v_NumRows);
1763: DBMS_SQL.BIND_ARRAY(v_insert_cursor,':CREATION_DATE',v_CREATION_DATE,1,v_NumRows);
1764: DBMS_SQL.BIND_ARRAY(v_insert_cursor,':LAST_UPDATED_BY',v_LAST_UPDATED_BY,1,v_NumRows);
1765: DBMS_SQL.BIND_ARRAY(v_insert_cursor,':LAST_UPDATE_DATE',v_LAST_UPDATE_DATE,1,v_NumRows);
1766: DBMS_SQL.BIND_ARRAY(v_insert_cursor,':EXCEPTION_DETAIL_ID',v_EXCEPTION_DETAIL_ID,1,v_NumRows);
1767: DBMS_SQL.BIND_ARRAY(v_insert_cursor,':EXCEPTION_TYPE',vExceptionTypeArray,1,v_NumRows);
1768: DBMS_SQL.BIND_ARRAY(v_insert_cursor,':EXCEPTION_TYPE_NAME',vExceptionTypeNameArray,1,v_NumRows);
1769: DBMS_SQL.BIND_ARRAY(v_insert_cursor,':EXCEPTION_GROUP',vExceptionGroupArray,1,v_NumRows);
1770: DBMS_SQL.BIND_ARRAY(v_insert_cursor,':EXCEPTION_GROUP_NAME',vExceptionGroupNameArray,1,v_NumRows);

Line 1767: DBMS_SQL.BIND_ARRAY(v_insert_cursor,':EXCEPTION_TYPE',vExceptionTypeArray,1,v_NumRows);

1763: DBMS_SQL.BIND_ARRAY(v_insert_cursor,':CREATION_DATE',v_CREATION_DATE,1,v_NumRows);
1764: DBMS_SQL.BIND_ARRAY(v_insert_cursor,':LAST_UPDATED_BY',v_LAST_UPDATED_BY,1,v_NumRows);
1765: DBMS_SQL.BIND_ARRAY(v_insert_cursor,':LAST_UPDATE_DATE',v_LAST_UPDATE_DATE,1,v_NumRows);
1766: DBMS_SQL.BIND_ARRAY(v_insert_cursor,':EXCEPTION_DETAIL_ID',v_EXCEPTION_DETAIL_ID,1,v_NumRows);
1767: DBMS_SQL.BIND_ARRAY(v_insert_cursor,':EXCEPTION_TYPE',vExceptionTypeArray,1,v_NumRows);
1768: DBMS_SQL.BIND_ARRAY(v_insert_cursor,':EXCEPTION_TYPE_NAME',vExceptionTypeNameArray,1,v_NumRows);
1769: DBMS_SQL.BIND_ARRAY(v_insert_cursor,':EXCEPTION_GROUP',vExceptionGroupArray,1,v_NumRows);
1770: DBMS_SQL.BIND_ARRAY(v_insert_cursor,':EXCEPTION_GROUP_NAME',vExceptionGroupNameArray,1,v_NumRows);
1771: DBMS_SQL.BIND_ARRAY(v_insert_cursor,':OWNING_COMPANY_ID',vOwningCompanyIdArray,1,v_NumRows);

Line 1768: DBMS_SQL.BIND_ARRAY(v_insert_cursor,':EXCEPTION_TYPE_NAME',vExceptionTypeNameArray,1,v_NumRows);

1764: DBMS_SQL.BIND_ARRAY(v_insert_cursor,':LAST_UPDATED_BY',v_LAST_UPDATED_BY,1,v_NumRows);
1765: DBMS_SQL.BIND_ARRAY(v_insert_cursor,':LAST_UPDATE_DATE',v_LAST_UPDATE_DATE,1,v_NumRows);
1766: DBMS_SQL.BIND_ARRAY(v_insert_cursor,':EXCEPTION_DETAIL_ID',v_EXCEPTION_DETAIL_ID,1,v_NumRows);
1767: DBMS_SQL.BIND_ARRAY(v_insert_cursor,':EXCEPTION_TYPE',vExceptionTypeArray,1,v_NumRows);
1768: DBMS_SQL.BIND_ARRAY(v_insert_cursor,':EXCEPTION_TYPE_NAME',vExceptionTypeNameArray,1,v_NumRows);
1769: DBMS_SQL.BIND_ARRAY(v_insert_cursor,':EXCEPTION_GROUP',vExceptionGroupArray,1,v_NumRows);
1770: DBMS_SQL.BIND_ARRAY(v_insert_cursor,':EXCEPTION_GROUP_NAME',vExceptionGroupNameArray,1,v_NumRows);
1771: DBMS_SQL.BIND_ARRAY(v_insert_cursor,':OWNING_COMPANY_ID',vOwningCompanyIdArray,1,v_NumRows);
1772:

Line 1769: DBMS_SQL.BIND_ARRAY(v_insert_cursor,':EXCEPTION_GROUP',vExceptionGroupArray,1,v_NumRows);

1765: DBMS_SQL.BIND_ARRAY(v_insert_cursor,':LAST_UPDATE_DATE',v_LAST_UPDATE_DATE,1,v_NumRows);
1766: DBMS_SQL.BIND_ARRAY(v_insert_cursor,':EXCEPTION_DETAIL_ID',v_EXCEPTION_DETAIL_ID,1,v_NumRows);
1767: DBMS_SQL.BIND_ARRAY(v_insert_cursor,':EXCEPTION_TYPE',vExceptionTypeArray,1,v_NumRows);
1768: DBMS_SQL.BIND_ARRAY(v_insert_cursor,':EXCEPTION_TYPE_NAME',vExceptionTypeNameArray,1,v_NumRows);
1769: DBMS_SQL.BIND_ARRAY(v_insert_cursor,':EXCEPTION_GROUP',vExceptionGroupArray,1,v_NumRows);
1770: DBMS_SQL.BIND_ARRAY(v_insert_cursor,':EXCEPTION_GROUP_NAME',vExceptionGroupNameArray,1,v_NumRows);
1771: DBMS_SQL.BIND_ARRAY(v_insert_cursor,':OWNING_COMPANY_ID',vOwningCompanyIdArray,1,v_NumRows);
1772:
1773:

Line 1770: DBMS_SQL.BIND_ARRAY(v_insert_cursor,':EXCEPTION_GROUP_NAME',vExceptionGroupNameArray,1,v_NumRows);

1766: DBMS_SQL.BIND_ARRAY(v_insert_cursor,':EXCEPTION_DETAIL_ID',v_EXCEPTION_DETAIL_ID,1,v_NumRows);
1767: DBMS_SQL.BIND_ARRAY(v_insert_cursor,':EXCEPTION_TYPE',vExceptionTypeArray,1,v_NumRows);
1768: DBMS_SQL.BIND_ARRAY(v_insert_cursor,':EXCEPTION_TYPE_NAME',vExceptionTypeNameArray,1,v_NumRows);
1769: DBMS_SQL.BIND_ARRAY(v_insert_cursor,':EXCEPTION_GROUP',vExceptionGroupArray,1,v_NumRows);
1770: DBMS_SQL.BIND_ARRAY(v_insert_cursor,':EXCEPTION_GROUP_NAME',vExceptionGroupNameArray,1,v_NumRows);
1771: DBMS_SQL.BIND_ARRAY(v_insert_cursor,':OWNING_COMPANY_ID',vOwningCompanyIdArray,1,v_NumRows);
1772:
1773:
1774: -- for transaction exceptions,if it is not running for full load

Line 1771: DBMS_SQL.BIND_ARRAY(v_insert_cursor,':OWNING_COMPANY_ID',vOwningCompanyIdArray,1,v_NumRows);

1767: DBMS_SQL.BIND_ARRAY(v_insert_cursor,':EXCEPTION_TYPE',vExceptionTypeArray,1,v_NumRows);
1768: DBMS_SQL.BIND_ARRAY(v_insert_cursor,':EXCEPTION_TYPE_NAME',vExceptionTypeNameArray,1,v_NumRows);
1769: DBMS_SQL.BIND_ARRAY(v_insert_cursor,':EXCEPTION_GROUP',vExceptionGroupArray,1,v_NumRows);
1770: DBMS_SQL.BIND_ARRAY(v_insert_cursor,':EXCEPTION_GROUP_NAME',vExceptionGroupNameArray,1,v_NumRows);
1771: DBMS_SQL.BIND_ARRAY(v_insert_cursor,':OWNING_COMPANY_ID',vOwningCompanyIdArray,1,v_NumRows);
1772:
1773:
1774: -- for transaction exceptions,if it is not running for full load
1775: -- delete exceptions rows which

Line 1812: v_ReturnCode := DBMS_SQL.EXECUTE(v_insert_cursor);

1808: -- execute the insert statement
1809: if v_debug and vTotalNumberOfFetches = 1 Then
1810: log_message('Before insert execution ');
1811: end if;
1812: v_ReturnCode := DBMS_SQL.EXECUTE(v_insert_cursor);
1813:
1814: if v_debug and vTotalNumberOfFetches = 1 Then
1815: log_message('number of records inserted='||v_ReturnCode);
1816: end if;

Line 1843: DBMS_SQL.CLOSE_CURSOR(v_fetch_cursor);

1839: END LOOP;
1840:
1841:
1842: log_message('Total number of exception ='||to_char(vTotalFetchedRows) );
1843: DBMS_SQL.CLOSE_CURSOR(v_fetch_cursor);
1844: DBMS_SQL.CLOSE_CURSOR(v_insert_cursor);
1845:
1846: end fetchAndInsertDetails;
1847:

Line 1844: DBMS_SQL.CLOSE_CURSOR(v_insert_cursor);

1840:
1841:
1842: log_message('Total number of exception ='||to_char(vTotalFetchedRows) );
1843: DBMS_SQL.CLOSE_CURSOR(v_fetch_cursor);
1844: DBMS_SQL.CLOSE_CURSOR(v_insert_cursor);
1845:
1846: end fetchAndInsertDetails;
1847:
1848: Procedure deleteResolvedExceptions is

Line 2314: DBMS_SQL.PARSE(l_cursor,Stmt, DBMS_SQL.native);

2310: Procedure parseStmt(l_cursor in number, Stmt IN VARCHAR2) is
2311: errorPos Number := -1;
2312: begin
2313: dumpStmt(Stmt);
2314: DBMS_SQL.PARSE(l_cursor,Stmt, DBMS_SQL.native);
2315: exception
2316: when others then
2317: errorPos := DBMS_SQL.last_error_position;
2318: if errorPos > 0 then

Line 2317: errorPos := DBMS_SQL.last_error_position;

2313: dumpStmt(Stmt);
2314: DBMS_SQL.PARSE(l_cursor,Stmt, DBMS_SQL.native);
2315: exception
2316: when others then
2317: errorPos := DBMS_SQL.last_error_position;
2318: if errorPos > 0 then
2319: log_message(substr(Stmt,1,errorPos)||'^^^^^');
2320: FND_MESSAGE.SET_NAME('MSC','MSC_UDE_PARSE_ERROR');
2321: FND_MESSAGE.SET_TOKEN('ERRPOS',to_char(errorPos) );

Line 2443: DBMS_SQL.DEFINE_ARRAY(v_fetch_cursor,columnCounter,v_Date1,vBatchSize,1);

2439: if DataArrayCounter = 1 then
2440:
2441: if dbms_call = 'DEFINE_ARRAY' then
2442: if data_type in ( 'DATE','DATETIME') then
2443: DBMS_SQL.DEFINE_ARRAY(v_fetch_cursor,columnCounter,v_Date1,vBatchSize,1);
2444: elsif data_type = 'NUMBER' then
2445: DBMS_SQL.DEFINE_ARRAY(v_fetch_cursor,columnCounter,v_number1,vBatchSize,1);
2446: elsif data_type = 'VARCHAR2' then
2447: DBMS_SQL.DEFINE_ARRAY(v_fetch_cursor,columnCounter,v_varchar1,vBatchSize,1);

Line 2445: DBMS_SQL.DEFINE_ARRAY(v_fetch_cursor,columnCounter,v_number1,vBatchSize,1);

2441: if dbms_call = 'DEFINE_ARRAY' then
2442: if data_type in ( 'DATE','DATETIME') then
2443: DBMS_SQL.DEFINE_ARRAY(v_fetch_cursor,columnCounter,v_Date1,vBatchSize,1);
2444: elsif data_type = 'NUMBER' then
2445: DBMS_SQL.DEFINE_ARRAY(v_fetch_cursor,columnCounter,v_number1,vBatchSize,1);
2446: elsif data_type = 'VARCHAR2' then
2447: DBMS_SQL.DEFINE_ARRAY(v_fetch_cursor,columnCounter,v_varchar1,vBatchSize,1);
2448: end if;
2449: elsif dbms_call = 'COLUMN_VALUE' Then

Line 2447: DBMS_SQL.DEFINE_ARRAY(v_fetch_cursor,columnCounter,v_varchar1,vBatchSize,1);

2443: DBMS_SQL.DEFINE_ARRAY(v_fetch_cursor,columnCounter,v_Date1,vBatchSize,1);
2444: elsif data_type = 'NUMBER' then
2445: DBMS_SQL.DEFINE_ARRAY(v_fetch_cursor,columnCounter,v_number1,vBatchSize,1);
2446: elsif data_type = 'VARCHAR2' then
2447: DBMS_SQL.DEFINE_ARRAY(v_fetch_cursor,columnCounter,v_varchar1,vBatchSize,1);
2448: end if;
2449: elsif dbms_call = 'COLUMN_VALUE' Then
2450: if data_type in ( 'DATE','DATETIME') then
2451: DBMS_SQL.COLUMN_VALUE(v_fetch_cursor,columnCounter,v_Date1);

Line 2451: DBMS_SQL.COLUMN_VALUE(v_fetch_cursor,columnCounter,v_Date1);

2447: DBMS_SQL.DEFINE_ARRAY(v_fetch_cursor,columnCounter,v_varchar1,vBatchSize,1);
2448: end if;
2449: elsif dbms_call = 'COLUMN_VALUE' Then
2450: if data_type in ( 'DATE','DATETIME') then
2451: DBMS_SQL.COLUMN_VALUE(v_fetch_cursor,columnCounter,v_Date1);
2452: elsif data_type = 'NUMBER' then
2453: DBMS_SQL.COLUMN_VALUE(v_fetch_cursor,columnCounter,v_number1);
2454: elsif data_type = 'VARCHAR2' then
2455: DBMS_SQL.COLUMN_VALUE(v_fetch_cursor,columnCounter,v_varchar1);

Line 2453: DBMS_SQL.COLUMN_VALUE(v_fetch_cursor,columnCounter,v_number1);

2449: elsif dbms_call = 'COLUMN_VALUE' Then
2450: if data_type in ( 'DATE','DATETIME') then
2451: DBMS_SQL.COLUMN_VALUE(v_fetch_cursor,columnCounter,v_Date1);
2452: elsif data_type = 'NUMBER' then
2453: DBMS_SQL.COLUMN_VALUE(v_fetch_cursor,columnCounter,v_number1);
2454: elsif data_type = 'VARCHAR2' then
2455: DBMS_SQL.COLUMN_VALUE(v_fetch_cursor,columnCounter,v_varchar1);
2456: end if;
2457: elsif dbms_call = 'BIND_ARRAY' Then

Line 2455: DBMS_SQL.COLUMN_VALUE(v_fetch_cursor,columnCounter,v_varchar1);

2451: DBMS_SQL.COLUMN_VALUE(v_fetch_cursor,columnCounter,v_Date1);
2452: elsif data_type = 'NUMBER' then
2453: DBMS_SQL.COLUMN_VALUE(v_fetch_cursor,columnCounter,v_number1);
2454: elsif data_type = 'VARCHAR2' then
2455: DBMS_SQL.COLUMN_VALUE(v_fetch_cursor,columnCounter,v_varchar1);
2456: end if;
2457: elsif dbms_call = 'BIND_ARRAY' Then
2458: if data_type in ( 'DATE','DATETIME') then
2459: DBMS_SQL.BIND_ARRAY(v_insert_cursor,':A'||to_char(columnCounter), v_Date1,vTotalFetchedRows-v_NumRows+1,vTotalFetchedRows);

Line 2459: DBMS_SQL.BIND_ARRAY(v_insert_cursor,':A'||to_char(columnCounter), v_Date1,vTotalFetchedRows-v_NumRows+1,vTotalFetchedRows);

2455: DBMS_SQL.COLUMN_VALUE(v_fetch_cursor,columnCounter,v_varchar1);
2456: end if;
2457: elsif dbms_call = 'BIND_ARRAY' Then
2458: if data_type in ( 'DATE','DATETIME') then
2459: DBMS_SQL.BIND_ARRAY(v_insert_cursor,':A'||to_char(columnCounter), v_Date1,vTotalFetchedRows-v_NumRows+1,vTotalFetchedRows);
2460: elsif data_type = 'VARCHAR2' then
2461: DBMS_SQL.BIND_ARRAY(v_insert_cursor,':A'||to_char(columnCounter), v_varchar1,vTotalFetchedRows-v_NumRows+1,vTotalFetchedRows);
2462: elsif data_type = 'NUMBER' then
2463: DBMS_SQL.BIND_ARRAY(v_insert_cursor,':A'||to_char(columnCounter), v_number1,vTotalFetchedRows-v_NumRows+1,vTotalFetchedRows);

Line 2461: DBMS_SQL.BIND_ARRAY(v_insert_cursor,':A'||to_char(columnCounter), v_varchar1,vTotalFetchedRows-v_NumRows+1,vTotalFetchedRows);

2457: elsif dbms_call = 'BIND_ARRAY' Then
2458: if data_type in ( 'DATE','DATETIME') then
2459: DBMS_SQL.BIND_ARRAY(v_insert_cursor,':A'||to_char(columnCounter), v_Date1,vTotalFetchedRows-v_NumRows+1,vTotalFetchedRows);
2460: elsif data_type = 'VARCHAR2' then
2461: DBMS_SQL.BIND_ARRAY(v_insert_cursor,':A'||to_char(columnCounter), v_varchar1,vTotalFetchedRows-v_NumRows+1,vTotalFetchedRows);
2462: elsif data_type = 'NUMBER' then
2463: DBMS_SQL.BIND_ARRAY(v_insert_cursor,':A'||to_char(columnCounter), v_number1,vTotalFetchedRows-v_NumRows+1,vTotalFetchedRows);
2464: end if;
2465: end if;

Line 2463: DBMS_SQL.BIND_ARRAY(v_insert_cursor,':A'||to_char(columnCounter), v_number1,vTotalFetchedRows-v_NumRows+1,vTotalFetchedRows);

2459: DBMS_SQL.BIND_ARRAY(v_insert_cursor,':A'||to_char(columnCounter), v_Date1,vTotalFetchedRows-v_NumRows+1,vTotalFetchedRows);
2460: elsif data_type = 'VARCHAR2' then
2461: DBMS_SQL.BIND_ARRAY(v_insert_cursor,':A'||to_char(columnCounter), v_varchar1,vTotalFetchedRows-v_NumRows+1,vTotalFetchedRows);
2462: elsif data_type = 'NUMBER' then
2463: DBMS_SQL.BIND_ARRAY(v_insert_cursor,':A'||to_char(columnCounter), v_number1,vTotalFetchedRows-v_NumRows+1,vTotalFetchedRows);
2464: end if;
2465: end if;
2466:
2467: elsif DataArrayCounter = 2 then

Line 2471: DBMS_SQL.DEFINE_ARRAY(v_fetch_cursor,columnCounter,v_Date2,vBatchSize,1);

2467: elsif DataArrayCounter = 2 then
2468:
2469: if dbms_call = 'DEFINE_ARRAY' then
2470: if data_type in ( 'DATE','DATETIME') then
2471: DBMS_SQL.DEFINE_ARRAY(v_fetch_cursor,columnCounter,v_Date2,vBatchSize,1);
2472: elsif data_type = 'VARCHAR2' then
2473: DBMS_SQL.DEFINE_ARRAY(v_fetch_cursor,columnCounter,v_varchar2,vBatchSize,1);
2474: elsif data_type = 'NUMBER' then
2475: DBMS_SQL.DEFINE_ARRAY(v_fetch_cursor,columnCounter,v_number2,vBatchSize,1);

Line 2473: DBMS_SQL.DEFINE_ARRAY(v_fetch_cursor,columnCounter,v_varchar2,vBatchSize,1);

2469: if dbms_call = 'DEFINE_ARRAY' then
2470: if data_type in ( 'DATE','DATETIME') then
2471: DBMS_SQL.DEFINE_ARRAY(v_fetch_cursor,columnCounter,v_Date2,vBatchSize,1);
2472: elsif data_type = 'VARCHAR2' then
2473: DBMS_SQL.DEFINE_ARRAY(v_fetch_cursor,columnCounter,v_varchar2,vBatchSize,1);
2474: elsif data_type = 'NUMBER' then
2475: DBMS_SQL.DEFINE_ARRAY(v_fetch_cursor,columnCounter,v_number2,vBatchSize,1);
2476: end if;
2477: elsif dbms_call = 'COLUMN_VALUE' Then

Line 2475: DBMS_SQL.DEFINE_ARRAY(v_fetch_cursor,columnCounter,v_number2,vBatchSize,1);

2471: DBMS_SQL.DEFINE_ARRAY(v_fetch_cursor,columnCounter,v_Date2,vBatchSize,1);
2472: elsif data_type = 'VARCHAR2' then
2473: DBMS_SQL.DEFINE_ARRAY(v_fetch_cursor,columnCounter,v_varchar2,vBatchSize,1);
2474: elsif data_type = 'NUMBER' then
2475: DBMS_SQL.DEFINE_ARRAY(v_fetch_cursor,columnCounter,v_number2,vBatchSize,1);
2476: end if;
2477: elsif dbms_call = 'COLUMN_VALUE' Then
2478: if data_type in ( 'DATE','DATETIME') then
2479: DBMS_SQL.COLUMN_VALUE(v_fetch_cursor,columnCounter,v_Date2);

Line 2479: DBMS_SQL.COLUMN_VALUE(v_fetch_cursor,columnCounter,v_Date2);

2475: DBMS_SQL.DEFINE_ARRAY(v_fetch_cursor,columnCounter,v_number2,vBatchSize,1);
2476: end if;
2477: elsif dbms_call = 'COLUMN_VALUE' Then
2478: if data_type in ( 'DATE','DATETIME') then
2479: DBMS_SQL.COLUMN_VALUE(v_fetch_cursor,columnCounter,v_Date2);
2480: elsif data_type = 'VARCHAR2' then
2481: DBMS_SQL.COLUMN_VALUE(v_fetch_cursor,columnCounter,v_varchar2);
2482: elsif data_type = 'NUMBER' then
2483: DBMS_SQL.COLUMN_VALUE(v_fetch_cursor,columnCounter,v_number2);

Line 2481: DBMS_SQL.COLUMN_VALUE(v_fetch_cursor,columnCounter,v_varchar2);

2477: elsif dbms_call = 'COLUMN_VALUE' Then
2478: if data_type in ( 'DATE','DATETIME') then
2479: DBMS_SQL.COLUMN_VALUE(v_fetch_cursor,columnCounter,v_Date2);
2480: elsif data_type = 'VARCHAR2' then
2481: DBMS_SQL.COLUMN_VALUE(v_fetch_cursor,columnCounter,v_varchar2);
2482: elsif data_type = 'NUMBER' then
2483: DBMS_SQL.COLUMN_VALUE(v_fetch_cursor,columnCounter,v_number2);
2484: end if;
2485:

Line 2483: DBMS_SQL.COLUMN_VALUE(v_fetch_cursor,columnCounter,v_number2);

2479: DBMS_SQL.COLUMN_VALUE(v_fetch_cursor,columnCounter,v_Date2);
2480: elsif data_type = 'VARCHAR2' then
2481: DBMS_SQL.COLUMN_VALUE(v_fetch_cursor,columnCounter,v_varchar2);
2482: elsif data_type = 'NUMBER' then
2483: DBMS_SQL.COLUMN_VALUE(v_fetch_cursor,columnCounter,v_number2);
2484: end if;
2485:
2486: elsif dbms_call = 'BIND_ARRAY' Then
2487:

Line 2489: DBMS_SQL.BIND_ARRAY(v_insert_cursor,':A'||to_char(columnCounter), v_Date2,vTotalFetchedRows-v_NumRows+1,vTotalFetchedRows);

2485:
2486: elsif dbms_call = 'BIND_ARRAY' Then
2487:
2488: if data_type in ( 'DATE','DATETIME') then
2489: DBMS_SQL.BIND_ARRAY(v_insert_cursor,':A'||to_char(columnCounter), v_Date2,vTotalFetchedRows-v_NumRows+1,vTotalFetchedRows);
2490: elsif data_type = 'VARCHAR2' then
2491: DBMS_SQL.BIND_ARRAY(v_insert_cursor,':A'||to_char(columnCounter), v_varchar2,vTotalFetchedRows-v_NumRows+1,vTotalFetchedRows);
2492: elsif data_type = 'NUMBER' then
2493: DBMS_SQL.BIND_ARRAY(v_insert_cursor,':A'||to_char(columnCounter), v_number2,vTotalFetchedRows-v_NumRows+1,vTotalFetchedRows);

Line 2491: DBMS_SQL.BIND_ARRAY(v_insert_cursor,':A'||to_char(columnCounter), v_varchar2,vTotalFetchedRows-v_NumRows+1,vTotalFetchedRows);

2487:
2488: if data_type in ( 'DATE','DATETIME') then
2489: DBMS_SQL.BIND_ARRAY(v_insert_cursor,':A'||to_char(columnCounter), v_Date2,vTotalFetchedRows-v_NumRows+1,vTotalFetchedRows);
2490: elsif data_type = 'VARCHAR2' then
2491: DBMS_SQL.BIND_ARRAY(v_insert_cursor,':A'||to_char(columnCounter), v_varchar2,vTotalFetchedRows-v_NumRows+1,vTotalFetchedRows);
2492: elsif data_type = 'NUMBER' then
2493: DBMS_SQL.BIND_ARRAY(v_insert_cursor,':A'||to_char(columnCounter), v_number2,vTotalFetchedRows-v_NumRows+1,vTotalFetchedRows);
2494: end if;
2495:

Line 2493: DBMS_SQL.BIND_ARRAY(v_insert_cursor,':A'||to_char(columnCounter), v_number2,vTotalFetchedRows-v_NumRows+1,vTotalFetchedRows);

2489: DBMS_SQL.BIND_ARRAY(v_insert_cursor,':A'||to_char(columnCounter), v_Date2,vTotalFetchedRows-v_NumRows+1,vTotalFetchedRows);
2490: elsif data_type = 'VARCHAR2' then
2491: DBMS_SQL.BIND_ARRAY(v_insert_cursor,':A'||to_char(columnCounter), v_varchar2,vTotalFetchedRows-v_NumRows+1,vTotalFetchedRows);
2492: elsif data_type = 'NUMBER' then
2493: DBMS_SQL.BIND_ARRAY(v_insert_cursor,':A'||to_char(columnCounter), v_number2,vTotalFetchedRows-v_NumRows+1,vTotalFetchedRows);
2494: end if;
2495:
2496: end if;
2497:

Line 2501: DBMS_SQL.DEFINE_ARRAY(v_fetch_cursor,columnCounter,v_Date3,vBatchSize,1);

2497:
2498: elsif DataArrayCounter = 3 then
2499: if dbms_call = 'DEFINE_ARRAY' then
2500: if data_type in ( 'DATE','DATETIME') then
2501: DBMS_SQL.DEFINE_ARRAY(v_fetch_cursor,columnCounter,v_Date3,vBatchSize,1);
2502: elsif data_type = 'VARCHAR2' then
2503: DBMS_SQL.DEFINE_ARRAY(v_fetch_cursor,columnCounter,v_varchar3,vBatchSize,1);
2504: elsif data_type = 'NUMBER' then
2505: DBMS_SQL.DEFINE_ARRAY(v_fetch_cursor,columnCounter,v_number3,vBatchSize,1);

Line 2503: DBMS_SQL.DEFINE_ARRAY(v_fetch_cursor,columnCounter,v_varchar3,vBatchSize,1);

2499: if dbms_call = 'DEFINE_ARRAY' then
2500: if data_type in ( 'DATE','DATETIME') then
2501: DBMS_SQL.DEFINE_ARRAY(v_fetch_cursor,columnCounter,v_Date3,vBatchSize,1);
2502: elsif data_type = 'VARCHAR2' then
2503: DBMS_SQL.DEFINE_ARRAY(v_fetch_cursor,columnCounter,v_varchar3,vBatchSize,1);
2504: elsif data_type = 'NUMBER' then
2505: DBMS_SQL.DEFINE_ARRAY(v_fetch_cursor,columnCounter,v_number3,vBatchSize,1);
2506: end if;
2507: elsif dbms_call = 'COLUMN_VALUE' Then

Line 2505: DBMS_SQL.DEFINE_ARRAY(v_fetch_cursor,columnCounter,v_number3,vBatchSize,1);

2501: DBMS_SQL.DEFINE_ARRAY(v_fetch_cursor,columnCounter,v_Date3,vBatchSize,1);
2502: elsif data_type = 'VARCHAR2' then
2503: DBMS_SQL.DEFINE_ARRAY(v_fetch_cursor,columnCounter,v_varchar3,vBatchSize,1);
2504: elsif data_type = 'NUMBER' then
2505: DBMS_SQL.DEFINE_ARRAY(v_fetch_cursor,columnCounter,v_number3,vBatchSize,1);
2506: end if;
2507: elsif dbms_call = 'COLUMN_VALUE' Then
2508: if data_type in ( 'DATE','DATETIME') then
2509: DBMS_SQL.COLUMN_VALUE(v_fetch_cursor,columnCounter,v_Date3);

Line 2509: DBMS_SQL.COLUMN_VALUE(v_fetch_cursor,columnCounter,v_Date3);

2505: DBMS_SQL.DEFINE_ARRAY(v_fetch_cursor,columnCounter,v_number3,vBatchSize,1);
2506: end if;
2507: elsif dbms_call = 'COLUMN_VALUE' Then
2508: if data_type in ( 'DATE','DATETIME') then
2509: DBMS_SQL.COLUMN_VALUE(v_fetch_cursor,columnCounter,v_Date3);
2510: elsif data_type = 'VARCHAR2' then
2511: DBMS_SQL.COLUMN_VALUE(v_fetch_cursor,columnCounter,v_varchar3);
2512: elsif data_type = 'NUMBER' then
2513: DBMS_SQL.COLUMN_VALUE(v_fetch_cursor,columnCounter,v_number3);

Line 2511: DBMS_SQL.COLUMN_VALUE(v_fetch_cursor,columnCounter,v_varchar3);

2507: elsif dbms_call = 'COLUMN_VALUE' Then
2508: if data_type in ( 'DATE','DATETIME') then
2509: DBMS_SQL.COLUMN_VALUE(v_fetch_cursor,columnCounter,v_Date3);
2510: elsif data_type = 'VARCHAR2' then
2511: DBMS_SQL.COLUMN_VALUE(v_fetch_cursor,columnCounter,v_varchar3);
2512: elsif data_type = 'NUMBER' then
2513: DBMS_SQL.COLUMN_VALUE(v_fetch_cursor,columnCounter,v_number3);
2514: end if;
2515:

Line 2513: DBMS_SQL.COLUMN_VALUE(v_fetch_cursor,columnCounter,v_number3);

2509: DBMS_SQL.COLUMN_VALUE(v_fetch_cursor,columnCounter,v_Date3);
2510: elsif data_type = 'VARCHAR2' then
2511: DBMS_SQL.COLUMN_VALUE(v_fetch_cursor,columnCounter,v_varchar3);
2512: elsif data_type = 'NUMBER' then
2513: DBMS_SQL.COLUMN_VALUE(v_fetch_cursor,columnCounter,v_number3);
2514: end if;
2515:
2516: elsif dbms_call = 'BIND_ARRAY' Then
2517:

Line 2519: DBMS_SQL.BIND_ARRAY(v_insert_cursor,':A'||to_char(columnCounter), v_Date3,vTotalFetchedRows-v_NumRows+1,vTotalFetchedRows);

2515:
2516: elsif dbms_call = 'BIND_ARRAY' Then
2517:
2518: if data_type in ( 'DATE','DATETIME') then
2519: DBMS_SQL.BIND_ARRAY(v_insert_cursor,':A'||to_char(columnCounter), v_Date3,vTotalFetchedRows-v_NumRows+1,vTotalFetchedRows);
2520: elsif data_type = 'VARCHAR2' then
2521: DBMS_SQL.BIND_ARRAY(v_insert_cursor,':A'||to_char(columnCounter), v_varchar3,vTotalFetchedRows-v_NumRows+1,vTotalFetchedRows);
2522: elsif data_type = 'NUMBER' then
2523: DBMS_SQL.BIND_ARRAY(v_insert_cursor,':A'||to_char(columnCounter), v_number3,vTotalFetchedRows-v_NumRows+1,vTotalFetchedRows);

Line 2521: DBMS_SQL.BIND_ARRAY(v_insert_cursor,':A'||to_char(columnCounter), v_varchar3,vTotalFetchedRows-v_NumRows+1,vTotalFetchedRows);

2517:
2518: if data_type in ( 'DATE','DATETIME') then
2519: DBMS_SQL.BIND_ARRAY(v_insert_cursor,':A'||to_char(columnCounter), v_Date3,vTotalFetchedRows-v_NumRows+1,vTotalFetchedRows);
2520: elsif data_type = 'VARCHAR2' then
2521: DBMS_SQL.BIND_ARRAY(v_insert_cursor,':A'||to_char(columnCounter), v_varchar3,vTotalFetchedRows-v_NumRows+1,vTotalFetchedRows);
2522: elsif data_type = 'NUMBER' then
2523: DBMS_SQL.BIND_ARRAY(v_insert_cursor,':A'||to_char(columnCounter), v_number3,vTotalFetchedRows-v_NumRows+1,vTotalFetchedRows);
2524: end if;
2525:

Line 2523: DBMS_SQL.BIND_ARRAY(v_insert_cursor,':A'||to_char(columnCounter), v_number3,vTotalFetchedRows-v_NumRows+1,vTotalFetchedRows);

2519: DBMS_SQL.BIND_ARRAY(v_insert_cursor,':A'||to_char(columnCounter), v_Date3,vTotalFetchedRows-v_NumRows+1,vTotalFetchedRows);
2520: elsif data_type = 'VARCHAR2' then
2521: DBMS_SQL.BIND_ARRAY(v_insert_cursor,':A'||to_char(columnCounter), v_varchar3,vTotalFetchedRows-v_NumRows+1,vTotalFetchedRows);
2522: elsif data_type = 'NUMBER' then
2523: DBMS_SQL.BIND_ARRAY(v_insert_cursor,':A'||to_char(columnCounter), v_number3,vTotalFetchedRows-v_NumRows+1,vTotalFetchedRows);
2524: end if;
2525:
2526: end if;
2527:

Line 2532: DBMS_SQL.DEFINE_ARRAY(v_fetch_cursor,columnCounter,v_Date4,vBatchSize,1);

2528: elsif DataArrayCounter = 4 then
2529:
2530: if dbms_call = 'DEFINE_ARRAY' then
2531: if data_type in ( 'DATE','DATETIME') then
2532: DBMS_SQL.DEFINE_ARRAY(v_fetch_cursor,columnCounter,v_Date4,vBatchSize,1);
2533: elsif data_type = 'VARCHAR2' then
2534: DBMS_SQL.DEFINE_ARRAY(v_fetch_cursor,columnCounter,v_varchar4,vBatchSize,1);
2535: elsif data_type = 'NUMBER' then
2536: DBMS_SQL.DEFINE_ARRAY(v_fetch_cursor,columnCounter,v_number4,vBatchSize,1);

Line 2534: DBMS_SQL.DEFINE_ARRAY(v_fetch_cursor,columnCounter,v_varchar4,vBatchSize,1);

2530: if dbms_call = 'DEFINE_ARRAY' then
2531: if data_type in ( 'DATE','DATETIME') then
2532: DBMS_SQL.DEFINE_ARRAY(v_fetch_cursor,columnCounter,v_Date4,vBatchSize,1);
2533: elsif data_type = 'VARCHAR2' then
2534: DBMS_SQL.DEFINE_ARRAY(v_fetch_cursor,columnCounter,v_varchar4,vBatchSize,1);
2535: elsif data_type = 'NUMBER' then
2536: DBMS_SQL.DEFINE_ARRAY(v_fetch_cursor,columnCounter,v_number4,vBatchSize,1);
2537: end if;
2538: elsif dbms_call = 'COLUMN_VALUE' Then

Line 2536: DBMS_SQL.DEFINE_ARRAY(v_fetch_cursor,columnCounter,v_number4,vBatchSize,1);

2532: DBMS_SQL.DEFINE_ARRAY(v_fetch_cursor,columnCounter,v_Date4,vBatchSize,1);
2533: elsif data_type = 'VARCHAR2' then
2534: DBMS_SQL.DEFINE_ARRAY(v_fetch_cursor,columnCounter,v_varchar4,vBatchSize,1);
2535: elsif data_type = 'NUMBER' then
2536: DBMS_SQL.DEFINE_ARRAY(v_fetch_cursor,columnCounter,v_number4,vBatchSize,1);
2537: end if;
2538: elsif dbms_call = 'COLUMN_VALUE' Then
2539: if data_type in ( 'DATE','DATETIME') then
2540: DBMS_SQL.COLUMN_VALUE(v_fetch_cursor,columnCounter,v_Date4);

Line 2540: DBMS_SQL.COLUMN_VALUE(v_fetch_cursor,columnCounter,v_Date4);

2536: DBMS_SQL.DEFINE_ARRAY(v_fetch_cursor,columnCounter,v_number4,vBatchSize,1);
2537: end if;
2538: elsif dbms_call = 'COLUMN_VALUE' Then
2539: if data_type in ( 'DATE','DATETIME') then
2540: DBMS_SQL.COLUMN_VALUE(v_fetch_cursor,columnCounter,v_Date4);
2541: elsif data_type = 'VARCHAR2' then
2542: DBMS_SQL.COLUMN_VALUE(v_fetch_cursor,columnCounter,v_varchar4);
2543: elsif data_type = 'NUMBER' then
2544: DBMS_SQL.COLUMN_VALUE(v_fetch_cursor,columnCounter,v_number4);

Line 2542: DBMS_SQL.COLUMN_VALUE(v_fetch_cursor,columnCounter,v_varchar4);

2538: elsif dbms_call = 'COLUMN_VALUE' Then
2539: if data_type in ( 'DATE','DATETIME') then
2540: DBMS_SQL.COLUMN_VALUE(v_fetch_cursor,columnCounter,v_Date4);
2541: elsif data_type = 'VARCHAR2' then
2542: DBMS_SQL.COLUMN_VALUE(v_fetch_cursor,columnCounter,v_varchar4);
2543: elsif data_type = 'NUMBER' then
2544: DBMS_SQL.COLUMN_VALUE(v_fetch_cursor,columnCounter,v_number4);
2545: end if;
2546:

Line 2544: DBMS_SQL.COLUMN_VALUE(v_fetch_cursor,columnCounter,v_number4);

2540: DBMS_SQL.COLUMN_VALUE(v_fetch_cursor,columnCounter,v_Date4);
2541: elsif data_type = 'VARCHAR2' then
2542: DBMS_SQL.COLUMN_VALUE(v_fetch_cursor,columnCounter,v_varchar4);
2543: elsif data_type = 'NUMBER' then
2544: DBMS_SQL.COLUMN_VALUE(v_fetch_cursor,columnCounter,v_number4);
2545: end if;
2546:
2547: elsif dbms_call = 'BIND_ARRAY' Then
2548:

Line 2550: DBMS_SQL.BIND_ARRAY(v_insert_cursor,':A'||to_char(columnCounter), v_Date4,vTotalFetchedRows-v_NumRows+1,vTotalFetchedRows);

2546:
2547: elsif dbms_call = 'BIND_ARRAY' Then
2548:
2549: if data_type in ( 'DATE','DATETIME') then
2550: DBMS_SQL.BIND_ARRAY(v_insert_cursor,':A'||to_char(columnCounter), v_Date4,vTotalFetchedRows-v_NumRows+1,vTotalFetchedRows);
2551: elsif data_type = 'VARCHAR2' then
2552: DBMS_SQL.BIND_ARRAY(v_insert_cursor,':A'||to_char(columnCounter), v_varchar4,vTotalFetchedRows-v_NumRows+1,vTotalFetchedRows);
2553: elsif data_type = 'NUMBER' then
2554: DBMS_SQL.BIND_ARRAY(v_insert_cursor,':A'||to_char(columnCounter), v_number4,vTotalFetchedRows-v_NumRows+1,vTotalFetchedRows);

Line 2552: DBMS_SQL.BIND_ARRAY(v_insert_cursor,':A'||to_char(columnCounter), v_varchar4,vTotalFetchedRows-v_NumRows+1,vTotalFetchedRows);

2548:
2549: if data_type in ( 'DATE','DATETIME') then
2550: DBMS_SQL.BIND_ARRAY(v_insert_cursor,':A'||to_char(columnCounter), v_Date4,vTotalFetchedRows-v_NumRows+1,vTotalFetchedRows);
2551: elsif data_type = 'VARCHAR2' then
2552: DBMS_SQL.BIND_ARRAY(v_insert_cursor,':A'||to_char(columnCounter), v_varchar4,vTotalFetchedRows-v_NumRows+1,vTotalFetchedRows);
2553: elsif data_type = 'NUMBER' then
2554: DBMS_SQL.BIND_ARRAY(v_insert_cursor,':A'||to_char(columnCounter), v_number4,vTotalFetchedRows-v_NumRows+1,vTotalFetchedRows);
2555: end if;
2556:

Line 2554: DBMS_SQL.BIND_ARRAY(v_insert_cursor,':A'||to_char(columnCounter), v_number4,vTotalFetchedRows-v_NumRows+1,vTotalFetchedRows);

2550: DBMS_SQL.BIND_ARRAY(v_insert_cursor,':A'||to_char(columnCounter), v_Date4,vTotalFetchedRows-v_NumRows+1,vTotalFetchedRows);
2551: elsif data_type = 'VARCHAR2' then
2552: DBMS_SQL.BIND_ARRAY(v_insert_cursor,':A'||to_char(columnCounter), v_varchar4,vTotalFetchedRows-v_NumRows+1,vTotalFetchedRows);
2553: elsif data_type = 'NUMBER' then
2554: DBMS_SQL.BIND_ARRAY(v_insert_cursor,':A'||to_char(columnCounter), v_number4,vTotalFetchedRows-v_NumRows+1,vTotalFetchedRows);
2555: end if;
2556:
2557: end if;
2558: elsif DataArrayCounter = 5 then

Line 2562: DBMS_SQL.DEFINE_ARRAY(v_fetch_cursor,columnCounter,v_Date5,vBatchSize,1);

2558: elsif DataArrayCounter = 5 then
2559:
2560: if dbms_call = 'DEFINE_ARRAY' then
2561: if data_type in ( 'DATE','DATETIME') then
2562: DBMS_SQL.DEFINE_ARRAY(v_fetch_cursor,columnCounter,v_Date5,vBatchSize,1);
2563: elsif data_type = 'VARCHAR2' then
2564: DBMS_SQL.DEFINE_ARRAY(v_fetch_cursor,columnCounter,v_varchar5,vBatchSize,1);
2565: elsif data_type = 'NUMBER' then
2566: DBMS_SQL.DEFINE_ARRAY(v_fetch_cursor,columnCounter,v_number5,vBatchSize,1);

Line 2564: DBMS_SQL.DEFINE_ARRAY(v_fetch_cursor,columnCounter,v_varchar5,vBatchSize,1);

2560: if dbms_call = 'DEFINE_ARRAY' then
2561: if data_type in ( 'DATE','DATETIME') then
2562: DBMS_SQL.DEFINE_ARRAY(v_fetch_cursor,columnCounter,v_Date5,vBatchSize,1);
2563: elsif data_type = 'VARCHAR2' then
2564: DBMS_SQL.DEFINE_ARRAY(v_fetch_cursor,columnCounter,v_varchar5,vBatchSize,1);
2565: elsif data_type = 'NUMBER' then
2566: DBMS_SQL.DEFINE_ARRAY(v_fetch_cursor,columnCounter,v_number5,vBatchSize,1);
2567: end if;
2568: elsif dbms_call = 'COLUMN_VALUE' Then

Line 2566: DBMS_SQL.DEFINE_ARRAY(v_fetch_cursor,columnCounter,v_number5,vBatchSize,1);

2562: DBMS_SQL.DEFINE_ARRAY(v_fetch_cursor,columnCounter,v_Date5,vBatchSize,1);
2563: elsif data_type = 'VARCHAR2' then
2564: DBMS_SQL.DEFINE_ARRAY(v_fetch_cursor,columnCounter,v_varchar5,vBatchSize,1);
2565: elsif data_type = 'NUMBER' then
2566: DBMS_SQL.DEFINE_ARRAY(v_fetch_cursor,columnCounter,v_number5,vBatchSize,1);
2567: end if;
2568: elsif dbms_call = 'COLUMN_VALUE' Then
2569: if data_type in ( 'DATE','DATETIME') then
2570: DBMS_SQL.COLUMN_VALUE(v_fetch_cursor,columnCounter,v_Date5);

Line 2570: DBMS_SQL.COLUMN_VALUE(v_fetch_cursor,columnCounter,v_Date5);

2566: DBMS_SQL.DEFINE_ARRAY(v_fetch_cursor,columnCounter,v_number5,vBatchSize,1);
2567: end if;
2568: elsif dbms_call = 'COLUMN_VALUE' Then
2569: if data_type in ( 'DATE','DATETIME') then
2570: DBMS_SQL.COLUMN_VALUE(v_fetch_cursor,columnCounter,v_Date5);
2571: elsif data_type = 'VARCHAR2' then
2572: DBMS_SQL.COLUMN_VALUE(v_fetch_cursor,columnCounter,v_varchar5);
2573: elsif data_type = 'NUMBER' then
2574: DBMS_SQL.COLUMN_VALUE(v_fetch_cursor,columnCounter,v_number5);

Line 2572: DBMS_SQL.COLUMN_VALUE(v_fetch_cursor,columnCounter,v_varchar5);

2568: elsif dbms_call = 'COLUMN_VALUE' Then
2569: if data_type in ( 'DATE','DATETIME') then
2570: DBMS_SQL.COLUMN_VALUE(v_fetch_cursor,columnCounter,v_Date5);
2571: elsif data_type = 'VARCHAR2' then
2572: DBMS_SQL.COLUMN_VALUE(v_fetch_cursor,columnCounter,v_varchar5);
2573: elsif data_type = 'NUMBER' then
2574: DBMS_SQL.COLUMN_VALUE(v_fetch_cursor,columnCounter,v_number5);
2575: end if;
2576:

Line 2574: DBMS_SQL.COLUMN_VALUE(v_fetch_cursor,columnCounter,v_number5);

2570: DBMS_SQL.COLUMN_VALUE(v_fetch_cursor,columnCounter,v_Date5);
2571: elsif data_type = 'VARCHAR2' then
2572: DBMS_SQL.COLUMN_VALUE(v_fetch_cursor,columnCounter,v_varchar5);
2573: elsif data_type = 'NUMBER' then
2574: DBMS_SQL.COLUMN_VALUE(v_fetch_cursor,columnCounter,v_number5);
2575: end if;
2576:
2577: elsif dbms_call = 'BIND_ARRAY' Then
2578:

Line 2580: DBMS_SQL.BIND_ARRAY(v_insert_cursor,':A'||to_char(columnCounter), v_Date5,vTotalFetchedRows-v_NumRows+1,vTotalFetchedRows);

2576:
2577: elsif dbms_call = 'BIND_ARRAY' Then
2578:
2579: if data_type in ( 'DATE','DATETIME') then
2580: DBMS_SQL.BIND_ARRAY(v_insert_cursor,':A'||to_char(columnCounter), v_Date5,vTotalFetchedRows-v_NumRows+1,vTotalFetchedRows);
2581: elsif data_type = 'VARCHAR2' then
2582: DBMS_SQL.BIND_ARRAY(v_insert_cursor,':A'||to_char(columnCounter), v_varchar5,vTotalFetchedRows-v_NumRows+1,vTotalFetchedRows);
2583: elsif data_type = 'NUMBER' then
2584: DBMS_SQL.BIND_ARRAY(v_insert_cursor,':A'||to_char(columnCounter), v_number5,vTotalFetchedRows-v_NumRows+1,vTotalFetchedRows);

Line 2582: DBMS_SQL.BIND_ARRAY(v_insert_cursor,':A'||to_char(columnCounter), v_varchar5,vTotalFetchedRows-v_NumRows+1,vTotalFetchedRows);

2578:
2579: if data_type in ( 'DATE','DATETIME') then
2580: DBMS_SQL.BIND_ARRAY(v_insert_cursor,':A'||to_char(columnCounter), v_Date5,vTotalFetchedRows-v_NumRows+1,vTotalFetchedRows);
2581: elsif data_type = 'VARCHAR2' then
2582: DBMS_SQL.BIND_ARRAY(v_insert_cursor,':A'||to_char(columnCounter), v_varchar5,vTotalFetchedRows-v_NumRows+1,vTotalFetchedRows);
2583: elsif data_type = 'NUMBER' then
2584: DBMS_SQL.BIND_ARRAY(v_insert_cursor,':A'||to_char(columnCounter), v_number5,vTotalFetchedRows-v_NumRows+1,vTotalFetchedRows);
2585: end if;
2586:

Line 2584: DBMS_SQL.BIND_ARRAY(v_insert_cursor,':A'||to_char(columnCounter), v_number5,vTotalFetchedRows-v_NumRows+1,vTotalFetchedRows);

2580: DBMS_SQL.BIND_ARRAY(v_insert_cursor,':A'||to_char(columnCounter), v_Date5,vTotalFetchedRows-v_NumRows+1,vTotalFetchedRows);
2581: elsif data_type = 'VARCHAR2' then
2582: DBMS_SQL.BIND_ARRAY(v_insert_cursor,':A'||to_char(columnCounter), v_varchar5,vTotalFetchedRows-v_NumRows+1,vTotalFetchedRows);
2583: elsif data_type = 'NUMBER' then
2584: DBMS_SQL.BIND_ARRAY(v_insert_cursor,':A'||to_char(columnCounter), v_number5,vTotalFetchedRows-v_NumRows+1,vTotalFetchedRows);
2585: end if;
2586:
2587: end if;
2588:

Line 2593: DBMS_SQL.DEFINE_ARRAY(v_fetch_cursor,columnCounter,v_Date6,vBatchSize,1);

2589: elsif DataArrayCounter = 6 then
2590:
2591: if dbms_call = 'DEFINE_ARRAY' then
2592: if data_type in ( 'DATE','DATETIME') then
2593: DBMS_SQL.DEFINE_ARRAY(v_fetch_cursor,columnCounter,v_Date6,vBatchSize,1);
2594: elsif data_type = 'VARCHAR2' then
2595: DBMS_SQL.DEFINE_ARRAY(v_fetch_cursor,columnCounter,v_varchar6,vBatchSize,1);
2596: elsif data_type = 'NUMBER' then
2597: DBMS_SQL.DEFINE_ARRAY(v_fetch_cursor,columnCounter,v_number6,vBatchSize,1);

Line 2595: DBMS_SQL.DEFINE_ARRAY(v_fetch_cursor,columnCounter,v_varchar6,vBatchSize,1);

2591: if dbms_call = 'DEFINE_ARRAY' then
2592: if data_type in ( 'DATE','DATETIME') then
2593: DBMS_SQL.DEFINE_ARRAY(v_fetch_cursor,columnCounter,v_Date6,vBatchSize,1);
2594: elsif data_type = 'VARCHAR2' then
2595: DBMS_SQL.DEFINE_ARRAY(v_fetch_cursor,columnCounter,v_varchar6,vBatchSize,1);
2596: elsif data_type = 'NUMBER' then
2597: DBMS_SQL.DEFINE_ARRAY(v_fetch_cursor,columnCounter,v_number6,vBatchSize,1);
2598: end if;
2599: elsif dbms_call = 'COLUMN_VALUE' Then

Line 2597: DBMS_SQL.DEFINE_ARRAY(v_fetch_cursor,columnCounter,v_number6,vBatchSize,1);

2593: DBMS_SQL.DEFINE_ARRAY(v_fetch_cursor,columnCounter,v_Date6,vBatchSize,1);
2594: elsif data_type = 'VARCHAR2' then
2595: DBMS_SQL.DEFINE_ARRAY(v_fetch_cursor,columnCounter,v_varchar6,vBatchSize,1);
2596: elsif data_type = 'NUMBER' then
2597: DBMS_SQL.DEFINE_ARRAY(v_fetch_cursor,columnCounter,v_number6,vBatchSize,1);
2598: end if;
2599: elsif dbms_call = 'COLUMN_VALUE' Then
2600: if data_type in ( 'DATE','DATETIME') then
2601: DBMS_SQL.COLUMN_VALUE(v_fetch_cursor,columnCounter,v_Date6);

Line 2601: DBMS_SQL.COLUMN_VALUE(v_fetch_cursor,columnCounter,v_Date6);

2597: DBMS_SQL.DEFINE_ARRAY(v_fetch_cursor,columnCounter,v_number6,vBatchSize,1);
2598: end if;
2599: elsif dbms_call = 'COLUMN_VALUE' Then
2600: if data_type in ( 'DATE','DATETIME') then
2601: DBMS_SQL.COLUMN_VALUE(v_fetch_cursor,columnCounter,v_Date6);
2602: elsif data_type = 'VARCHAR2' then
2603: DBMS_SQL.COLUMN_VALUE(v_fetch_cursor,columnCounter,v_varchar6);
2604: elsif data_type = 'NUMBER' then
2605: DBMS_SQL.COLUMN_VALUE(v_fetch_cursor,columnCounter,v_number6);

Line 2603: DBMS_SQL.COLUMN_VALUE(v_fetch_cursor,columnCounter,v_varchar6);

2599: elsif dbms_call = 'COLUMN_VALUE' Then
2600: if data_type in ( 'DATE','DATETIME') then
2601: DBMS_SQL.COLUMN_VALUE(v_fetch_cursor,columnCounter,v_Date6);
2602: elsif data_type = 'VARCHAR2' then
2603: DBMS_SQL.COLUMN_VALUE(v_fetch_cursor,columnCounter,v_varchar6);
2604: elsif data_type = 'NUMBER' then
2605: DBMS_SQL.COLUMN_VALUE(v_fetch_cursor,columnCounter,v_number6);
2606: end if;
2607:

Line 2605: DBMS_SQL.COLUMN_VALUE(v_fetch_cursor,columnCounter,v_number6);

2601: DBMS_SQL.COLUMN_VALUE(v_fetch_cursor,columnCounter,v_Date6);
2602: elsif data_type = 'VARCHAR2' then
2603: DBMS_SQL.COLUMN_VALUE(v_fetch_cursor,columnCounter,v_varchar6);
2604: elsif data_type = 'NUMBER' then
2605: DBMS_SQL.COLUMN_VALUE(v_fetch_cursor,columnCounter,v_number6);
2606: end if;
2607:
2608: elsif dbms_call = 'BIND_ARRAY' Then
2609:

Line 2611: DBMS_SQL.BIND_ARRAY(v_insert_cursor,':A'||to_char(columnCounter), v_Date6,vTotalFetchedRows-v_NumRows+1,vTotalFetchedRows);

2607:
2608: elsif dbms_call = 'BIND_ARRAY' Then
2609:
2610: if data_type in ( 'DATE','DATETIME') then
2611: DBMS_SQL.BIND_ARRAY(v_insert_cursor,':A'||to_char(columnCounter), v_Date6,vTotalFetchedRows-v_NumRows+1,vTotalFetchedRows);
2612: elsif data_type = 'VARCHAR2' then
2613: DBMS_SQL.BIND_ARRAY(v_insert_cursor,':A'||to_char(columnCounter), v_varchar6,vTotalFetchedRows-v_NumRows+1,vTotalFetchedRows);
2614: elsif data_type = 'NUMBER' then
2615: DBMS_SQL.BIND_ARRAY(v_insert_cursor,':A'||to_char(columnCounter), v_number6,vTotalFetchedRows-v_NumRows+1,vTotalFetchedRows);

Line 2613: DBMS_SQL.BIND_ARRAY(v_insert_cursor,':A'||to_char(columnCounter), v_varchar6,vTotalFetchedRows-v_NumRows+1,vTotalFetchedRows);

2609:
2610: if data_type in ( 'DATE','DATETIME') then
2611: DBMS_SQL.BIND_ARRAY(v_insert_cursor,':A'||to_char(columnCounter), v_Date6,vTotalFetchedRows-v_NumRows+1,vTotalFetchedRows);
2612: elsif data_type = 'VARCHAR2' then
2613: DBMS_SQL.BIND_ARRAY(v_insert_cursor,':A'||to_char(columnCounter), v_varchar6,vTotalFetchedRows-v_NumRows+1,vTotalFetchedRows);
2614: elsif data_type = 'NUMBER' then
2615: DBMS_SQL.BIND_ARRAY(v_insert_cursor,':A'||to_char(columnCounter), v_number6,vTotalFetchedRows-v_NumRows+1,vTotalFetchedRows);
2616: end if;
2617:

Line 2615: DBMS_SQL.BIND_ARRAY(v_insert_cursor,':A'||to_char(columnCounter), v_number6,vTotalFetchedRows-v_NumRows+1,vTotalFetchedRows);

2611: DBMS_SQL.BIND_ARRAY(v_insert_cursor,':A'||to_char(columnCounter), v_Date6,vTotalFetchedRows-v_NumRows+1,vTotalFetchedRows);
2612: elsif data_type = 'VARCHAR2' then
2613: DBMS_SQL.BIND_ARRAY(v_insert_cursor,':A'||to_char(columnCounter), v_varchar6,vTotalFetchedRows-v_NumRows+1,vTotalFetchedRows);
2614: elsif data_type = 'NUMBER' then
2615: DBMS_SQL.BIND_ARRAY(v_insert_cursor,':A'||to_char(columnCounter), v_number6,vTotalFetchedRows-v_NumRows+1,vTotalFetchedRows);
2616: end if;
2617:
2618: end if;
2619: elsif DataArrayCounter = 7 then

Line 2623: DBMS_SQL.DEFINE_ARRAY(v_fetch_cursor,columnCounter,v_Date7,vBatchSize,1);

2619: elsif DataArrayCounter = 7 then
2620:
2621: if dbms_call = 'DEFINE_ARRAY' then
2622: if data_type in ( 'DATE','DATETIME') then
2623: DBMS_SQL.DEFINE_ARRAY(v_fetch_cursor,columnCounter,v_Date7,vBatchSize,1);
2624: elsif data_type = 'VARCHAR2' then
2625: DBMS_SQL.DEFINE_ARRAY(v_fetch_cursor,columnCounter,v_varchar7,vBatchSize,1);
2626: elsif data_type = 'NUMBER' then
2627: DBMS_SQL.DEFINE_ARRAY(v_fetch_cursor,columnCounter,v_number7,vBatchSize,1);

Line 2625: DBMS_SQL.DEFINE_ARRAY(v_fetch_cursor,columnCounter,v_varchar7,vBatchSize,1);

2621: if dbms_call = 'DEFINE_ARRAY' then
2622: if data_type in ( 'DATE','DATETIME') then
2623: DBMS_SQL.DEFINE_ARRAY(v_fetch_cursor,columnCounter,v_Date7,vBatchSize,1);
2624: elsif data_type = 'VARCHAR2' then
2625: DBMS_SQL.DEFINE_ARRAY(v_fetch_cursor,columnCounter,v_varchar7,vBatchSize,1);
2626: elsif data_type = 'NUMBER' then
2627: DBMS_SQL.DEFINE_ARRAY(v_fetch_cursor,columnCounter,v_number7,vBatchSize,1);
2628: end if;
2629: elsif dbms_call = 'COLUMN_VALUE' Then

Line 2627: DBMS_SQL.DEFINE_ARRAY(v_fetch_cursor,columnCounter,v_number7,vBatchSize,1);

2623: DBMS_SQL.DEFINE_ARRAY(v_fetch_cursor,columnCounter,v_Date7,vBatchSize,1);
2624: elsif data_type = 'VARCHAR2' then
2625: DBMS_SQL.DEFINE_ARRAY(v_fetch_cursor,columnCounter,v_varchar7,vBatchSize,1);
2626: elsif data_type = 'NUMBER' then
2627: DBMS_SQL.DEFINE_ARRAY(v_fetch_cursor,columnCounter,v_number7,vBatchSize,1);
2628: end if;
2629: elsif dbms_call = 'COLUMN_VALUE' Then
2630: if data_type in ( 'DATE','DATETIME') then
2631: DBMS_SQL.COLUMN_VALUE(v_fetch_cursor,columnCounter,v_Date7);

Line 2631: DBMS_SQL.COLUMN_VALUE(v_fetch_cursor,columnCounter,v_Date7);

2627: DBMS_SQL.DEFINE_ARRAY(v_fetch_cursor,columnCounter,v_number7,vBatchSize,1);
2628: end if;
2629: elsif dbms_call = 'COLUMN_VALUE' Then
2630: if data_type in ( 'DATE','DATETIME') then
2631: DBMS_SQL.COLUMN_VALUE(v_fetch_cursor,columnCounter,v_Date7);
2632: elsif data_type = 'VARCHAR2' then
2633: DBMS_SQL.COLUMN_VALUE(v_fetch_cursor,columnCounter,v_varchar7);
2634: elsif data_type = 'NUMBER' then
2635: DBMS_SQL.COLUMN_VALUE(v_fetch_cursor,columnCounter,v_number7);

Line 2633: DBMS_SQL.COLUMN_VALUE(v_fetch_cursor,columnCounter,v_varchar7);

2629: elsif dbms_call = 'COLUMN_VALUE' Then
2630: if data_type in ( 'DATE','DATETIME') then
2631: DBMS_SQL.COLUMN_VALUE(v_fetch_cursor,columnCounter,v_Date7);
2632: elsif data_type = 'VARCHAR2' then
2633: DBMS_SQL.COLUMN_VALUE(v_fetch_cursor,columnCounter,v_varchar7);
2634: elsif data_type = 'NUMBER' then
2635: DBMS_SQL.COLUMN_VALUE(v_fetch_cursor,columnCounter,v_number7);
2636: end if;
2637:

Line 2635: DBMS_SQL.COLUMN_VALUE(v_fetch_cursor,columnCounter,v_number7);

2631: DBMS_SQL.COLUMN_VALUE(v_fetch_cursor,columnCounter,v_Date7);
2632: elsif data_type = 'VARCHAR2' then
2633: DBMS_SQL.COLUMN_VALUE(v_fetch_cursor,columnCounter,v_varchar7);
2634: elsif data_type = 'NUMBER' then
2635: DBMS_SQL.COLUMN_VALUE(v_fetch_cursor,columnCounter,v_number7);
2636: end if;
2637:
2638: elsif dbms_call = 'BIND_ARRAY' Then
2639:

Line 2641: DBMS_SQL.BIND_ARRAY(v_insert_cursor,':A'||to_char(columnCounter), v_Date7,vTotalFetchedRows-v_NumRows+1,vTotalFetchedRows);

2637:
2638: elsif dbms_call = 'BIND_ARRAY' Then
2639:
2640: if data_type in ( 'DATE','DATETIME') then
2641: DBMS_SQL.BIND_ARRAY(v_insert_cursor,':A'||to_char(columnCounter), v_Date7,vTotalFetchedRows-v_NumRows+1,vTotalFetchedRows);
2642: elsif data_type = 'VARCHAR2' then
2643: DBMS_SQL.BIND_ARRAY(v_insert_cursor,':A'||to_char(columnCounter), v_varchar7,vTotalFetchedRows-v_NumRows+1,vTotalFetchedRows);
2644: elsif data_type = 'NUMBER' then
2645: DBMS_SQL.BIND_ARRAY(v_insert_cursor,':A'||to_char(columnCounter), v_number7,vTotalFetchedRows-v_NumRows+1,vTotalFetchedRows);

Line 2643: DBMS_SQL.BIND_ARRAY(v_insert_cursor,':A'||to_char(columnCounter), v_varchar7,vTotalFetchedRows-v_NumRows+1,vTotalFetchedRows);

2639:
2640: if data_type in ( 'DATE','DATETIME') then
2641: DBMS_SQL.BIND_ARRAY(v_insert_cursor,':A'||to_char(columnCounter), v_Date7,vTotalFetchedRows-v_NumRows+1,vTotalFetchedRows);
2642: elsif data_type = 'VARCHAR2' then
2643: DBMS_SQL.BIND_ARRAY(v_insert_cursor,':A'||to_char(columnCounter), v_varchar7,vTotalFetchedRows-v_NumRows+1,vTotalFetchedRows);
2644: elsif data_type = 'NUMBER' then
2645: DBMS_SQL.BIND_ARRAY(v_insert_cursor,':A'||to_char(columnCounter), v_number7,vTotalFetchedRows-v_NumRows+1,vTotalFetchedRows);
2646: end if;
2647:

Line 2645: DBMS_SQL.BIND_ARRAY(v_insert_cursor,':A'||to_char(columnCounter), v_number7,vTotalFetchedRows-v_NumRows+1,vTotalFetchedRows);

2641: DBMS_SQL.BIND_ARRAY(v_insert_cursor,':A'||to_char(columnCounter), v_Date7,vTotalFetchedRows-v_NumRows+1,vTotalFetchedRows);
2642: elsif data_type = 'VARCHAR2' then
2643: DBMS_SQL.BIND_ARRAY(v_insert_cursor,':A'||to_char(columnCounter), v_varchar7,vTotalFetchedRows-v_NumRows+1,vTotalFetchedRows);
2644: elsif data_type = 'NUMBER' then
2645: DBMS_SQL.BIND_ARRAY(v_insert_cursor,':A'||to_char(columnCounter), v_number7,vTotalFetchedRows-v_NumRows+1,vTotalFetchedRows);
2646: end if;
2647:
2648: end if;
2649:

Line 2654: DBMS_SQL.DEFINE_ARRAY(v_fetch_cursor,columnCounter,v_varchar8,vBatchSize,1);

2650:
2651: elsif DataArrayCounter = 8 then
2652: if dbms_call = 'DEFINE_ARRAY' then
2653: If data_type = 'VARCHAR2' then
2654: DBMS_SQL.DEFINE_ARRAY(v_fetch_cursor,columnCounter,v_varchar8,vBatchSize,1);
2655: elsif data_type = 'NUMBER' then
2656: DBMS_SQL.DEFINE_ARRAY(v_fetch_cursor,columnCounter,v_number8,vBatchSize,1);
2657: end if;
2658: elsif dbms_call = 'COLUMN_VALUE' Then

Line 2656: DBMS_SQL.DEFINE_ARRAY(v_fetch_cursor,columnCounter,v_number8,vBatchSize,1);

2652: if dbms_call = 'DEFINE_ARRAY' then
2653: If data_type = 'VARCHAR2' then
2654: DBMS_SQL.DEFINE_ARRAY(v_fetch_cursor,columnCounter,v_varchar8,vBatchSize,1);
2655: elsif data_type = 'NUMBER' then
2656: DBMS_SQL.DEFINE_ARRAY(v_fetch_cursor,columnCounter,v_number8,vBatchSize,1);
2657: end if;
2658: elsif dbms_call = 'COLUMN_VALUE' Then
2659: if data_type = 'VARCHAR2' then
2660: DBMS_SQL.COLUMN_VALUE(v_fetch_cursor,columnCounter,v_varchar8);

Line 2660: DBMS_SQL.COLUMN_VALUE(v_fetch_cursor,columnCounter,v_varchar8);

2656: DBMS_SQL.DEFINE_ARRAY(v_fetch_cursor,columnCounter,v_number8,vBatchSize,1);
2657: end if;
2658: elsif dbms_call = 'COLUMN_VALUE' Then
2659: if data_type = 'VARCHAR2' then
2660: DBMS_SQL.COLUMN_VALUE(v_fetch_cursor,columnCounter,v_varchar8);
2661: elsif data_type = 'NUMBER' then
2662: DBMS_SQL.COLUMN_VALUE(v_fetch_cursor,columnCounter,v_number8);
2663: end if;
2664:

Line 2662: DBMS_SQL.COLUMN_VALUE(v_fetch_cursor,columnCounter,v_number8);

2658: elsif dbms_call = 'COLUMN_VALUE' Then
2659: if data_type = 'VARCHAR2' then
2660: DBMS_SQL.COLUMN_VALUE(v_fetch_cursor,columnCounter,v_varchar8);
2661: elsif data_type = 'NUMBER' then
2662: DBMS_SQL.COLUMN_VALUE(v_fetch_cursor,columnCounter,v_number8);
2663: end if;
2664:
2665: elsif dbms_call = 'BIND_ARRAY' Then
2666: if data_type = 'VARCHAR2' then

Line 2667: DBMS_SQL.BIND_ARRAY(v_insert_cursor,':A'||to_char(columnCounter), v_varchar8,vTotalFetchedRows-v_NumRows+1,vTotalFetchedRows);

2663: end if;
2664:
2665: elsif dbms_call = 'BIND_ARRAY' Then
2666: if data_type = 'VARCHAR2' then
2667: DBMS_SQL.BIND_ARRAY(v_insert_cursor,':A'||to_char(columnCounter), v_varchar8,vTotalFetchedRows-v_NumRows+1,vTotalFetchedRows);
2668: elsif data_type = 'NUMBER' then
2669: DBMS_SQL.BIND_ARRAY(v_insert_cursor,':A'||to_char(columnCounter), v_number8,vTotalFetchedRows-v_NumRows+1,vTotalFetchedRows);
2670: end if;
2671:

Line 2669: DBMS_SQL.BIND_ARRAY(v_insert_cursor,':A'||to_char(columnCounter), v_number8,vTotalFetchedRows-v_NumRows+1,vTotalFetchedRows);

2665: elsif dbms_call = 'BIND_ARRAY' Then
2666: if data_type = 'VARCHAR2' then
2667: DBMS_SQL.BIND_ARRAY(v_insert_cursor,':A'||to_char(columnCounter), v_varchar8,vTotalFetchedRows-v_NumRows+1,vTotalFetchedRows);
2668: elsif data_type = 'NUMBER' then
2669: DBMS_SQL.BIND_ARRAY(v_insert_cursor,':A'||to_char(columnCounter), v_number8,vTotalFetchedRows-v_NumRows+1,vTotalFetchedRows);
2670: end if;
2671:
2672: end if;
2673:

Line 2677: DBMS_SQL.DEFINE_ARRAY(v_fetch_cursor,columnCounter,v_varchar9,vBatchSize,1);

2673:
2674: elsif DataArrayCounter = 9 then
2675: if dbms_call = 'DEFINE_ARRAY' then
2676: If data_type = 'VARCHAR2' then
2677: DBMS_SQL.DEFINE_ARRAY(v_fetch_cursor,columnCounter,v_varchar9,vBatchSize,1);
2678: elsif data_type = 'NUMBER' then
2679: DBMS_SQL.DEFINE_ARRAY(v_fetch_cursor,columnCounter,v_number9,vBatchSize,1);
2680: end if;
2681: elsif dbms_call = 'COLUMN_VALUE' Then

Line 2679: DBMS_SQL.DEFINE_ARRAY(v_fetch_cursor,columnCounter,v_number9,vBatchSize,1);

2675: if dbms_call = 'DEFINE_ARRAY' then
2676: If data_type = 'VARCHAR2' then
2677: DBMS_SQL.DEFINE_ARRAY(v_fetch_cursor,columnCounter,v_varchar9,vBatchSize,1);
2678: elsif data_type = 'NUMBER' then
2679: DBMS_SQL.DEFINE_ARRAY(v_fetch_cursor,columnCounter,v_number9,vBatchSize,1);
2680: end if;
2681: elsif dbms_call = 'COLUMN_VALUE' Then
2682: if data_type = 'VARCHAR2' then
2683: DBMS_SQL.COLUMN_VALUE(v_fetch_cursor,columnCounter,v_varchar9);

Line 2683: DBMS_SQL.COLUMN_VALUE(v_fetch_cursor,columnCounter,v_varchar9);

2679: DBMS_SQL.DEFINE_ARRAY(v_fetch_cursor,columnCounter,v_number9,vBatchSize,1);
2680: end if;
2681: elsif dbms_call = 'COLUMN_VALUE' Then
2682: if data_type = 'VARCHAR2' then
2683: DBMS_SQL.COLUMN_VALUE(v_fetch_cursor,columnCounter,v_varchar9);
2684: elsif data_type = 'NUMBER' then
2685: DBMS_SQL.COLUMN_VALUE(v_fetch_cursor,columnCounter,v_number9);
2686: end if;
2687:

Line 2685: DBMS_SQL.COLUMN_VALUE(v_fetch_cursor,columnCounter,v_number9);

2681: elsif dbms_call = 'COLUMN_VALUE' Then
2682: if data_type = 'VARCHAR2' then
2683: DBMS_SQL.COLUMN_VALUE(v_fetch_cursor,columnCounter,v_varchar9);
2684: elsif data_type = 'NUMBER' then
2685: DBMS_SQL.COLUMN_VALUE(v_fetch_cursor,columnCounter,v_number9);
2686: end if;
2687:
2688: elsif dbms_call = 'BIND_ARRAY' Then
2689: if data_type = 'VARCHAR2' then

Line 2690: DBMS_SQL.BIND_ARRAY(v_insert_cursor,':A'||to_char(columnCounter), v_varchar9,vTotalFetchedRows-v_NumRows+1,vTotalFetchedRows);

2686: end if;
2687:
2688: elsif dbms_call = 'BIND_ARRAY' Then
2689: if data_type = 'VARCHAR2' then
2690: DBMS_SQL.BIND_ARRAY(v_insert_cursor,':A'||to_char(columnCounter), v_varchar9,vTotalFetchedRows-v_NumRows+1,vTotalFetchedRows);
2691: elsif data_type = 'NUMBER' then
2692: DBMS_SQL.BIND_ARRAY(v_insert_cursor,':A'||to_char(columnCounter), v_number9,vTotalFetchedRows-v_NumRows+1,vTotalFetchedRows);
2693: end if;
2694:

Line 2692: DBMS_SQL.BIND_ARRAY(v_insert_cursor,':A'||to_char(columnCounter), v_number9,vTotalFetchedRows-v_NumRows+1,vTotalFetchedRows);

2688: elsif dbms_call = 'BIND_ARRAY' Then
2689: if data_type = 'VARCHAR2' then
2690: DBMS_SQL.BIND_ARRAY(v_insert_cursor,':A'||to_char(columnCounter), v_varchar9,vTotalFetchedRows-v_NumRows+1,vTotalFetchedRows);
2691: elsif data_type = 'NUMBER' then
2692: DBMS_SQL.BIND_ARRAY(v_insert_cursor,':A'||to_char(columnCounter), v_number9,vTotalFetchedRows-v_NumRows+1,vTotalFetchedRows);
2693: end if;
2694:
2695: end if;
2696:

Line 2700: DBMS_SQL.DEFINE_ARRAY(v_fetch_cursor,columnCounter,v_varchar10,vBatchSize,1);

2696:
2697: elsif DataArrayCounter = 10 then
2698: if dbms_call = 'DEFINE_ARRAY' then
2699: If data_type = 'VARCHAR2' then
2700: DBMS_SQL.DEFINE_ARRAY(v_fetch_cursor,columnCounter,v_varchar10,vBatchSize,1);
2701: elsif data_type = 'NUMBER' then
2702: DBMS_SQL.DEFINE_ARRAY(v_fetch_cursor,columnCounter,v_number10,vBatchSize,1);
2703: end if;
2704: elsif dbms_call = 'COLUMN_VALUE' Then

Line 2702: DBMS_SQL.DEFINE_ARRAY(v_fetch_cursor,columnCounter,v_number10,vBatchSize,1);

2698: if dbms_call = 'DEFINE_ARRAY' then
2699: If data_type = 'VARCHAR2' then
2700: DBMS_SQL.DEFINE_ARRAY(v_fetch_cursor,columnCounter,v_varchar10,vBatchSize,1);
2701: elsif data_type = 'NUMBER' then
2702: DBMS_SQL.DEFINE_ARRAY(v_fetch_cursor,columnCounter,v_number10,vBatchSize,1);
2703: end if;
2704: elsif dbms_call = 'COLUMN_VALUE' Then
2705: if data_type = 'VARCHAR2' then
2706: DBMS_SQL.COLUMN_VALUE(v_fetch_cursor,columnCounter,v_varchar10);

Line 2706: DBMS_SQL.COLUMN_VALUE(v_fetch_cursor,columnCounter,v_varchar10);

2702: DBMS_SQL.DEFINE_ARRAY(v_fetch_cursor,columnCounter,v_number10,vBatchSize,1);
2703: end if;
2704: elsif dbms_call = 'COLUMN_VALUE' Then
2705: if data_type = 'VARCHAR2' then
2706: DBMS_SQL.COLUMN_VALUE(v_fetch_cursor,columnCounter,v_varchar10);
2707: elsif data_type = 'NUMBER' then
2708: DBMS_SQL.COLUMN_VALUE(v_fetch_cursor,columnCounter,v_number10);
2709: end if;
2710:

Line 2708: DBMS_SQL.COLUMN_VALUE(v_fetch_cursor,columnCounter,v_number10);

2704: elsif dbms_call = 'COLUMN_VALUE' Then
2705: if data_type = 'VARCHAR2' then
2706: DBMS_SQL.COLUMN_VALUE(v_fetch_cursor,columnCounter,v_varchar10);
2707: elsif data_type = 'NUMBER' then
2708: DBMS_SQL.COLUMN_VALUE(v_fetch_cursor,columnCounter,v_number10);
2709: end if;
2710:
2711: elsif dbms_call = 'BIND_ARRAY' Then
2712: if data_type = 'VARCHAR2' then

Line 2713: DBMS_SQL.BIND_ARRAY(v_insert_cursor,':A'||to_char(columnCounter), v_varchar10,vTotalFetchedRows-v_NumRows+1,vTotalFetchedRows);

2709: end if;
2710:
2711: elsif dbms_call = 'BIND_ARRAY' Then
2712: if data_type = 'VARCHAR2' then
2713: DBMS_SQL.BIND_ARRAY(v_insert_cursor,':A'||to_char(columnCounter), v_varchar10,vTotalFetchedRows-v_NumRows+1,vTotalFetchedRows);
2714: elsif data_type = 'NUMBER' then
2715: DBMS_SQL.BIND_ARRAY(v_insert_cursor,':A'||to_char(columnCounter), v_number10,vTotalFetchedRows-v_NumRows+1,vTotalFetchedRows);
2716: end if;
2717:

Line 2715: DBMS_SQL.BIND_ARRAY(v_insert_cursor,':A'||to_char(columnCounter), v_number10,vTotalFetchedRows-v_NumRows+1,vTotalFetchedRows);

2711: elsif dbms_call = 'BIND_ARRAY' Then
2712: if data_type = 'VARCHAR2' then
2713: DBMS_SQL.BIND_ARRAY(v_insert_cursor,':A'||to_char(columnCounter), v_varchar10,vTotalFetchedRows-v_NumRows+1,vTotalFetchedRows);
2714: elsif data_type = 'NUMBER' then
2715: DBMS_SQL.BIND_ARRAY(v_insert_cursor,':A'||to_char(columnCounter), v_number10,vTotalFetchedRows-v_NumRows+1,vTotalFetchedRows);
2716: end if;
2717:
2718: end if;
2719:

Line 2723: DBMS_SQL.DEFINE_ARRAY(v_fetch_cursor,columnCounter,v_varchar11,vBatchSize,1);

2719:
2720: elsif DataArrayCounter = 11 then
2721: if dbms_call = 'DEFINE_ARRAY' then
2722: If data_type = 'VARCHAR2' then
2723: DBMS_SQL.DEFINE_ARRAY(v_fetch_cursor,columnCounter,v_varchar11,vBatchSize,1);
2724: end if;
2725: elsif dbms_call = 'COLUMN_VALUE' Then
2726: if data_type = 'VARCHAR2' then
2727: DBMS_SQL.COLUMN_VALUE(v_fetch_cursor,columnCounter,v_varchar11);

Line 2727: DBMS_SQL.COLUMN_VALUE(v_fetch_cursor,columnCounter,v_varchar11);

2723: DBMS_SQL.DEFINE_ARRAY(v_fetch_cursor,columnCounter,v_varchar11,vBatchSize,1);
2724: end if;
2725: elsif dbms_call = 'COLUMN_VALUE' Then
2726: if data_type = 'VARCHAR2' then
2727: DBMS_SQL.COLUMN_VALUE(v_fetch_cursor,columnCounter,v_varchar11);
2728: end if;
2729: elsif dbms_call = 'BIND_ARRAY' Then
2730: if data_type = 'VARCHAR2' then
2731: DBMS_SQL.BIND_ARRAY(v_insert_cursor,':A'||to_char(columnCounter), v_varchar11,vTotalFetchedRows-v_NumRows+1,vTotalFetchedRows);

Line 2731: DBMS_SQL.BIND_ARRAY(v_insert_cursor,':A'||to_char(columnCounter), v_varchar11,vTotalFetchedRows-v_NumRows+1,vTotalFetchedRows);

2727: DBMS_SQL.COLUMN_VALUE(v_fetch_cursor,columnCounter,v_varchar11);
2728: end if;
2729: elsif dbms_call = 'BIND_ARRAY' Then
2730: if data_type = 'VARCHAR2' then
2731: DBMS_SQL.BIND_ARRAY(v_insert_cursor,':A'||to_char(columnCounter), v_varchar11,vTotalFetchedRows-v_NumRows+1,vTotalFetchedRows);
2732: end if;
2733: end if;
2734: elsif DataArrayCounter = 12 then
2735: if dbms_call = 'DEFINE_ARRAY' then

Line 2737: DBMS_SQL.DEFINE_ARRAY(v_fetch_cursor,columnCounter,v_varchar12,vBatchSize,1);

2733: end if;
2734: elsif DataArrayCounter = 12 then
2735: if dbms_call = 'DEFINE_ARRAY' then
2736: If data_type = 'VARCHAR2' then
2737: DBMS_SQL.DEFINE_ARRAY(v_fetch_cursor,columnCounter,v_varchar12,vBatchSize,1);
2738: end if;
2739: elsif dbms_call = 'COLUMN_VALUE' Then
2740: if data_type = 'VARCHAR2' then
2741: DBMS_SQL.COLUMN_VALUE(v_fetch_cursor,columnCounter,v_varchar12);

Line 2741: DBMS_SQL.COLUMN_VALUE(v_fetch_cursor,columnCounter,v_varchar12);

2737: DBMS_SQL.DEFINE_ARRAY(v_fetch_cursor,columnCounter,v_varchar12,vBatchSize,1);
2738: end if;
2739: elsif dbms_call = 'COLUMN_VALUE' Then
2740: if data_type = 'VARCHAR2' then
2741: DBMS_SQL.COLUMN_VALUE(v_fetch_cursor,columnCounter,v_varchar12);
2742: end if;
2743: elsif dbms_call = 'BIND_ARRAY' Then
2744: if data_type = 'VARCHAR2' then
2745: DBMS_SQL.BIND_ARRAY(v_insert_cursor,':A'||to_char(columnCounter), v_varchar12,vTotalFetchedRows-v_NumRows+1,vTotalFetchedRows);

Line 2745: DBMS_SQL.BIND_ARRAY(v_insert_cursor,':A'||to_char(columnCounter), v_varchar12,vTotalFetchedRows-v_NumRows+1,vTotalFetchedRows);

2741: DBMS_SQL.COLUMN_VALUE(v_fetch_cursor,columnCounter,v_varchar12);
2742: end if;
2743: elsif dbms_call = 'BIND_ARRAY' Then
2744: if data_type = 'VARCHAR2' then
2745: DBMS_SQL.BIND_ARRAY(v_insert_cursor,':A'||to_char(columnCounter), v_varchar12,vTotalFetchedRows-v_NumRows+1,vTotalFetchedRows);
2746: end if;
2747: end if;
2748: elsif DataArrayCounter = 13 then
2749: if dbms_call = 'DEFINE_ARRAY' then

Line 2751: DBMS_SQL.DEFINE_ARRAY(v_fetch_cursor,columnCounter,v_varchar13,vBatchSize,1);

2747: end if;
2748: elsif DataArrayCounter = 13 then
2749: if dbms_call = 'DEFINE_ARRAY' then
2750: If data_type = 'VARCHAR2' then
2751: DBMS_SQL.DEFINE_ARRAY(v_fetch_cursor,columnCounter,v_varchar13,vBatchSize,1);
2752: end if;
2753: elsif dbms_call = 'COLUMN_VALUE' Then
2754: if data_type = 'VARCHAR2' then
2755: DBMS_SQL.COLUMN_VALUE(v_fetch_cursor,columnCounter,v_varchar13);

Line 2755: DBMS_SQL.COLUMN_VALUE(v_fetch_cursor,columnCounter,v_varchar13);

2751: DBMS_SQL.DEFINE_ARRAY(v_fetch_cursor,columnCounter,v_varchar13,vBatchSize,1);
2752: end if;
2753: elsif dbms_call = 'COLUMN_VALUE' Then
2754: if data_type = 'VARCHAR2' then
2755: DBMS_SQL.COLUMN_VALUE(v_fetch_cursor,columnCounter,v_varchar13);
2756: end if;
2757: elsif dbms_call = 'BIND_ARRAY' Then
2758: if data_type = 'VARCHAR2' then
2759: DBMS_SQL.BIND_ARRAY(v_insert_cursor,':A'||to_char(columnCounter), v_varchar13,vTotalFetchedRows-v_NumRows+1,vTotalFetchedRows);

Line 2759: DBMS_SQL.BIND_ARRAY(v_insert_cursor,':A'||to_char(columnCounter), v_varchar13,vTotalFetchedRows-v_NumRows+1,vTotalFetchedRows);

2755: DBMS_SQL.COLUMN_VALUE(v_fetch_cursor,columnCounter,v_varchar13);
2756: end if;
2757: elsif dbms_call = 'BIND_ARRAY' Then
2758: if data_type = 'VARCHAR2' then
2759: DBMS_SQL.BIND_ARRAY(v_insert_cursor,':A'||to_char(columnCounter), v_varchar13,vTotalFetchedRows-v_NumRows+1,vTotalFetchedRows);
2760: end if;
2761: end if;
2762: elsif DataArrayCounter = 14 then
2763: if dbms_call = 'DEFINE_ARRAY' then

Line 2765: DBMS_SQL.DEFINE_ARRAY(v_fetch_cursor,columnCounter,v_varchar14,vBatchSize,1);

2761: end if;
2762: elsif DataArrayCounter = 14 then
2763: if dbms_call = 'DEFINE_ARRAY' then
2764: If data_type = 'VARCHAR2' then
2765: DBMS_SQL.DEFINE_ARRAY(v_fetch_cursor,columnCounter,v_varchar14,vBatchSize,1);
2766: end if;
2767: elsif dbms_call = 'COLUMN_VALUE' Then
2768: if data_type = 'VARCHAR2' then
2769: DBMS_SQL.COLUMN_VALUE(v_fetch_cursor,columnCounter,v_varchar14);

Line 2769: DBMS_SQL.COLUMN_VALUE(v_fetch_cursor,columnCounter,v_varchar14);

2765: DBMS_SQL.DEFINE_ARRAY(v_fetch_cursor,columnCounter,v_varchar14,vBatchSize,1);
2766: end if;
2767: elsif dbms_call = 'COLUMN_VALUE' Then
2768: if data_type = 'VARCHAR2' then
2769: DBMS_SQL.COLUMN_VALUE(v_fetch_cursor,columnCounter,v_varchar14);
2770: end if;
2771: elsif dbms_call = 'BIND_ARRAY' Then
2772: if data_type = 'VARCHAR2' then
2773: DBMS_SQL.BIND_ARRAY(v_insert_cursor,':A'||to_char(columnCounter), v_varchar14,vTotalFetchedRows-v_NumRows+1,vTotalFetchedRows);

Line 2773: DBMS_SQL.BIND_ARRAY(v_insert_cursor,':A'||to_char(columnCounter), v_varchar14,vTotalFetchedRows-v_NumRows+1,vTotalFetchedRows);

2769: DBMS_SQL.COLUMN_VALUE(v_fetch_cursor,columnCounter,v_varchar14);
2770: end if;
2771: elsif dbms_call = 'BIND_ARRAY' Then
2772: if data_type = 'VARCHAR2' then
2773: DBMS_SQL.BIND_ARRAY(v_insert_cursor,':A'||to_char(columnCounter), v_varchar14,vTotalFetchedRows-v_NumRows+1,vTotalFetchedRows);
2774: end if;
2775: end if;
2776: elsif DataArrayCounter = 15 then
2777: if dbms_call = 'DEFINE_ARRAY' then

Line 2779: DBMS_SQL.DEFINE_ARRAY(v_fetch_cursor,columnCounter,v_varchar15,vBatchSize,1);

2775: end if;
2776: elsif DataArrayCounter = 15 then
2777: if dbms_call = 'DEFINE_ARRAY' then
2778: If data_type = 'VARCHAR2' then
2779: DBMS_SQL.DEFINE_ARRAY(v_fetch_cursor,columnCounter,v_varchar15,vBatchSize,1);
2780: end if;
2781: elsif dbms_call = 'COLUMN_VALUE' Then
2782: if data_type = 'VARCHAR2' then
2783: DBMS_SQL.COLUMN_VALUE(v_fetch_cursor,columnCounter,v_varchar15);

Line 2783: DBMS_SQL.COLUMN_VALUE(v_fetch_cursor,columnCounter,v_varchar15);

2779: DBMS_SQL.DEFINE_ARRAY(v_fetch_cursor,columnCounter,v_varchar15,vBatchSize,1);
2780: end if;
2781: elsif dbms_call = 'COLUMN_VALUE' Then
2782: if data_type = 'VARCHAR2' then
2783: DBMS_SQL.COLUMN_VALUE(v_fetch_cursor,columnCounter,v_varchar15);
2784: end if;
2785: elsif dbms_call = 'BIND_ARRAY' Then
2786: if data_type = 'VARCHAR2' then
2787: DBMS_SQL.BIND_ARRAY(v_insert_cursor,':A'||to_char(columnCounter), v_varchar15,vTotalFetchedRows-v_NumRows+1,vTotalFetchedRows);

Line 2787: DBMS_SQL.BIND_ARRAY(v_insert_cursor,':A'||to_char(columnCounter), v_varchar15,vTotalFetchedRows-v_NumRows+1,vTotalFetchedRows);

2783: DBMS_SQL.COLUMN_VALUE(v_fetch_cursor,columnCounter,v_varchar15);
2784: end if;
2785: elsif dbms_call = 'BIND_ARRAY' Then
2786: if data_type = 'VARCHAR2' then
2787: DBMS_SQL.BIND_ARRAY(v_insert_cursor,':A'||to_char(columnCounter), v_varchar15,vTotalFetchedRows-v_NumRows+1,vTotalFetchedRows);
2788: end if;
2789: end if;
2790: elsif DataArrayCounter = 16 then
2791: if dbms_call = 'DEFINE_ARRAY' then

Line 2793: DBMS_SQL.DEFINE_ARRAY(v_fetch_cursor,columnCounter,v_varchar16,vBatchSize,1);

2789: end if;
2790: elsif DataArrayCounter = 16 then
2791: if dbms_call = 'DEFINE_ARRAY' then
2792: If data_type = 'VARCHAR2' then
2793: DBMS_SQL.DEFINE_ARRAY(v_fetch_cursor,columnCounter,v_varchar16,vBatchSize,1);
2794: end if;
2795: elsif dbms_call = 'COLUMN_VALUE' Then
2796: if data_type = 'VARCHAR2' then
2797: DBMS_SQL.COLUMN_VALUE(v_fetch_cursor,columnCounter,v_varchar16);

Line 2797: DBMS_SQL.COLUMN_VALUE(v_fetch_cursor,columnCounter,v_varchar16);

2793: DBMS_SQL.DEFINE_ARRAY(v_fetch_cursor,columnCounter,v_varchar16,vBatchSize,1);
2794: end if;
2795: elsif dbms_call = 'COLUMN_VALUE' Then
2796: if data_type = 'VARCHAR2' then
2797: DBMS_SQL.COLUMN_VALUE(v_fetch_cursor,columnCounter,v_varchar16);
2798: end if;
2799: elsif dbms_call = 'BIND_ARRAY' Then
2800: if data_type = 'VARCHAR2' then
2801: DBMS_SQL.BIND_ARRAY(v_insert_cursor,':A'||to_char(columnCounter), v_varchar16,vTotalFetchedRows-v_NumRows+1,vTotalFetchedRows);

Line 2801: DBMS_SQL.BIND_ARRAY(v_insert_cursor,':A'||to_char(columnCounter), v_varchar16,vTotalFetchedRows-v_NumRows+1,vTotalFetchedRows);

2797: DBMS_SQL.COLUMN_VALUE(v_fetch_cursor,columnCounter,v_varchar16);
2798: end if;
2799: elsif dbms_call = 'BIND_ARRAY' Then
2800: if data_type = 'VARCHAR2' then
2801: DBMS_SQL.BIND_ARRAY(v_insert_cursor,':A'||to_char(columnCounter), v_varchar16,vTotalFetchedRows-v_NumRows+1,vTotalFetchedRows);
2802: end if;
2803: end if;
2804: elsif DataArrayCounter = 17 then
2805: if dbms_call = 'DEFINE_ARRAY' then

Line 2807: DBMS_SQL.DEFINE_ARRAY(v_fetch_cursor,columnCounter,v_varchar17,vBatchSize,1);

2803: end if;
2804: elsif DataArrayCounter = 17 then
2805: if dbms_call = 'DEFINE_ARRAY' then
2806: If data_type = 'VARCHAR2' then
2807: DBMS_SQL.DEFINE_ARRAY(v_fetch_cursor,columnCounter,v_varchar17,vBatchSize,1);
2808: end if;
2809: elsif dbms_call = 'COLUMN_VALUE' Then
2810: if data_type = 'VARCHAR2' then
2811: DBMS_SQL.COLUMN_VALUE(v_fetch_cursor,columnCounter,v_varchar17);

Line 2811: DBMS_SQL.COLUMN_VALUE(v_fetch_cursor,columnCounter,v_varchar17);

2807: DBMS_SQL.DEFINE_ARRAY(v_fetch_cursor,columnCounter,v_varchar17,vBatchSize,1);
2808: end if;
2809: elsif dbms_call = 'COLUMN_VALUE' Then
2810: if data_type = 'VARCHAR2' then
2811: DBMS_SQL.COLUMN_VALUE(v_fetch_cursor,columnCounter,v_varchar17);
2812: end if;
2813: elsif dbms_call = 'BIND_ARRAY' Then
2814: if data_type = 'VARCHAR2' then
2815: DBMS_SQL.BIND_ARRAY(v_insert_cursor,':A'||to_char(columnCounter), v_varchar17,vTotalFetchedRows-v_NumRows+1,vTotalFetchedRows);

Line 2815: DBMS_SQL.BIND_ARRAY(v_insert_cursor,':A'||to_char(columnCounter), v_varchar17,vTotalFetchedRows-v_NumRows+1,vTotalFetchedRows);

2811: DBMS_SQL.COLUMN_VALUE(v_fetch_cursor,columnCounter,v_varchar17);
2812: end if;
2813: elsif dbms_call = 'BIND_ARRAY' Then
2814: if data_type = 'VARCHAR2' then
2815: DBMS_SQL.BIND_ARRAY(v_insert_cursor,':A'||to_char(columnCounter), v_varchar17,vTotalFetchedRows-v_NumRows+1,vTotalFetchedRows);
2816: end if;
2817: end if;
2818: elsif DataArrayCounter = 18 then
2819: if dbms_call = 'DEFINE_ARRAY' then

Line 2821: DBMS_SQL.DEFINE_ARRAY(v_fetch_cursor,columnCounter,v_varchar18,vBatchSize,1);

2817: end if;
2818: elsif DataArrayCounter = 18 then
2819: if dbms_call = 'DEFINE_ARRAY' then
2820: If data_type = 'VARCHAR2' then
2821: DBMS_SQL.DEFINE_ARRAY(v_fetch_cursor,columnCounter,v_varchar18,vBatchSize,1);
2822: end if;
2823: elsif dbms_call = 'COLUMN_VALUE' Then
2824: if data_type = 'VARCHAR2' then
2825: DBMS_SQL.COLUMN_VALUE(v_fetch_cursor,columnCounter,v_varchar18);

Line 2825: DBMS_SQL.COLUMN_VALUE(v_fetch_cursor,columnCounter,v_varchar18);

2821: DBMS_SQL.DEFINE_ARRAY(v_fetch_cursor,columnCounter,v_varchar18,vBatchSize,1);
2822: end if;
2823: elsif dbms_call = 'COLUMN_VALUE' Then
2824: if data_type = 'VARCHAR2' then
2825: DBMS_SQL.COLUMN_VALUE(v_fetch_cursor,columnCounter,v_varchar18);
2826: end if;
2827: elsif dbms_call = 'BIND_ARRAY' Then
2828: if data_type = 'VARCHAR2' then
2829: DBMS_SQL.BIND_ARRAY(v_insert_cursor,':A'||to_char(columnCounter), v_varchar18,vTotalFetchedRows-v_NumRows+1,vTotalFetchedRows);

Line 2829: DBMS_SQL.BIND_ARRAY(v_insert_cursor,':A'||to_char(columnCounter), v_varchar18,vTotalFetchedRows-v_NumRows+1,vTotalFetchedRows);

2825: DBMS_SQL.COLUMN_VALUE(v_fetch_cursor,columnCounter,v_varchar18);
2826: end if;
2827: elsif dbms_call = 'BIND_ARRAY' Then
2828: if data_type = 'VARCHAR2' then
2829: DBMS_SQL.BIND_ARRAY(v_insert_cursor,':A'||to_char(columnCounter), v_varchar18,vTotalFetchedRows-v_NumRows+1,vTotalFetchedRows);
2830: end if;
2831: end if;
2832: elsif DataArrayCounter = 19 then
2833: if dbms_call = 'DEFINE_ARRAY' then

Line 2835: DBMS_SQL.DEFINE_ARRAY(v_fetch_cursor,columnCounter,v_varchar19,vBatchSize,1);

2831: end if;
2832: elsif DataArrayCounter = 19 then
2833: if dbms_call = 'DEFINE_ARRAY' then
2834: If data_type = 'VARCHAR2' then
2835: DBMS_SQL.DEFINE_ARRAY(v_fetch_cursor,columnCounter,v_varchar19,vBatchSize,1);
2836: end if;
2837: elsif dbms_call = 'COLUMN_VALUE' Then
2838: if data_type = 'VARCHAR2' then
2839: DBMS_SQL.COLUMN_VALUE(v_fetch_cursor,columnCounter,v_varchar19);

Line 2839: DBMS_SQL.COLUMN_VALUE(v_fetch_cursor,columnCounter,v_varchar19);

2835: DBMS_SQL.DEFINE_ARRAY(v_fetch_cursor,columnCounter,v_varchar19,vBatchSize,1);
2836: end if;
2837: elsif dbms_call = 'COLUMN_VALUE' Then
2838: if data_type = 'VARCHAR2' then
2839: DBMS_SQL.COLUMN_VALUE(v_fetch_cursor,columnCounter,v_varchar19);
2840: end if;
2841: elsif dbms_call = 'BIND_ARRAY' Then
2842: if data_type = 'VARCHAR2' then
2843: DBMS_SQL.BIND_ARRAY(v_insert_cursor,':A'||to_char(columnCounter), v_varchar19,vTotalFetchedRows-v_NumRows+1,vTotalFetchedRows);

Line 2843: DBMS_SQL.BIND_ARRAY(v_insert_cursor,':A'||to_char(columnCounter), v_varchar19,vTotalFetchedRows-v_NumRows+1,vTotalFetchedRows);

2839: DBMS_SQL.COLUMN_VALUE(v_fetch_cursor,columnCounter,v_varchar19);
2840: end if;
2841: elsif dbms_call = 'BIND_ARRAY' Then
2842: if data_type = 'VARCHAR2' then
2843: DBMS_SQL.BIND_ARRAY(v_insert_cursor,':A'||to_char(columnCounter), v_varchar19,vTotalFetchedRows-v_NumRows+1,vTotalFetchedRows);
2844: end if;
2845: end if;
2846: elsif DataArrayCounter = 20 then
2847: if dbms_call = 'DEFINE_ARRAY' then

Line 2849: DBMS_SQL.DEFINE_ARRAY(v_fetch_cursor,columnCounter,v_varchar20,vBatchSize,1);

2845: end if;
2846: elsif DataArrayCounter = 20 then
2847: if dbms_call = 'DEFINE_ARRAY' then
2848: If data_type = 'VARCHAR2' then
2849: DBMS_SQL.DEFINE_ARRAY(v_fetch_cursor,columnCounter,v_varchar20,vBatchSize,1);
2850: end if;
2851: elsif dbms_call = 'COLUMN_VALUE' Then
2852: if data_type = 'VARCHAR2' then
2853: DBMS_SQL.COLUMN_VALUE(v_fetch_cursor,columnCounter,v_varchar20);

Line 2853: DBMS_SQL.COLUMN_VALUE(v_fetch_cursor,columnCounter,v_varchar20);

2849: DBMS_SQL.DEFINE_ARRAY(v_fetch_cursor,columnCounter,v_varchar20,vBatchSize,1);
2850: end if;
2851: elsif dbms_call = 'COLUMN_VALUE' Then
2852: if data_type = 'VARCHAR2' then
2853: DBMS_SQL.COLUMN_VALUE(v_fetch_cursor,columnCounter,v_varchar20);
2854: end if;
2855: elsif dbms_call = 'BIND_ARRAY' Then
2856: if data_type = 'VARCHAR2' then
2857: DBMS_SQL.BIND_ARRAY(v_insert_cursor,':A'||to_char(columnCounter), v_varchar20,vTotalFetchedRows-v_NumRows+1,vTotalFetchedRows);

Line 2857: DBMS_SQL.BIND_ARRAY(v_insert_cursor,':A'||to_char(columnCounter), v_varchar20,vTotalFetchedRows-v_NumRows+1,vTotalFetchedRows);

2853: DBMS_SQL.COLUMN_VALUE(v_fetch_cursor,columnCounter,v_varchar20);
2854: end if;
2855: elsif dbms_call = 'BIND_ARRAY' Then
2856: if data_type = 'VARCHAR2' then
2857: DBMS_SQL.BIND_ARRAY(v_insert_cursor,':A'||to_char(columnCounter), v_varchar20,vTotalFetchedRows-v_NumRows+1,vTotalFetchedRows);
2858: end if;
2859: end if;
2860:
2861: end if;

Line 3379: oErrorPosition := DBMS_SQL.last_error_position;

3375: log_message(oErrorMessage);
3376:
3377: when others then
3378: oErrorMessage := SQLERRM;
3379: oErrorPosition := DBMS_SQL.last_error_position;
3380: log_message(oErrorPosition);
3381: log_message(oErrorMessage);
3382: end ;
3383:

Line 3430: oErrorPosition := DBMS_SQL.last_error_position;

3426: end if;
3427: exception
3428: when others then
3429: oErrorMessage := SQLERRM;
3430: oErrorPosition := DBMS_SQL.last_error_position;
3431: log_message(oErrorPosition);
3432: log_message(oErrorMessage);
3433: end;
3434:

Line 3474: v_fetch_cursor := DBMS_SQL.OPEN_CURSOR;

3470: end if;
3471: buildFromClause;
3472:
3473: --parse the complete select statement
3474: v_fetch_cursor := DBMS_SQL.OPEN_CURSOR;
3475: if v_debug then
3476: log_message('before select parseStmt' );
3477: end if;
3478: oSqlStmt := vSelectStmt||vFromClause||vWhereStmt||vGroupByStmt||vHavingWhere||vSortStmt;

Line 3495: oErrorPosition := DBMS_SQL.last_error_position;

3491: -- unexpected error happened before reaching parse statement
3492: oErrorPosition := -1;
3493: else
3494: -- error ocured during parse
3495: oErrorPosition := DBMS_SQL.last_error_position;
3496: end if;
3497:
3498: oErrorMessage := SQLERRM;
3499: if dbms_sql.is_open(v_fetch_cursor) THEN

Line 3499: if dbms_sql.is_open(v_fetch_cursor) THEN

3495: oErrorPosition := DBMS_SQL.last_error_position;
3496: end if;
3497:
3498: oErrorMessage := SQLERRM;
3499: if dbms_sql.is_open(v_fetch_cursor) THEN
3500: dbms_sql.close_cursor(v_fetch_cursor);
3501: end if;
3502: if dbms_sql.is_open(v_insert_cursor) THEN
3503: dbms_sql.close_cursor(v_insert_cursor);

Line 3500: dbms_sql.close_cursor(v_fetch_cursor);

3496: end if;
3497:
3498: oErrorMessage := SQLERRM;
3499: if dbms_sql.is_open(v_fetch_cursor) THEN
3500: dbms_sql.close_cursor(v_fetch_cursor);
3501: end if;
3502: if dbms_sql.is_open(v_insert_cursor) THEN
3503: dbms_sql.close_cursor(v_insert_cursor);
3504: end if;

Line 3502: if dbms_sql.is_open(v_insert_cursor) THEN

3498: oErrorMessage := SQLERRM;
3499: if dbms_sql.is_open(v_fetch_cursor) THEN
3500: dbms_sql.close_cursor(v_fetch_cursor);
3501: end if;
3502: if dbms_sql.is_open(v_insert_cursor) THEN
3503: dbms_sql.close_cursor(v_insert_cursor);
3504: end if;
3505:
3506: end ValidateDefinition;

Line 3503: dbms_sql.close_cursor(v_insert_cursor);

3499: if dbms_sql.is_open(v_fetch_cursor) THEN
3500: dbms_sql.close_cursor(v_fetch_cursor);
3501: end if;
3502: if dbms_sql.is_open(v_insert_cursor) THEN
3503: dbms_sql.close_cursor(v_insert_cursor);
3504: end if;
3505:
3506: end ValidateDefinition;
3507:

Line 4037: function getVarcharArray(arrayIndex in number ) return DBMS_SQL.VARCHAR2_TABLE IS

4033:
4034: end;
4035:
4036: --this doesn't work
4037: function getVarcharArray(arrayIndex in number ) return DBMS_SQL.VARCHAR2_TABLE IS
4038: begin
4039: if arrayIndex = 1 then
4040: return( v_varchar1);
4041: elsif arrayIndex = 2 then