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

Line 45: select_cursor := DBMS_SQL.open_cursor;

41: count_rows NUMBER;
42: l_comm_lines_api_id NUMBER;
43: i BINARY_INTEGER := 1;
44: BEGIN
45: select_cursor := DBMS_SQL.open_cursor;
46: sql_stmt := 'SELECT COMM_LINES_API_ID FROM CN_ADJUSTMENTS_V WHERE ';
47: sql_stmt := sql_stmt || x_where_clause;
48: dbms_sql.parse(select_cursor,sql_stmt,DBMS_SQL.NATIVE);
49: DBMS_SQL.define_column (select_cursor,1,l_comm_lines_api_id);

Line 48: dbms_sql.parse(select_cursor,sql_stmt,DBMS_SQL.NATIVE);

44: BEGIN
45: select_cursor := DBMS_SQL.open_cursor;
46: sql_stmt := 'SELECT COMM_LINES_API_ID FROM CN_ADJUSTMENTS_V WHERE ';
47: sql_stmt := sql_stmt || x_where_clause;
48: dbms_sql.parse(select_cursor,sql_stmt,DBMS_SQL.NATIVE);
49: DBMS_SQL.define_column (select_cursor,1,l_comm_lines_api_id);
50: count_rows := DBMS_SQL.execute (select_cursor);
51: tab_mass_update_comm.delete;
52: LOOP

Line 49: DBMS_SQL.define_column (select_cursor,1,l_comm_lines_api_id);

45: select_cursor := DBMS_SQL.open_cursor;
46: sql_stmt := 'SELECT COMM_LINES_API_ID FROM CN_ADJUSTMENTS_V WHERE ';
47: sql_stmt := sql_stmt || x_where_clause;
48: dbms_sql.parse(select_cursor,sql_stmt,DBMS_SQL.NATIVE);
49: DBMS_SQL.define_column (select_cursor,1,l_comm_lines_api_id);
50: count_rows := DBMS_SQL.execute (select_cursor);
51: tab_mass_update_comm.delete;
52: LOOP
53: IF (dbms_sql.fetch_rows(select_cursor) > 0) THEN

Line 50: count_rows := DBMS_SQL.execute (select_cursor);

46: sql_stmt := 'SELECT COMM_LINES_API_ID FROM CN_ADJUSTMENTS_V WHERE ';
47: sql_stmt := sql_stmt || x_where_clause;
48: dbms_sql.parse(select_cursor,sql_stmt,DBMS_SQL.NATIVE);
49: DBMS_SQL.define_column (select_cursor,1,l_comm_lines_api_id);
50: count_rows := DBMS_SQL.execute (select_cursor);
51: tab_mass_update_comm.delete;
52: LOOP
53: IF (dbms_sql.fetch_rows(select_cursor) > 0) THEN
54: DBMS_SQL.column_value (select_cursor,1,l_comm_lines_api_id);

Line 53: IF (dbms_sql.fetch_rows(select_cursor) > 0) THEN

49: DBMS_SQL.define_column (select_cursor,1,l_comm_lines_api_id);
50: count_rows := DBMS_SQL.execute (select_cursor);
51: tab_mass_update_comm.delete;
52: LOOP
53: IF (dbms_sql.fetch_rows(select_cursor) > 0) THEN
54: DBMS_SQL.column_value (select_cursor,1,l_comm_lines_api_id);
55: tab_mass_update_comm(i) := l_comm_lines_api_id;
56: i := i + 1;
57: ELSE

Line 54: DBMS_SQL.column_value (select_cursor,1,l_comm_lines_api_id);

50: count_rows := DBMS_SQL.execute (select_cursor);
51: tab_mass_update_comm.delete;
52: LOOP
53: IF (dbms_sql.fetch_rows(select_cursor) > 0) THEN
54: DBMS_SQL.column_value (select_cursor,1,l_comm_lines_api_id);
55: tab_mass_update_comm(i) := l_comm_lines_api_id;
56: i := i + 1;
57: ELSE
58: EXIT;

Line 61: DBMS_SQL.close_cursor(select_cursor);

57: ELSE
58: EXIT;
59: END IF;
60: END LOOP;
61: DBMS_SQL.close_cursor(select_cursor);
62: END mass_adjust_build_query;
63: --
64:
65: -- Negate a transaction (original transaction t1)

Line 1100: deal_select_cursor := DBMS_SQL.open_cursor;

