DBA Data[Home] [Help]

APPS.FND_SET dependencies on FND_REQUEST_GROUPS

Line 193: group_id fnd_request_groups.request_group_id%TYPE;

189:
190: /* Get a request group ID given name and appl ID */
191: FUNCTION request_group_id_f(group_application_id number,
192: request_group varchar2) return number is
193: group_id fnd_request_groups.request_group_id%TYPE;
194: BEGIN
195: SELECT request_group_id
196: INTO group_id
197: FROM fnd_request_groups

Line 197: FROM fnd_request_groups

193: group_id fnd_request_groups.request_group_id%TYPE;
194: BEGIN
195: SELECT request_group_id
196: INTO group_id
197: FROM fnd_request_groups
198: WHERE application_id = group_application_id
199: AND request_group_name = request_group;
200:
201: RETURN group_id;

Line 755: last_update_login fnd_request_groups.last_update_login%TYPE

751: print_together IN VARCHAR2 DEFAULT 'N',
752: incompatibilities_allowed IN VARCHAR2 DEFAULT 'N',
753: language_code IN VARCHAR2 DEFAULT 'US')
754: is
755: last_update_login fnd_request_groups.last_update_login%TYPE
756: := last_update_login_f;
757: last_update_date fnd_request_groups.last_update_date%TYPE
758: := last_update_date_f;
759: last_updated_by fnd_request_groups.last_updated_by%TYPE

Line 757: last_update_date fnd_request_groups.last_update_date%TYPE

753: language_code IN VARCHAR2 DEFAULT 'US')
754: is
755: last_update_login fnd_request_groups.last_update_login%TYPE
756: := last_update_login_f;
757: last_update_date fnd_request_groups.last_update_date%TYPE
758: := last_update_date_f;
759: last_updated_by fnd_request_groups.last_updated_by%TYPE
760: := last_updated_by_f;
761: creation_date fnd_request_groups.creation_date%TYPE

Line 759: last_updated_by fnd_request_groups.last_updated_by%TYPE

755: last_update_login fnd_request_groups.last_update_login%TYPE
756: := last_update_login_f;
757: last_update_date fnd_request_groups.last_update_date%TYPE
758: := last_update_date_f;
759: last_updated_by fnd_request_groups.last_updated_by%TYPE
760: := last_updated_by_f;
761: creation_date fnd_request_groups.creation_date%TYPE
762: := creation_date_f;
763: created_by fnd_request_groups.created_by%TYPE

Line 761: creation_date fnd_request_groups.creation_date%TYPE

757: last_update_date fnd_request_groups.last_update_date%TYPE
758: := last_update_date_f;
759: last_updated_by fnd_request_groups.last_updated_by%TYPE
760: := last_updated_by_f;
761: creation_date fnd_request_groups.creation_date%TYPE
762: := creation_date_f;
763: created_by fnd_request_groups.created_by%TYPE
764: := created_by_f;
765: set_appl_id fnd_application.application_id%TYPE;

Line 763: created_by fnd_request_groups.created_by%TYPE

759: last_updated_by fnd_request_groups.last_updated_by%TYPE
760: := last_updated_by_f;
761: creation_date fnd_request_groups.creation_date%TYPE
762: := creation_date_f;
763: created_by fnd_request_groups.created_by%TYPE
764: := created_by_f;
765: set_appl_id fnd_application.application_id%TYPE;
766: set_id fnd_request_sets.request_set_id%TYPE;
767: owner_id fnd_user.user_id%TYPE;

Line 884: last_update_login fnd_request_groups.last_update_login%TYPE

880: start_stage IN VARCHAR2 DEFAULT 'N',
881: language_code IN VARCHAR2 DEFAULT 'US'
882: )
883: is
884: last_update_login fnd_request_groups.last_update_login%TYPE
885: := last_update_login_f;
886: last_update_date fnd_request_groups.last_update_date%TYPE
887: := last_update_date_f;
888: last_updated_by fnd_request_groups.last_updated_by%TYPE

Line 886: last_update_date fnd_request_groups.last_update_date%TYPE

882: )
883: is
884: last_update_login fnd_request_groups.last_update_login%TYPE
885: := last_update_login_f;
886: last_update_date fnd_request_groups.last_update_date%TYPE
887: := last_update_date_f;
888: last_updated_by fnd_request_groups.last_updated_by%TYPE
889: := last_updated_by_f;
890: creation_date fnd_request_groups.creation_date%TYPE

Line 888: last_updated_by fnd_request_groups.last_updated_by%TYPE

884: last_update_login fnd_request_groups.last_update_login%TYPE
885: := last_update_login_f;
886: last_update_date fnd_request_groups.last_update_date%TYPE
887: := last_update_date_f;
888: last_updated_by fnd_request_groups.last_updated_by%TYPE
889: := last_updated_by_f;
890: creation_date fnd_request_groups.creation_date%TYPE
891: := creation_date_f;
892: created_by fnd_request_groups.created_by%TYPE

Line 890: creation_date fnd_request_groups.creation_date%TYPE

886: last_update_date fnd_request_groups.last_update_date%TYPE
887: := last_update_date_f;
888: last_updated_by fnd_request_groups.last_updated_by%TYPE
889: := last_updated_by_f;
890: creation_date fnd_request_groups.creation_date%TYPE
891: := creation_date_f;
892: created_by fnd_request_groups.created_by%TYPE
893: := created_by_f;
894: set_appl_id fnd_application.application_id%TYPE;

Line 892: created_by fnd_request_groups.created_by%TYPE

888: last_updated_by fnd_request_groups.last_updated_by%TYPE
889: := last_updated_by_f;
890: creation_date fnd_request_groups.creation_date%TYPE
891: := creation_date_f;
892: created_by fnd_request_groups.created_by%TYPE
893: := created_by_f;
894: set_appl_id fnd_application.application_id%TYPE;
895: set_id fnd_request_sets.request_set_id%TYPE;
896: print_style_name fnd_printer_styles.printer_style_name%TYPE;

Line 1027: last_update_login fnd_request_groups.last_update_login%TYPE

1023: success varchar2 default 'N',
1024: warning varchar2 default 'N',
1025: error varchar2 default 'N')
1026: is
1027: last_update_login fnd_request_groups.last_update_login%TYPE
1028: := last_update_login_f;
1029: last_update_date fnd_request_groups.last_update_date%TYPE
1030: := last_update_date_f;
1031: last_updated_by fnd_request_groups.last_updated_by%TYPE

Line 1029: last_update_date fnd_request_groups.last_update_date%TYPE

1025: error varchar2 default 'N')
1026: is
1027: last_update_login fnd_request_groups.last_update_login%TYPE
1028: := last_update_login_f;
1029: last_update_date fnd_request_groups.last_update_date%TYPE
1030: := last_update_date_f;
1031: last_updated_by fnd_request_groups.last_updated_by%TYPE
1032: := last_updated_by_f;
1033: set_appl_id fnd_application.application_id%TYPE;

Line 1031: last_updated_by fnd_request_groups.last_updated_by%TYPE

1027: last_update_login fnd_request_groups.last_update_login%TYPE
1028: := last_update_login_f;
1029: last_update_date fnd_request_groups.last_update_date%TYPE
1030: := last_update_date_f;
1031: last_updated_by fnd_request_groups.last_updated_by%TYPE
1032: := last_updated_by_f;
1033: set_appl_id fnd_application.application_id%TYPE;
1034: set_id fnd_request_sets.request_set_id%TYPE;
1035: from_stage_id fnd_request_set_stages_tl.request_set_stage_id%TYPE;

Line 1111: last_update_login fnd_request_groups.last_update_login%TYPE

1107: number_of_copies IN NUMBER DEFAULT 0,
1108: save_output IN VARCHAR2 DEFAULT 'Y',
1109: style IN VARCHAR2 DEFAULT NULL,
1110: printer IN VARCHAR2 DEFAULT NULL) is
1111: last_update_login fnd_request_groups.last_update_login%TYPE
1112: := last_update_login_f;
1113: last_update_date fnd_request_groups.last_update_date%TYPE
1114: := last_update_date_f;
1115: last_updated_by fnd_request_groups.last_updated_by%TYPE

Line 1113: last_update_date fnd_request_groups.last_update_date%TYPE

1109: style IN VARCHAR2 DEFAULT NULL,
1110: printer IN VARCHAR2 DEFAULT NULL) is
1111: last_update_login fnd_request_groups.last_update_login%TYPE
1112: := last_update_login_f;
1113: last_update_date fnd_request_groups.last_update_date%TYPE
1114: := last_update_date_f;
1115: last_updated_by fnd_request_groups.last_updated_by%TYPE
1116: := last_updated_by_f;
1117: creation_date fnd_request_groups.creation_date%TYPE

Line 1115: last_updated_by fnd_request_groups.last_updated_by%TYPE

1111: last_update_login fnd_request_groups.last_update_login%TYPE
1112: := last_update_login_f;
1113: last_update_date fnd_request_groups.last_update_date%TYPE
1114: := last_update_date_f;
1115: last_updated_by fnd_request_groups.last_updated_by%TYPE
1116: := last_updated_by_f;
1117: creation_date fnd_request_groups.creation_date%TYPE
1118: := creation_date_f;
1119: created_by fnd_request_groups.created_by%TYPE

Line 1117: creation_date fnd_request_groups.creation_date%TYPE

1113: last_update_date fnd_request_groups.last_update_date%TYPE
1114: := last_update_date_f;
1115: last_updated_by fnd_request_groups.last_updated_by%TYPE
1116: := last_updated_by_f;
1117: creation_date fnd_request_groups.creation_date%TYPE
1118: := creation_date_f;
1119: created_by fnd_request_groups.created_by%TYPE
1120: := created_by_f;
1121: set_appl_id fnd_application.application_id%TYPE;

Line 1119: created_by fnd_request_groups.created_by%TYPE

1115: last_updated_by fnd_request_groups.last_updated_by%TYPE
1116: := last_updated_by_f;
1117: creation_date fnd_request_groups.creation_date%TYPE
1118: := creation_date_f;
1119: created_by fnd_request_groups.created_by%TYPE
1120: := created_by_f;
1121: set_appl_id fnd_application.application_id%TYPE;
1122: program_appl_id fnd_application.application_id%TYPE;
1123: set_id fnd_request_sets.request_set_id%TYPE;

Line 1415: last_update_login fnd_request_groups.last_update_login%TYPE

1411: modify IN VARCHAR2 DEFAULT 'Y',
1412: shared_parameter IN VARCHAR2 DEFAULT NULL,
1413: default_type IN VARCHAR2 DEFAULT NULL,
1414: default_value IN VARCHAR2 DEFAULT NULL) is
1415: last_update_login fnd_request_groups.last_update_login%TYPE
1416: := last_update_login_f;
1417: last_update_date fnd_request_groups.last_update_date%TYPE
1418: := last_update_date_f;
1419: last_updated_by fnd_request_groups.last_updated_by%TYPE

Line 1417: last_update_date fnd_request_groups.last_update_date%TYPE

1413: default_type IN VARCHAR2 DEFAULT NULL,
1414: default_value IN VARCHAR2 DEFAULT NULL) is
1415: last_update_login fnd_request_groups.last_update_login%TYPE
1416: := last_update_login_f;
1417: last_update_date fnd_request_groups.last_update_date%TYPE
1418: := last_update_date_f;
1419: last_updated_by fnd_request_groups.last_updated_by%TYPE
1420: := last_updated_by_f;
1421: creation_date fnd_request_groups.creation_date%TYPE

Line 1419: last_updated_by fnd_request_groups.last_updated_by%TYPE

1415: last_update_login fnd_request_groups.last_update_login%TYPE
1416: := last_update_login_f;
1417: last_update_date fnd_request_groups.last_update_date%TYPE
1418: := last_update_date_f;
1419: last_updated_by fnd_request_groups.last_updated_by%TYPE
1420: := last_updated_by_f;
1421: creation_date fnd_request_groups.creation_date%TYPE
1422: := creation_date_f;
1423: created_by fnd_request_groups.created_by%TYPE

Line 1421: creation_date fnd_request_groups.creation_date%TYPE

1417: last_update_date fnd_request_groups.last_update_date%TYPE
1418: := last_update_date_f;
1419: last_updated_by fnd_request_groups.last_updated_by%TYPE
1420: := last_updated_by_f;
1421: creation_date fnd_request_groups.creation_date%TYPE
1422: := creation_date_f;
1423: created_by fnd_request_groups.created_by%TYPE
1424: := created_by_f;
1425: set_appl_id fnd_application.application_id%TYPE;

Line 1423: created_by fnd_request_groups.created_by%TYPE

1419: last_updated_by fnd_request_groups.last_updated_by%TYPE
1420: := last_updated_by_f;
1421: creation_date fnd_request_groups.creation_date%TYPE
1422: := creation_date_f;
1423: created_by fnd_request_groups.created_by%TYPE
1424: := created_by_f;
1425: set_appl_id fnd_application.application_id%TYPE;
1426: program_appl_id fnd_application.application_id%TYPE;
1427: set_id fnd_request_sets.request_set_id%TYPE;

Line 1552: last_update_login fnd_request_groups.last_update_login%TYPE

1548: set_application IN VARCHAR2,
1549: request_group IN VARCHAR2,
1550: group_application IN VARCHAR2)
1551: is
1552: last_update_login fnd_request_groups.last_update_login%TYPE
1553: := last_update_login_f;
1554: last_update_date fnd_request_groups.last_update_date%TYPE
1555: := last_update_date_f;
1556: last_updated_by fnd_request_groups.last_updated_by%TYPE

Line 1554: last_update_date fnd_request_groups.last_update_date%TYPE

1550: group_application IN VARCHAR2)
1551: is
1552: last_update_login fnd_request_groups.last_update_login%TYPE
1553: := last_update_login_f;
1554: last_update_date fnd_request_groups.last_update_date%TYPE
1555: := last_update_date_f;
1556: last_updated_by fnd_request_groups.last_updated_by%TYPE
1557: := last_updated_by_f;
1558: creation_date fnd_request_groups.creation_date%TYPE

Line 1556: last_updated_by fnd_request_groups.last_updated_by%TYPE

1552: last_update_login fnd_request_groups.last_update_login%TYPE
1553: := last_update_login_f;
1554: last_update_date fnd_request_groups.last_update_date%TYPE
1555: := last_update_date_f;
1556: last_updated_by fnd_request_groups.last_updated_by%TYPE
1557: := last_updated_by_f;
1558: creation_date fnd_request_groups.creation_date%TYPE
1559: := creation_date_f;
1560: created_by fnd_request_groups.created_by%TYPE

Line 1558: creation_date fnd_request_groups.creation_date%TYPE

1554: last_update_date fnd_request_groups.last_update_date%TYPE
1555: := last_update_date_f;
1556: last_updated_by fnd_request_groups.last_updated_by%TYPE
1557: := last_updated_by_f;
1558: creation_date fnd_request_groups.creation_date%TYPE
1559: := creation_date_f;
1560: created_by fnd_request_groups.created_by%TYPE
1561: := created_by_f;
1562: set_application_id

Line 1560: created_by fnd_request_groups.created_by%TYPE

1556: last_updated_by fnd_request_groups.last_updated_by%TYPE
1557: := last_updated_by_f;
1558: creation_date fnd_request_groups.creation_date%TYPE
1559: := creation_date_f;
1560: created_by fnd_request_groups.created_by%TYPE
1561: := created_by_f;
1562: set_application_id
1563: fnd_application.application_id%TYPE;
1564: group_application_id

Line 1569: fnd_request_groups.request_group_id%TYPE;

1565: fnd_application.application_id%TYPE;
1566: set_id
1567: fnd_request_sets.request_set_id%TYPE;
1568: group_id
1569: fnd_request_groups.request_group_id%TYPE;
1570: BEGIN
1571: message_init;
1572:
1573: check_notnull(set_application);

Line 1638: fnd_request_groups.request_group_id%TYPE;

1634: fnd_application.application_id%TYPE;
1635: set_id
1636: fnd_request_sets.request_set_id%TYPE;
1637: group_id
1638: fnd_request_groups.request_group_id%TYPE;
1639: BEGIN
1640: message_init;
1641:
1642: check_notnull(set_application);

Line 2325: group_id fnd_request_groups.request_group_id%TYPE;

2321:
2322: set_application_id fnd_application.application_id%TYPE;
2323: group_application_id fnd_application.application_id%TYPE;
2324: set_id fnd_request_sets.request_set_id%TYPE;
2325: group_id fnd_request_groups.request_group_id%TYPE;
2326: dummy varchar2(1);
2327:
2328: BEGIN
2329: message_init;

Line 2566: group_id fnd_request_groups.request_group_id%TYPE;

2562: RETURN BOOLEAN is
2563: fn_application_id fnd_application.application_id%TYPE;
2564: group_application_id fnd_application.application_id%TYPE;
2565: fn_id number;
2566: group_id fnd_request_groups.request_group_id%TYPE;
2567: dummy varchar2(1);
2568:
2569: begin
2570: message_init;

Line 2610: last_update_login fnd_request_groups.last_update_login%TYPE

2606: procedure add_function_to_group(function_short_name IN VARCHAR2,
2607: function_application IN VARCHAR2,
2608: request_group IN VARCHAR2,
2609: group_application IN VARCHAR2) is
2610: last_update_login fnd_request_groups.last_update_login%TYPE
2611: := last_update_login_f;
2612: last_update_date fnd_request_groups.last_update_date%TYPE
2613: := last_update_date_f;
2614: last_updated_by fnd_request_groups.last_updated_by%TYPE

Line 2612: last_update_date fnd_request_groups.last_update_date%TYPE

2608: request_group IN VARCHAR2,
2609: group_application IN VARCHAR2) is
2610: last_update_login fnd_request_groups.last_update_login%TYPE
2611: := last_update_login_f;
2612: last_update_date fnd_request_groups.last_update_date%TYPE
2613: := last_update_date_f;
2614: last_updated_by fnd_request_groups.last_updated_by%TYPE
2615: := last_updated_by_f;
2616: creation_date fnd_request_groups.creation_date%TYPE

Line 2614: last_updated_by fnd_request_groups.last_updated_by%TYPE

2610: last_update_login fnd_request_groups.last_update_login%TYPE
2611: := last_update_login_f;
2612: last_update_date fnd_request_groups.last_update_date%TYPE
2613: := last_update_date_f;
2614: last_updated_by fnd_request_groups.last_updated_by%TYPE
2615: := last_updated_by_f;
2616: creation_date fnd_request_groups.creation_date%TYPE
2617: := creation_date_f;
2618: created_by fnd_request_groups.created_by%TYPE

Line 2616: creation_date fnd_request_groups.creation_date%TYPE

2612: last_update_date fnd_request_groups.last_update_date%TYPE
2613: := last_update_date_f;
2614: last_updated_by fnd_request_groups.last_updated_by%TYPE
2615: := last_updated_by_f;
2616: creation_date fnd_request_groups.creation_date%TYPE
2617: := creation_date_f;
2618: created_by fnd_request_groups.created_by%TYPE
2619: := created_by_f;
2620: fn_application_id

Line 2618: created_by fnd_request_groups.created_by%TYPE

2614: last_updated_by fnd_request_groups.last_updated_by%TYPE
2615: := last_updated_by_f;
2616: creation_date fnd_request_groups.creation_date%TYPE
2617: := creation_date_f;
2618: created_by fnd_request_groups.created_by%TYPE
2619: := created_by_f;
2620: fn_application_id
2621: fnd_application.application_id%TYPE;
2622: group_application_id

Line 2627: fnd_request_groups.request_group_id%TYPE;

2623: fnd_application.application_id%TYPE;
2624: fn_id
2625: fnd_request_sets.request_set_id%TYPE;
2626: group_id
2627: fnd_request_groups.request_group_id%TYPE;
2628: begin
2629: message_init;
2630:
2631: check_notnull(function_application);

Line 2691: fnd_request_groups.request_group_id%TYPE;

2687: group_application_id
2688: fnd_application.application_id%TYPE;
2689: fn_id number;
2690: group_id
2691: fnd_request_groups.request_group_id%TYPE;
2692: begin
2693: message_init;
2694:
2695: check_notnull(function_application);