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.GL_REP_ATTRIBUTES dependencies on DBMS_SQL

Line 730: li_cursor_id :=DBMS_SQL.OPEN_CURSOR;

726: BEGIN
727: --------------------------------
728: --Open the cursor for attributes
729: --------------------------------
730: li_cursor_id :=DBMS_SQL.OPEN_CURSOR;
731: DBMS_SQL.PARSE(li_cursor_id,lc_select_stmt,DBMS_SQL.v7);
732: dbms_sql.bind_variable(li_cursor_id, ':ln_p_coa_id',ln_p_coa_id);
733: IF ln_params <> 2 THEN
734: dbms_sql.bind_variable(li_cursor_id, ':lc_p_segment_name',lc_p_segment_name);

Line 731: DBMS_SQL.PARSE(li_cursor_id,lc_select_stmt,DBMS_SQL.v7);

727: --------------------------------
728: --Open the cursor for attributes
729: --------------------------------
730: li_cursor_id :=DBMS_SQL.OPEN_CURSOR;
731: DBMS_SQL.PARSE(li_cursor_id,lc_select_stmt,DBMS_SQL.v7);
732: dbms_sql.bind_variable(li_cursor_id, ':ln_p_coa_id',ln_p_coa_id);
733: IF ln_params <> 2 THEN
734: dbms_sql.bind_variable(li_cursor_id, ':lc_p_segment_name',lc_p_segment_name);
735: dbms_sql.bind_variable(li_cursor_id, ':lc_p_denorm_seg',lc_p_denorm_seg);

Line 732: dbms_sql.bind_variable(li_cursor_id, ':ln_p_coa_id',ln_p_coa_id);

728: --Open the cursor for attributes
729: --------------------------------
730: li_cursor_id :=DBMS_SQL.OPEN_CURSOR;
731: DBMS_SQL.PARSE(li_cursor_id,lc_select_stmt,DBMS_SQL.v7);
732: dbms_sql.bind_variable(li_cursor_id, ':ln_p_coa_id',ln_p_coa_id);
733: IF ln_params <> 2 THEN
734: dbms_sql.bind_variable(li_cursor_id, ':lc_p_segment_name',lc_p_segment_name);
735: dbms_sql.bind_variable(li_cursor_id, ':lc_p_denorm_seg',lc_p_denorm_seg);
736: END IF;

Line 734: dbms_sql.bind_variable(li_cursor_id, ':lc_p_segment_name',lc_p_segment_name);

730: li_cursor_id :=DBMS_SQL.OPEN_CURSOR;
731: DBMS_SQL.PARSE(li_cursor_id,lc_select_stmt,DBMS_SQL.v7);
732: dbms_sql.bind_variable(li_cursor_id, ':ln_p_coa_id',ln_p_coa_id);
733: IF ln_params <> 2 THEN
734: dbms_sql.bind_variable(li_cursor_id, ':lc_p_segment_name',lc_p_segment_name);
735: dbms_sql.bind_variable(li_cursor_id, ':lc_p_denorm_seg',lc_p_denorm_seg);
736: END IF;
737:
738: -----------------------------------------

Line 735: dbms_sql.bind_variable(li_cursor_id, ':lc_p_denorm_seg',lc_p_denorm_seg);

731: DBMS_SQL.PARSE(li_cursor_id,lc_select_stmt,DBMS_SQL.v7);
732: dbms_sql.bind_variable(li_cursor_id, ':ln_p_coa_id',ln_p_coa_id);
733: IF ln_params <> 2 THEN
734: dbms_sql.bind_variable(li_cursor_id, ':lc_p_segment_name',lc_p_segment_name);
735: dbms_sql.bind_variable(li_cursor_id, ':lc_p_denorm_seg',lc_p_denorm_seg);
736: END IF;
737:
738: -----------------------------------------
739: --Assign variables for the cursor columns

Line 742: DBMS_SQL.DEFINE_COLUMN(li_cursor_id,1,ln_flex_value_set_id);

738: -----------------------------------------
739: --Assign variables for the cursor columns
740: -----------------------------------------
741: IF ln_params = 2 THEN
742: DBMS_SQL.DEFINE_COLUMN(li_cursor_id,1,ln_flex_value_set_id);
743: DBMS_SQL.DEFINE_COLUMN(li_cursor_id,2,lc_attribute_num,30);
744: DBMS_SQL.DEFINE_COLUMN(li_cursor_id,3,ln_table_id);
745: DBMS_SQL.DEFINE_COLUMN(li_cursor_id,4,lc_application_column_name,30);
746: DBMS_SQL.DEFINE_COLUMN(li_cursor_id,5,lc_segment_name,30);

Line 743: DBMS_SQL.DEFINE_COLUMN(li_cursor_id,2,lc_attribute_num,30);

739: --Assign variables for the cursor columns
740: -----------------------------------------
741: IF ln_params = 2 THEN
742: DBMS_SQL.DEFINE_COLUMN(li_cursor_id,1,ln_flex_value_set_id);
743: DBMS_SQL.DEFINE_COLUMN(li_cursor_id,2,lc_attribute_num,30);
744: DBMS_SQL.DEFINE_COLUMN(li_cursor_id,3,ln_table_id);
745: DBMS_SQL.DEFINE_COLUMN(li_cursor_id,4,lc_application_column_name,30);
746: DBMS_SQL.DEFINE_COLUMN(li_cursor_id,5,lc_segment_name,30);
747: DBMS_SQL.DEFINE_COLUMN(li_cursor_id,6,ln_segment_num);

Line 744: DBMS_SQL.DEFINE_COLUMN(li_cursor_id,3,ln_table_id);

740: -----------------------------------------
741: IF ln_params = 2 THEN
742: DBMS_SQL.DEFINE_COLUMN(li_cursor_id,1,ln_flex_value_set_id);
743: DBMS_SQL.DEFINE_COLUMN(li_cursor_id,2,lc_attribute_num,30);
744: DBMS_SQL.DEFINE_COLUMN(li_cursor_id,3,ln_table_id);
745: DBMS_SQL.DEFINE_COLUMN(li_cursor_id,4,lc_application_column_name,30);
746: DBMS_SQL.DEFINE_COLUMN(li_cursor_id,5,lc_segment_name,30);
747: DBMS_SQL.DEFINE_COLUMN(li_cursor_id,6,ln_segment_num);
748: DBMS_SQL.DEFINE_COLUMN(li_cursor_id,7,lc_validation_type,1);

Line 745: DBMS_SQL.DEFINE_COLUMN(li_cursor_id,4,lc_application_column_name,30);

741: IF ln_params = 2 THEN
742: DBMS_SQL.DEFINE_COLUMN(li_cursor_id,1,ln_flex_value_set_id);
743: DBMS_SQL.DEFINE_COLUMN(li_cursor_id,2,lc_attribute_num,30);
744: DBMS_SQL.DEFINE_COLUMN(li_cursor_id,3,ln_table_id);
745: DBMS_SQL.DEFINE_COLUMN(li_cursor_id,4,lc_application_column_name,30);
746: DBMS_SQL.DEFINE_COLUMN(li_cursor_id,5,lc_segment_name,30);
747: DBMS_SQL.DEFINE_COLUMN(li_cursor_id,6,ln_segment_num);
748: DBMS_SQL.DEFINE_COLUMN(li_cursor_id,7,lc_validation_type,1);
749: DBMS_SQL.DEFINE_COLUMN(li_cursor_id,8,lc_attr_segment_name,30);

Line 746: DBMS_SQL.DEFINE_COLUMN(li_cursor_id,5,lc_segment_name,30);

742: DBMS_SQL.DEFINE_COLUMN(li_cursor_id,1,ln_flex_value_set_id);
743: DBMS_SQL.DEFINE_COLUMN(li_cursor_id,2,lc_attribute_num,30);
744: DBMS_SQL.DEFINE_COLUMN(li_cursor_id,3,ln_table_id);
745: DBMS_SQL.DEFINE_COLUMN(li_cursor_id,4,lc_application_column_name,30);
746: DBMS_SQL.DEFINE_COLUMN(li_cursor_id,5,lc_segment_name,30);
747: DBMS_SQL.DEFINE_COLUMN(li_cursor_id,6,ln_segment_num);
748: DBMS_SQL.DEFINE_COLUMN(li_cursor_id,7,lc_validation_type,1);
749: DBMS_SQL.DEFINE_COLUMN(li_cursor_id,8,lc_attr_segment_name,30);
750: ELSE

Line 747: DBMS_SQL.DEFINE_COLUMN(li_cursor_id,6,ln_segment_num);

743: DBMS_SQL.DEFINE_COLUMN(li_cursor_id,2,lc_attribute_num,30);
744: DBMS_SQL.DEFINE_COLUMN(li_cursor_id,3,ln_table_id);
745: DBMS_SQL.DEFINE_COLUMN(li_cursor_id,4,lc_application_column_name,30);
746: DBMS_SQL.DEFINE_COLUMN(li_cursor_id,5,lc_segment_name,30);
747: DBMS_SQL.DEFINE_COLUMN(li_cursor_id,6,ln_segment_num);
748: DBMS_SQL.DEFINE_COLUMN(li_cursor_id,7,lc_validation_type,1);
749: DBMS_SQL.DEFINE_COLUMN(li_cursor_id,8,lc_attr_segment_name,30);
750: ELSE
751: DBMS_SQL.DEFINE_COLUMN(li_cursor_id,1,ln_flex_value_set_id);

Line 748: DBMS_SQL.DEFINE_COLUMN(li_cursor_id,7,lc_validation_type,1);

744: DBMS_SQL.DEFINE_COLUMN(li_cursor_id,3,ln_table_id);
745: DBMS_SQL.DEFINE_COLUMN(li_cursor_id,4,lc_application_column_name,30);
746: DBMS_SQL.DEFINE_COLUMN(li_cursor_id,5,lc_segment_name,30);
747: DBMS_SQL.DEFINE_COLUMN(li_cursor_id,6,ln_segment_num);
748: DBMS_SQL.DEFINE_COLUMN(li_cursor_id,7,lc_validation_type,1);
749: DBMS_SQL.DEFINE_COLUMN(li_cursor_id,8,lc_attr_segment_name,30);
750: ELSE
751: DBMS_SQL.DEFINE_COLUMN(li_cursor_id,1,ln_flex_value_set_id);
752: DBMS_SQL.DEFINE_COLUMN(li_cursor_id,2,lc_attribute_num,30);

Line 749: DBMS_SQL.DEFINE_COLUMN(li_cursor_id,8,lc_attr_segment_name,30);

745: DBMS_SQL.DEFINE_COLUMN(li_cursor_id,4,lc_application_column_name,30);
746: DBMS_SQL.DEFINE_COLUMN(li_cursor_id,5,lc_segment_name,30);
747: DBMS_SQL.DEFINE_COLUMN(li_cursor_id,6,ln_segment_num);
748: DBMS_SQL.DEFINE_COLUMN(li_cursor_id,7,lc_validation_type,1);
749: DBMS_SQL.DEFINE_COLUMN(li_cursor_id,8,lc_attr_segment_name,30);
750: ELSE
751: DBMS_SQL.DEFINE_COLUMN(li_cursor_id,1,ln_flex_value_set_id);
752: DBMS_SQL.DEFINE_COLUMN(li_cursor_id,2,lc_attribute_num,30);
753: DBMS_SQL.DEFINE_COLUMN(li_cursor_id,3,ln_table_id);

Line 751: DBMS_SQL.DEFINE_COLUMN(li_cursor_id,1,ln_flex_value_set_id);

747: DBMS_SQL.DEFINE_COLUMN(li_cursor_id,6,ln_segment_num);
748: DBMS_SQL.DEFINE_COLUMN(li_cursor_id,7,lc_validation_type,1);
749: DBMS_SQL.DEFINE_COLUMN(li_cursor_id,8,lc_attr_segment_name,30);
750: ELSE
751: DBMS_SQL.DEFINE_COLUMN(li_cursor_id,1,ln_flex_value_set_id);
752: DBMS_SQL.DEFINE_COLUMN(li_cursor_id,2,lc_attribute_num,30);
753: DBMS_SQL.DEFINE_COLUMN(li_cursor_id,3,ln_table_id);
754: DBMS_SQL.DEFINE_COLUMN(li_cursor_id,4,lc_application_column_name,30);
755: DBMS_SQL.DEFINE_COLUMN(li_cursor_id,5,lc_segment_name,30);

Line 752: DBMS_SQL.DEFINE_COLUMN(li_cursor_id,2,lc_attribute_num,30);

748: DBMS_SQL.DEFINE_COLUMN(li_cursor_id,7,lc_validation_type,1);
749: DBMS_SQL.DEFINE_COLUMN(li_cursor_id,8,lc_attr_segment_name,30);
750: ELSE
751: DBMS_SQL.DEFINE_COLUMN(li_cursor_id,1,ln_flex_value_set_id);
752: DBMS_SQL.DEFINE_COLUMN(li_cursor_id,2,lc_attribute_num,30);
753: DBMS_SQL.DEFINE_COLUMN(li_cursor_id,3,ln_table_id);
754: DBMS_SQL.DEFINE_COLUMN(li_cursor_id,4,lc_application_column_name,30);
755: DBMS_SQL.DEFINE_COLUMN(li_cursor_id,5,lc_segment_name,30);
756: DBMS_SQL.DEFINE_COLUMN(li_cursor_id,6,ln_segment_num);

Line 753: DBMS_SQL.DEFINE_COLUMN(li_cursor_id,3,ln_table_id);

749: DBMS_SQL.DEFINE_COLUMN(li_cursor_id,8,lc_attr_segment_name,30);
750: ELSE
751: DBMS_SQL.DEFINE_COLUMN(li_cursor_id,1,ln_flex_value_set_id);
752: DBMS_SQL.DEFINE_COLUMN(li_cursor_id,2,lc_attribute_num,30);
753: DBMS_SQL.DEFINE_COLUMN(li_cursor_id,3,ln_table_id);
754: DBMS_SQL.DEFINE_COLUMN(li_cursor_id,4,lc_application_column_name,30);
755: DBMS_SQL.DEFINE_COLUMN(li_cursor_id,5,lc_segment_name,30);
756: DBMS_SQL.DEFINE_COLUMN(li_cursor_id,6,ln_segment_num);
757: DBMS_SQL.DEFINE_COLUMN(li_cursor_id,7,lc_validation_type,1);

Line 754: DBMS_SQL.DEFINE_COLUMN(li_cursor_id,4,lc_application_column_name,30);

750: ELSE
751: DBMS_SQL.DEFINE_COLUMN(li_cursor_id,1,ln_flex_value_set_id);
752: DBMS_SQL.DEFINE_COLUMN(li_cursor_id,2,lc_attribute_num,30);
753: DBMS_SQL.DEFINE_COLUMN(li_cursor_id,3,ln_table_id);
754: DBMS_SQL.DEFINE_COLUMN(li_cursor_id,4,lc_application_column_name,30);
755: DBMS_SQL.DEFINE_COLUMN(li_cursor_id,5,lc_segment_name,30);
756: DBMS_SQL.DEFINE_COLUMN(li_cursor_id,6,ln_segment_num);
757: DBMS_SQL.DEFINE_COLUMN(li_cursor_id,7,lc_validation_type,1);
758: END IF;

Line 755: DBMS_SQL.DEFINE_COLUMN(li_cursor_id,5,lc_segment_name,30);

751: DBMS_SQL.DEFINE_COLUMN(li_cursor_id,1,ln_flex_value_set_id);
752: DBMS_SQL.DEFINE_COLUMN(li_cursor_id,2,lc_attribute_num,30);
753: DBMS_SQL.DEFINE_COLUMN(li_cursor_id,3,ln_table_id);
754: DBMS_SQL.DEFINE_COLUMN(li_cursor_id,4,lc_application_column_name,30);
755: DBMS_SQL.DEFINE_COLUMN(li_cursor_id,5,lc_segment_name,30);
756: DBMS_SQL.DEFINE_COLUMN(li_cursor_id,6,ln_segment_num);
757: DBMS_SQL.DEFINE_COLUMN(li_cursor_id,7,lc_validation_type,1);
758: END IF;
759: -----------------------------------

Line 756: DBMS_SQL.DEFINE_COLUMN(li_cursor_id,6,ln_segment_num);

752: DBMS_SQL.DEFINE_COLUMN(li_cursor_id,2,lc_attribute_num,30);
753: DBMS_SQL.DEFINE_COLUMN(li_cursor_id,3,ln_table_id);
754: DBMS_SQL.DEFINE_COLUMN(li_cursor_id,4,lc_application_column_name,30);
755: DBMS_SQL.DEFINE_COLUMN(li_cursor_id,5,lc_segment_name,30);
756: DBMS_SQL.DEFINE_COLUMN(li_cursor_id,6,ln_segment_num);
757: DBMS_SQL.DEFINE_COLUMN(li_cursor_id,7,lc_validation_type,1);
758: END IF;
759: -----------------------------------
760: --Execute the cursor for attributes

Line 757: DBMS_SQL.DEFINE_COLUMN(li_cursor_id,7,lc_validation_type,1);

753: DBMS_SQL.DEFINE_COLUMN(li_cursor_id,3,ln_table_id);
754: DBMS_SQL.DEFINE_COLUMN(li_cursor_id,4,lc_application_column_name,30);
755: DBMS_SQL.DEFINE_COLUMN(li_cursor_id,5,lc_segment_name,30);
756: DBMS_SQL.DEFINE_COLUMN(li_cursor_id,6,ln_segment_num);
757: DBMS_SQL.DEFINE_COLUMN(li_cursor_id,7,lc_validation_type,1);
758: END IF;
759: -----------------------------------
760: --Execute the cursor for attributes
761: -----------------------------------

Line 762: li_dummy:=DBMS_SQL.EXECUTE(li_cursor_id);

758: END IF;
759: -----------------------------------
760: --Execute the cursor for attributes
761: -----------------------------------
762: li_dummy:=DBMS_SQL.EXECUTE(li_cursor_id);
763: --
764: -----------------------------------------
765: --Start building the the update statement
766: -----------------------------------------

Line 773: IF DBMS_SQL.FETCH_ROWS(li_cursor_id) = 0 THEN

769: LOOP
770: -------------------------------
771: --Fetch each row for attributes
772: -------------------------------
773: IF DBMS_SQL.FETCH_ROWS(li_cursor_id) = 0 THEN
774: EXIT;
775: END IF;
776: IF ln_params=2 THEN
777: DBMS_SQL.COLUMN_VALUE(li_cursor_id,1,ln_flex_value_set_id);

Line 777: DBMS_SQL.COLUMN_VALUE(li_cursor_id,1,ln_flex_value_set_id);

773: IF DBMS_SQL.FETCH_ROWS(li_cursor_id) = 0 THEN
774: EXIT;
775: END IF;
776: IF ln_params=2 THEN
777: DBMS_SQL.COLUMN_VALUE(li_cursor_id,1,ln_flex_value_set_id);
778: DBMS_SQL.COLUMN_VALUE(li_cursor_id,2,lc_attribute_num);
779: DBMS_SQL.COLUMN_VALUE(li_cursor_id,3,ln_table_id);
780: DBMS_SQL.COLUMN_VALUE(li_cursor_id,4,lc_application_column_name);
781: DBMS_SQL.COLUMN_VALUE(li_cursor_id,5,lc_segment_name);

Line 778: DBMS_SQL.COLUMN_VALUE(li_cursor_id,2,lc_attribute_num);

774: EXIT;
775: END IF;
776: IF ln_params=2 THEN
777: DBMS_SQL.COLUMN_VALUE(li_cursor_id,1,ln_flex_value_set_id);
778: DBMS_SQL.COLUMN_VALUE(li_cursor_id,2,lc_attribute_num);
779: DBMS_SQL.COLUMN_VALUE(li_cursor_id,3,ln_table_id);
780: DBMS_SQL.COLUMN_VALUE(li_cursor_id,4,lc_application_column_name);
781: DBMS_SQL.COLUMN_VALUE(li_cursor_id,5,lc_segment_name);
782: DBMS_SQL.COLUMN_VALUE(li_cursor_id,6,ln_segment_num);

Line 779: DBMS_SQL.COLUMN_VALUE(li_cursor_id,3,ln_table_id);

775: END IF;
776: IF ln_params=2 THEN
777: DBMS_SQL.COLUMN_VALUE(li_cursor_id,1,ln_flex_value_set_id);
778: DBMS_SQL.COLUMN_VALUE(li_cursor_id,2,lc_attribute_num);
779: DBMS_SQL.COLUMN_VALUE(li_cursor_id,3,ln_table_id);
780: DBMS_SQL.COLUMN_VALUE(li_cursor_id,4,lc_application_column_name);
781: DBMS_SQL.COLUMN_VALUE(li_cursor_id,5,lc_segment_name);
782: DBMS_SQL.COLUMN_VALUE(li_cursor_id,6,ln_segment_num);
783: DBMS_SQL.COLUMN_VALUE(li_cursor_id,7,lc_validation_type);

Line 780: DBMS_SQL.COLUMN_VALUE(li_cursor_id,4,lc_application_column_name);

776: IF ln_params=2 THEN
777: DBMS_SQL.COLUMN_VALUE(li_cursor_id,1,ln_flex_value_set_id);
778: DBMS_SQL.COLUMN_VALUE(li_cursor_id,2,lc_attribute_num);
779: DBMS_SQL.COLUMN_VALUE(li_cursor_id,3,ln_table_id);
780: DBMS_SQL.COLUMN_VALUE(li_cursor_id,4,lc_application_column_name);
781: DBMS_SQL.COLUMN_VALUE(li_cursor_id,5,lc_segment_name);
782: DBMS_SQL.COLUMN_VALUE(li_cursor_id,6,ln_segment_num);
783: DBMS_SQL.COLUMN_VALUE(li_cursor_id,7,lc_validation_type);
784: DBMS_SQL.COLUMN_VALUE(li_cursor_id,8,lc_attr_segment_name);

