465: p_data_entry_mode NUMBER,
466: p_layout_mode NUMBER,
467: p_auto_row_count NUMBER,
468: p_default_parent_spec VARCHAR2,
469: p_last_updated_by NUMBER := fnd_global.user_id,
470: p_created_by NUMBER := fnd_global.user_id,
471: p_last_update_login NUMBER := fnd_global.user_id,
472: x_plan_relationship_id IN OUT NOCOPY NUMBER)
473: IS
466: p_layout_mode NUMBER,
467: p_auto_row_count NUMBER,
468: p_default_parent_spec VARCHAR2,
469: p_last_updated_by NUMBER := fnd_global.user_id,
470: p_created_by NUMBER := fnd_global.user_id,
471: p_last_update_login NUMBER := fnd_global.user_id,
472: x_plan_relationship_id IN OUT NOCOPY NUMBER)
473: IS
474:
467: p_auto_row_count NUMBER,
468: p_default_parent_spec VARCHAR2,
469: p_last_updated_by NUMBER := fnd_global.user_id,
470: p_created_by NUMBER := fnd_global.user_id,
471: p_last_update_login NUMBER := fnd_global.user_id,
472: x_plan_relationship_id IN OUT NOCOPY NUMBER)
473: IS
474:
475: l_sysdate DATE;
621: p_parent_char_id NUMBER,
622: p_child_char_id NUMBER,
623: p_element_relationship_type NUMBER,
624: p_link_flag VARCHAR2,
625: p_last_updated_by NUMBER := fnd_global.user_id,
626: p_created_by NUMBER := fnd_global.user_id,
627: p_last_update_login NUMBER := fnd_global.user_id,
628: x_element_relationship_id OUT NOCOPY NUMBER) IS
629:
622: p_child_char_id NUMBER,
623: p_element_relationship_type NUMBER,
624: p_link_flag VARCHAR2,
625: p_last_updated_by NUMBER := fnd_global.user_id,
626: p_created_by NUMBER := fnd_global.user_id,
627: p_last_update_login NUMBER := fnd_global.user_id,
628: x_element_relationship_id OUT NOCOPY NUMBER) IS
629:
630: l_sysdate DATE;
623: p_element_relationship_type NUMBER,
624: p_link_flag VARCHAR2,
625: p_last_updated_by NUMBER := fnd_global.user_id,
626: p_created_by NUMBER := fnd_global.user_id,
627: p_last_update_login NUMBER := fnd_global.user_id,
628: x_element_relationship_id OUT NOCOPY NUMBER) IS
629:
630: l_sysdate DATE;
631: l_row_id VARCHAR2(1000);
664: p_low_value VARCHAR2,
665: -- p_low_value_id NUMBER,
666: p_high_value VARCHAR2,
667: -- p_high_value_id NUMBER,
668: p_last_updated_by NUMBER := fnd_global.user_id,
669: p_created_by NUMBER := fnd_global.user_id,
670: p_last_update_login NUMBER := fnd_global.user_id,
671: x_criteria_id OUT NOCOPY NUMBER) IS
672:
665: -- p_low_value_id NUMBER,
666: p_high_value VARCHAR2,
667: -- p_high_value_id NUMBER,
668: p_last_updated_by NUMBER := fnd_global.user_id,
669: p_created_by NUMBER := fnd_global.user_id,
670: p_last_update_login NUMBER := fnd_global.user_id,
671: x_criteria_id OUT NOCOPY NUMBER) IS
672:
673: l_sysdate DATE;
666: p_high_value VARCHAR2,
667: -- p_high_value_id NUMBER,
668: p_last_updated_by NUMBER := fnd_global.user_id,
669: p_created_by NUMBER := fnd_global.user_id,
670: p_last_update_login NUMBER := fnd_global.user_id,
671: x_criteria_id OUT NOCOPY NUMBER) IS
672:
673: l_sysdate DATE;
674: l_row_id VARCHAR2(1000);
706: p_data_entry_mode NUMBER,
707: p_layout_mode NUMBER,
708: p_auto_row_count NUMBER,
709: p_default_parent_spec VARCHAR2,
710: p_last_updated_by NUMBER:=fnd_global.user_id,
711: p_created_by NUMBER:=fnd_global.user_id,
712: p_last_update_login NUMBER:=fnd_global.user_id
713: ) IS
714: l_sysdate DATE;
707: p_layout_mode NUMBER,
708: p_auto_row_count NUMBER,
709: p_default_parent_spec VARCHAR2,
710: p_last_updated_by NUMBER:=fnd_global.user_id,
711: p_created_by NUMBER:=fnd_global.user_id,
712: p_last_update_login NUMBER:=fnd_global.user_id
713: ) IS
714: l_sysdate DATE;
715: l_rowid VARCHAR2(1000);
708: p_auto_row_count NUMBER,
709: p_default_parent_spec VARCHAR2,
710: p_last_updated_by NUMBER:=fnd_global.user_id,
711: p_created_by NUMBER:=fnd_global.user_id,
712: p_last_update_login NUMBER:=fnd_global.user_id
713: ) IS
714: l_sysdate DATE;
715: l_rowid VARCHAR2(1000);
716: l_default_parent_spec NUMBER := 2;
759: p_parent_char_id NUMBER,
760: p_child_char_id NUMBER,
761: p_element_relationship_type NUMBER,
762: p_link_flag VARCHAR2,
763: p_last_updated_by NUMBER := fnd_global.user_id,
764: p_created_by NUMBER := fnd_global.user_id,
765: p_last_update_login NUMBER := fnd_global.user_id,
766: p_row_id VARCHAR2) IS
767:
760: p_child_char_id NUMBER,
761: p_element_relationship_type NUMBER,
762: p_link_flag VARCHAR2,
763: p_last_updated_by NUMBER := fnd_global.user_id,
764: p_created_by NUMBER := fnd_global.user_id,
765: p_last_update_login NUMBER := fnd_global.user_id,
766: p_row_id VARCHAR2) IS
767:
768: l_sysdate DATE;
761: p_element_relationship_type NUMBER,
762: p_link_flag VARCHAR2,
763: p_last_updated_by NUMBER := fnd_global.user_id,
764: p_created_by NUMBER := fnd_global.user_id,
765: p_last_update_login NUMBER := fnd_global.user_id,
766: p_row_id VARCHAR2) IS
767:
768: l_sysdate DATE;
769: l_row_id VARCHAR2(1000);
803: p_char_id NUMBER,
804: p_operator NUMBER,
805: p_low_value VARCHAR2,
806: p_high_value VARCHAR2,
807: p_last_updated_by NUMBER := fnd_global.user_id,
808: p_created_by NUMBER := fnd_global.user_id,
809: p_last_update_login NUMBER := fnd_global.user_id,
810: p_criteria_id NUMBER) IS
811:
804: p_operator NUMBER,
805: p_low_value VARCHAR2,
806: p_high_value VARCHAR2,
807: p_last_updated_by NUMBER := fnd_global.user_id,
808: p_created_by NUMBER := fnd_global.user_id,
809: p_last_update_login NUMBER := fnd_global.user_id,
810: p_criteria_id NUMBER) IS
811:
812: l_sysdate DATE;
805: p_low_value VARCHAR2,
806: p_high_value VARCHAR2,
807: p_last_updated_by NUMBER := fnd_global.user_id,
808: p_created_by NUMBER := fnd_global.user_id,
809: p_last_update_login NUMBER := fnd_global.user_id,
810: p_criteria_id NUMBER) IS
811:
812: l_sysdate DATE;
813: