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_SCH_WB dependencies on ORDER_SCH_WB

Line 34: order_sch_wb.debug_session_id := x_session_id;

30:
31: sql_stmt VARCHAR2(1000);
32: l_count NUMBER := 0;
33: begin
34: order_sch_wb.debug_session_id := x_session_id;
35:
36: IF PG_DEBUG in ('Y', 'C') THEN
37: atp_debug('GET_ATP_RESULT: ' || 'got here');
38: select count(*)

Line 449: order_sch_wb.debug_session_id := p_session_id;

445: ( p_session_id NUMBER,
446: p_where_clause varchar2) IS
447: sqlstmt VARCHAR2(100);
448: BEGIN
449: order_sch_wb.debug_session_id := p_session_id;
450:
451: IF PG_DEBUG in ('Y', 'C') THEN
452: atp_debug('delete_lines: ' || ' deleting all rows for session_id 1 '||p_session_id);
453: END IF;

Line 679: IF inst = order_sch_wb.server THEN

675: IF dblink IS NOT NULL THEN
676: l_dblink := '@'||dblink;
677: END IF;
678:
679: IF inst = order_sch_wb.server THEN
680: -- called from Planning server
681: -- msc_item_id is passed in for item_id
682: sqlstring :=
683: ' SELECT rule_name '||

Line 877: IF x_inst = order_sch_wb.apps THEN

873: END IF;
874: END IF;
875:
876:
877: IF x_inst = order_sch_wb.apps THEN
878:
879: x_assignment_set_id := fnd_profile.value('MRP_ATP_ASSIGN_SET');
880:
881: if x_assignment_set_id is null then

Line 989: --IF order_sch_wb.mr_debug = 'Y' THEN

985: END get_assignment_set;
986:
987: PROCEDURE atp_debug(buf IN VARCHAR2) IS
988: BEGIN
989: --IF order_sch_wb.mr_debug = 'Y' THEN
990: IF order_sch_wb.mr_debug in ('Y','C') THEN
991: IF order_sch_wb.file_or_terminal = 1 THEN
992: mrp_timing(buf);
993: ELSE

Line 990: IF order_sch_wb.mr_debug in ('Y','C') THEN

986:
987: PROCEDURE atp_debug(buf IN VARCHAR2) IS
988: BEGIN
989: --IF order_sch_wb.mr_debug = 'Y' THEN
990: IF order_sch_wb.mr_debug in ('Y','C') THEN
991: IF order_sch_wb.file_or_terminal = 1 THEN
992: mrp_timing(buf);
993: ELSE
994: -- dbms_output.put_line(buf);

Line 991: IF order_sch_wb.file_or_terminal = 1 THEN

987: PROCEDURE atp_debug(buf IN VARCHAR2) IS
988: BEGIN
989: --IF order_sch_wb.mr_debug = 'Y' THEN
990: IF order_sch_wb.mr_debug in ('Y','C') THEN
991: IF order_sch_wb.file_or_terminal = 1 THEN
992: mrp_timing(buf);
993: ELSE
994: -- dbms_output.put_line(buf);
995: null;

Line 1005: utl_file.put(fname, 'atp_session: '||order_sch_wb.debug_session_id||' '||buf);

1001: IS
1002: fname utl_file.file_type ;
1003: BEGIN
1004: IF (utl_file.is_open(fname)) THEN
1005: utl_file.put(fname, 'atp_session: '||order_sch_wb.debug_session_id||' '||buf);
1006: utl_file.fflush(fname);
1007: utl_file.fclose(fname);
1008: ELSE
1009: if order_sch_wb.file_dir is null then

Line 1009: if order_sch_wb.file_dir is null then

1005: utl_file.put(fname, 'atp_session: '||order_sch_wb.debug_session_id||' '||buf);
1006: utl_file.fflush(fname);
1007: utl_file.fclose(fname);
1008: ELSE
1009: if order_sch_wb.file_dir is null then
1010: --select ltrim(rtrim(substr(value, instr(value,',',-1,1)+1)))
1011: -- into order_sch_wb.file_dir from v$parameter where name= 'utl_file_dir';
1012: /*bug 3374136 changes start*/
1013: select ltrim(rtrim(value)) into order_sch_wb.file_dir from

Line 1011: -- into order_sch_wb.file_dir from v$parameter where name= 'utl_file_dir';

1007: utl_file.fclose(fname);
1008: ELSE
1009: if order_sch_wb.file_dir is null then
1010: --select ltrim(rtrim(substr(value, instr(value,',',-1,1)+1)))
1011: -- into order_sch_wb.file_dir from v$parameter where name= 'utl_file_dir';
1012: /*bug 3374136 changes start*/
1013: select ltrim(rtrim(value)) into order_sch_wb.file_dir from
1014: (select value from v$parameter2 where name='utl_file_dir' order by rownum desc)
1015: where rownum <2;

Line 1013: select ltrim(rtrim(value)) into order_sch_wb.file_dir from

1009: if order_sch_wb.file_dir is null then
1010: --select ltrim(rtrim(substr(value, instr(value,',',-1,1)+1)))
1011: -- into order_sch_wb.file_dir from v$parameter where name= 'utl_file_dir';
1012: /*bug 3374136 changes start*/
1013: select ltrim(rtrim(value)) into order_sch_wb.file_dir from
1014: (select value from v$parameter2 where name='utl_file_dir' order by rownum desc)
1015: where rownum <2;
1016: /*bug 3374136 changes end*/
1017: end if;

Line 1018: -- dbms_output.put_line('dir '||order_sch_wb.file_dir||order_sch_wb.debug_session_id);

1014: (select value from v$parameter2 where name='utl_file_dir' order by rownum desc)
1015: where rownum <2;
1016: /*bug 3374136 changes end*/
1017: end if;
1018: -- dbms_output.put_line('dir '||order_sch_wb.file_dir||order_sch_wb.debug_session_id);
1019:
1020: fname := utl_file.fopen(order_sch_wb.file_dir,'session-'||order_sch_wb.debug_session_id,'a');
1021: utl_file.put(fname, buf);
1022: utl_file.fflush(fname);

Line 1020: fname := utl_file.fopen(order_sch_wb.file_dir,'session-'||order_sch_wb.debug_session_id,'a');

1016: /*bug 3374136 changes end*/
1017: end if;
1018: -- dbms_output.put_line('dir '||order_sch_wb.file_dir||order_sch_wb.debug_session_id);
1019:
1020: fname := utl_file.fopen(order_sch_wb.file_dir,'session-'||order_sch_wb.debug_session_id,'a');
1021: utl_file.put(fname, buf);
1022: utl_file.fflush(fname);
1023: utl_file.fclose(fname);
1024: END IF;

Line 1076: x_atp_period_string order_sch_wb.atp_period_string_typ;

1072:
1073: rec_cnt number;
1074: day_gap number;
1075:
1076: x_atp_period_string order_sch_wb.atp_period_string_typ;
1077:
1078: -- The week and period is calculated based on the source org of the line.
1079: -- We may need to do it for the org in which that pegging node is
1080: cursor wk_cur is select b.week_start_date

Line 1122: inventory_item_name||order_sch_wb.delim||owb_tree.lookups(5) -- 'Item'

1118: and b.period_start_date <= v_period_end_date;
1119:
1120: cursor get_item_name is
1121: SELECT DISTINCT
1122: inventory_item_name||order_sch_wb.delim||owb_tree.lookups(5) -- 'Item'
1123: ||order_sch_wb.delim||source_organization_code
1124: FROM mrp_atp_schedule_temp
1125: WHERE end_pegging_id = p_end_pegging_id;
1126:

Line 1123: ||order_sch_wb.delim||source_organization_code

1119:
1120: cursor get_item_name is
1121: SELECT DISTINCT
1122: inventory_item_name||order_sch_wb.delim||owb_tree.lookups(5) -- 'Item'
1123: ||order_sch_wb.delim||source_organization_code
1124: FROM mrp_atp_schedule_temp
1125: WHERE end_pegging_id = p_end_pegging_id;
1126:
1127: BEGIN

Line 1145: inventory_item_name||order_sch_wb.delim||owb_tree.lookups(5)||order_sch_wb.delim||organization_code,

1141:
1142: IF p_pegging_id IS NOT NULL THEN
1143: SELECT Decode(department_id, NULL,
1144: Decode(supplier_id, NULL,
1145: inventory_item_name||order_sch_wb.delim||owb_tree.lookups(5)||order_sch_wb.delim||organization_code,
1146: -- 'Item'
1147: supplier_name||order_sch_wb.delim||owb_tree.lookups(17)||order_sch_wb.delim||supplier_site_name),
1148: department_code||order_sch_wb.delim||Decode(resource_code, NULL, owb_tree.lookups(18),owb_tree.lookups(6))||order_sch_wb.delim||Decode(resource_code, NULL, ' ', resource_code))
1149: -- blank above is so that pivot table will get some value to display

Line 1147: supplier_name||order_sch_wb.delim||owb_tree.lookups(17)||order_sch_wb.delim||supplier_site_name),

1143: SELECT Decode(department_id, NULL,
1144: Decode(supplier_id, NULL,
1145: inventory_item_name||order_sch_wb.delim||owb_tree.lookups(5)||order_sch_wb.delim||organization_code,
1146: -- 'Item'
1147: supplier_name||order_sch_wb.delim||owb_tree.lookups(17)||order_sch_wb.delim||supplier_site_name),
1148: department_code||order_sch_wb.delim||Decode(resource_code, NULL, owb_tree.lookups(18),owb_tree.lookups(6))||order_sch_wb.delim||Decode(resource_code, NULL, ' ', resource_code))
1149: -- blank above is so that pivot table will get some value to display
1150: -- for line. otherwise following values shift left.
1151: INTO l_pivot_hdr

Line 1148: department_code||order_sch_wb.delim||Decode(resource_code, NULL, owb_tree.lookups(18),owb_tree.lookups(6))||order_sch_wb.delim||Decode(resource_code, NULL, ' ', resource_code))

1144: Decode(supplier_id, NULL,
1145: inventory_item_name||order_sch_wb.delim||owb_tree.lookups(5)||order_sch_wb.delim||organization_code,
1146: -- 'Item'
1147: supplier_name||order_sch_wb.delim||owb_tree.lookups(17)||order_sch_wb.delim||supplier_site_name),
1148: department_code||order_sch_wb.delim||Decode(resource_code, NULL, owb_tree.lookups(18),owb_tree.lookups(6))||order_sch_wb.delim||Decode(resource_code, NULL, ' ', resource_code))
1149: -- blank above is so that pivot table will get some value to display
1150: -- for line. otherwise following values shift left.
1151: INTO l_pivot_hdr
1152: FROM mrp_atp_details_temp

Line 1260: p_date_str := p_date_str||order_sch_wb.delim||'Dy';

1256:
1257: IF x_atp_period_string.total_supply_quantity.COUNT > 0 THEN
1258:
1259: p_row_hdr_str := 'RowHeader';
1260: p_date_str := p_date_str||order_sch_wb.delim||'Dy';
1261: p_week_str := p_week_str||order_sch_wb.delim||'Wk';
1262: p_period_str := p_period_str||order_sch_wb.delim||'Pr';
1263: p_net_atp_str := 'GD'||order_sch_wb.delim||'New-End';
1264: p_cum_atp_str := 'GD'||order_sch_wb.delim||'New-End';

Line 1261: p_week_str := p_week_str||order_sch_wb.delim||'Wk';

1257: IF x_atp_period_string.total_supply_quantity.COUNT > 0 THEN
1258:
1259: p_row_hdr_str := 'RowHeader';
1260: p_date_str := p_date_str||order_sch_wb.delim||'Dy';
1261: p_week_str := p_week_str||order_sch_wb.delim||'Wk';
1262: p_period_str := p_period_str||order_sch_wb.delim||'Pr';
1263: p_net_atp_str := 'GD'||order_sch_wb.delim||'New-End';
1264: p_cum_atp_str := 'GD'||order_sch_wb.delim||'New-End';
1265: p_supply_str := 'GD'||order_sch_wb.delim||'New-End';

Line 1262: p_period_str := p_period_str||order_sch_wb.delim||'Pr';

1258:
1259: p_row_hdr_str := 'RowHeader';
1260: p_date_str := p_date_str||order_sch_wb.delim||'Dy';
1261: p_week_str := p_week_str||order_sch_wb.delim||'Wk';
1262: p_period_str := p_period_str||order_sch_wb.delim||'Pr';
1263: p_net_atp_str := 'GD'||order_sch_wb.delim||'New-End';
1264: p_cum_atp_str := 'GD'||order_sch_wb.delim||'New-End';
1265: p_supply_str := 'GD'||order_sch_wb.delim||'New-End';
1266: p_demand_str := 'GD'||order_sch_wb.delim||'New-End';

Line 1263: p_net_atp_str := 'GD'||order_sch_wb.delim||'New-End';

1259: p_row_hdr_str := 'RowHeader';
1260: p_date_str := p_date_str||order_sch_wb.delim||'Dy';
1261: p_week_str := p_week_str||order_sch_wb.delim||'Wk';
1262: p_period_str := p_period_str||order_sch_wb.delim||'Pr';
1263: p_net_atp_str := 'GD'||order_sch_wb.delim||'New-End';
1264: p_cum_atp_str := 'GD'||order_sch_wb.delim||'New-End';
1265: p_supply_str := 'GD'||order_sch_wb.delim||'New-End';
1266: p_demand_str := 'GD'||order_sch_wb.delim||'New-End';
1267: p_bkd_demand_str := 'GD'||order_sch_wb.delim||'New-End';

Line 1264: p_cum_atp_str := 'GD'||order_sch_wb.delim||'New-End';

1260: p_date_str := p_date_str||order_sch_wb.delim||'Dy';
1261: p_week_str := p_week_str||order_sch_wb.delim||'Wk';
1262: p_period_str := p_period_str||order_sch_wb.delim||'Pr';
1263: p_net_atp_str := 'GD'||order_sch_wb.delim||'New-End';
1264: p_cum_atp_str := 'GD'||order_sch_wb.delim||'New-End';
1265: p_supply_str := 'GD'||order_sch_wb.delim||'New-End';
1266: p_demand_str := 'GD'||order_sch_wb.delim||'New-End';
1267: p_bkd_demand_str := 'GD'||order_sch_wb.delim||'New-End';
1268:

Line 1265: p_supply_str := 'GD'||order_sch_wb.delim||'New-End';

1261: p_week_str := p_week_str||order_sch_wb.delim||'Wk';
1262: p_period_str := p_period_str||order_sch_wb.delim||'Pr';
1263: p_net_atp_str := 'GD'||order_sch_wb.delim||'New-End';
1264: p_cum_atp_str := 'GD'||order_sch_wb.delim||'New-End';
1265: p_supply_str := 'GD'||order_sch_wb.delim||'New-End';
1266: p_demand_str := 'GD'||order_sch_wb.delim||'New-End';
1267: p_bkd_demand_str := 'GD'||order_sch_wb.delim||'New-End';
1268:
1269: v_week_start_date := x_atp_period_string.period_start_date(1);

Line 1266: p_demand_str := 'GD'||order_sch_wb.delim||'New-End';

1262: p_period_str := p_period_str||order_sch_wb.delim||'Pr';
1263: p_net_atp_str := 'GD'||order_sch_wb.delim||'New-End';
1264: p_cum_atp_str := 'GD'||order_sch_wb.delim||'New-End';
1265: p_supply_str := 'GD'||order_sch_wb.delim||'New-End';
1266: p_demand_str := 'GD'||order_sch_wb.delim||'New-End';
1267: p_bkd_demand_str := 'GD'||order_sch_wb.delim||'New-End';
1268:
1269: v_week_start_date := x_atp_period_string.period_start_date(1);
1270: v_period_start_date := x_atp_period_string.period_start_date(1);

Line 1267: p_bkd_demand_str := 'GD'||order_sch_wb.delim||'New-End';

1263: p_net_atp_str := 'GD'||order_sch_wb.delim||'New-End';
1264: p_cum_atp_str := 'GD'||order_sch_wb.delim||'New-End';
1265: p_supply_str := 'GD'||order_sch_wb.delim||'New-End';
1266: p_demand_str := 'GD'||order_sch_wb.delim||'New-End';
1267: p_bkd_demand_str := 'GD'||order_sch_wb.delim||'New-End';
1268:
1269: v_week_start_date := x_atp_period_string.period_start_date(1);
1270: v_period_start_date := x_atp_period_string.period_start_date(1);
1271: v_week_end_date := x_atp_period_string.period_end_date(x_atp_period_string.period_end_date.count);

Line 1273: IF order_sch_wb.mr_debug = 'Y' THEN

1269: v_week_start_date := x_atp_period_string.period_start_date(1);
1270: v_period_start_date := x_atp_period_string.period_start_date(1);
1271: v_week_end_date := x_atp_period_string.period_end_date(x_atp_period_string.period_end_date.count);
1272: v_period_end_date := v_week_end_date;
1273: IF order_sch_wb.mr_debug = 'Y' THEN
1274: IF PG_DEBUG in ('Y', 'C') THEN
1275: msc_sch_wb.atp_debug('get_period_atp_strings: ' || '$$$ '||v_week_start_date||' '||v_week_end_date||' '||v_period_start_date||' '||v_period_end_date);
1276: END IF;
1277: END IF;

Line 1281: p_supply_str := p_supply_str||order_sch_wb.delim||Rtrim(To_char(x_atp_period_string.total_supply_quantity(j),order_sch_wb.mrn_canonical_num),'.');

1277: END IF;
1278:
1279:
1280: FOR j IN 1..x_atp_period_string.total_supply_quantity.COUNT loop
1281: p_supply_str := p_supply_str||order_sch_wb.delim||Rtrim(To_char(x_atp_period_string.total_supply_quantity(j),order_sch_wb.mrn_canonical_num),'.');
1282: p_demand_str := p_demand_str||order_sch_wb.delim||Rtrim(To_char(x_atp_period_string.total_demand_quantity(j),order_sch_wb.mrn_canonical_num),'.');
1283: p_bkd_demand_str := p_bkd_demand_str||order_sch_wb.delim||Rtrim(To_char(x_atp_period_string.bucketed_quantity(j),order_sch_wb.mrn_canonical_num),'.');
1284: p_net_atp_str := p_net_atp_str||order_sch_wb.delim||Rtrim(To_char(x_atp_period_string.period_quantity(j),order_sch_wb.mrn_canonical_num),'.');
1285:

Line 1282: p_demand_str := p_demand_str||order_sch_wb.delim||Rtrim(To_char(x_atp_period_string.total_demand_quantity(j),order_sch_wb.mrn_canonical_num),'.');

1278:
1279:
1280: FOR j IN 1..x_atp_period_string.total_supply_quantity.COUNT loop
1281: p_supply_str := p_supply_str||order_sch_wb.delim||Rtrim(To_char(x_atp_period_string.total_supply_quantity(j),order_sch_wb.mrn_canonical_num),'.');
1282: p_demand_str := p_demand_str||order_sch_wb.delim||Rtrim(To_char(x_atp_period_string.total_demand_quantity(j),order_sch_wb.mrn_canonical_num),'.');
1283: p_bkd_demand_str := p_bkd_demand_str||order_sch_wb.delim||Rtrim(To_char(x_atp_period_string.bucketed_quantity(j),order_sch_wb.mrn_canonical_num),'.');
1284: p_net_atp_str := p_net_atp_str||order_sch_wb.delim||Rtrim(To_char(x_atp_period_string.period_quantity(j),order_sch_wb.mrn_canonical_num),'.');
1285:
1286: if (p_dmd_flag = 0 ) AND (x_atp_period_string.cumulative_quantity(j) = 0) THEN

Line 1283: p_bkd_demand_str := p_bkd_demand_str||order_sch_wb.delim||Rtrim(To_char(x_atp_period_string.bucketed_quantity(j),order_sch_wb.mrn_canonical_num),'.');

1279:
1280: FOR j IN 1..x_atp_period_string.total_supply_quantity.COUNT loop
1281: p_supply_str := p_supply_str||order_sch_wb.delim||Rtrim(To_char(x_atp_period_string.total_supply_quantity(j),order_sch_wb.mrn_canonical_num),'.');
1282: p_demand_str := p_demand_str||order_sch_wb.delim||Rtrim(To_char(x_atp_period_string.total_demand_quantity(j),order_sch_wb.mrn_canonical_num),'.');
1283: p_bkd_demand_str := p_bkd_demand_str||order_sch_wb.delim||Rtrim(To_char(x_atp_period_string.bucketed_quantity(j),order_sch_wb.mrn_canonical_num),'.');
1284: p_net_atp_str := p_net_atp_str||order_sch_wb.delim||Rtrim(To_char(x_atp_period_string.period_quantity(j),order_sch_wb.mrn_canonical_num),'.');
1285:
1286: if (p_dmd_flag = 0 ) AND (x_atp_period_string.cumulative_quantity(j) = 0) THEN
1287: p_cum_atp_str := p_cum_atp_str||order_sch_wb.delim||Rtrim(To_char(l_old_cum,order_sch_wb.mrn_canonical_num),'.');

Line 1284: p_net_atp_str := p_net_atp_str||order_sch_wb.delim||Rtrim(To_char(x_atp_period_string.period_quantity(j),order_sch_wb.mrn_canonical_num),'.');

1280: FOR j IN 1..x_atp_period_string.total_supply_quantity.COUNT loop
1281: p_supply_str := p_supply_str||order_sch_wb.delim||Rtrim(To_char(x_atp_period_string.total_supply_quantity(j),order_sch_wb.mrn_canonical_num),'.');
1282: p_demand_str := p_demand_str||order_sch_wb.delim||Rtrim(To_char(x_atp_period_string.total_demand_quantity(j),order_sch_wb.mrn_canonical_num),'.');
1283: p_bkd_demand_str := p_bkd_demand_str||order_sch_wb.delim||Rtrim(To_char(x_atp_period_string.bucketed_quantity(j),order_sch_wb.mrn_canonical_num),'.');
1284: p_net_atp_str := p_net_atp_str||order_sch_wb.delim||Rtrim(To_char(x_atp_period_string.period_quantity(j),order_sch_wb.mrn_canonical_num),'.');
1285:
1286: if (p_dmd_flag = 0 ) AND (x_atp_period_string.cumulative_quantity(j) = 0) THEN
1287: p_cum_atp_str := p_cum_atp_str||order_sch_wb.delim||Rtrim(To_char(l_old_cum,order_sch_wb.mrn_canonical_num),'.');
1288: else

Line 1287: p_cum_atp_str := p_cum_atp_str||order_sch_wb.delim||Rtrim(To_char(l_old_cum,order_sch_wb.mrn_canonical_num),'.');

1283: p_bkd_demand_str := p_bkd_demand_str||order_sch_wb.delim||Rtrim(To_char(x_atp_period_string.bucketed_quantity(j),order_sch_wb.mrn_canonical_num),'.');
1284: p_net_atp_str := p_net_atp_str||order_sch_wb.delim||Rtrim(To_char(x_atp_period_string.period_quantity(j),order_sch_wb.mrn_canonical_num),'.');
1285:
1286: if (p_dmd_flag = 0 ) AND (x_atp_period_string.cumulative_quantity(j) = 0) THEN
1287: p_cum_atp_str := p_cum_atp_str||order_sch_wb.delim||Rtrim(To_char(l_old_cum,order_sch_wb.mrn_canonical_num),'.');
1288: else
1289: p_cum_atp_str := p_cum_atp_str||order_sch_wb.delim||Rtrim(To_char(x_atp_period_string.cumulative_quantity(j),order_sch_wb.mrn_canonical_num),'.');
1290: l_old_cum := x_atp_period_string.cumulative_quantity(j);
1291: end if;

Line 1289: p_cum_atp_str := p_cum_atp_str||order_sch_wb.delim||Rtrim(To_char(x_atp_period_string.cumulative_quantity(j),order_sch_wb.mrn_canonical_num),'.');

1285:
1286: if (p_dmd_flag = 0 ) AND (x_atp_period_string.cumulative_quantity(j) = 0) THEN
1287: p_cum_atp_str := p_cum_atp_str||order_sch_wb.delim||Rtrim(To_char(l_old_cum,order_sch_wb.mrn_canonical_num),'.');
1288: else
1289: p_cum_atp_str := p_cum_atp_str||order_sch_wb.delim||Rtrim(To_char(x_atp_period_string.cumulative_quantity(j),order_sch_wb.mrn_canonical_num),'.');
1290: l_old_cum := x_atp_period_string.cumulative_quantity(j);
1291: end if;
1292:
1293: p_date_str := p_date_str||order_sch_wb.delim||To_char(x_atp_period_string.period_start_date(j),order_sch_wb.MRD_CANONICAL_DATE);

Line 1293: p_date_str := p_date_str||order_sch_wb.delim||To_char(x_atp_period_string.period_start_date(j),order_sch_wb.MRD_CANONICAL_DATE);

