APPS.WSH_TRIPS_ACTIONS dependencies on WSH_TMP

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

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

Line 2017: FROM WSH_TMP

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

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

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

Line 2048: INSERT INTO wsh_tmp (id,

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