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 1098: deal_select_cursor := DBMS_SQL.open_cursor;

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

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

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

Line 1109: DBMS_SQL.bind_variable(

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

Line 1111: DBMS_SQL.bind_variable(

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

Line 1115: DBMS_SQL.bind_variable(

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

Line 1120: DBMS_SQL.bind_variable(

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

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

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

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

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

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

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

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

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

Line 1178: DBMS_SQL.close_cursor(deal_select_cursor);

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

Line 1218: assign_select_cursor := DBMS_SQL.open_cursor;

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

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

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

Line 1229: DBMS_SQL.bind_variable(

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

Line 1231: DBMS_SQL.bind_variable(

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

Line 1235: DBMS_SQL.bind_variable(

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

Line 1240: DBMS_SQL.bind_variable(

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 1329: DBMS_SQL.close_cursor(assign_select_cursor);

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