1289: p_cum_atp_str := p_cum_atp_str||order_sch_wb.delim||Rtrim(To_char(x_atp_period_string.cumulative_quantity(j),order_sch_wb.mrn_canonical_num),'.');
1290: l_old_cum := x_atp_period_string.cumulative_quantity(j);
1291: end if;
1292:
1293: p_date_str := p_date_str||order_sch_wb.delim||To_char(x_atp_period_string.period_start_date(j),order_sch_wb.MRD_CANONICAL_DATE);
1294: -- dbms_output.put_line(x_atp_period_string.period_start_date(j));
1295: IF x_atp_period_string.period_start_date(j) <>
1296: x_atp_period_string.period_end_date(j) THEN
1297: day_gap := x_atp_period_string.period_end_date(j) -

Line 1300: p_supply_str := p_supply_str||order_sch_wb.delim||0;

1296: x_atp_period_string.period_end_date(j) THEN
1297: day_gap := x_atp_period_string.period_end_date(j) -
1298: x_atp_period_string.period_start_date(j);
1299: for i in 1..day_gap loop
1300: p_supply_str := p_supply_str||order_sch_wb.delim||0;
1301: p_demand_str := p_demand_str||order_sch_wb.delim||0;
1302: p_bkd_demand_str := p_bkd_demand_str||order_sch_wb.delim||0;
1303: p_net_atp_str := p_net_atp_str||order_sch_wb.delim||0;
1304: p_cum_atp_str := p_cum_atp_str||order_sch_wb.delim||Rtrim(To_char(l_old_cum,order_sch_wb.mrn_canonical_num),'.');

Line 1301: p_demand_str := p_demand_str||order_sch_wb.delim||0;

1297: day_gap := x_atp_period_string.period_end_date(j) -
1298: x_atp_period_string.period_start_date(j);
1299: for i in 1..day_gap loop
1300: p_supply_str := p_supply_str||order_sch_wb.delim||0;
1301: p_demand_str := p_demand_str||order_sch_wb.delim||0;
1302: p_bkd_demand_str := p_bkd_demand_str||order_sch_wb.delim||0;
1303: p_net_atp_str := p_net_atp_str||order_sch_wb.delim||0;
1304: p_cum_atp_str := p_cum_atp_str||order_sch_wb.delim||Rtrim(To_char(l_old_cum,order_sch_wb.mrn_canonical_num),'.');
1305: x_atp_period_string.period_start_date(j) := x_atp_period_string.period_start_date(j) + 1;

Line 1302: p_bkd_demand_str := p_bkd_demand_str||order_sch_wb.delim||0;

1298: x_atp_period_string.period_start_date(j);
1299: for i in 1..day_gap loop
1300: p_supply_str := p_supply_str||order_sch_wb.delim||0;
1301: p_demand_str := p_demand_str||order_sch_wb.delim||0;
1302: p_bkd_demand_str := p_bkd_demand_str||order_sch_wb.delim||0;
1303: p_net_atp_str := p_net_atp_str||order_sch_wb.delim||0;
1304: p_cum_atp_str := p_cum_atp_str||order_sch_wb.delim||Rtrim(To_char(l_old_cum,order_sch_wb.mrn_canonical_num),'.');
1305: x_atp_period_string.period_start_date(j) := x_atp_period_string.period_start_date(j) + 1;
1306: p_date_str := p_date_str||order_sch_wb.delim||To_char(x_atp_period_string.period_start_date(j),order_sch_wb.MRD_CANONICAL_DATE);

Line 1303: p_net_atp_str := p_net_atp_str||order_sch_wb.delim||0;

1299: for i in 1..day_gap loop
1300: p_supply_str := p_supply_str||order_sch_wb.delim||0;
1301: p_demand_str := p_demand_str||order_sch_wb.delim||0;
1302: p_bkd_demand_str := p_bkd_demand_str||order_sch_wb.delim||0;
1303: p_net_atp_str := p_net_atp_str||order_sch_wb.delim||0;
1304: p_cum_atp_str := p_cum_atp_str||order_sch_wb.delim||Rtrim(To_char(l_old_cum,order_sch_wb.mrn_canonical_num),'.');
1305: x_atp_period_string.period_start_date(j) := x_atp_period_string.period_start_date(j) + 1;
1306: p_date_str := p_date_str||order_sch_wb.delim||To_char(x_atp_period_string.period_start_date(j),order_sch_wb.MRD_CANONICAL_DATE);
1307: -- dbms_output.put_line('!! '||x_atp_period_string.period_start_date(j));

Line 1304: p_cum_atp_str := p_cum_atp_str||order_sch_wb.delim||Rtrim(To_char(l_old_cum,order_sch_wb.mrn_canonical_num),'.');

1300: p_supply_str := p_supply_str||order_sch_wb.delim||0;
1301: p_demand_str := p_demand_str||order_sch_wb.delim||0;
1302: p_bkd_demand_str := p_bkd_demand_str||order_sch_wb.delim||0;
1303: p_net_atp_str := p_net_atp_str||order_sch_wb.delim||0;
1304: p_cum_atp_str := p_cum_atp_str||order_sch_wb.delim||Rtrim(To_char(l_old_cum,order_sch_wb.mrn_canonical_num),'.');
1305: x_atp_period_string.period_start_date(j) := x_atp_period_string.period_start_date(j) + 1;
1306: p_date_str := p_date_str||order_sch_wb.delim||To_char(x_atp_period_string.period_start_date(j),order_sch_wb.MRD_CANONICAL_DATE);
1307: -- dbms_output.put_line('!! '||x_atp_period_string.period_start_date(j));
1308: END LOOP;

Line 1306: p_date_str := p_date_str||order_sch_wb.delim||To_char(x_atp_period_string.period_start_date(j),order_sch_wb.MRD_CANONICAL_DATE);

1302: p_bkd_demand_str := p_bkd_demand_str||order_sch_wb.delim||0;
1303: p_net_atp_str := p_net_atp_str||order_sch_wb.delim||0;
1304: p_cum_atp_str := p_cum_atp_str||order_sch_wb.delim||Rtrim(To_char(l_old_cum,order_sch_wb.mrn_canonical_num),'.');
1305: x_atp_period_string.period_start_date(j) := x_atp_period_string.period_start_date(j) + 1;
1306: p_date_str := p_date_str||order_sch_wb.delim||To_char(x_atp_period_string.period_start_date(j),order_sch_wb.MRD_CANONICAL_DATE);
1307: -- dbms_output.put_line('!! '||x_atp_period_string.period_start_date(j));
1308: END LOOP;
1309: END IF;
1310: END LOOP;

Line 1312: p_week_str := p_week_str||order_sch_wb.delim||To_char(v_week_start_date,order_sch_wb.mrd_canonical_date);

1308: END LOOP;
1309: END IF;
1310: END LOOP;
1311:
1312: p_week_str := p_week_str||order_sch_wb.delim||To_char(v_week_start_date,order_sch_wb.mrd_canonical_date);
1313: IF p_inst = 'SERVER' THEN
1314: open msc_wk_cur;
1315: LOOP
1316: fetch msc_wk_cur into v_wk_start_date;

Line 1318: p_week_str := p_week_str||order_sch_wb.delim||To_char(v_wk_start_date,order_sch_wb.MRD_CANONICAL_DATE);

1314: open msc_wk_cur;
1315: LOOP
1316: fetch msc_wk_cur into v_wk_start_date;
1317: EXIT WHEN msc_wk_cur%NOTFOUND;
1318: p_week_str := p_week_str||order_sch_wb.delim||To_char(v_wk_start_date,order_sch_wb.MRD_CANONICAL_DATE);
1319: end loop;
1320: close msc_wk_cur;
1321: ELSE
1322: open wk_cur;

Line 1326: p_week_str := p_week_str||order_sch_wb.delim||To_char(v_wk_start_date,order_sch_wb.MRD_CANONICAL_DATE);

1322: open wk_cur;
1323: LOOP
1324: fetch wk_cur into v_wk_start_date;
1325: EXIT WHEN wk_cur%NOTFOUND;
1326: p_week_str := p_week_str||order_sch_wb.delim||To_char(v_wk_start_date,order_sch_wb.MRD_CANONICAL_DATE);
1327: end loop;
1328: close wk_cur;
1329: END IF;
1330:

Line 1332: p_period_str := p_period_str||order_sch_wb.delim||To_char(v_period_start_date,order_sch_wb.MRD_CANONICAL_DATE);

1328: close wk_cur;
1329: END IF;
1330:
1331:
1332: p_period_str := p_period_str||order_sch_wb.delim||To_char(v_period_start_date,order_sch_wb.MRD_CANONICAL_DATE);
1333: IF p_inst = 'SERVER' THEN
1334: open msc_pr_cur;
1335: loop
1336: fetch msc_pr_cur into v_pr_start_date;

Line 1338: p_period_str := p_period_str||order_sch_wb.delim||To_char(v_pr_start_date,order_sch_wb.MRD_CANONICAL_DATE);

1334: open msc_pr_cur;
1335: loop
1336: fetch msc_pr_cur into v_pr_start_date;
1337: EXIT WHEN msc_pr_cur%NOTFOUND;
1338: p_period_str := p_period_str||order_sch_wb.delim||To_char(v_pr_start_date,order_sch_wb.MRD_CANONICAL_DATE);
1339: end loop;
1340: close msc_pr_cur;
1341: ELSE
1342: open pr_cur;

Line 1346: p_period_str := p_period_str||order_sch_wb.delim||To_char(v_pr_start_date,order_sch_wb.MRD_CANONICAL_DATE);

1342: open pr_cur;
1343: loop
1344: fetch pr_cur into v_pr_start_date;
1345: EXIT WHEN pr_cur%NOTFOUND;
1346: p_period_str := p_period_str||order_sch_wb.delim||To_char(v_pr_start_date,order_sch_wb.MRD_CANONICAL_DATE);
1347: end loop;
1348: close pr_cur;
1349: END IF;
1350: p_date_str := p_date_str||order_sch_wb.delim||'End';

Line 1350: p_date_str := p_date_str||order_sch_wb.delim||'End';

1346: p_period_str := p_period_str||order_sch_wb.delim||To_char(v_pr_start_date,order_sch_wb.MRD_CANONICAL_DATE);
1347: end loop;
1348: close pr_cur;
1349: END IF;
1350: p_date_str := p_date_str||order_sch_wb.delim||'End';
1351: p_week_str := p_week_str||order_sch_wb.delim||'End';
1352: p_period_str := p_period_str||order_sch_wb.delim||'End';
1353:
1354: IF NOT p_is_allocated THEN

Line 1351: p_week_str := p_week_str||order_sch_wb.delim||'End';

1347: end loop;
1348: close pr_cur;
1349: END IF;
1350: p_date_str := p_date_str||order_sch_wb.delim||'End';
1351: p_week_str := p_week_str||order_sch_wb.delim||'End';
1352: p_period_str := p_period_str||order_sch_wb.delim||'End';
1353:
1354: IF NOT p_is_allocated THEN
1355: p_row_hdr_str := p_row_hdr_str||order_sch_wb.delim||l_pivot_hdr

Line 1352: p_period_str := p_period_str||order_sch_wb.delim||'End';

1348: close pr_cur;
1349: END IF;
1350: p_date_str := p_date_str||order_sch_wb.delim||'End';
1351: p_week_str := p_week_str||order_sch_wb.delim||'End';
1352: p_period_str := p_period_str||order_sch_wb.delim||'End';
1353:
1354: IF NOT p_is_allocated THEN
1355: p_row_hdr_str := p_row_hdr_str||order_sch_wb.delim||l_pivot_hdr
1356: ||order_sch_wb.delim||owb_tree.lookups(13)||order_sch_wb.delim||

Line 1355: p_row_hdr_str := p_row_hdr_str||order_sch_wb.delim||l_pivot_hdr

1351: p_week_str := p_week_str||order_sch_wb.delim||'End';
1352: p_period_str := p_period_str||order_sch_wb.delim||'End';
1353:
1354: IF NOT p_is_allocated THEN
1355: p_row_hdr_str := p_row_hdr_str||order_sch_wb.delim||l_pivot_hdr
1356: ||order_sch_wb.delim||owb_tree.lookups(13)||order_sch_wb.delim||
1357: owb_tree.lookups(14)||order_sch_wb.delim||owb_tree.lookups(27)||order_sch_wb.delim||owb_tree.lookups(15)||order_sch_wb.delim||
1358: owb_tree.lookups(16)||order_sch_wb.delim||'End';
1359: ELSE

