461: p_data_entry_mode NUMBER,
462: p_layout_mode NUMBER,
463: p_auto_row_count NUMBER,
464: p_default_parent_spec VARCHAR2,
465: p_last_updated_by NUMBER := fnd_global.user_id,
466: p_created_by NUMBER := fnd_global.user_id,
467: p_last_update_login NUMBER := fnd_global.user_id,
468: x_plan_relationship_id IN OUT NOCOPY NUMBER)
469: IS
462: p_layout_mode NUMBER,
463: p_auto_row_count NUMBER,
464: p_default_parent_spec VARCHAR2,
465: p_last_updated_by NUMBER := fnd_global.user_id,
466: p_created_by NUMBER := fnd_global.user_id,
467: p_last_update_login NUMBER := fnd_global.user_id,
468: x_plan_relationship_id IN OUT NOCOPY NUMBER)
469: IS
470:
463: p_auto_row_count NUMBER,
464: p_default_parent_spec VARCHAR2,
465: p_last_updated_by NUMBER := fnd_global.user_id,
466: p_created_by NUMBER := fnd_global.user_id,
467: p_last_update_login NUMBER := fnd_global.user_id,
468: x_plan_relationship_id IN OUT NOCOPY NUMBER)
469: IS
470:
471: l_sysdate DATE;
617: p_parent_char_id NUMBER,
618: p_child_char_id NUMBER,
619: p_element_relationship_type NUMBER,
620: p_link_flag VARCHAR2,
621: p_last_updated_by NUMBER := fnd_global.user_id,
622: p_created_by NUMBER := fnd_global.user_id,
623: p_last_update_login NUMBER := fnd_global.user_id,
624: x_element_relationship_id OUT NOCOPY NUMBER) IS
625:
618: p_child_char_id NUMBER,
619: p_element_relationship_type NUMBER,
620: p_link_flag VARCHAR2,
621: p_last_updated_by NUMBER := fnd_global.user_id,
622: p_created_by NUMBER := fnd_global.user_id,
623: p_last_update_login NUMBER := fnd_global.user_id,
624: x_element_relationship_id OUT NOCOPY NUMBER) IS
625:
626: l_sysdate DATE;
619: p_element_relationship_type NUMBER,
620: p_link_flag VARCHAR2,
621: p_last_updated_by NUMBER := fnd_global.user_id,
622: p_created_by NUMBER := fnd_global.user_id,
623: p_last_update_login NUMBER := fnd_global.user_id,
624: x_element_relationship_id OUT NOCOPY NUMBER) IS
625:
626: l_sysdate DATE;
627: l_row_id VARCHAR2(1000);
660: p_low_value VARCHAR2,
661: -- p_low_value_id NUMBER,
662: p_high_value VARCHAR2,
663: -- p_high_value_id NUMBER,
664: p_last_updated_by NUMBER := fnd_global.user_id,
665: p_created_by NUMBER := fnd_global.user_id,
666: p_last_update_login NUMBER := fnd_global.user_id,
667: x_criteria_id OUT NOCOPY NUMBER) IS
668:
661: -- p_low_value_id NUMBER,
662: p_high_value VARCHAR2,
663: -- p_high_value_id NUMBER,
664: p_last_updated_by NUMBER := fnd_global.user_id,
665: p_created_by NUMBER := fnd_global.user_id,
666: p_last_update_login NUMBER := fnd_global.user_id,
667: x_criteria_id OUT NOCOPY NUMBER) IS
668:
669: l_sysdate DATE;
662: p_high_value VARCHAR2,
663: -- p_high_value_id NUMBER,
664: p_last_updated_by NUMBER := fnd_global.user_id,
665: p_created_by NUMBER := fnd_global.user_id,
666: p_last_update_login NUMBER := fnd_global.user_id,
667: x_criteria_id OUT NOCOPY NUMBER) IS
668:
669: l_sysdate DATE;
670: l_row_id VARCHAR2(1000);
702: p_data_entry_mode NUMBER,
703: p_layout_mode NUMBER,
704: p_auto_row_count NUMBER,
705: p_default_parent_spec VARCHAR2,
706: p_last_updated_by NUMBER:=fnd_global.user_id,
707: p_created_by NUMBER:=fnd_global.user_id,
708: p_last_update_login NUMBER:=fnd_global.user_id
709: ) IS
710: l_sysdate DATE;
703: p_layout_mode NUMBER,
704: p_auto_row_count NUMBER,
705: p_default_parent_spec VARCHAR2,
706: p_last_updated_by NUMBER:=fnd_global.user_id,
707: p_created_by NUMBER:=fnd_global.user_id,
708: p_last_update_login NUMBER:=fnd_global.user_id
709: ) IS
710: l_sysdate DATE;
711: l_rowid VARCHAR2(1000);
704: p_auto_row_count NUMBER,
705: p_default_parent_spec VARCHAR2,
706: p_last_updated_by NUMBER:=fnd_global.user_id,
707: p_created_by NUMBER:=fnd_global.user_id,
708: p_last_update_login NUMBER:=fnd_global.user_id
709: ) IS
710: l_sysdate DATE;
711: l_rowid VARCHAR2(1000);
712: l_default_parent_spec NUMBER := 2;
755: p_parent_char_id NUMBER,
756: p_child_char_id NUMBER,
757: p_element_relationship_type NUMBER,
758: p_link_flag VARCHAR2,
759: p_last_updated_by NUMBER := fnd_global.user_id,
760: p_created_by NUMBER := fnd_global.user_id,
761: p_last_update_login NUMBER := fnd_global.user_id,
762: p_row_id VARCHAR2) IS
763:
756: p_child_char_id NUMBER,
757: p_element_relationship_type NUMBER,
758: p_link_flag VARCHAR2,
759: p_last_updated_by NUMBER := fnd_global.user_id,
760: p_created_by NUMBER := fnd_global.user_id,
761: p_last_update_login NUMBER := fnd_global.user_id,
762: p_row_id VARCHAR2) IS
763:
764: l_sysdate DATE;
757: p_element_relationship_type NUMBER,
758: p_link_flag VARCHAR2,
759: p_last_updated_by NUMBER := fnd_global.user_id,
760: p_created_by NUMBER := fnd_global.user_id,
761: p_last_update_login NUMBER := fnd_global.user_id,
762: p_row_id VARCHAR2) IS
763:
764: l_sysdate DATE;
765: l_row_id VARCHAR2(1000);
799: p_char_id NUMBER,
800: p_operator NUMBER,
801: p_low_value VARCHAR2,
802: p_high_value VARCHAR2,
803: p_last_updated_by NUMBER := fnd_global.user_id,
804: p_created_by NUMBER := fnd_global.user_id,
805: p_last_update_login NUMBER := fnd_global.user_id,
806: p_criteria_id NUMBER) IS
807:
800: p_operator NUMBER,
801: p_low_value VARCHAR2,
802: p_high_value VARCHAR2,
803: p_last_updated_by NUMBER := fnd_global.user_id,
804: p_created_by NUMBER := fnd_global.user_id,
805: p_last_update_login NUMBER := fnd_global.user_id,
806: p_criteria_id NUMBER) IS
807:
808: l_sysdate DATE;
801: p_low_value VARCHAR2,
802: p_high_value VARCHAR2,
803: p_last_updated_by NUMBER := fnd_global.user_id,
804: p_created_by NUMBER := fnd_global.user_id,
805: p_last_update_login NUMBER := fnd_global.user_id,
806: p_criteria_id NUMBER) IS
807:
808: l_sysdate DATE;
809: