eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.JTF_DPF dependencies on FND_GLOBAL

Line 538: last_updated_by = fnd_global.user_id,

534: rule_name = upd.p_new_name,
535: -- rule_description = p_new_descr,
536: object_version_number = OBJECT_VERSION_NUMBER+1,
537: last_update_date = sysdate,
538: last_updated_by = fnd_global.user_id,
539: LAST_UPDATE_LOGIN = FND_GLOBAL.CONC_LOGIN_ID
540: where rule_id = p_rule_id;
541:
542: if upd.p_new_descr is null or fnd_api.g_miss_char <> upd.p_new_descr then

Line 539: LAST_UPDATE_LOGIN = FND_GLOBAL.CONC_LOGIN_ID

535: -- rule_description = p_new_descr,
536: object_version_number = OBJECT_VERSION_NUMBER+1,
537: last_update_date = sysdate,
538: last_updated_by = fnd_global.user_id,
539: LAST_UPDATE_LOGIN = FND_GLOBAL.CONC_LOGIN_ID
540: where rule_id = p_rule_id;
541:
542: if upd.p_new_descr is null or fnd_api.g_miss_char <> upd.p_new_descr then
543: update jtf_dpf_rules_tl

Line 547: last_updated_by = fnd_global.user_id,

543: update jtf_dpf_rules_tl
544: set rule_description = upd.p_new_descr,
545: -- object_version_number = OBJECT_VERSION_NUMBER+1,
546: last_update_date = sysdate,
547: last_updated_by = fnd_global.user_id,
548: LAST_UPDATE_LOGIN = FND_GLOBAL.CONC_LOGIN_ID
549: where rule_id = p_rule_id and language = userenv('LANG');
550: end if;
551: return 1;

Line 548: LAST_UPDATE_LOGIN = FND_GLOBAL.CONC_LOGIN_ID

544: set rule_description = upd.p_new_descr,
545: -- object_version_number = OBJECT_VERSION_NUMBER+1,
546: last_update_date = sysdate,
547: last_updated_by = fnd_global.user_id,
548: LAST_UPDATE_LOGIN = FND_GLOBAL.CONC_LOGIN_ID
549: where rule_id = p_rule_id and language = userenv('LANG');
550: end if;
551: return 1;
552: end;

Line 585: X_CREATED_BY => FND_GLOBAL.USER_ID,

581: X_OBJECT_VERSION_NUMBER => 1,
582: X_RULE_NAME => p_name,
583: X_RULE_DESCRIPTION => p_descr,
584: X_CREATION_DATE => SYSDATE,
585: X_CREATED_BY => FND_GLOBAL.USER_ID,
586: X_LAST_UPDATE_DATE => SYSDATE,
587: X_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,
588: X_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_ID);
589:

Line 587: X_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,

583: X_RULE_DESCRIPTION => p_descr,
584: X_CREATION_DATE => SYSDATE,
585: X_CREATED_BY => FND_GLOBAL.USER_ID,
586: X_LAST_UPDATE_DATE => SYSDATE,
587: X_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,
588: X_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_ID);
589:
590:
591: -- insert into jtf_dpf_rules_b(

Line 588: X_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_ID);

584: X_CREATION_DATE => SYSDATE,
585: X_CREATED_BY => FND_GLOBAL.USER_ID,
586: X_LAST_UPDATE_DATE => SYSDATE,
587: X_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,
588: X_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_ID);
589:
590:
591: -- insert into jtf_dpf_rules_b(
592: -- rule_id,

Line 602: -- FND_GLOBAL.USER_ID,

598: -- LAST_UPDATED_BY,
599: -- LAST_UPDATE_LOGIN)
600: -- values(t_ruleid, t_appid, p_name, -- p_descr,
601: -- 1,
602: -- FND_GLOBAL.USER_ID,
603: -- SYSDATE,
604: -- SYSDATE,
605: -- FND_GLOBAL.USER_ID,
606: -- FND_GLOBAL.CONC_LOGIN_ID);

Line 605: -- FND_GLOBAL.USER_ID,

601: -- 1,
602: -- FND_GLOBAL.USER_ID,
603: -- SYSDATE,
604: -- SYSDATE,
605: -- FND_GLOBAL.USER_ID,
606: -- FND_GLOBAL.CONC_LOGIN_ID);
607: --
608: -- insert into jtf_dpf_rules_tl(
609: -- RULE_ID,

Line 606: -- FND_GLOBAL.CONC_LOGIN_ID);

602: -- FND_GLOBAL.USER_ID,
603: -- SYSDATE,
604: -- SYSDATE,
605: -- FND_GLOBAL.USER_ID,
606: -- FND_GLOBAL.CONC_LOGIN_ID);
607: --
608: -- insert into jtf_dpf_rules_tl(
609: -- RULE_ID,
610: -- LANGUAGE,

Line 625: -- FND_GLOBAL.USER_ID,

621: -- userenv('LANG'),
622: -- userenv('LANG'),
623: -- p_descr,
624: -- 1,
625: -- FND_GLOBAL.USER_ID,
626: -- SYSDATE,
627: -- SYSDATE,
628: -- FND_GLOBAL.USER_ID,
629: -- FND_GLOBAL.CONC_LOGIN_ID);

Line 628: -- FND_GLOBAL.USER_ID,

624: -- 1,
625: -- FND_GLOBAL.USER_ID,
626: -- SYSDATE,
627: -- SYSDATE,
628: -- FND_GLOBAL.USER_ID,
629: -- FND_GLOBAL.CONC_LOGIN_ID);
630:
631:
632: rule_set_params(t_ruleid, rules);

Line 629: -- FND_GLOBAL.CONC_LOGIN_ID);

625: -- FND_GLOBAL.USER_ID,
626: -- SYSDATE,
627: -- SYSDATE,
628: -- FND_GLOBAL.USER_ID,
629: -- FND_GLOBAL.CONC_LOGIN_ID);
630:
631:
632: rule_set_params(t_ruleid, rules);
633: -- commit;

Line 669: FND_GLOBAL.USER_ID,

665: rules(idx).condition,
666: rules(idx).param_name,
667: rules(idx).param_value,
668: 1,
669: FND_GLOBAL.USER_ID,
670: SYSDATE,
671: SYSDATE,
672: FND_GLOBAL.USER_ID,
673: FND_GLOBAL.CONC_LOGIN_ID);

Line 672: FND_GLOBAL.USER_ID,

668: 1,
669: FND_GLOBAL.USER_ID,
670: SYSDATE,
671: SYSDATE,
672: FND_GLOBAL.USER_ID,
673: FND_GLOBAL.CONC_LOGIN_ID);
674:
675: if idx = rules.last then exit; end if;
676: idx := rules.next(idx);

Line 673: FND_GLOBAL.CONC_LOGIN_ID);

669: FND_GLOBAL.USER_ID,
670: SYSDATE,
671: SYSDATE,
672: FND_GLOBAL.USER_ID,
673: FND_GLOBAL.CONC_LOGIN_ID);
674:
675: if idx = rules.last then exit; end if;
676: idx := rules.next(idx);
677: end loop;

Line 720: last_updated_by = fnd_global.user_id,

716: physical_page_name = upd.p_name,
717: -- physical_page_description = p_descr,
718: object_version_number = OBJECT_VERSION_NUMBER+1,
719: last_update_date = sysdate,
720: last_updated_by = fnd_global.user_id,
721: LAST_UPDATE_LOGIN = FND_GLOBAL.CONC_LOGIN_ID
722: where physical_page_id = p_ppid;
723:
724: if upd.p_descr is null or fnd_api.g_miss_char <> upd.p_descr then

Line 721: LAST_UPDATE_LOGIN = FND_GLOBAL.CONC_LOGIN_ID

717: -- physical_page_description = p_descr,
718: object_version_number = OBJECT_VERSION_NUMBER+1,
719: last_update_date = sysdate,
720: last_updated_by = fnd_global.user_id,
721: LAST_UPDATE_LOGIN = FND_GLOBAL.CONC_LOGIN_ID
722: where physical_page_id = p_ppid;
723:
724: if upd.p_descr is null or fnd_api.g_miss_char <> upd.p_descr then
725: update jtf_dpf_physical_pages_tl

Line 730: last_updated_by = fnd_global.user_id,

726: set
727: physical_page_description = upd.p_descr,
728: -- object_version_number = OBJECT_VERSION_NUMBER+1,
729: last_update_date = sysdate,
730: last_updated_by = fnd_global.user_id,
731: LAST_UPDATE_LOGIN = FND_GLOBAL.CONC_LOGIN_ID
732: where physical_page_id = p_ppid and
733: language=userenv('LANG');
734: end if;

Line 731: LAST_UPDATE_LOGIN = FND_GLOBAL.CONC_LOGIN_ID

727: physical_page_description = upd.p_descr,
728: -- object_version_number = OBJECT_VERSION_NUMBER+1,
729: last_update_date = sysdate,
730: last_updated_by = fnd_global.user_id,
731: LAST_UPDATE_LOGIN = FND_GLOBAL.CONC_LOGIN_ID
732: where physical_page_id = p_ppid and
733: language=userenv('LANG');
734: end if;
735: -- commit;

Line 765: FND_GLOBAL.USER_ID,

761: p_ppid,
762: p_new_ones(idx).name,
763: p_new_ones(idx).value,
764: 1,
765: FND_GLOBAL.USER_ID,
766: SYSDATE,
767: SYSDATE,
768: FND_GLOBAL.USER_ID,
769: FND_GLOBAL.CONC_LOGIN_ID);

Line 768: FND_GLOBAL.USER_ID,

764: 1,
765: FND_GLOBAL.USER_ID,
766: SYSDATE,
767: SYSDATE,
768: FND_GLOBAL.USER_ID,
769: FND_GLOBAL.CONC_LOGIN_ID);
770: if idx = p_new_ones.last then exit; end if;
771: idx := p_new_ones.next(idx);
772: end loop;

Line 769: FND_GLOBAL.CONC_LOGIN_ID);

765: FND_GLOBAL.USER_ID,
766: SYSDATE,
767: SYSDATE,
768: FND_GLOBAL.USER_ID,
769: FND_GLOBAL.CONC_LOGIN_ID);
770: if idx = p_new_ones.last then exit; end if;
771: idx := p_new_ones.next(idx);
772: end loop;
773: end if;

Line 809: X_CREATED_BY => FND_GLOBAL.USER_ID,

805: X_APPLICATION_ID => t_appid,
806: X_OBJECT_VERSION_NUMBER => 1,
807: X_PHYSICAL_PAGE_DESCRIPTION => p_descr,
808: X_CREATION_DATE => SYSDATE,
809: X_CREATED_BY => FND_GLOBAL.USER_ID,
810: X_LAST_UPDATE_DATE => SYSDATE,
811: X_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,
812: X_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_ID);
813:

Line 811: X_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,

807: X_PHYSICAL_PAGE_DESCRIPTION => p_descr,
808: X_CREATION_DATE => SYSDATE,
809: X_CREATED_BY => FND_GLOBAL.USER_ID,
810: X_LAST_UPDATE_DATE => SYSDATE,
811: X_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,
812: X_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_ID);
813:
814: -- insert into jtf_dpf_physical_pages_b(
815: -- physical_page_id,

Line 812: X_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_ID);

808: X_CREATION_DATE => SYSDATE,
809: X_CREATED_BY => FND_GLOBAL.USER_ID,
810: X_LAST_UPDATE_DATE => SYSDATE,
811: X_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,
812: X_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_ID);
813:
814: -- insert into jtf_dpf_physical_pages_b(
815: -- physical_page_id,
816: -- physical_page_name,

Line 831: -- FND_GLOBAL.USER_ID,

827: -- p_name,
828: -- -- p_descr,
829: -- t_appid,
830: -- 1,
831: -- FND_GLOBAL.USER_ID,
832: -- SYSDATE,
833: -- SYSDATE,
834: -- FND_GLOBAL.USER_ID,
835: -- FND_GLOBAL.CONC_LOGIN_ID);

Line 834: -- FND_GLOBAL.USER_ID,

830: -- 1,
831: -- FND_GLOBAL.USER_ID,
832: -- SYSDATE,
833: -- SYSDATE,
834: -- FND_GLOBAL.USER_ID,
835: -- FND_GLOBAL.CONC_LOGIN_ID);
836: --
837: -- insert into jtf_dpf_physical_pages_tl(
838: -- PHYSICAL_PAGE_ID,

Line 835: -- FND_GLOBAL.CONC_LOGIN_ID);

831: -- FND_GLOBAL.USER_ID,
832: -- SYSDATE,
833: -- SYSDATE,
834: -- FND_GLOBAL.USER_ID,
835: -- FND_GLOBAL.CONC_LOGIN_ID);
836: --
837: -- insert into jtf_dpf_physical_pages_tl(
838: -- PHYSICAL_PAGE_ID,
839: -- LANGUAGE,

Line 854: -- FND_GLOBAL.USER_ID,

850: -- userenv('LANG'),
851: -- userenv('LANG'),
852: -- p_descr,
853: -- 1,
854: -- FND_GLOBAL.USER_ID,
855: -- SYSDATE,
856: -- SYSDATE,
857: -- FND_GLOBAL.USER_ID,
858: -- FND_GLOBAL.CONC_LOGIN_ID);

Line 857: -- FND_GLOBAL.USER_ID,

853: -- 1,
854: -- FND_GLOBAL.USER_ID,
855: -- SYSDATE,
856: -- SYSDATE,
857: -- FND_GLOBAL.USER_ID,
858: -- FND_GLOBAL.CONC_LOGIN_ID);
859:
860: -- commit;
861: return 1;

Line 858: -- FND_GLOBAL.CONC_LOGIN_ID);

854: -- FND_GLOBAL.USER_ID,
855: -- SYSDATE,
856: -- SYSDATE,
857: -- FND_GLOBAL.USER_ID,
858: -- FND_GLOBAL.CONC_LOGIN_ID);
859:
860: -- commit;
861: return 1;
862: end;

Line 948: last_updated_by = fnd_global.user_id,

944: secure_flow_flag = upd.p_new_secure_flow_flag,
945: application_id = t_appid,
946: object_version_number = OBJECT_VERSION_NUMBER+1,
947: last_update_date = sysdate,
948: last_updated_by = fnd_global.user_id,
949: LAST_UPDATE_LOGIN = FND_GLOBAL.CONC_LOGIN_ID
950: where logical_flow_id = p_logical_flow_id;
951:
952: if upd.p_new_descr is null or fnd_api.g_miss_char <> upd.p_new_descr then

Line 949: LAST_UPDATE_LOGIN = FND_GLOBAL.CONC_LOGIN_ID

945: application_id = t_appid,
946: object_version_number = OBJECT_VERSION_NUMBER+1,
947: last_update_date = sysdate,
948: last_updated_by = fnd_global.user_id,
949: LAST_UPDATE_LOGIN = FND_GLOBAL.CONC_LOGIN_ID
950: where logical_flow_id = p_logical_flow_id;
951:
952: if upd.p_new_descr is null or fnd_api.g_miss_char <> upd.p_new_descr then
953: update jtf_dpf_logical_flows_tl

Line 958: last_updated_by = fnd_global.user_id,

954: set
955: logical_flow_description = upd.p_new_descr,
956: -- object_version_number = OBJECT_VERSION_NUMBER+1,
957: last_update_date = sysdate,
958: last_updated_by = fnd_global.user_id,
959: LAST_UPDATE_LOGIN = FND_GLOBAL.CONC_LOGIN_ID
960: where logical_flow_id = p_logical_flow_id and
961: language=userenv('LANG');
962: end if;

Line 959: LAST_UPDATE_LOGIN = FND_GLOBAL.CONC_LOGIN_ID

955: logical_flow_description = upd.p_new_descr,
956: -- object_version_number = OBJECT_VERSION_NUMBER+1,
957: last_update_date = sysdate,
958: last_updated_by = fnd_global.user_id,
959: LAST_UPDATE_LOGIN = FND_GLOBAL.CONC_LOGIN_ID
960: where logical_flow_id = p_logical_flow_id and
961: language=userenv('LANG');
962: end if;
963:

Line 1041: X_CREATED_BY => FND_GLOBAL.USER_ID,

1037: -- X_ENABLED_CLONE_FLAG => 'T',
1038: X_OBJECT_VERSION_NUMBER => 1,
1039: X_LOGICAL_FLOW_DESCRIPTION => P_NEW_DESCR,
1040: X_CREATION_DATE => SYSDATE,
1041: X_CREATED_BY => FND_GLOBAL.USER_ID,
1042: X_LAST_UPDATE_DATE => SYSDATE,
1043: X_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,
1044: X_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_ID);
1045:

Line 1043: X_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,

1039: X_LOGICAL_FLOW_DESCRIPTION => P_NEW_DESCR,
1040: X_CREATION_DATE => SYSDATE,
1041: X_CREATED_BY => FND_GLOBAL.USER_ID,
1042: X_LAST_UPDATE_DATE => SYSDATE,
1043: X_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,
1044: X_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_ID);
1045:
1046: -- insert into jtf_dpf_logical_flows_b(
1047: -- logical_flow_id,

Line 1044: X_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_ID);

1040: X_CREATION_DATE => SYSDATE,
1041: X_CREATED_BY => FND_GLOBAL.USER_ID,
1042: X_LAST_UPDATE_DATE => SYSDATE,
1043: X_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,
1044: X_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_ID);
1045:
1046: -- insert into jtf_dpf_logical_flows_b(
1047: -- logical_flow_id,
1048: -- logical_flow_head_id,

Line 1077: -- FND_GLOBAL.USER_ID,

1073: -- p_new_flow_finalizer_class,
1074: -- 'T',
1075: -- 'F',
1076: -- 1,
1077: -- FND_GLOBAL.USER_ID,
1078: -- SYSDATE,
1079: -- SYSDATE,
1080: -- FND_GLOBAL.USER_ID,
1081: -- FND_GLOBAL.CONC_LOGIN_ID);

Line 1080: -- FND_GLOBAL.USER_ID,

1076: -- 1,
1077: -- FND_GLOBAL.USER_ID,
1078: -- SYSDATE,
1079: -- SYSDATE,
1080: -- FND_GLOBAL.USER_ID,
1081: -- FND_GLOBAL.CONC_LOGIN_ID);
1082: --
1083: -- insert into jtf_dpf_logical_flows_tl(
1084: -- logical_flow_id,

Line 1081: -- FND_GLOBAL.CONC_LOGIN_ID);

1077: -- FND_GLOBAL.USER_ID,
1078: -- SYSDATE,
1079: -- SYSDATE,
1080: -- FND_GLOBAL.USER_ID,
1081: -- FND_GLOBAL.CONC_LOGIN_ID);
1082: --
1083: -- insert into jtf_dpf_logical_flows_tl(
1084: -- logical_flow_id,
1085: -- language,

Line 1100: -- FND_GLOBAL.USER_ID,

1096: -- userenv('LANG'),
1097: -- userenv('LANG'),
1098: -- p_new_descr,
1099: -- 1,
1100: -- FND_GLOBAL.USER_ID,
1101: -- SYSDATE,
1102: -- SYSDATE,
1103: -- FND_GLOBAL.USER_ID,
1104: -- FND_GLOBAL.CONC_LOGIN_ID);

Line 1103: -- FND_GLOBAL.USER_ID,

1099: -- 1,
1100: -- FND_GLOBAL.USER_ID,
1101: -- SYSDATE,
1102: -- SYSDATE,
1103: -- FND_GLOBAL.USER_ID,
1104: -- FND_GLOBAL.CONC_LOGIN_ID);
1105:
1106: -- commit;
1107: return 1;

Line 1104: -- FND_GLOBAL.CONC_LOGIN_ID);

1100: -- FND_GLOBAL.USER_ID,
1101: -- SYSDATE,
1102: -- SYSDATE,
1103: -- FND_GLOBAL.USER_ID,
1104: -- FND_GLOBAL.CONC_LOGIN_ID);
1105:
1106: -- commit;
1107: return 1;
1108: end;

Line 1160: FND_GLOBAL.USER_ID,

1156: o.RETURN_TO_PAGE_ID,
1157: 'F',
1158: 'F',
1159: 1,
1160: FND_GLOBAL.USER_ID,
1161: SYSDATE,
1162: SYSDATE,
1163: FND_GLOBAL.USER_ID,
1164: FND_GLOBAL.CONC_LOGIN_ID

Line 1163: FND_GLOBAL.USER_ID,

1159: 1,
1160: FND_GLOBAL.USER_ID,
1161: SYSDATE,
1162: SYSDATE,
1163: FND_GLOBAL.USER_ID,
1164: FND_GLOBAL.CONC_LOGIN_ID
1165: from jtf_dpf_logical_flows_b o
1166: where o.logical_flow_id = p_flow_id;
1167:

Line 1164: FND_GLOBAL.CONC_LOGIN_ID

1160: FND_GLOBAL.USER_ID,
1161: SYSDATE,
1162: SYSDATE,
1163: FND_GLOBAL.USER_ID,
1164: FND_GLOBAL.CONC_LOGIN_ID
1165: from jtf_dpf_logical_flows_b o
1166: where o.logical_flow_id = p_flow_id;
1167:
1168: insert into jtf_dpf_logical_flows_tl(

Line 1185: FND_GLOBAL.USER_ID,

1181: o.language,
1182: o.source_lang,
1183: o.logical_flow_description,
1184: -- 1,
1185: FND_GLOBAL.USER_ID,
1186: -- SYSDATE,
1187: SYSDATE,
1188: FND_GLOBAL.USER_ID,
1189: FND_GLOBAL.CONC_LOGIN_ID

Line 1188: FND_GLOBAL.USER_ID,

1184: -- 1,
1185: FND_GLOBAL.USER_ID,
1186: -- SYSDATE,
1187: SYSDATE,
1188: FND_GLOBAL.USER_ID,
1189: FND_GLOBAL.CONC_LOGIN_ID
1190: from jtf_dpf_logical_flows_tl o
1191: where o.logical_flow_id = p_flow_id;
1192:

Line 1189: FND_GLOBAL.CONC_LOGIN_ID

1185: FND_GLOBAL.USER_ID,
1186: -- SYSDATE,
1187: SYSDATE,
1188: FND_GLOBAL.USER_ID,
1189: FND_GLOBAL.CONC_LOGIN_ID
1190: from jtf_dpf_logical_flows_tl o
1191: where o.logical_flow_id = p_flow_id;
1192:
1193: -- insert N new rows into table jtf_dpf_lgcl_next_rules with

Line 1220: FND_GLOBAL.USER_ID,

1216: o.RULE_EVAL_SEQ ,
1217: new_flow_id,
1218: o.RULE_ID ,
1219: 1,
1220: FND_GLOBAL.USER_ID,
1221: SYSDATE,
1222: SYSDATE,
1223: FND_GLOBAL.USER_ID,
1224: FND_GLOBAL.CONC_LOGIN_ID

Line 1223: FND_GLOBAL.USER_ID,

1219: 1,
1220: FND_GLOBAL.USER_ID,
1221: SYSDATE,
1222: SYSDATE,
1223: FND_GLOBAL.USER_ID,
1224: FND_GLOBAL.CONC_LOGIN_ID
1225: from jtf_dpf_lgcl_next_rules o
1226: where o.logical_flow_id = p_flow_id;
1227:

Line 1224: FND_GLOBAL.CONC_LOGIN_ID

1220: FND_GLOBAL.USER_ID,
1221: SYSDATE,
1222: SYSDATE,
1223: FND_GLOBAL.USER_ID,
1224: FND_GLOBAL.CONC_LOGIN_ID
1225: from jtf_dpf_lgcl_next_rules o
1226: where o.logical_flow_id = p_flow_id;
1227:
1228: return 1;

Line 1253: last_updated_by = fnd_global.user_id,

1249: update jtf_dpf_logical_flows_b
1250: set enabled_clone_flag = 'F',
1251: object_version_number = OBJECT_VERSION_NUMBER+1,
1252: last_update_date = sysdate,
1253: last_updated_by = fnd_global.user_id,
1254: LAST_UPDATE_LOGIN = FND_GLOBAL.CONC_LOGIN_ID
1255: where application_id = l_app_id and logical_flow_name = l_flow_name;
1256:
1257: -- activate this one

Line 1254: LAST_UPDATE_LOGIN = FND_GLOBAL.CONC_LOGIN_ID

1250: set enabled_clone_flag = 'F',
1251: object_version_number = OBJECT_VERSION_NUMBER+1,
1252: last_update_date = sysdate,
1253: last_updated_by = fnd_global.user_id,
1254: LAST_UPDATE_LOGIN = FND_GLOBAL.CONC_LOGIN_ID
1255: where application_id = l_app_id and logical_flow_name = l_flow_name;
1256:
1257: -- activate this one
1258: update jtf_dpf_logical_flows_b

Line 1262: last_updated_by = fnd_global.user_id,

1258: update jtf_dpf_logical_flows_b
1259: set enabled_clone_flag = 'T',
1260: object_version_number = OBJECT_VERSION_NUMBER+1,
1261: last_update_date = sysdate,
1262: last_updated_by = fnd_global.user_id,
1263: LAST_UPDATE_LOGIN = FND_GLOBAL.CONC_LOGIN_ID
1264: where logical_flow_id = p_flow_id;
1265:
1266: return 1;

Line 1263: LAST_UPDATE_LOGIN = FND_GLOBAL.CONC_LOGIN_ID

1259: set enabled_clone_flag = 'T',
1260: object_version_number = OBJECT_VERSION_NUMBER+1,
1261: last_update_date = sysdate,
1262: last_updated_by = fnd_global.user_id,
1263: LAST_UPDATE_LOGIN = FND_GLOBAL.CONC_LOGIN_ID
1264: where logical_flow_id = p_flow_id;
1265:
1266: return 1;
1267: end;

Line 1330: last_updated_by = fnd_global.user_id,

1326: page_controller_class = upd.p_new_page_controller_class,
1327: page_permission_name = upd.p_new_page_permission_name,
1328: object_version_number = OBJECT_VERSION_NUMBER+1,
1329: last_update_date = sysdate,
1330: last_updated_by = fnd_global.user_id,
1331: LAST_UPDATE_LOGIN = FND_GLOBAL.CONC_LOGIN_ID
1332: where logical_page_id = p_logical_page_id;
1333:
1334: if upd.p_new_descr is null or fnd_api.g_miss_char <> upd.p_new_descr then

Line 1331: LAST_UPDATE_LOGIN = FND_GLOBAL.CONC_LOGIN_ID

1327: page_permission_name = upd.p_new_page_permission_name,
1328: object_version_number = OBJECT_VERSION_NUMBER+1,
1329: last_update_date = sysdate,
1330: last_updated_by = fnd_global.user_id,
1331: LAST_UPDATE_LOGIN = FND_GLOBAL.CONC_LOGIN_ID
1332: where logical_page_id = p_logical_page_id;
1333:
1334: if upd.p_new_descr is null or fnd_api.g_miss_char <> upd.p_new_descr then
1335: update jtf_dpf_logical_pages_tl set

Line 1339: last_updated_by = fnd_global.user_id,

1335: update jtf_dpf_logical_pages_tl set
1336: logical_page_description = upd.p_new_descr,
1337: -- object_version_number = OBJECT_VERSION_NUMBER+1,
1338: last_update_date = sysdate,
1339: last_updated_by = fnd_global.user_id,
1340: LAST_UPDATE_LOGIN = FND_GLOBAL.CONC_LOGIN_ID
1341: where logical_page_id = p_logical_page_id and
1342: language = userenv('LANG');
1343: end if;

Line 1340: LAST_UPDATE_LOGIN = FND_GLOBAL.CONC_LOGIN_ID

1336: logical_page_description = upd.p_new_descr,
1337: -- object_version_number = OBJECT_VERSION_NUMBER+1,
1338: last_update_date = sysdate,
1339: last_updated_by = fnd_global.user_id,
1340: LAST_UPDATE_LOGIN = FND_GLOBAL.CONC_LOGIN_ID
1341: where logical_page_id = p_logical_page_id and
1342: language = userenv('LANG');
1343: end if;
1344:

Line 1367: FND_GLOBAL.USER_ID,

1363: p_logical_page_id,
1364: 'T',
1365: upd.p_default_physical_id,
1366: 1,
1367: FND_GLOBAL.USER_ID,
1368: SYSDATE,
1369: SYSDATE,
1370: FND_GLOBAL.USER_ID,
1371: FND_GLOBAL.CONC_LOGIN_ID);

Line 1370: FND_GLOBAL.USER_ID,

1366: 1,
1367: FND_GLOBAL.USER_ID,
1368: SYSDATE,
1369: SYSDATE,
1370: FND_GLOBAL.USER_ID,
1371: FND_GLOBAL.CONC_LOGIN_ID);
1372:
1373: end if;
1374: -- commit;

Line 1371: FND_GLOBAL.CONC_LOGIN_ID);

1367: FND_GLOBAL.USER_ID,
1368: SYSDATE,
1369: SYSDATE,
1370: FND_GLOBAL.USER_ID,
1371: FND_GLOBAL.CONC_LOGIN_ID);
1372:
1373: end if;
1374: -- commit;
1375: return 1;

Line 1427: X_CREATED_BY => FND_GLOBAL.USER_ID,

1423: X_PAGE_PERMISSION_NAME => p_new_page_permission_name,
1424: X_OBJECT_VERSION_NUMBER => 1,
1425: X_LOGICAL_PAGE_DESCRIPTION => p_new_descr,
1426: X_CREATION_DATE => SYSDATE,
1427: X_CREATED_BY => FND_GLOBAL.USER_ID,
1428: X_LAST_UPDATE_DATE => SYSDATE,
1429: X_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,
1430: X_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_ID);
1431:

Line 1429: X_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,

1425: X_LOGICAL_PAGE_DESCRIPTION => p_new_descr,
1426: X_CREATION_DATE => SYSDATE,
1427: X_CREATED_BY => FND_GLOBAL.USER_ID,
1428: X_LAST_UPDATE_DATE => SYSDATE,
1429: X_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,
1430: X_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_ID);
1431:
1432: -- insert into jtf_dpf_logical_pages_b(
1433: -- enabled_flag,

Line 1430: X_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_ID);

1426: X_CREATION_DATE => SYSDATE,
1427: X_CREATED_BY => FND_GLOBAL.USER_ID,
1428: X_LAST_UPDATE_DATE => SYSDATE,
1429: X_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,
1430: X_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_ID);
1431:
1432: -- insert into jtf_dpf_logical_pages_b(
1433: -- enabled_flag,
1434: -- logical_page_id,

Line 1457: -- FND_GLOBAL.USER_ID,

1453: -- -- p_new_descr,
1454: -- p_new_page_controller_class,
1455: -- p_new_page_permission_name,
1456: -- 1,
1457: -- FND_GLOBAL.USER_ID,
1458: -- SYSDATE,
1459: -- SYSDATE,
1460: -- FND_GLOBAL.USER_ID,
1461: -- FND_GLOBAL.CONC_LOGIN_ID)

Line 1460: -- FND_GLOBAL.USER_ID,

1456: -- 1,
1457: -- FND_GLOBAL.USER_ID,
1458: -- SYSDATE,
1459: -- SYSDATE,
1460: -- FND_GLOBAL.USER_ID,
1461: -- FND_GLOBAL.CONC_LOGIN_ID)
1462: -- returning logical_page_id into t_new_logical_page_id;
1463: --
1464: -- insert into jtf_dpf_logical_pages_tl(

Line 1461: -- FND_GLOBAL.CONC_LOGIN_ID)

1457: -- FND_GLOBAL.USER_ID,
1458: -- SYSDATE,
1459: -- SYSDATE,
1460: -- FND_GLOBAL.USER_ID,
1461: -- FND_GLOBAL.CONC_LOGIN_ID)
1462: -- returning logical_page_id into t_new_logical_page_id;
1463: --
1464: -- insert into jtf_dpf_logical_pages_tl(
1465: -- logical_page_id,

Line 1481: -- FND_GLOBAL.USER_ID,

1477: -- userenv('LANG'),
1478: -- userenv('LANG'),
1479: -- p_new_descr,
1480: -- 1,
1481: -- FND_GLOBAL.USER_ID,
1482: -- SYSDATE,
1483: -- SYSDATE,
1484: -- FND_GLOBAL.USER_ID,
1485: -- FND_GLOBAL.CONC_LOGIN_ID);

Line 1484: -- FND_GLOBAL.USER_ID,

1480: -- 1,
1481: -- FND_GLOBAL.USER_ID,
1482: -- SYSDATE,
1483: -- SYSDATE,
1484: -- FND_GLOBAL.USER_ID,
1485: -- FND_GLOBAL.CONC_LOGIN_ID);
1486:
1487: insert into jtf_dpf_lgcl_phy_rules (
1488: logical_physical_id,

Line 1485: -- FND_GLOBAL.CONC_LOGIN_ID);

1481: -- FND_GLOBAL.USER_ID,
1482: -- SYSDATE,
1483: -- SYSDATE,
1484: -- FND_GLOBAL.USER_ID,
1485: -- FND_GLOBAL.CONC_LOGIN_ID);
1486:
1487: insert into jtf_dpf_lgcl_phy_rules (
1488: logical_physical_id,
1489: logical_page_id,

Line 1504: FND_GLOBAL.USER_ID,

1500: t_new_logical_page_id,
1501: 'T',
1502: p_default_physical_id,
1503: 1,
1504: FND_GLOBAL.USER_ID,
1505: SYSDATE,
1506: SYSDATE,
1507: FND_GLOBAL.USER_ID,
1508: FND_GLOBAL.CONC_LOGIN_ID);

Line 1507: FND_GLOBAL.USER_ID,

1503: 1,
1504: FND_GLOBAL.USER_ID,
1505: SYSDATE,
1506: SYSDATE,
1507: FND_GLOBAL.USER_ID,
1508: FND_GLOBAL.CONC_LOGIN_ID);
1509:
1510: -- commit;
1511: return 1;

Line 1508: FND_GLOBAL.CONC_LOGIN_ID);

1504: FND_GLOBAL.USER_ID,
1505: SYSDATE,
1506: SYSDATE,
1507: FND_GLOBAL.USER_ID,
1508: FND_GLOBAL.CONC_LOGIN_ID);
1509:
1510: -- commit;
1511: return 1;
1512: end;

Line 1553: FND_GLOBAL.USER_ID,

1549: idx,
1550: p_new_ones(idx).physical_page_id,
1551: p_new_ones(idx).rule_id,
1552: 1,
1553: FND_GLOBAL.USER_ID,
1554: SYSDATE,
1555: SYSDATE,
1556: FND_GLOBAL.USER_ID,
1557: FND_GLOBAL.CONC_LOGIN_ID);

Line 1556: FND_GLOBAL.USER_ID,

1552: 1,
1553: FND_GLOBAL.USER_ID,
1554: SYSDATE,
1555: SYSDATE,
1556: FND_GLOBAL.USER_ID,
1557: FND_GLOBAL.CONC_LOGIN_ID);
1558:
1559: if idx = p_new_ones.last then exit; end if;
1560: idx := p_new_ones.next(idx);

Line 1557: FND_GLOBAL.CONC_LOGIN_ID);

1553: FND_GLOBAL.USER_ID,
1554: SYSDATE,
1555: SYSDATE,
1556: FND_GLOBAL.USER_ID,
1557: FND_GLOBAL.CONC_LOGIN_ID);
1558:
1559: if idx = p_new_ones.last then exit; end if;
1560: idx := p_new_ones.next(idx);
1561: end loop;

Line 1625: FND_GLOBAL.USER_ID,

1621: p_next_log_page_id,
1622: 'T',
1623: p_flow_id,
1624: 1,
1625: FND_GLOBAL.USER_ID,
1626: SYSDATE,
1627: SYSDATE,
1628: FND_GLOBAL.USER_ID,
1629: FND_GLOBAL.CONC_LOGIN_ID);

Line 1628: FND_GLOBAL.USER_ID,

1624: 1,
1625: FND_GLOBAL.USER_ID,
1626: SYSDATE,
1627: SYSDATE,
1628: FND_GLOBAL.USER_ID,
1629: FND_GLOBAL.CONC_LOGIN_ID);
1630:
1631: end if;
1632: -- commit;

Line 1629: FND_GLOBAL.CONC_LOGIN_ID);

1625: FND_GLOBAL.USER_ID,
1626: SYSDATE,
1627: SYSDATE,
1628: FND_GLOBAL.USER_ID,
1629: FND_GLOBAL.CONC_LOGIN_ID);
1630:
1631: end if;
1632: -- commit;
1633: return 1;

Line 1675: FND_GLOBAL.USER_ID,

1671: idx,
1672: p_flow_id,
1673: p_new_ones(idx).rule_id,
1674: 1,
1675: FND_GLOBAL.USER_ID,
1676: SYSDATE,
1677: SYSDATE,
1678: FND_GLOBAL.USER_ID,
1679: FND_GLOBAL.CONC_LOGIN_ID);

Line 1678: FND_GLOBAL.USER_ID,

1674: 1,
1675: FND_GLOBAL.USER_ID,
1676: SYSDATE,
1677: SYSDATE,
1678: FND_GLOBAL.USER_ID,
1679: FND_GLOBAL.CONC_LOGIN_ID);
1680:
1681: if idx = p_new_ones.last then exit; end if;
1682: idx := p_new_ones.next(idx);

Line 1679: FND_GLOBAL.CONC_LOGIN_ID);

1675: FND_GLOBAL.USER_ID,
1676: SYSDATE,
1677: SYSDATE,
1678: FND_GLOBAL.USER_ID,
1679: FND_GLOBAL.CONC_LOGIN_ID);
1680:
1681: if idx = p_new_ones.last then exit; end if;
1682: idx := p_new_ones.next(idx);
1683: end loop;