1096: l_api_rec cn_comm_lines_api_pkg.comm_lines_api_rec_type;
1097: -- To mask this non-standard API
1098: x_return_status VARCHAR2(1000);
1099: BEGIN
1100: deal_select_cursor := DBMS_SQL.open_cursor;
1101: sql_stmt := 'SELECT COMM_LINES_API_ID FROM CN_ADJUSTMENTS_V WHERE
1102: direct_salesrep_id = :X_source_salesrep_id AND revenue_type = :l_revenue';
1103: --
1104: IF (x_invoice_number IS NOT NULL) THEN

Line 1110: dbms_sql.parse(deal_select_cursor,sql_stmt,DBMS_SQL.NATIVE);

1106: ELSIF(x_order_number IS NOT NULL) THEN
1107: sql_stmt := sql_stmt || ' and order_number = :X_order_number';
1108: END IF;
1109: --
1110: dbms_sql.parse(deal_select_cursor,sql_stmt,DBMS_SQL.NATIVE);
1111: DBMS_SQL.bind_variable(
1112: deal_select_cursor,'x_source_salesrep_id',x_source_salesrep_id);
1113: DBMS_SQL.bind_variable(
1114: deal_select_cursor,'l_revenue',l_revenue);

Line 1111: DBMS_SQL.bind_variable(

1107: sql_stmt := sql_stmt || ' and order_number = :X_order_number';
1108: END IF;
1109: --
1110: dbms_sql.parse(deal_select_cursor,sql_stmt,DBMS_SQL.NATIVE);
1111: DBMS_SQL.bind_variable(
1112: deal_select_cursor,'x_source_salesrep_id',x_source_salesrep_id);
1113: DBMS_SQL.bind_variable(
1114: deal_select_cursor,'l_revenue',l_revenue);
1115: --

Line 1113: DBMS_SQL.bind_variable(

1109: --
1110: dbms_sql.parse(deal_select_cursor,sql_stmt,DBMS_SQL.NATIVE);
1111: DBMS_SQL.bind_variable(
1112: deal_select_cursor,'x_source_salesrep_id',x_source_salesrep_id);
1113: DBMS_SQL.bind_variable(
1114: deal_select_cursor,'l_revenue',l_revenue);
1115: --
1116: IF (x_invoice_number IS NOT NULL) THEN
1117: DBMS_SQL.bind_variable(

Line 1117: DBMS_SQL.bind_variable(

1113: DBMS_SQL.bind_variable(
1114: deal_select_cursor,'l_revenue',l_revenue);
1115: --
1116: IF (x_invoice_number IS NOT NULL) THEN
1117: DBMS_SQL.bind_variable(
1118: deal_select_cursor,'x_invoice_number',x_invoice_number);
1119: END IF;
1120: --
1121: IF (x_order_number IS NOT NULL) THEN

Line 1122: DBMS_SQL.bind_variable(

1118: deal_select_cursor,'x_invoice_number',x_invoice_number);
1119: END IF;
1120: --
1121: IF (x_order_number IS NOT NULL) THEN
1122: DBMS_SQL.bind_variable(
1123: deal_select_cursor,'x_order_number',x_order_number);
1124: END IF;
1125: --
1126: DBMS_SQL.define_column (deal_select_cursor,1,l_comm_lines_api_id);

Line 1126: DBMS_SQL.define_column (deal_select_cursor,1,l_comm_lines_api_id);

1122: DBMS_SQL.bind_variable(
1123: deal_select_cursor,'x_order_number',x_order_number);
1124: END IF;
1125: --
1126: DBMS_SQL.define_column (deal_select_cursor,1,l_comm_lines_api_id);
1127: count_rows := DBMS_SQL.execute (deal_select_cursor);
1128: LOOP
1129: IF (dbms_sql.fetch_rows(deal_select_cursor) > 0) THEN
1130: DBMS_SQL.column_value (deal_select_cursor,1,l_comm_lines_api_id);

Line 1127: count_rows := DBMS_SQL.execute (deal_select_cursor);

1123: deal_select_cursor,'x_order_number',x_order_number);
1124: END IF;
1125: --
1126: DBMS_SQL.define_column (deal_select_cursor,1,l_comm_lines_api_id);
1127: count_rows := DBMS_SQL.execute (deal_select_cursor);
1128: LOOP
1129: IF (dbms_sql.fetch_rows(deal_select_cursor) > 0) THEN
1130: DBMS_SQL.column_value (deal_select_cursor,1,l_comm_lines_api_id);
1131: --

Line 1129: IF (dbms_sql.fetch_rows(deal_select_cursor) > 0) THEN

1125: --
1126: DBMS_SQL.define_column (deal_select_cursor,1,l_comm_lines_api_id);
1127: count_rows := DBMS_SQL.execute (deal_select_cursor);
1128: LOOP
1129: IF (dbms_sql.fetch_rows(deal_select_cursor) > 0) THEN
1130: DBMS_SQL.column_value (deal_select_cursor,1,l_comm_lines_api_id);
1131: --
1132: --cn_adjustments_pkg.get_api_data(l_comm_lines_api_id,l_adj_tbl);
1133: cn_get_tx_data_pub.get_api_data(l_comm_lines_api_id,l_adj_tbl);

Line 1130: DBMS_SQL.column_value (deal_select_cursor,1,l_comm_lines_api_id);

1126: DBMS_SQL.define_column (deal_select_cursor,1,l_comm_lines_api_id);
1127: count_rows := DBMS_SQL.execute (deal_select_cursor);
1128: LOOP
1129: IF (dbms_sql.fetch_rows(deal_select_cursor) > 0) THEN
1130: DBMS_SQL.column_value (deal_select_cursor,1,l_comm_lines_api_id);
1131: --
1132: --cn_adjustments_pkg.get_api_data(l_comm_lines_api_id,l_adj_tbl);
1133: cn_get_tx_data_pub.get_api_data(l_comm_lines_api_id,l_adj_tbl);
1134: --

Line 1180: DBMS_SQL.close_cursor(deal_select_cursor);

1176: ELSE
1177: EXIT;
1178: END IF;
1179: END LOOP;
1180: DBMS_SQL.close_cursor(deal_select_cursor);
1181: END deal_split;
1182: --
1183: PROCEDURE deal_assign(
1184: x_from_salesrep_id NUMBER,

Line 1220: assign_select_cursor := DBMS_SQL.open_cursor;

1216: -- To mask this non-standard API
1217: x_return_status VARCHAR2(1000);
1218: --
1219: BEGIN
1220: assign_select_cursor := DBMS_SQL.open_cursor;
1221: sql_stmt := 'SELECT comm_lines_api_id,load_status FROM cn_adjustments_v WHERE';
1222: sql_stmt := sql_stmt || ' direct_salesrep_id = :x_from_salesrep_id AND revenue_type = :l_revenue';
1223: --
1224: IF (x_invoice_number IS NOT NULL) THEN

Line 1230: dbms_sql.parse(assign_select_cursor,sql_stmt,DBMS_SQL.NATIVE);

1226: ELSIF(x_order_number IS NOT NULL) THEN
1227: sql_stmt := sql_stmt || ' AND order_number = :x_order_number';
1228: END IF;
1229: --
1230: dbms_sql.parse(assign_select_cursor,sql_stmt,DBMS_SQL.NATIVE);
1231: DBMS_SQL.bind_variable(
1232: assign_select_cursor,'x_from_salesrep_id',x_from_salesrep_id);
1233: DBMS_SQL.bind_variable(
1234: assign_select_cursor,'l_revenue',l_revenue);

Line 1231: DBMS_SQL.bind_variable(

1227: sql_stmt := sql_stmt || ' AND order_number = :x_order_number';
1228: END IF;
1229: --
1230: dbms_sql.parse(assign_select_cursor,sql_stmt,DBMS_SQL.NATIVE);
1231: DBMS_SQL.bind_variable(
1232: assign_select_cursor,'x_from_salesrep_id',x_from_salesrep_id);
1233: DBMS_SQL.bind_variable(
1234: assign_select_cursor,'l_revenue',l_revenue);
1235: --

Line 1233: DBMS_SQL.bind_variable(

1229: --
1230: dbms_sql.parse(assign_select_cursor,sql_stmt,DBMS_SQL.NATIVE);
1231: DBMS_SQL.bind_variable(
1232: assign_select_cursor,'x_from_salesrep_id',x_from_salesrep_id);
1233: DBMS_SQL.bind_variable(
1234: assign_select_cursor,'l_revenue',l_revenue);
1235: --
1236: IF (x_invoice_number IS NOT NULL) THEN
1237: DBMS_SQL.bind_variable(

Line 1237: DBMS_SQL.bind_variable(

1233: DBMS_SQL.bind_variable(
1234: assign_select_cursor,'l_revenue',l_revenue);
1235: --
1236: IF (x_invoice_number IS NOT NULL) THEN
1237: DBMS_SQL.bind_variable(
1238: assign_select_cursor,'x_invoice_number',x_invoice_number);
1239: END IF;
1240: --
1241: IF (x_order_number IS NOT NULL) THEN

Line 1242: DBMS_SQL.bind_variable(

1238: assign_select_cursor,'x_invoice_number',x_invoice_number);
1239: END IF;
1240: --
1241: IF (x_order_number IS NOT NULL) THEN
1242: DBMS_SQL.bind_variable(
1243: assign_select_cursor,'x_order_number',x_order_number);
1244: END IF;
1245: --
1246: DBMS_SQL.define_column (assign_select_cursor,1,l_comm_lines_api_id);

Line 1246: DBMS_SQL.define_column (assign_select_cursor,1,l_comm_lines_api_id);

1242: DBMS_SQL.bind_variable(
1243: assign_select_cursor,'x_order_number',x_order_number);
1244: END IF;
1245: --
1246: DBMS_SQL.define_column (assign_select_cursor,1,l_comm_lines_api_id);
1247: DBMS_SQL.define_column (assign_select_cursor,2,l_load_status,30);
1248: count_rows := DBMS_SQL.execute (assign_select_cursor);
1249: LOOP
1250: IF (dbms_sql.fetch_rows(assign_select_cursor) > 0) THEN

Line 1247: DBMS_SQL.define_column (assign_select_cursor,2,l_load_status,30);

1243: assign_select_cursor,'x_order_number',x_order_number);
1244: END IF;
1245: --
1246: DBMS_SQL.define_column (assign_select_cursor,1,l_comm_lines_api_id);
1247: DBMS_SQL.define_column (assign_select_cursor,2,l_load_status,30);
1248: count_rows := DBMS_SQL.execute (assign_select_cursor);
1249: LOOP
1250: IF (dbms_sql.fetch_rows(assign_select_cursor) > 0) THEN
1251: DBMS_SQL.column_value (assign_select_cursor,1,l_comm_lines_api_id);

Line 1248: count_rows := DBMS_SQL.execute (assign_select_cursor);

1244: END IF;
1245: --
1246: DBMS_SQL.define_column (assign_select_cursor,1,l_comm_lines_api_id);
1247: DBMS_SQL.define_column (assign_select_cursor,2,l_load_status,30);
1248: count_rows := DBMS_SQL.execute (assign_select_cursor);
1249: LOOP
1250: IF (dbms_sql.fetch_rows(assign_select_cursor) > 0) THEN
1251: DBMS_SQL.column_value (assign_select_cursor,1,l_comm_lines_api_id);
1252: DBMS_SQL.column_value (assign_select_cursor,2,l_load_status);

Line 1250: IF (dbms_sql.fetch_rows(assign_select_cursor) > 0) THEN

1246: DBMS_SQL.define_column (assign_select_cursor,1,l_comm_lines_api_id);
1247: DBMS_SQL.define_column (assign_select_cursor,2,l_load_status,30);
1248: count_rows := DBMS_SQL.execute (assign_select_cursor);
1249: LOOP
1250: IF (dbms_sql.fetch_rows(assign_select_cursor) > 0) THEN
1251: DBMS_SQL.column_value (assign_select_cursor,1,l_comm_lines_api_id);
1252: DBMS_SQL.column_value (assign_select_cursor,2,l_load_status);
1253: IF (l_load_status = 'LOADED') THEN
1254: FOR rec IN header_cur(l_comm_lines_api_id)

Line 1251: DBMS_SQL.column_value (assign_select_cursor,1,l_comm_lines_api_id);

1247: DBMS_SQL.define_column (assign_select_cursor,2,l_load_status,30);
1248: count_rows := DBMS_SQL.execute (assign_select_cursor);
1249: LOOP
1250: IF (dbms_sql.fetch_rows(assign_select_cursor) > 0) THEN
1251: DBMS_SQL.column_value (assign_select_cursor,1,l_comm_lines_api_id);
1252: DBMS_SQL.column_value (assign_select_cursor,2,l_load_status);
1253: IF (l_load_status = 'LOADED') THEN
1254: FOR rec IN header_cur(l_comm_lines_api_id)
1255: LOOP

Line 1252: DBMS_SQL.column_value (assign_select_cursor,2,l_load_status);

1248: count_rows := DBMS_SQL.execute (assign_select_cursor);
1249: LOOP
1250: IF (dbms_sql.fetch_rows(assign_select_cursor) > 0) THEN
1251: DBMS_SQL.column_value (assign_select_cursor,1,l_comm_lines_api_id);
1252: DBMS_SQL.column_value (assign_select_cursor,2,l_load_status);
1253: IF (l_load_status = 'LOADED') THEN
1254: FOR rec IN header_cur(l_comm_lines_api_id)
1255: LOOP
1256: IF(nvl(rec.adjust_status,'X') <> 'FROZEN') THEN

Line 1331: DBMS_SQL.close_cursor(assign_select_cursor);

1327: ELSE
1328: exit;
1329: END IF;
1330: END LOOP;
1331: DBMS_SQL.close_cursor(assign_select_cursor);
1332: END deal_assign;
1333: --
1334: PROCEDURE get_cust_info(
1335: p_comm_lines_api_id IN NUMBER,