Line 781: DBMS_SQL.COLUMN_VALUE(li_cursor_id,5,lc_segment_name);

777: DBMS_SQL.COLUMN_VALUE(li_cursor_id,1,ln_flex_value_set_id);
778: DBMS_SQL.COLUMN_VALUE(li_cursor_id,2,lc_attribute_num);
779: DBMS_SQL.COLUMN_VALUE(li_cursor_id,3,ln_table_id);
780: DBMS_SQL.COLUMN_VALUE(li_cursor_id,4,lc_application_column_name);
781: DBMS_SQL.COLUMN_VALUE(li_cursor_id,5,lc_segment_name);
782: DBMS_SQL.COLUMN_VALUE(li_cursor_id,6,ln_segment_num);
783: DBMS_SQL.COLUMN_VALUE(li_cursor_id,7,lc_validation_type);
784: DBMS_SQL.COLUMN_VALUE(li_cursor_id,8,lc_attr_segment_name);
785: ELSE

Line 782: DBMS_SQL.COLUMN_VALUE(li_cursor_id,6,ln_segment_num);

778: DBMS_SQL.COLUMN_VALUE(li_cursor_id,2,lc_attribute_num);
779: DBMS_SQL.COLUMN_VALUE(li_cursor_id,3,ln_table_id);
780: DBMS_SQL.COLUMN_VALUE(li_cursor_id,4,lc_application_column_name);
781: DBMS_SQL.COLUMN_VALUE(li_cursor_id,5,lc_segment_name);
782: DBMS_SQL.COLUMN_VALUE(li_cursor_id,6,ln_segment_num);
783: DBMS_SQL.COLUMN_VALUE(li_cursor_id,7,lc_validation_type);
784: DBMS_SQL.COLUMN_VALUE(li_cursor_id,8,lc_attr_segment_name);
785: ELSE
786: DBMS_SQL.COLUMN_VALUE(li_cursor_id,1,ln_flex_value_set_id);

Line 783: DBMS_SQL.COLUMN_VALUE(li_cursor_id,7,lc_validation_type);

779: DBMS_SQL.COLUMN_VALUE(li_cursor_id,3,ln_table_id);
780: DBMS_SQL.COLUMN_VALUE(li_cursor_id,4,lc_application_column_name);
781: DBMS_SQL.COLUMN_VALUE(li_cursor_id,5,lc_segment_name);
782: DBMS_SQL.COLUMN_VALUE(li_cursor_id,6,ln_segment_num);
783: DBMS_SQL.COLUMN_VALUE(li_cursor_id,7,lc_validation_type);
784: DBMS_SQL.COLUMN_VALUE(li_cursor_id,8,lc_attr_segment_name);
785: ELSE
786: DBMS_SQL.COLUMN_VALUE(li_cursor_id,1,ln_flex_value_set_id);
787: DBMS_SQL.COLUMN_VALUE(li_cursor_id,2,lc_attribute_num);

Line 784: DBMS_SQL.COLUMN_VALUE(li_cursor_id,8,lc_attr_segment_name);

780: DBMS_SQL.COLUMN_VALUE(li_cursor_id,4,lc_application_column_name);
781: DBMS_SQL.COLUMN_VALUE(li_cursor_id,5,lc_segment_name);
782: DBMS_SQL.COLUMN_VALUE(li_cursor_id,6,ln_segment_num);
783: DBMS_SQL.COLUMN_VALUE(li_cursor_id,7,lc_validation_type);
784: DBMS_SQL.COLUMN_VALUE(li_cursor_id,8,lc_attr_segment_name);
785: ELSE
786: DBMS_SQL.COLUMN_VALUE(li_cursor_id,1,ln_flex_value_set_id);
787: DBMS_SQL.COLUMN_VALUE(li_cursor_id,2,lc_attribute_num);
788: DBMS_SQL.COLUMN_VALUE(li_cursor_id,3,ln_table_id);

Line 786: DBMS_SQL.COLUMN_VALUE(li_cursor_id,1,ln_flex_value_set_id);

782: DBMS_SQL.COLUMN_VALUE(li_cursor_id,6,ln_segment_num);
783: DBMS_SQL.COLUMN_VALUE(li_cursor_id,7,lc_validation_type);
784: DBMS_SQL.COLUMN_VALUE(li_cursor_id,8,lc_attr_segment_name);
785: ELSE
786: DBMS_SQL.COLUMN_VALUE(li_cursor_id,1,ln_flex_value_set_id);
787: DBMS_SQL.COLUMN_VALUE(li_cursor_id,2,lc_attribute_num);
788: DBMS_SQL.COLUMN_VALUE(li_cursor_id,3,ln_table_id);
789: DBMS_SQL.COLUMN_VALUE(li_cursor_id,4,lc_application_column_name);
790: DBMS_SQL.COLUMN_VALUE(li_cursor_id,5,lc_segment_name);

Line 787: DBMS_SQL.COLUMN_VALUE(li_cursor_id,2,lc_attribute_num);

783: DBMS_SQL.COLUMN_VALUE(li_cursor_id,7,lc_validation_type);
784: DBMS_SQL.COLUMN_VALUE(li_cursor_id,8,lc_attr_segment_name);
785: ELSE
786: DBMS_SQL.COLUMN_VALUE(li_cursor_id,1,ln_flex_value_set_id);
787: DBMS_SQL.COLUMN_VALUE(li_cursor_id,2,lc_attribute_num);
788: DBMS_SQL.COLUMN_VALUE(li_cursor_id,3,ln_table_id);
789: DBMS_SQL.COLUMN_VALUE(li_cursor_id,4,lc_application_column_name);
790: DBMS_SQL.COLUMN_VALUE(li_cursor_id,5,lc_segment_name);
791: DBMS_SQL.COLUMN_VALUE(li_cursor_id,6,ln_segment_num);

Line 788: DBMS_SQL.COLUMN_VALUE(li_cursor_id,3,ln_table_id);

784: DBMS_SQL.COLUMN_VALUE(li_cursor_id,8,lc_attr_segment_name);
785: ELSE
786: DBMS_SQL.COLUMN_VALUE(li_cursor_id,1,ln_flex_value_set_id);
787: DBMS_SQL.COLUMN_VALUE(li_cursor_id,2,lc_attribute_num);
788: DBMS_SQL.COLUMN_VALUE(li_cursor_id,3,ln_table_id);
789: DBMS_SQL.COLUMN_VALUE(li_cursor_id,4,lc_application_column_name);
790: DBMS_SQL.COLUMN_VALUE(li_cursor_id,5,lc_segment_name);
791: DBMS_SQL.COLUMN_VALUE(li_cursor_id,6,ln_segment_num);
792: DBMS_SQL.COLUMN_VALUE(li_cursor_id,7,lc_validation_type);

Line 789: DBMS_SQL.COLUMN_VALUE(li_cursor_id,4,lc_application_column_name);

785: ELSE
786: DBMS_SQL.COLUMN_VALUE(li_cursor_id,1,ln_flex_value_set_id);
787: DBMS_SQL.COLUMN_VALUE(li_cursor_id,2,lc_attribute_num);
788: DBMS_SQL.COLUMN_VALUE(li_cursor_id,3,ln_table_id);
789: DBMS_SQL.COLUMN_VALUE(li_cursor_id,4,lc_application_column_name);
790: DBMS_SQL.COLUMN_VALUE(li_cursor_id,5,lc_segment_name);
791: DBMS_SQL.COLUMN_VALUE(li_cursor_id,6,ln_segment_num);
792: DBMS_SQL.COLUMN_VALUE(li_cursor_id,7,lc_validation_type);
793: END IF;

Line 790: DBMS_SQL.COLUMN_VALUE(li_cursor_id,5,lc_segment_name);

786: DBMS_SQL.COLUMN_VALUE(li_cursor_id,1,ln_flex_value_set_id);
787: DBMS_SQL.COLUMN_VALUE(li_cursor_id,2,lc_attribute_num);
788: DBMS_SQL.COLUMN_VALUE(li_cursor_id,3,ln_table_id);
789: DBMS_SQL.COLUMN_VALUE(li_cursor_id,4,lc_application_column_name);
790: DBMS_SQL.COLUMN_VALUE(li_cursor_id,5,lc_segment_name);
791: DBMS_SQL.COLUMN_VALUE(li_cursor_id,6,ln_segment_num);
792: DBMS_SQL.COLUMN_VALUE(li_cursor_id,7,lc_validation_type);
793: END IF;
794:

Line 791: DBMS_SQL.COLUMN_VALUE(li_cursor_id,6,ln_segment_num);

787: DBMS_SQL.COLUMN_VALUE(li_cursor_id,2,lc_attribute_num);
788: DBMS_SQL.COLUMN_VALUE(li_cursor_id,3,ln_table_id);
789: DBMS_SQL.COLUMN_VALUE(li_cursor_id,4,lc_application_column_name);
790: DBMS_SQL.COLUMN_VALUE(li_cursor_id,5,lc_segment_name);
791: DBMS_SQL.COLUMN_VALUE(li_cursor_id,6,ln_segment_num);
792: DBMS_SQL.COLUMN_VALUE(li_cursor_id,7,lc_validation_type);
793: END IF;
794:
795: ----------------------------------

Line 792: DBMS_SQL.COLUMN_VALUE(li_cursor_id,7,lc_validation_type);

788: DBMS_SQL.COLUMN_VALUE(li_cursor_id,3,ln_table_id);
789: DBMS_SQL.COLUMN_VALUE(li_cursor_id,4,lc_application_column_name);
790: DBMS_SQL.COLUMN_VALUE(li_cursor_id,5,lc_segment_name);
791: DBMS_SQL.COLUMN_VALUE(li_cursor_id,6,ln_segment_num);
792: DBMS_SQL.COLUMN_VALUE(li_cursor_id,7,lc_validation_type);
793: END IF;
794:
795: ----------------------------------
796: --If the validation is independent

Line 867: li_cursor_id2:=DBMS_SQL.OPEN_CURSOR;

863:
864: ----------------------------------------------
865: --Open, Parse and Execute the Update statement
866: ----------------------------------------------
867: li_cursor_id2:=DBMS_SQL.OPEN_CURSOR;
868: --
869: DBMS_SQL.PARSE(li_cursor_id2,lc_sql_stmt,DBMS_SQL.v7);
870: dbms_sql.bind_variable(li_cursor_id2, ':ln_p_coa_id',ln_p_coa_id);
871: --

Line 869: DBMS_SQL.PARSE(li_cursor_id2,lc_sql_stmt,DBMS_SQL.v7);

865: --Open, Parse and Execute the Update statement
866: ----------------------------------------------
867: li_cursor_id2:=DBMS_SQL.OPEN_CURSOR;
868: --
869: DBMS_SQL.PARSE(li_cursor_id2,lc_sql_stmt,DBMS_SQL.v7);
870: dbms_sql.bind_variable(li_cursor_id2, ':ln_p_coa_id',ln_p_coa_id);
871: --
872: li_dummy1:=DBMS_SQL.EXECUTE(li_cursor_id2);
873: --

Line 870: dbms_sql.bind_variable(li_cursor_id2, ':ln_p_coa_id',ln_p_coa_id);

866: ----------------------------------------------
867: li_cursor_id2:=DBMS_SQL.OPEN_CURSOR;
868: --
869: DBMS_SQL.PARSE(li_cursor_id2,lc_sql_stmt,DBMS_SQL.v7);
870: dbms_sql.bind_variable(li_cursor_id2, ':ln_p_coa_id',ln_p_coa_id);
871: --
872: li_dummy1:=DBMS_SQL.EXECUTE(li_cursor_id2);
873: --
874: DBMS_SQL.CLOSE_CURSOR(li_cursor_id);

Line 872: li_dummy1:=DBMS_SQL.EXECUTE(li_cursor_id2);

868: --
869: DBMS_SQL.PARSE(li_cursor_id2,lc_sql_stmt,DBMS_SQL.v7);
870: dbms_sql.bind_variable(li_cursor_id2, ':ln_p_coa_id',ln_p_coa_id);
871: --
872: li_dummy1:=DBMS_SQL.EXECUTE(li_cursor_id2);
873: --
874: DBMS_SQL.CLOSE_CURSOR(li_cursor_id);
875: --
876:

Line 874: DBMS_SQL.CLOSE_CURSOR(li_cursor_id);

870: dbms_sql.bind_variable(li_cursor_id2, ':ln_p_coa_id',ln_p_coa_id);
871: --
872: li_dummy1:=DBMS_SQL.EXECUTE(li_cursor_id2);
873: --
874: DBMS_SQL.CLOSE_CURSOR(li_cursor_id);
875: --
876:
877: COMMIT;
878: