APPS.FND_APP_SYSTEM dependencies on FND_SIDS

Line 558: l_rec fnd_sids%rowtype;

554: procedure register_sid ( Sid varchar2,
555: sid_guid raw
556: )
557: as
558: l_rec fnd_sids%rowtype;
559: l_insert boolean := false;
560: begin
561:
562: l_rec.sid := Sid;

Line 575: from fnd_sids a

571: begin
572:
573: select a.sid_guid
574: into l_rec.sid_guid
575: from fnd_sids a
576: where a.sid_guid = l_rec.sid_guid;
577:
578: exception
579: when no_data_found then

Line 588: insert into fnd_sids

584:
585: if ( l_insert )
586: then
587:
588: insert into fnd_sids
589: (sid_guid,Sid,
590: last_updated_by,last_update_date,last_update_login,
591: creation_date,created_by
592: )

Line 597: update fnd_sids a

593: values ( l_rec.sid_guid,l_rec.sid,
594: 1,sysdate,0,sysdate,1 );
595: else
596:
597: update fnd_sids a
598: set a.sid = nvl(l_rec.sid,a.sid),
599: a.last_update_date = SYSDATE,
600: a.last_updated_by = 1
601: where a.sid_guid = l_rec.sid_guid;