APPS.FTE_TENDER_PVT dependencies on FTE_TENDER_SNAPSHOT

Line 1354: SELECT count(*) INTO l_temp_id FROM FTE_TENDER_SNAPSHOT

1350: x_msg_data := 0;
1351:
1352:
1353: -- first delete snapshot then create
1354: SELECT count(*) INTO l_temp_id FROM FTE_TENDER_SNAPSHOT
1355: WHERE load_tender_number = p_tender_id and rownum = 1;
1356:
1357: IF (l_temp_id > 0) THEN
1358: DELETE FROM FTE_TENDER_SNAPSHOT

Line 1358: DELETE FROM FTE_TENDER_SNAPSHOT

1354: SELECT count(*) INTO l_temp_id FROM FTE_TENDER_SNAPSHOT
1355: WHERE load_tender_number = p_tender_id and rownum = 1;
1356:
1357: IF (l_temp_id > 0) THEN
1358: DELETE FROM FTE_TENDER_SNAPSHOT
1359: WHERE LOAD_TENDER_NUMBER = p_tender_id;
1360: END IF;
1361:
1362: -- Standard call to get message count and if count is 1,get message info.

Line 1481: INSERT INTO FTE_TENDER_SNAPSHOT(

1477: x_msg_data := 0;
1478:
1479: IF(p_action = 'CREATE')
1480: THEN
1481: INSERT INTO FTE_TENDER_SNAPSHOT(
1482: LOAD_TENDER_NUMBER,
1483: TRIP_ID,
1484: STOP_ID,
1485: TOTAL_WEIGHT,

Line 1511: UPDATE FTE_TENDER_SNAPSHOT SET

1507: FND_GLOBAL.LOGIN_ID,
1508: p_session_value);
1509: ELSIF (p_action = 'UPDATE') THEN
1510:
1511: UPDATE FTE_TENDER_SNAPSHOT SET
1512: TOTAL_WEIGHT = decode(p_total_weight,
1513: NULL,total_weight,
1514: FND_API.G_MISS_NUM,NULL,
1515: p_total_weight),

Line 1539: DELETE FTE_TENDER_SNAPSHOT

1535: WHERE TRIP_ID = p_trip_id
1536: AND STOP_ID = p_stop_id
1537: AND LOAD_TENDER_NUMBER = p_tender_id;
1538: ELSIF (p_action = 'DELETE') THEN
1539: DELETE FTE_TENDER_SNAPSHOT
1540: WHERE LOAD_TENDER_NUMBER = p_tender_id;
1541: END IF;
1542:
1543:

Line 1856: from fte_tender_snapshot

1852: ---
1853: cursor get_snapshot_cur(c_trip_id NUMBER, c_stop_id NUMBER) is
1854: select trip_id, stop_id, load_tender_number,session_value,
1855: total_weight,total_volume,weight_uom,volume_uom
1856: from fte_tender_snapshot
1857: where trip_id = c_trip_id
1858: and stop_id = c_stop_id;
1859: ---
1860: cursor get_tender_number_cur(c_trip_id NUMBER) is

Line 1869: from fte_tender_snapshot

1865: --
1866: cursor get_snapshot_session_cur(c_trip_id NUMBER, c_tender_number NUMBER,
1867: c_session_value VARCHAR2) is
1868: select session_value
1869: from fte_tender_snapshot
1870: where trip_id = c_trip_id
1871: and load_tender_number = c_tender_number
1872: and session_value = c_session_value;
1873: