DBA Data[Home] [Help]

APPS.PAY_ARCHIVE_UTILS dependencies on FF_ROUTE_PARAMETER_VALUES

Line 548: from ff_route_parameter_values

544: begin
545:
546: select route_parameter_id
547: into l_dummy_id
548: from ff_route_parameter_values
549: where route_parameter_id = l_route_parameter_id
550: and user_entity_id = l_user_entity_seq;
551:
552: update ff_route_parameter_values

Line 552: update ff_route_parameter_values

548: from ff_route_parameter_values
549: where route_parameter_id = l_route_parameter_id
550: and user_entity_id = l_user_entity_seq;
551:
552: update ff_route_parameter_values
553: set value = l_user_entity_seq
554: where route_parameter_id = l_route_parameter_id
555: and user_entity_id = l_user_entity_seq;
556:

Line 561: insert into ff_route_parameter_values

557: exception when no_data_found then
558: --
559: -- route parameter does not exist so cause insert
560: --
561: insert into ff_route_parameter_values
562: (
563: route_parameter_id,
564: user_entity_id,
565: value,

Line 638: insert into ff_route_parameter_values

634: 0, /* created_by */
635: sysdate /* creation_date */
636: );
637:
638: insert into ff_route_parameter_values
639: (
640: route_parameter_id,
641: user_entity_id,
642: value,

Line 810: insert into ff_route_parameter_values

806: 0,
807: sysdate
808: );
809: --
810: insert into ff_route_parameter_values
811: (
812: route_parameter_id,
813: user_entity_id,
814: value,