APPS.WSH_TRIPS_ACTIONS dependencies on WSH_TMP

Line 1868: -- will get their value from wsh_tmp table which has varchar2 columns

1864: j NUMBER;
1865: l_fte_flag VARCHAR2(2) := 'N';
1866:
1867: -- the following 5 variables are defined as varchar2(30) since they
1868: -- will get their value from wsh_tmp table which has varchar2 columns
1869:
1870: l_pickup_location_id VARCHAR2(30);
1871: l_dropoff_location_id VARCHAR2(30);
1872: l_MODE_OF_TRANSPORT VARCHAR2(30);

Line 2019: FROM WSH_TMP

2015: column2,
2016: column3,
2017: column4,
2018: column5
2019: FROM WSH_TMP
2020: WHERE flag = '~'
2021: order by column1, column2, column3, column4, column5;
2022:
2023: e_invalid_count EXCEPTION;

Line 2046: DELETE FROM wsh_tmp where flag = '~';

2042: IF p_del_tbl.delivery_id.COUNT < 1 THEN
2043: RAISE e_invalid_count;
2044: END IF;
2045:
2046: DELETE FROM wsh_tmp where flag = '~';
2047:
2048:
2049: FORALL i IN 1..p_del_tbl.delivery_id.count
2050: INSERT INTO wsh_tmp (id,

Line 2050: INSERT INTO wsh_tmp (id,

2046: DELETE FROM wsh_tmp where flag = '~';
2047:
2048:
2049: FORALL i IN 1..p_del_tbl.delivery_id.count
2050: INSERT INTO wsh_tmp (id,
2051: flag,
2052: column1,
2053: column2,
2054: column3,