Line 1356: ||order_sch_wb.delim||owb_tree.lookups(13)||order_sch_wb.delim||

1352: p_period_str := p_period_str||order_sch_wb.delim||'End';
1353:
1354: IF NOT p_is_allocated THEN
1355: p_row_hdr_str := p_row_hdr_str||order_sch_wb.delim||l_pivot_hdr
1356: ||order_sch_wb.delim||owb_tree.lookups(13)||order_sch_wb.delim||
1357: owb_tree.lookups(14)||order_sch_wb.delim||owb_tree.lookups(27)||order_sch_wb.delim||owb_tree.lookups(15)||order_sch_wb.delim||
1358: owb_tree.lookups(16)||order_sch_wb.delim||'End';
1359: ELSE
1360: IF p_pegging_id is null THEN

Line 1357: owb_tree.lookups(14)||order_sch_wb.delim||owb_tree.lookups(27)||order_sch_wb.delim||owb_tree.lookups(15)||order_sch_wb.delim||

1353:
1354: IF NOT p_is_allocated THEN
1355: p_row_hdr_str := p_row_hdr_str||order_sch_wb.delim||l_pivot_hdr
1356: ||order_sch_wb.delim||owb_tree.lookups(13)||order_sch_wb.delim||
1357: owb_tree.lookups(14)||order_sch_wb.delim||owb_tree.lookups(27)||order_sch_wb.delim||owb_tree.lookups(15)||order_sch_wb.delim||
1358: owb_tree.lookups(16)||order_sch_wb.delim||'End';
1359: ELSE
1360: IF p_pegging_id is null THEN
1361: p_row_hdr_str:= owb_tree.lookups(6)||order_sch_wb.delim;

Line 1358: owb_tree.lookups(16)||order_sch_wb.delim||'End';

1354: IF NOT p_is_allocated THEN
1355: p_row_hdr_str := p_row_hdr_str||order_sch_wb.delim||l_pivot_hdr
1356: ||order_sch_wb.delim||owb_tree.lookups(13)||order_sch_wb.delim||
1357: owb_tree.lookups(14)||order_sch_wb.delim||owb_tree.lookups(27)||order_sch_wb.delim||owb_tree.lookups(15)||order_sch_wb.delim||
1358: owb_tree.lookups(16)||order_sch_wb.delim||'End';
1359: ELSE
1360: IF p_pegging_id is null THEN
1361: p_row_hdr_str:= owb_tree.lookups(6)||order_sch_wb.delim;
1362: ELSE

Line 1361: p_row_hdr_str:= owb_tree.lookups(6)||order_sch_wb.delim;

1357: owb_tree.lookups(14)||order_sch_wb.delim||owb_tree.lookups(27)||order_sch_wb.delim||owb_tree.lookups(15)||order_sch_wb.delim||
1358: owb_tree.lookups(16)||order_sch_wb.delim||'End';
1359: ELSE
1360: IF p_pegging_id is null THEN
1361: p_row_hdr_str:= owb_tree.lookups(6)||order_sch_wb.delim;
1362: ELSE
1363: p_row_hdr_str:= owb_tree.lookups(5)||order_sch_wb.delim;
1364: END IF;
1365: p_row_hdr_str := p_row_hdr_str||

Line 1363: p_row_hdr_str:= owb_tree.lookups(5)||order_sch_wb.delim;

1359: ELSE
1360: IF p_pegging_id is null THEN
1361: p_row_hdr_str:= owb_tree.lookups(6)||order_sch_wb.delim;
1362: ELSE
1363: p_row_hdr_str:= owb_tree.lookups(5)||order_sch_wb.delim;
1364: END IF;
1365: p_row_hdr_str := p_row_hdr_str||
1366: owb_tree.lookups(13)||order_sch_wb.delim||
1367: owb_tree.lookups(14)||order_sch_wb.delim||owb_tree.lookups(27)||order_sch_wb.delim||

Line 1366: owb_tree.lookups(13)||order_sch_wb.delim||

1362: ELSE
1363: p_row_hdr_str:= owb_tree.lookups(5)||order_sch_wb.delim;
1364: END IF;
1365: p_row_hdr_str := p_row_hdr_str||
1366: owb_tree.lookups(13)||order_sch_wb.delim||
1367: owb_tree.lookups(14)||order_sch_wb.delim||owb_tree.lookups(27)||order_sch_wb.delim||
1368: owb_tree.lookups(15)||order_sch_wb.delim||
1369: owb_tree.lookups(16)||order_sch_wb.delim||'End';
1370: END IF;

Line 1367: owb_tree.lookups(14)||order_sch_wb.delim||owb_tree.lookups(27)||order_sch_wb.delim||

1363: p_row_hdr_str:= owb_tree.lookups(5)||order_sch_wb.delim;
1364: END IF;
1365: p_row_hdr_str := p_row_hdr_str||
1366: owb_tree.lookups(13)||order_sch_wb.delim||
1367: owb_tree.lookups(14)||order_sch_wb.delim||owb_tree.lookups(27)||order_sch_wb.delim||
1368: owb_tree.lookups(15)||order_sch_wb.delim||
1369: owb_tree.lookups(16)||order_sch_wb.delim||'End';
1370: END IF;
1371:

Line 1368: owb_tree.lookups(15)||order_sch_wb.delim||

1364: END IF;
1365: p_row_hdr_str := p_row_hdr_str||
1366: owb_tree.lookups(13)||order_sch_wb.delim||
1367: owb_tree.lookups(14)||order_sch_wb.delim||owb_tree.lookups(27)||order_sch_wb.delim||
1368: owb_tree.lookups(15)||order_sch_wb.delim||
1369: owb_tree.lookups(16)||order_sch_wb.delim||'End';
1370: END IF;
1371:
1372: p_supply_str := p_supply_str||order_sch_wb.delim||'End';

Line 1369: owb_tree.lookups(16)||order_sch_wb.delim||'End';

1365: p_row_hdr_str := p_row_hdr_str||
1366: owb_tree.lookups(13)||order_sch_wb.delim||
1367: owb_tree.lookups(14)||order_sch_wb.delim||owb_tree.lookups(27)||order_sch_wb.delim||
1368: owb_tree.lookups(15)||order_sch_wb.delim||
1369: owb_tree.lookups(16)||order_sch_wb.delim||'End';
1370: END IF;
1371:
1372: p_supply_str := p_supply_str||order_sch_wb.delim||'End';
1373: p_demand_str := p_demand_str||order_sch_wb.delim||'End';

Line 1372: p_supply_str := p_supply_str||order_sch_wb.delim||'End';

1368: owb_tree.lookups(15)||order_sch_wb.delim||
1369: owb_tree.lookups(16)||order_sch_wb.delim||'End';
1370: END IF;
1371:
1372: p_supply_str := p_supply_str||order_sch_wb.delim||'End';
1373: p_demand_str := p_demand_str||order_sch_wb.delim||'End';
1374: p_bkd_demand_str := p_bkd_demand_str||order_sch_wb.delim||'End';
1375: p_net_atp_str := p_net_atp_str||order_sch_wb.delim||'End';
1376: p_cum_atp_str := p_cum_atp_str||order_sch_wb.delim||'End';

Line 1373: p_demand_str := p_demand_str||order_sch_wb.delim||'End';

1369: owb_tree.lookups(16)||order_sch_wb.delim||'End';
1370: END IF;
1371:
1372: p_supply_str := p_supply_str||order_sch_wb.delim||'End';
1373: p_demand_str := p_demand_str||order_sch_wb.delim||'End';
1374: p_bkd_demand_str := p_bkd_demand_str||order_sch_wb.delim||'End';
1375: p_net_atp_str := p_net_atp_str||order_sch_wb.delim||'End';
1376: p_cum_atp_str := p_cum_atp_str||order_sch_wb.delim||'End';
1377: END IF;

Line 1374: p_bkd_demand_str := p_bkd_demand_str||order_sch_wb.delim||'End';

1370: END IF;
1371:
1372: p_supply_str := p_supply_str||order_sch_wb.delim||'End';
1373: p_demand_str := p_demand_str||order_sch_wb.delim||'End';
1374: p_bkd_demand_str := p_bkd_demand_str||order_sch_wb.delim||'End';
1375: p_net_atp_str := p_net_atp_str||order_sch_wb.delim||'End';
1376: p_cum_atp_str := p_cum_atp_str||order_sch_wb.delim||'End';
1377: END IF;
1378: EXCEPTION

Line 1375: p_net_atp_str := p_net_atp_str||order_sch_wb.delim||'End';

1371:
1372: p_supply_str := p_supply_str||order_sch_wb.delim||'End';
1373: p_demand_str := p_demand_str||order_sch_wb.delim||'End';
1374: p_bkd_demand_str := p_bkd_demand_str||order_sch_wb.delim||'End';
1375: p_net_atp_str := p_net_atp_str||order_sch_wb.delim||'End';
1376: p_cum_atp_str := p_cum_atp_str||order_sch_wb.delim||'End';
1377: END IF;
1378: EXCEPTION
1379: WHEN OTHERS THEN

Line 1376: p_cum_atp_str := p_cum_atp_str||order_sch_wb.delim||'End';

1372: p_supply_str := p_supply_str||order_sch_wb.delim||'End';
1373: p_demand_str := p_demand_str||order_sch_wb.delim||'End';
1374: p_bkd_demand_str := p_bkd_demand_str||order_sch_wb.delim||'End';
1375: p_net_atp_str := p_net_atp_str||order_sch_wb.delim||'End';
1376: p_cum_atp_str := p_cum_atp_str||order_sch_wb.delim||'End';
1377: END IF;
1378: EXCEPTION
1379: WHEN OTHERS THEN
1380: IF PG_DEBUG in ('Y', 'C') THEN

Line 1502: where CHART_OF_ACCOUNTS_ID = order_sch_wb.PARAMETER_CHART_OF_ACCOUNTS_ID

1498: elsif supply_demand_source_type = 3 THEN
1499: SELECT CONCATENATED_SEGMENTS
1500: INTO supply_demand_source_name
1501: FROM gl_code_combinations_kfv
1502: where CHART_OF_ACCOUNTS_ID = order_sch_wb.PARAMETER_CHART_OF_ACCOUNTS_ID
1503: and CODE_COMBINATION_ID = supply_demand_source_id;
1504: elsif (supply_demand_source_type = 4) or (supply_demand_source_type = 5) then
1505: SELECT WIP_ENTITY_NAME
1506: INTO supply_demand_source_name

Line 1537: supply_demand_source_name := order_sch_wb.form_field_C_COLUMN1;

1533: NULL;
1534: -- If it is resource supply, there is no identifier
1535: -- :SD_DETAIL.sd_type := :PARAMETER.resource_supply;
1536: elsif supply_demand_source_type is not null THEN
1537: supply_demand_source_name := order_sch_wb.form_field_C_COLUMN1;
1538: end if;
1539:
1540: RETURN supply_demand_source_name;
1541:

Line 1660: order_sch_wb.mr_debug := NVL(fnd_profile.value('MSC_ATP_DEBUG'),'N');

1656:
1657: PROCEDURE set_session_id(p_session_id IN NUMBER)
1658: IS
1659: BEGIN
1660: order_sch_wb.mr_debug := NVL(fnd_profile.value('MSC_ATP_DEBUG'),'N');
1661: order_sch_wb.debug_session_id := p_session_id;
1662: MSC_ATP_PVT.G_SESSION_ID := p_session_id;
1663:
1664: END set_session_id;

Line 1661: order_sch_wb.debug_session_id := p_session_id;

1657: PROCEDURE set_session_id(p_session_id IN NUMBER)
1658: IS
1659: BEGIN
1660: order_sch_wb.mr_debug := NVL(fnd_profile.value('MSC_ATP_DEBUG'),'N');
1661: order_sch_wb.debug_session_id := p_session_id;
1662: MSC_ATP_PVT.G_SESSION_ID := p_session_id;
1663:
1664: END set_session_id;
1665:

Line 1666: PROCEDURE extend_other_cols(x_other_cols IN OUT NoCopy order_sch_wb.other_cols_typ, amount NUMBER)

1662: MSC_ATP_PVT.G_SESSION_ID := p_session_id;
1663:
1664: END set_session_id;
1665:
1666: PROCEDURE extend_other_cols(x_other_cols IN OUT NoCopy order_sch_wb.other_cols_typ, amount NUMBER)
1667: IS
1668: BEGIN
1669: x_other_cols.row_index.extend(amount);
1670: x_other_cols.org_code.extend(amount);