APPS.FTE_TRACKING_WRAPPER dependencies on FTE_MESSAGE_LOCATION

Line 441: INSERT INTO FTE_MESSAGE_LOCATION (

437: END ;
438:
439:
440: BEGIN
441: INSERT INTO FTE_MESSAGE_LOCATION (
442: location_to_id,
443: ID ,
444: DESCRIPTION ,
445: GEOCOORDINATES ,

Line 493: FTE_MESSAGE_LOCATION

489: LAST_UPDATE_LOGIN ,
490: l_transaction_id_s ,
491: LOCATION_TO_TABLE
492: from
493: FTE_MESSAGE_LOCATION
494: where transaction_id = p_transaction_id;
495: EXCEPTION
496: WHEN OTHERS THEN
497: null;

Line 552: (select id from fte_message_location where

548: LAST_UPDATE_LOGIN )
549: SELECT
550: decode (ADDRESS_TO_TABLE,'FTE_MESSAGE_PARTNER',
551: l_address_to_id,
552: (select id from fte_message_location where
553: location_to_table =( SELECT fl.location_to_table
554: FROM fte_message_location fl WHERE fl.id= fa.address_to_id
555: AND transaction_id = p_transaction_id ) and
556: transaction_id = l_transaction_id_s

Line 554: FROM fte_message_location fl WHERE fl.id= fa.address_to_id

550: decode (ADDRESS_TO_TABLE,'FTE_MESSAGE_PARTNER',
551: l_address_to_id,
552: (select id from fte_message_location where
553: location_to_table =( SELECT fl.location_to_table
554: FROM fte_message_location fl WHERE fl.id= fa.address_to_id
555: AND transaction_id = p_transaction_id ) and
556: transaction_id = l_transaction_id_s
557: )
558: ),

Line 835: -- key for fte_message_location .

831: --
832: -- COMMENT : Get the city,state and country information from the
833: -- fte_message_address and populate the location cloumn of
834: -- fte_delivery_proof table using address_to_id as the foreign
835: -- key for fte_message_location .
836: --========================================================================
837:
838: FUNCTION GET_LOCATION(p_location_id IN NUMBER)
839: RETURN VARCHAR2

Line 1052: FROM fte_message_location

1048:
1049: BEGIN
1050: --Get the location inforamtion for the POD from the fte_message_address for the location id
1051: SELECT id INTO l_location_id
1052: FROM fte_message_location
1053: WHERE transaction_id=p_transaction_id
1054: and location_to_table = 'FTE_DELIVERY_PROOF';
1055: l_address:=get_location(l_location_id);
1056:

Line 1144: from fte_message_location

1140:
1141: BEGIN
1142: --Get the location inforamtion for the POD from the fte_message_address for the location id
1143: select id into l_location_id
1144: from fte_message_location
1145: where transaction_id=p_transaction_id
1146: and location_to_table = 'FTE_DELIVERY_PROOF';
1147:
1148: l_address :=GET_LOCATION(l_location_id);

Line 1234: from fte_message_location

1230: --Get the location inforamtion for the POD from the fte_message_address for the location id
1231:
1232: BEGIN
1233: select id into l_location_id
1234: from fte_message_location
1235: where transaction_id=p_transaction_id
1236: and location_to_table = 'FTE_DELIVERY_PROOF';
1237:
1238: l_address :=GET_LOCATION(l_location_id);

Line 1484: from fte_message_location

1480: --Get the location inforamtion for the POD from the fte_message_address for the location id
1481:
1482: BEGIN
1483: select id into l_location_id
1484: from fte_message_location
1485: where transaction_id=p_transaction_id
1486: and location_to_table = 'FTE_DELIVERY_PROOF';
1487:
1488: l_address :=GET_LOCATION(l_location_id);