DBA Data[Home] [Help]

APPS.JTF_IH_IMPORT dependencies on FND_GLOBAL

Line 511: fnd_global.resp_appl_id,

507: END IF;
508: JTF_IH_PUB.Create_MediaItem(1.0,
509: 'T',
510: 'F',
511: fnd_global.resp_appl_id,
512: fnd_global.resp_id,
513: fnd_global.user_id,
514: fnd_global.login_id,
515: l_return_status,

Line 512: fnd_global.resp_id,

508: JTF_IH_PUB.Create_MediaItem(1.0,
509: 'T',
510: 'F',
511: fnd_global.resp_appl_id,
512: fnd_global.resp_id,
513: fnd_global.user_id,
514: fnd_global.login_id,
515: l_return_status,
516: l_msg_count,

Line 513: fnd_global.user_id,

509: 'T',
510: 'F',
511: fnd_global.resp_appl_id,
512: fnd_global.resp_id,
513: fnd_global.user_id,
514: fnd_global.login_id,
515: l_return_status,
516: l_msg_count,
517: l_msg_data,

Line 514: fnd_global.login_id,

510: 'F',
511: fnd_global.resp_appl_id,
512: fnd_global.resp_id,
513: fnd_global.user_id,
514: fnd_global.login_id,
515: l_return_status,
516: l_msg_count,
517: l_msg_data,
518: l_media_item_stg_rec,

Line 581: fnd_global.resp_appl_id,

577: bInteractionError := FALSE;
578: JTF_IH_PUB.Open_Interaction(1.0,
579: 'T',
580: 'F',
581: fnd_global.resp_appl_id,
582: fnd_global.resp_id,
583: fnd_global.user_id,
584: fnd_global.login_id,
585: l_return_status,

Line 582: fnd_global.resp_id,

578: JTF_IH_PUB.Open_Interaction(1.0,
579: 'T',
580: 'F',
581: fnd_global.resp_appl_id,
582: fnd_global.resp_id,
583: fnd_global.user_id,
584: fnd_global.login_id,
585: l_return_status,
586: l_msg_count,

Line 583: fnd_global.user_id,

579: 'T',
580: 'F',
581: fnd_global.resp_appl_id,
582: fnd_global.resp_id,
583: fnd_global.user_id,
584: fnd_global.login_id,
585: l_return_status,
586: l_msg_count,
587: l_msg_data,

Line 584: fnd_global.login_id,

580: 'F',
581: fnd_global.resp_appl_id,
582: fnd_global.resp_id,
583: fnd_global.user_id,
584: fnd_global.login_id,
585: l_return_status,
586: l_msg_count,
587: l_msg_data,
588: l_interaction_rec,

Line 607: fnd_global.resp_appl_id,

603: l_activity_rec.Interaction_Id := l_interaction_id;
604: JTF_IH_PUB.Add_Activity(1.0,
605: 'T',
606: 'F',
607: fnd_global.resp_appl_id,
608: fnd_global.resp_id,
609: fnd_global.user_id,
610: fnd_global.login_id,
611: l_return_status,

Line 608: fnd_global.resp_id,

604: JTF_IH_PUB.Add_Activity(1.0,
605: 'T',
606: 'F',
607: fnd_global.resp_appl_id,
608: fnd_global.resp_id,
609: fnd_global.user_id,
610: fnd_global.login_id,
611: l_return_status,
612: l_msg_count,

Line 609: fnd_global.user_id,

605: 'T',
606: 'F',
607: fnd_global.resp_appl_id,
608: fnd_global.resp_id,
609: fnd_global.user_id,
610: fnd_global.login_id,
611: l_return_status,
612: l_msg_count,
613: l_msg_data,

Line 610: fnd_global.login_id,

606: 'F',
607: fnd_global.resp_appl_id,
608: fnd_global.resp_id,
609: fnd_global.user_id,
610: fnd_global.login_id,
611: l_return_status,
612: l_msg_count,
613: l_msg_data,
614: l_activity_rec,

Line 636: fnd_global.resp_appl_id,

632: l_interaction_rec.Interaction_ID := l_interaction_id;
633: JTF_IH_PUB.Close_Interaction( 1.0,
634: 'T',
635: 'F',
636: fnd_global.resp_appl_id,
637: fnd_global.resp_id,
638: fnd_global.user_id,
639: fnd_global.login_id,
640: l_return_status,

Line 637: fnd_global.resp_id,

633: JTF_IH_PUB.Close_Interaction( 1.0,
634: 'T',
635: 'F',
636: fnd_global.resp_appl_id,
637: fnd_global.resp_id,
638: fnd_global.user_id,
639: fnd_global.login_id,
640: l_return_status,
641: l_msg_count,

Line 638: fnd_global.user_id,

634: 'T',
635: 'F',
636: fnd_global.resp_appl_id,
637: fnd_global.resp_id,
638: fnd_global.user_id,
639: fnd_global.login_id,
640: l_return_status,
641: l_msg_count,
642: l_msg_data,

Line 639: fnd_global.login_id,

635: 'F',
636: fnd_global.resp_appl_id,
637: fnd_global.resp_id,
638: fnd_global.user_id,
639: fnd_global.login_id,
640: l_return_status,
641: l_msg_count,
642: l_msg_data,
643: l_interaction_rec);

Line 813: NVL(created_by, fnd_global.user_id),

809: SELECT
810: interaction_id,
811: object_version_number,
812: NVL(creation_date, SYSDATE),
813: NVL(created_by, fnd_global.user_id),
814: NVL(last_update_date, SYSDATE),
815: NVL(last_updated_by,fnd_global.user_id),
816: NVL(last_update_login,fnd_global.login_id),
817: interaction_inters_id,

Line 815: NVL(last_updated_by,fnd_global.user_id),

811: object_version_number,
812: NVL(creation_date, SYSDATE),
813: NVL(created_by, fnd_global.user_id),
814: NVL(last_update_date, SYSDATE),
815: NVL(last_updated_by,fnd_global.user_id),
816: NVL(last_update_login,fnd_global.login_id),
817: interaction_inters_id,
818: object_id,
819: object_type,

Line 816: NVL(last_update_login,fnd_global.login_id),

812: NVL(creation_date, SYSDATE),
813: NVL(created_by, fnd_global.user_id),
814: NVL(last_update_date, SYSDATE),
815: NVL(last_updated_by,fnd_global.user_id),
816: NVL(last_update_login,fnd_global.login_id),
817: interaction_inters_id,
818: object_id,
819: object_type,
820: source_code,

Line 924: NVL(created_by,fnd_global.user_id) AS created_by,

920: NVL(media_id,nMediaID) AS media_id,
921: object_version_number,
922: NVL(creation_date,SYSDATE) AS creation_date,
923: NVL(last_update_date,SYSDATE) AS last_update_date,
924: NVL(created_by,fnd_global.user_id) AS created_by,
925: NVL(last_updated_by,fnd_global.user_id) AS last_updated_by,
926: NVL(last_update_login,fnd_global.login_id) AS last_update_login,
927: duration,
928: direction,

Line 925: NVL(last_updated_by,fnd_global.user_id) AS last_updated_by,

921: object_version_number,
922: NVL(creation_date,SYSDATE) AS creation_date,
923: NVL(last_update_date,SYSDATE) AS last_update_date,
924: NVL(created_by,fnd_global.user_id) AS created_by,
925: NVL(last_updated_by,fnd_global.user_id) AS last_updated_by,
926: NVL(last_update_login,fnd_global.login_id) AS last_update_login,
927: duration,
928: direction,
929: end_date_time,

Line 926: NVL(last_update_login,fnd_global.login_id) AS last_update_login,

922: NVL(creation_date,SYSDATE) AS creation_date,
923: NVL(last_update_date,SYSDATE) AS last_update_date,
924: NVL(created_by,fnd_global.user_id) AS created_by,
925: NVL(last_updated_by,fnd_global.user_id) AS last_updated_by,
926: NVL(last_update_login,fnd_global.login_id) AS last_update_login,
927: duration,
928: direction,
929: end_date_time,
930: source_item_create_date_time,

Line 1030: NVL(created_by,fnd_global.user_id),

1026: SELECT DISTINCT
1027: activity_id,
1028: object_version_number,
1029: NVL(creation_date,SYSDATE),
1030: NVL(created_by,fnd_global.user_id),
1031: NVL(last_updated_by,fnd_global.user_id),
1032: NVL(last_update_date,SYSDATE),
1033: NVL(last_update_login,fnd_global.login_id),
1034: doc_source_object_name,

Line 1031: NVL(last_updated_by,fnd_global.user_id),

1027: activity_id,
1028: object_version_number,
1029: NVL(creation_date,SYSDATE),
1030: NVL(created_by,fnd_global.user_id),
1031: NVL(last_updated_by,fnd_global.user_id),
1032: NVL(last_update_date,SYSDATE),
1033: NVL(last_update_login,fnd_global.login_id),
1034: doc_source_object_name,
1035: cust_account_id,

Line 1033: NVL(last_update_login,fnd_global.login_id),

1029: NVL(creation_date,SYSDATE),
1030: NVL(created_by,fnd_global.user_id),
1031: NVL(last_updated_by,fnd_global.user_id),
1032: NVL(last_update_date,SYSDATE),
1033: NVL(last_update_login,fnd_global.login_id),
1034: doc_source_object_name,
1035: cust_account_id,
1036: cust_org_id,
1037: interaction_id,