DBA Data[Home] [Help]

APPS.JTF_AMV_ATTACHMENT_PUB dependencies on FND_GLOBAL

Line 476: FND_GLOBAL.user_id,

472: )
473: VALUES (
474: l_act_attachment_rec.attachment_id,
475: SYSDATE,
476: FND_GLOBAL.user_id,
477: SYSDATE,
478: FND_GLOBAL.user_id,
479: FND_GLOBAL.conc_login_id,
480: 1, -- object_version_number

Line 478: FND_GLOBAL.user_id,

474: l_act_attachment_rec.attachment_id,
475: SYSDATE,
476: FND_GLOBAL.user_id,
477: SYSDATE,
478: FND_GLOBAL.user_id,
479: FND_GLOBAL.conc_login_id,
480: 1, -- object_version_number
481: l_act_attachment_rec.owner_user_id,
482: l_act_attachment_rec.attachment_used_by_id,

Line 479: FND_GLOBAL.conc_login_id,

475: SYSDATE,
476: FND_GLOBAL.user_id,
477: SYSDATE,
478: FND_GLOBAL.user_id,
479: FND_GLOBAL.conc_login_id,
480: 1, -- object_version_number
481: l_act_attachment_rec.owner_user_id,
482: l_act_attachment_rec.attachment_used_by_id,
483: l_act_attachment_rec.attachment_used_by,

Line 530: last_updated_by = FND_GLOBAL.user_id,

526: );
527: IF (l_act_attachment_rec.attachment_used_by = G_USED_BY_ITEM) THEN
528: update jtf_amv_items_b
529: set last_update_date = sysdate,
530: last_updated_by = FND_GLOBAL.user_id,
531: last_update_login = FND_GLOBAL.conc_login_id
532: where item_id = l_act_attachment_rec.attachment_used_by_id ;
533: END IF;
534: ------------------------- finish -------------------------------

Line 531: last_update_login = FND_GLOBAL.conc_login_id

527: IF (l_act_attachment_rec.attachment_used_by = G_USED_BY_ITEM) THEN
528: update jtf_amv_items_b
529: set last_update_date = sysdate,
530: last_updated_by = FND_GLOBAL.user_id,
531: last_update_login = FND_GLOBAL.conc_login_id
532: where item_id = l_act_attachment_rec.attachment_used_by_id ;
533: END IF;
534: ------------------------- finish -------------------------------
535: x_act_attachment_id := l_act_attachment_rec.attachment_id;

Line 791: last_updated_by = FND_GLOBAL.user_id,

787: END IF;
788: -------------------------- update --------------------
789: UPDATE jtf_amv_attachments SET
790: last_update_date = SYSDATE,
791: last_updated_by = FND_GLOBAL.user_id,
792: last_update_login = FND_GLOBAL.conc_login_id,
793: object_version_number = l_act_attachment_rec.object_version_number + 1,
794: owner_user_id = l_act_attachment_rec.owner_user_id,
795: attachment_used_by_id = l_act_attachment_rec.attachment_used_by_id,

Line 792: last_update_login = FND_GLOBAL.conc_login_id,

788: -------------------------- update --------------------
789: UPDATE jtf_amv_attachments SET
790: last_update_date = SYSDATE,
791: last_updated_by = FND_GLOBAL.user_id,
792: last_update_login = FND_GLOBAL.conc_login_id,
793: object_version_number = l_act_attachment_rec.object_version_number + 1,
794: owner_user_id = l_act_attachment_rec.owner_user_id,
795: attachment_used_by_id = l_act_attachment_rec.attachment_used_by_id,
796: attachment_used_by = l_act_attachment_rec.attachment_used_by,

Line 854: last_updated_by = FND_GLOBAL.user_id,

850:
851: IF (l_act_attachment_rec.attachment_used_by = G_USED_BY_ITEM) THEN
852: update jtf_amv_items_b
853: set last_update_date = sysdate,
854: last_updated_by = FND_GLOBAL.user_id,
855: last_update_login = FND_GLOBAL.conc_login_id
856: where item_id = l_act_attachment_rec.attachment_used_by_id;
857: END IF;
858: -------------------- finish --------------------------

Line 855: last_update_login = FND_GLOBAL.conc_login_id

851: IF (l_act_attachment_rec.attachment_used_by = G_USED_BY_ITEM) THEN
852: update jtf_amv_items_b
853: set last_update_date = sysdate,
854: last_updated_by = FND_GLOBAL.user_id,
855: last_update_login = FND_GLOBAL.conc_login_id
856: where item_id = l_act_attachment_rec.attachment_used_by_id;
857: END IF;
858: -------------------- finish --------------------------
859: IF FND_API.to_boolean(p_commit) THEN