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.OKL_CS_TRANSACTIONS_PVT dependencies on DBMS_SQL

Line 40: l_cursor := DBMS_SQL.OPEN_CURSOR;

36: ELSE
37: l_sql := ' SELECT '||p_select||' FROM '||p_from;
38: END IF;
39:
40: l_cursor := DBMS_SQL.OPEN_CURSOR;
41: DBMS_SQL.PARSE(l_cursor, l_sql , DBMS_SQL.V7);
42:
43: DBMS_SQL.DEFINE_COLUMN(l_cursor, 1, x_inv_total);
44: DBMS_SQL.DEFINE_COLUMN(l_cursor, 2, x_rec_total);

Line 41: DBMS_SQL.PARSE(l_cursor, l_sql , DBMS_SQL.V7);

37: l_sql := ' SELECT '||p_select||' FROM '||p_from;
38: END IF;
39:
40: l_cursor := DBMS_SQL.OPEN_CURSOR;
41: DBMS_SQL.PARSE(l_cursor, l_sql , DBMS_SQL.V7);
42:
43: DBMS_SQL.DEFINE_COLUMN(l_cursor, 1, x_inv_total);
44: DBMS_SQL.DEFINE_COLUMN(l_cursor, 2, x_rec_total);
45: DBMS_SQL.DEFINE_COLUMN(l_cursor, 3, x_due_total);

Line 43: DBMS_SQL.DEFINE_COLUMN(l_cursor, 1, x_inv_total);

39:
40: l_cursor := DBMS_SQL.OPEN_CURSOR;
41: DBMS_SQL.PARSE(l_cursor, l_sql , DBMS_SQL.V7);
42:
43: DBMS_SQL.DEFINE_COLUMN(l_cursor, 1, x_inv_total);
44: DBMS_SQL.DEFINE_COLUMN(l_cursor, 2, x_rec_total);
45: DBMS_SQL.DEFINE_COLUMN(l_cursor, 3, x_due_total);
46: IF p_from IN ('OKL_CS_BILLINGTRX_UV','OKL_CS_ACCOUNT_CONT_INV_UV','OKL_CS_ACCOUNT_INV_UV') THEN
47: DBMS_SQL.DEFINE_COLUMN(l_cursor, 4, x_credit_total);

Line 44: DBMS_SQL.DEFINE_COLUMN(l_cursor, 2, x_rec_total);

40: l_cursor := DBMS_SQL.OPEN_CURSOR;
41: DBMS_SQL.PARSE(l_cursor, l_sql , DBMS_SQL.V7);
42:
43: DBMS_SQL.DEFINE_COLUMN(l_cursor, 1, x_inv_total);
44: DBMS_SQL.DEFINE_COLUMN(l_cursor, 2, x_rec_total);
45: DBMS_SQL.DEFINE_COLUMN(l_cursor, 3, x_due_total);
46: IF p_from IN ('OKL_CS_BILLINGTRX_UV','OKL_CS_ACCOUNT_CONT_INV_UV','OKL_CS_ACCOUNT_INV_UV') THEN
47: DBMS_SQL.DEFINE_COLUMN(l_cursor, 4, x_credit_total);
48: DBMS_SQL.DEFINE_COLUMN(l_cursor, 5, x_adjust_total);

Line 45: DBMS_SQL.DEFINE_COLUMN(l_cursor, 3, x_due_total);

41: DBMS_SQL.PARSE(l_cursor, l_sql , DBMS_SQL.V7);
42:
43: DBMS_SQL.DEFINE_COLUMN(l_cursor, 1, x_inv_total);
44: DBMS_SQL.DEFINE_COLUMN(l_cursor, 2, x_rec_total);
45: DBMS_SQL.DEFINE_COLUMN(l_cursor, 3, x_due_total);
46: IF p_from IN ('OKL_CS_BILLINGTRX_UV','OKL_CS_ACCOUNT_CONT_INV_UV','OKL_CS_ACCOUNT_INV_UV') THEN
47: DBMS_SQL.DEFINE_COLUMN(l_cursor, 4, x_credit_total);
48: DBMS_SQL.DEFINE_COLUMN(l_cursor, 5, x_adjust_total);
49: END IF;

Line 47: DBMS_SQL.DEFINE_COLUMN(l_cursor, 4, x_credit_total);

43: DBMS_SQL.DEFINE_COLUMN(l_cursor, 1, x_inv_total);
44: DBMS_SQL.DEFINE_COLUMN(l_cursor, 2, x_rec_total);
45: DBMS_SQL.DEFINE_COLUMN(l_cursor, 3, x_due_total);
46: IF p_from IN ('OKL_CS_BILLINGTRX_UV','OKL_CS_ACCOUNT_CONT_INV_UV','OKL_CS_ACCOUNT_INV_UV') THEN
47: DBMS_SQL.DEFINE_COLUMN(l_cursor, 4, x_credit_total);
48: DBMS_SQL.DEFINE_COLUMN(l_cursor, 5, x_adjust_total);
49: END IF;
50:
51: l_rows := DBMS_SQL.EXECUTE_AND_FETCH(l_cursor);

Line 48: DBMS_SQL.DEFINE_COLUMN(l_cursor, 5, x_adjust_total);

44: DBMS_SQL.DEFINE_COLUMN(l_cursor, 2, x_rec_total);
45: DBMS_SQL.DEFINE_COLUMN(l_cursor, 3, x_due_total);
46: IF p_from IN ('OKL_CS_BILLINGTRX_UV','OKL_CS_ACCOUNT_CONT_INV_UV','OKL_CS_ACCOUNT_INV_UV') THEN
47: DBMS_SQL.DEFINE_COLUMN(l_cursor, 4, x_credit_total);
48: DBMS_SQL.DEFINE_COLUMN(l_cursor, 5, x_adjust_total);
49: END IF;
50:
51: l_rows := DBMS_SQL.EXECUTE_AND_FETCH(l_cursor);
52:

Line 51: l_rows := DBMS_SQL.EXECUTE_AND_FETCH(l_cursor);

47: DBMS_SQL.DEFINE_COLUMN(l_cursor, 4, x_credit_total);
48: DBMS_SQL.DEFINE_COLUMN(l_cursor, 5, x_adjust_total);
49: END IF;
50:
51: l_rows := DBMS_SQL.EXECUTE_AND_FETCH(l_cursor);
52:
53: IF l_rows = 1 THEN
54:
55: DBMS_SQL.COLUMN_VALUE(l_cursor, 1, x_inv_total);

Line 55: DBMS_SQL.COLUMN_VALUE(l_cursor, 1, x_inv_total);

51: l_rows := DBMS_SQL.EXECUTE_AND_FETCH(l_cursor);
52:
53: IF l_rows = 1 THEN
54:
55: DBMS_SQL.COLUMN_VALUE(l_cursor, 1, x_inv_total);
56: DBMS_SQL.COLUMN_VALUE(l_cursor, 2, x_rec_total);
57: DBMS_SQL.COLUMN_VALUE(l_cursor, 3, x_due_total);
58: IF p_from IN ('OKL_CS_BILLINGTRX_UV','OKL_CS_ACCOUNT_CONT_INV_UV','OKL_CS_ACCOUNT_INV_UV') THEN
59: DBMS_SQL.COLUMN_VALUE(l_cursor, 4, x_credit_total);

Line 56: DBMS_SQL.COLUMN_VALUE(l_cursor, 2, x_rec_total);

52:
53: IF l_rows = 1 THEN
54:
55: DBMS_SQL.COLUMN_VALUE(l_cursor, 1, x_inv_total);
56: DBMS_SQL.COLUMN_VALUE(l_cursor, 2, x_rec_total);
57: DBMS_SQL.COLUMN_VALUE(l_cursor, 3, x_due_total);
58: IF p_from IN ('OKL_CS_BILLINGTRX_UV','OKL_CS_ACCOUNT_CONT_INV_UV','OKL_CS_ACCOUNT_INV_UV') THEN
59: DBMS_SQL.COLUMN_VALUE(l_cursor, 4, x_credit_total);
60: DBMS_SQL.COLUMN_VALUE(l_cursor, 5, x_adjust_total);

Line 57: DBMS_SQL.COLUMN_VALUE(l_cursor, 3, x_due_total);

53: IF l_rows = 1 THEN
54:
55: DBMS_SQL.COLUMN_VALUE(l_cursor, 1, x_inv_total);
56: DBMS_SQL.COLUMN_VALUE(l_cursor, 2, x_rec_total);
57: DBMS_SQL.COLUMN_VALUE(l_cursor, 3, x_due_total);
58: IF p_from IN ('OKL_CS_BILLINGTRX_UV','OKL_CS_ACCOUNT_CONT_INV_UV','OKL_CS_ACCOUNT_INV_UV') THEN
59: DBMS_SQL.COLUMN_VALUE(l_cursor, 4, x_credit_total);
60: DBMS_SQL.COLUMN_VALUE(l_cursor, 5, x_adjust_total);
61: END IF;

Line 59: DBMS_SQL.COLUMN_VALUE(l_cursor, 4, x_credit_total);

55: DBMS_SQL.COLUMN_VALUE(l_cursor, 1, x_inv_total);
56: DBMS_SQL.COLUMN_VALUE(l_cursor, 2, x_rec_total);
57: DBMS_SQL.COLUMN_VALUE(l_cursor, 3, x_due_total);
58: IF p_from IN ('OKL_CS_BILLINGTRX_UV','OKL_CS_ACCOUNT_CONT_INV_UV','OKL_CS_ACCOUNT_INV_UV') THEN
59: DBMS_SQL.COLUMN_VALUE(l_cursor, 4, x_credit_total);
60: DBMS_SQL.COLUMN_VALUE(l_cursor, 5, x_adjust_total);
61: END IF;
62:
63: x_return_status := OKL_API.G_RET_STS_SUCCESS;

Line 60: DBMS_SQL.COLUMN_VALUE(l_cursor, 5, x_adjust_total);

56: DBMS_SQL.COLUMN_VALUE(l_cursor, 2, x_rec_total);
57: DBMS_SQL.COLUMN_VALUE(l_cursor, 3, x_due_total);
58: IF p_from IN ('OKL_CS_BILLINGTRX_UV','OKL_CS_ACCOUNT_CONT_INV_UV','OKL_CS_ACCOUNT_INV_UV') THEN
59: DBMS_SQL.COLUMN_VALUE(l_cursor, 4, x_credit_total);
60: DBMS_SQL.COLUMN_VALUE(l_cursor, 5, x_adjust_total);
61: END IF;
62:
63: x_return_status := OKL_API.G_RET_STS_SUCCESS;
64:

Line 72: DBMS_SQL.CLOSE_CURSOR(l_cursor);

68:
69: END IF;
70:
71: x_row_count := l_rows;
72: DBMS_SQL.CLOSE_CURSOR(l_cursor);
73:
74: EXCEPTION
75:
76: WHEN OTHERS THEN

Line 86: DBMS_SQL.CLOSE_CURSOR(l_cursor);

82: p_token2 => G_SQLERRM_TOKEN,
83: p_token2_value => SQLERRM);
84:
85: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
86: DBMS_SQL.CLOSE_CURSOR(l_cursor);
87:
88: END get_totals;
89:
90: