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

Line 866: l_CursorID := dbms_sql.open_cursor;

862: l_statement := l_statement || ' ORDER BY T.LAST_UPDATE_DATE desc ';
863: End If;
864:
865: -- Prepare dynamic sql statement
866: l_CursorID := dbms_sql.open_cursor;
867:
868: dbms_sql.parse(l_CursorID, l_statement, dbms_sql.NATIVE);
869: dbms_sql.define_column(l_CursorID, 1, l_template_id);
870: dbms_sql.define_column(l_CursorID, 2, l_template_name,500);

Line 868: dbms_sql.parse(l_CursorID, l_statement, dbms_sql.NATIVE);

864:
865: -- Prepare dynamic sql statement
866: l_CursorID := dbms_sql.open_cursor;
867:
868: dbms_sql.parse(l_CursorID, l_statement, dbms_sql.NATIVE);
869: dbms_sql.define_column(l_CursorID, 1, l_template_id);
870: dbms_sql.define_column(l_CursorID, 2, l_template_name,500);
871: dbms_sql.define_column(l_CursorID, 3, l_start_date_active);
872: dbms_sql.define_column(l_CursorID, 4, l_end_date_active);

Line 869: dbms_sql.define_column(l_CursorID, 1, l_template_id);

865: -- Prepare dynamic sql statement
866: l_CursorID := dbms_sql.open_cursor;
867:
868: dbms_sql.parse(l_CursorID, l_statement, dbms_sql.NATIVE);
869: dbms_sql.define_column(l_CursorID, 1, l_template_id);
870: dbms_sql.define_column(l_CursorID, 2, l_template_name,500);
871: dbms_sql.define_column(l_CursorID, 3, l_start_date_active);
872: dbms_sql.define_column(l_CursorID, 4, l_end_date_active);
873: dbms_sql.define_column(l_CursorID, 5, l_default_flag, 60);

Line 870: dbms_sql.define_column(l_CursorID, 2, l_template_name,500);

866: l_CursorID := dbms_sql.open_cursor;
867:
868: dbms_sql.parse(l_CursorID, l_statement, dbms_sql.NATIVE);
869: dbms_sql.define_column(l_CursorID, 1, l_template_id);
870: dbms_sql.define_column(l_CursorID, 2, l_template_name,500);
871: dbms_sql.define_column(l_CursorID, 3, l_start_date_active);
872: dbms_sql.define_column(l_CursorID, 4, l_end_date_active);
873: dbms_sql.define_column(l_CursorID, 5, l_default_flag, 60);
874: dbms_sql.define_column(l_CursorID, 6, l_last_updated_date);

Line 871: dbms_sql.define_column(l_CursorID, 3, l_start_date_active);

867:
868: dbms_sql.parse(l_CursorID, l_statement, dbms_sql.NATIVE);
869: dbms_sql.define_column(l_CursorID, 1, l_template_id);
870: dbms_sql.define_column(l_CursorID, 2, l_template_name,500);
871: dbms_sql.define_column(l_CursorID, 3, l_start_date_active);
872: dbms_sql.define_column(l_CursorID, 4, l_end_date_active);
873: dbms_sql.define_column(l_CursorID, 5, l_default_flag, 60);
874: dbms_sql.define_column(l_CursorID, 6, l_last_updated_date);
875: dbms_sql.define_column(l_CursorID, 7, l_short_code, 150);

Line 872: dbms_sql.define_column(l_CursorID, 4, l_end_date_active);

868: dbms_sql.parse(l_CursorID, l_statement, dbms_sql.NATIVE);
869: dbms_sql.define_column(l_CursorID, 1, l_template_id);
870: dbms_sql.define_column(l_CursorID, 2, l_template_name,500);
871: dbms_sql.define_column(l_CursorID, 3, l_start_date_active);
872: dbms_sql.define_column(l_CursorID, 4, l_end_date_active);
873: dbms_sql.define_column(l_CursorID, 5, l_default_flag, 60);
874: dbms_sql.define_column(l_CursorID, 6, l_last_updated_date);
875: dbms_sql.define_column(l_CursorID, 7, l_short_code, 150);
876: dbms_sql.define_column(l_CursorID, 8, l_uni_question_note_flag,1);

Line 873: dbms_sql.define_column(l_CursorID, 5, l_default_flag, 60);

869: dbms_sql.define_column(l_CursorID, 1, l_template_id);
870: dbms_sql.define_column(l_CursorID, 2, l_template_name,500);
871: dbms_sql.define_column(l_CursorID, 3, l_start_date_active);
872: dbms_sql.define_column(l_CursorID, 4, l_end_date_active);
873: dbms_sql.define_column(l_CursorID, 5, l_default_flag, 60);
874: dbms_sql.define_column(l_CursorID, 6, l_last_updated_date);
875: dbms_sql.define_column(l_CursorID, 7, l_short_code, 150);
876: dbms_sql.define_column(l_CursorID, 8, l_uni_question_note_flag,1);
877: dbms_sql.define_column(l_CursorID, 9, l_uni_question_note_type, 30);

Line 874: dbms_sql.define_column(l_CursorID, 6, l_last_updated_date);

870: dbms_sql.define_column(l_CursorID, 2, l_template_name,500);
871: dbms_sql.define_column(l_CursorID, 3, l_start_date_active);
872: dbms_sql.define_column(l_CursorID, 4, l_end_date_active);
873: dbms_sql.define_column(l_CursorID, 5, l_default_flag, 60);
874: dbms_sql.define_column(l_CursorID, 6, l_last_updated_date);
875: dbms_sql.define_column(l_CursorID, 7, l_short_code, 150);
876: dbms_sql.define_column(l_CursorID, 8, l_uni_question_note_flag,1);
877: dbms_sql.define_column(l_CursorID, 9, l_uni_question_note_type, 30);
878:

Line 875: dbms_sql.define_column(l_CursorID, 7, l_short_code, 150);

871: dbms_sql.define_column(l_CursorID, 3, l_start_date_active);
872: dbms_sql.define_column(l_CursorID, 4, l_end_date_active);
873: dbms_sql.define_column(l_CursorID, 5, l_default_flag, 60);
874: dbms_sql.define_column(l_CursorID, 6, l_last_updated_date);
875: dbms_sql.define_column(l_CursorID, 7, l_short_code, 150);
876: dbms_sql.define_column(l_CursorID, 8, l_uni_question_note_flag,1);
877: dbms_sql.define_column(l_CursorID, 9, l_uni_question_note_type, 30);
878:
879: If (p_template_name Is Not Null

Line 876: dbms_sql.define_column(l_CursorID, 8, l_uni_question_note_flag,1);

872: dbms_sql.define_column(l_CursorID, 4, l_end_date_active);
873: dbms_sql.define_column(l_CursorID, 5, l_default_flag, 60);
874: dbms_sql.define_column(l_CursorID, 6, l_last_updated_date);
875: dbms_sql.define_column(l_CursorID, 7, l_short_code, 150);
876: dbms_sql.define_column(l_CursorID, 8, l_uni_question_note_flag,1);
877: dbms_sql.define_column(l_CursorID, 9, l_uni_question_note_type, 30);
878:
879: If (p_template_name Is Not Null
880: and p_template_name <> FND_API.G_MISS_CHAR

Line 877: dbms_sql.define_column(l_CursorID, 9, l_uni_question_note_type, 30);

873: dbms_sql.define_column(l_CursorID, 5, l_default_flag, 60);
874: dbms_sql.define_column(l_CursorID, 6, l_last_updated_date);
875: dbms_sql.define_column(l_CursorID, 7, l_short_code, 150);
876: dbms_sql.define_column(l_CursorID, 8, l_uni_question_note_flag,1);
877: dbms_sql.define_column(l_CursorID, 9, l_uni_question_note_type, 30);
878:
879: If (p_template_name Is Not Null
880: and p_template_name <> FND_API.G_MISS_CHAR
881: and length(P_Template_Name) > 0) Then

Line 882: dbms_sql.bind_variable(l_CursorID, 'v_Template_Name', P_Template_Name);

878:
879: If (p_template_name Is Not Null
880: and p_template_name <> FND_API.G_MISS_CHAR
881: and length(P_Template_Name) > 0) Then
882: dbms_sql.bind_variable(l_CursorID, 'v_Template_Name', P_Template_Name);
883: End If;
884:
885: l_total_templates_notused := dbms_sql.execute(l_CursorID);
886:

Line 885: l_total_templates_notused := dbms_sql.execute(l_CursorID);

881: and length(P_Template_Name) > 0) Then
882: dbms_sql.bind_variable(l_CursorID, 'v_Template_Name', P_Template_Name);
883: End If;
884:
885: l_total_templates_notused := dbms_sql.execute(l_CursorID);
886:
887: i:=1;
888: j:=0;
889: --l_date_format := get_date_format;

Line 893: While (dbms_sql.fetch_rows(l_CursorID) > 0) Loop

889: --l_date_format := get_date_format;
890: l_date_format := get_date_format_from_user_two;
891: l_default_update_format2 :=
892: get_date_format_from_user_two||' HH24:MI:SS';
893: While (dbms_sql.fetch_rows(l_CursorID) > 0) Loop
894: If (i >= l_start_template and i <= l_end_template) Then
895: dbms_sql.column_value(l_CursorID, 1, l_template_id);
896: dbms_sql.column_value(l_CursorID, 2, l_template_name);
897: dbms_sql.column_value(l_CursorID, 3, l_start_date_active);

Line 895: dbms_sql.column_value(l_CursorID, 1, l_template_id);

891: l_default_update_format2 :=
892: get_date_format_from_user_two||' HH24:MI:SS';
893: While (dbms_sql.fetch_rows(l_CursorID) > 0) Loop
894: If (i >= l_start_template and i <= l_end_template) Then
895: dbms_sql.column_value(l_CursorID, 1, l_template_id);
896: dbms_sql.column_value(l_CursorID, 2, l_template_name);
897: dbms_sql.column_value(l_CursorID, 3, l_start_date_active);
898: dbms_sql.column_value(l_CursorID, 4, l_end_date_active);
899: dbms_sql.column_value(l_CursorID, 5, l_default_flag);

Line 896: dbms_sql.column_value(l_CursorID, 2, l_template_name);

892: get_date_format_from_user_two||' HH24:MI:SS';
893: While (dbms_sql.fetch_rows(l_CursorID) > 0) Loop
894: If (i >= l_start_template and i <= l_end_template) Then
895: dbms_sql.column_value(l_CursorID, 1, l_template_id);
896: dbms_sql.column_value(l_CursorID, 2, l_template_name);
897: dbms_sql.column_value(l_CursorID, 3, l_start_date_active);
898: dbms_sql.column_value(l_CursorID, 4, l_end_date_active);
899: dbms_sql.column_value(l_CursorID, 5, l_default_flag);
900: dbms_sql.column_value(l_CursorID, 6, l_last_updated_date);

Line 897: dbms_sql.column_value(l_CursorID, 3, l_start_date_active);

893: While (dbms_sql.fetch_rows(l_CursorID) > 0) Loop
894: If (i >= l_start_template and i <= l_end_template) Then
895: dbms_sql.column_value(l_CursorID, 1, l_template_id);
896: dbms_sql.column_value(l_CursorID, 2, l_template_name);
897: dbms_sql.column_value(l_CursorID, 3, l_start_date_active);
898: dbms_sql.column_value(l_CursorID, 4, l_end_date_active);
899: dbms_sql.column_value(l_CursorID, 5, l_default_flag);
900: dbms_sql.column_value(l_CursorID, 6, l_last_updated_date);
901: dbms_sql.column_value(l_CursorID, 7, l_short_code);

Line 898: dbms_sql.column_value(l_CursorID, 4, l_end_date_active);

894: If (i >= l_start_template and i <= l_end_template) Then
895: dbms_sql.column_value(l_CursorID, 1, l_template_id);
896: dbms_sql.column_value(l_CursorID, 2, l_template_name);
897: dbms_sql.column_value(l_CursorID, 3, l_start_date_active);
898: dbms_sql.column_value(l_CursorID, 4, l_end_date_active);
899: dbms_sql.column_value(l_CursorID, 5, l_default_flag);
900: dbms_sql.column_value(l_CursorID, 6, l_last_updated_date);
901: dbms_sql.column_value(l_CursorID, 7, l_short_code);
902: dbms_sql.column_value(l_CursorID, 8, l_uni_question_note_flag);

Line 899: dbms_sql.column_value(l_CursorID, 5, l_default_flag);

895: dbms_sql.column_value(l_CursorID, 1, l_template_id);
896: dbms_sql.column_value(l_CursorID, 2, l_template_name);
897: dbms_sql.column_value(l_CursorID, 3, l_start_date_active);
898: dbms_sql.column_value(l_CursorID, 4, l_end_date_active);
899: dbms_sql.column_value(l_CursorID, 5, l_default_flag);
900: dbms_sql.column_value(l_CursorID, 6, l_last_updated_date);
901: dbms_sql.column_value(l_CursorID, 7, l_short_code);
902: dbms_sql.column_value(l_CursorID, 8, l_uni_question_note_flag);
903: dbms_sql.column_value(l_CursorID, 9, l_uni_question_note_type);

Line 900: dbms_sql.column_value(l_CursorID, 6, l_last_updated_date);

896: dbms_sql.column_value(l_CursorID, 2, l_template_name);
897: dbms_sql.column_value(l_CursorID, 3, l_start_date_active);
898: dbms_sql.column_value(l_CursorID, 4, l_end_date_active);
899: dbms_sql.column_value(l_CursorID, 5, l_default_flag);
900: dbms_sql.column_value(l_CursorID, 6, l_last_updated_date);
901: dbms_sql.column_value(l_CursorID, 7, l_short_code);
902: dbms_sql.column_value(l_CursorID, 8, l_uni_question_note_flag);
903: dbms_sql.column_value(l_CursorID, 9, l_uni_question_note_type);
904:

Line 901: dbms_sql.column_value(l_CursorID, 7, l_short_code);

897: dbms_sql.column_value(l_CursorID, 3, l_start_date_active);
898: dbms_sql.column_value(l_CursorID, 4, l_end_date_active);
899: dbms_sql.column_value(l_CursorID, 5, l_default_flag);
900: dbms_sql.column_value(l_CursorID, 6, l_last_updated_date);
901: dbms_sql.column_value(l_CursorID, 7, l_short_code);
902: dbms_sql.column_value(l_CursorID, 8, l_uni_question_note_flag);
903: dbms_sql.column_value(l_CursorID, 9, l_uni_question_note_type);
904:
905: x_template_list_to_show(j).mTemplateID := l_template_id;

Line 902: dbms_sql.column_value(l_CursorID, 8, l_uni_question_note_flag);

898: dbms_sql.column_value(l_CursorID, 4, l_end_date_active);
899: dbms_sql.column_value(l_CursorID, 5, l_default_flag);
900: dbms_sql.column_value(l_CursorID, 6, l_last_updated_date);
901: dbms_sql.column_value(l_CursorID, 7, l_short_code);
902: dbms_sql.column_value(l_CursorID, 8, l_uni_question_note_flag);
903: dbms_sql.column_value(l_CursorID, 9, l_uni_question_note_type);
904:
905: x_template_list_to_show(j).mTemplateID := l_template_id;
906: x_template_list_to_show(j).mTemplateName := l_template_name;

Line 903: dbms_sql.column_value(l_CursorID, 9, l_uni_question_note_type);

899: dbms_sql.column_value(l_CursorID, 5, l_default_flag);
900: dbms_sql.column_value(l_CursorID, 6, l_last_updated_date);
901: dbms_sql.column_value(l_CursorID, 7, l_short_code);
902: dbms_sql.column_value(l_CursorID, 8, l_uni_question_note_flag);
903: dbms_sql.column_value(l_CursorID, 9, l_uni_question_note_type);
904:
905: x_template_list_to_show(j).mTemplateID := l_template_id;
906: x_template_list_to_show(j).mTemplateName := l_template_name;
907: x_template_list_to_show(j).mShortCode := l_short_code;

Line 927: dbms_sql.close_cursor(l_CursorID);

923: End If;
924: i := i+1;
925: End Loop;
926:
927: dbms_sql.close_cursor(l_CursorID);
928: x_retrieved_template_num := j;
929: x_total_templates := i - 1;
930:
931: IF FND_API.To_Boolean( p_commit ) THEN

Line 1195: l_CursorID := dbms_sql.open_cursor;

1191: '.template_id=tb.template_id ) ' ||
1192: ' and trunc(sysdate) between trunc(nvl(tb.start_date_active, sysdate))' ||
1193: ' and trunc(nvl(tb.end_date_active, sysdate)) ';
1194:
1195: l_CursorID := dbms_sql.open_cursor;
1196: dbms_sql.parse(l_CursorID, l_Cursor_Statement, dbms_sql.NATIVE);
1197:
1198: For i In p_Object_Other_list.First..p_Object_Other_list.LAST Loop
1199: If ( needBind ( i) = 1 ) then

Line 1196: dbms_sql.parse(l_CursorID, l_Cursor_Statement, dbms_sql.NATIVE);

1192: ' and trunc(sysdate) between trunc(nvl(tb.start_date_active, sysdate))' ||
1193: ' and trunc(nvl(tb.end_date_active, sysdate)) ';
1194:
1195: l_CursorID := dbms_sql.open_cursor;
1196: dbms_sql.parse(l_CursorID, l_Cursor_Statement, dbms_sql.NATIVE);
1197:
1198: For i In p_Object_Other_list.First..p_Object_Other_list.LAST Loop
1199: If ( needBind ( i) = 1 ) then
1200: If(p_Object_Other_list(i).mOBJECT_CODE <> 'IBU_TP_SR_PROBCODE') Then

Line 1201: dbms_sql.bind_variable (l_CursorID, ':v_Other_ID' || i ,

1197:
1198: For i In p_Object_Other_list.First..p_Object_Other_list.LAST Loop
1199: If ( needBind ( i) = 1 ) then
1200: If(p_Object_Other_list(i).mOBJECT_CODE <> 'IBU_TP_SR_PROBCODE') Then
1201: dbms_sql.bind_variable (l_CursorID, ':v_Other_ID' || i ,
1202: p_Object_Other_list(i).mother_id);
1203: dbms_sql.bind_variable (l_CursorID, ':v_Object_Code' || i,
1204: p_Object_Other_list(i).mobject_code);
1205: Else

Line 1203: dbms_sql.bind_variable (l_CursorID, ':v_Object_Code' || i,

1199: If ( needBind ( i) = 1 ) then
1200: If(p_Object_Other_list(i).mOBJECT_CODE <> 'IBU_TP_SR_PROBCODE') Then
1201: dbms_sql.bind_variable (l_CursorID, ':v_Other_ID' || i ,
1202: p_Object_Other_list(i).mother_id);
1203: dbms_sql.bind_variable (l_CursorID, ':v_Object_Code' || i,
1204: p_Object_Other_list(i).mobject_code);
1205: Else
1206: If(p_Object_Other_list(i).mLOOKUP_CODE <> 'NONE') Then
1207: dbms_sql.bind_variable (l_CursorID, ':v_Other_CODE' || i ,

Line 1207: dbms_sql.bind_variable (l_CursorID, ':v_Other_CODE' || i ,

1203: dbms_sql.bind_variable (l_CursorID, ':v_Object_Code' || i,
1204: p_Object_Other_list(i).mobject_code);
1205: Else
1206: If(p_Object_Other_list(i).mLOOKUP_CODE <> 'NONE') Then
1207: dbms_sql.bind_variable (l_CursorID, ':v_Other_CODE' || i ,
1208: p_Object_Other_list(i).mLOOKUP_CODE);
1209: dbms_sql.bind_variable (l_CursorID, ':v_Object_Code' || i,
1210: p_Object_Other_list(i).mobject_code);
1211: End If;

Line 1209: dbms_sql.bind_variable (l_CursorID, ':v_Object_Code' || i,

1205: Else
1206: If(p_Object_Other_list(i).mLOOKUP_CODE <> 'NONE') Then
1207: dbms_sql.bind_variable (l_CursorID, ':v_Other_CODE' || i ,
1208: p_Object_Other_list(i).mLOOKUP_CODE);
1209: dbms_sql.bind_variable (l_CursorID, ':v_Object_Code' || i,
1210: p_Object_Other_list(i).mobject_code);
1211: End If;
1212: End If;
1213: End If; -- end needBind IF

Line 1216: dbms_sql.define_column(l_CursorID, 1, L_TEMPLATE_ID);

1212: End If;
1213: End If; -- end needBind IF
1214: End Loop;
1215:
1216: dbms_sql.define_column(l_CursorID, 1, L_TEMPLATE_ID);
1217: dbms_sql.define_column(l_CursorID, 2, L_TEMPLATE_NAME, 300);
1218: dbms_sql.define_column(l_CursorID, 3, L_START_DATE);
1219: dbms_sql.define_column(l_CursorID, 4, L_END_DATE);
1220: dbms_sql.define_column(l_CursorID, 5, L_DEFAULT_FLAG, 100);

Line 1217: dbms_sql.define_column(l_CursorID, 2, L_TEMPLATE_NAME, 300);

1213: End If; -- end needBind IF
1214: End Loop;
1215:
1216: dbms_sql.define_column(l_CursorID, 1, L_TEMPLATE_ID);
1217: dbms_sql.define_column(l_CursorID, 2, L_TEMPLATE_NAME, 300);
1218: dbms_sql.define_column(l_CursorID, 3, L_START_DATE);
1219: dbms_sql.define_column(l_CursorID, 4, L_END_DATE);
1220: dbms_sql.define_column(l_CursorID, 5, L_DEFAULT_FLAG, 100);
1221: dbms_sql.define_column(l_CursorID, 6, L_LAST_UPDATE_DATE);

Line 1218: dbms_sql.define_column(l_CursorID, 3, L_START_DATE);

1214: End Loop;
1215:
1216: dbms_sql.define_column(l_CursorID, 1, L_TEMPLATE_ID);
1217: dbms_sql.define_column(l_CursorID, 2, L_TEMPLATE_NAME, 300);
1218: dbms_sql.define_column(l_CursorID, 3, L_START_DATE);
1219: dbms_sql.define_column(l_CursorID, 4, L_END_DATE);
1220: dbms_sql.define_column(l_CursorID, 5, L_DEFAULT_FLAG, 100);
1221: dbms_sql.define_column(l_CursorID, 6, L_LAST_UPDATE_DATE);
1222: dbms_sql.define_column(l_CursorID, 7, l_Short_Code, 150);

Line 1219: dbms_sql.define_column(l_CursorID, 4, L_END_DATE);

1215:
1216: dbms_sql.define_column(l_CursorID, 1, L_TEMPLATE_ID);
1217: dbms_sql.define_column(l_CursorID, 2, L_TEMPLATE_NAME, 300);
1218: dbms_sql.define_column(l_CursorID, 3, L_START_DATE);
1219: dbms_sql.define_column(l_CursorID, 4, L_END_DATE);
1220: dbms_sql.define_column(l_CursorID, 5, L_DEFAULT_FLAG, 100);
1221: dbms_sql.define_column(l_CursorID, 6, L_LAST_UPDATE_DATE);
1222: dbms_sql.define_column(l_CursorID, 7, l_Short_Code, 150);
1223: dbms_sql.define_column(l_CursorID, 8, l_UNI_QUESTION_NOTE_FLAG, 1);

Line 1220: dbms_sql.define_column(l_CursorID, 5, L_DEFAULT_FLAG, 100);

1216: dbms_sql.define_column(l_CursorID, 1, L_TEMPLATE_ID);
1217: dbms_sql.define_column(l_CursorID, 2, L_TEMPLATE_NAME, 300);
1218: dbms_sql.define_column(l_CursorID, 3, L_START_DATE);
1219: dbms_sql.define_column(l_CursorID, 4, L_END_DATE);
1220: dbms_sql.define_column(l_CursorID, 5, L_DEFAULT_FLAG, 100);
1221: dbms_sql.define_column(l_CursorID, 6, L_LAST_UPDATE_DATE);
1222: dbms_sql.define_column(l_CursorID, 7, l_Short_Code, 150);
1223: dbms_sql.define_column(l_CursorID, 8, l_UNI_QUESTION_NOTE_FLAG, 1);
1224: dbms_sql.define_column(l_CursorID, 9, l_UNI_QUESTION_NOTE_TYPE, 30);

Line 1221: dbms_sql.define_column(l_CursorID, 6, L_LAST_UPDATE_DATE);

1217: dbms_sql.define_column(l_CursorID, 2, L_TEMPLATE_NAME, 300);
1218: dbms_sql.define_column(l_CursorID, 3, L_START_DATE);
1219: dbms_sql.define_column(l_CursorID, 4, L_END_DATE);
1220: dbms_sql.define_column(l_CursorID, 5, L_DEFAULT_FLAG, 100);
1221: dbms_sql.define_column(l_CursorID, 6, L_LAST_UPDATE_DATE);
1222: dbms_sql.define_column(l_CursorID, 7, l_Short_Code, 150);
1223: dbms_sql.define_column(l_CursorID, 8, l_UNI_QUESTION_NOTE_FLAG, 1);
1224: dbms_sql.define_column(l_CursorID, 9, l_UNI_QUESTION_NOTE_TYPE, 30);
1225:

Line 1222: dbms_sql.define_column(l_CursorID, 7, l_Short_Code, 150);

1218: dbms_sql.define_column(l_CursorID, 3, L_START_DATE);
1219: dbms_sql.define_column(l_CursorID, 4, L_END_DATE);
1220: dbms_sql.define_column(l_CursorID, 5, L_DEFAULT_FLAG, 100);
1221: dbms_sql.define_column(l_CursorID, 6, L_LAST_UPDATE_DATE);
1222: dbms_sql.define_column(l_CursorID, 7, l_Short_Code, 150);
1223: dbms_sql.define_column(l_CursorID, 8, l_UNI_QUESTION_NOTE_FLAG, 1);
1224: dbms_sql.define_column(l_CursorID, 9, l_UNI_QUESTION_NOTE_TYPE, 30);
1225:
1226: l_total_attribute_num := dbms_sql.execute(l_CursorID);

Line 1223: dbms_sql.define_column(l_CursorID, 8, l_UNI_QUESTION_NOTE_FLAG, 1);

1219: dbms_sql.define_column(l_CursorID, 4, L_END_DATE);
1220: dbms_sql.define_column(l_CursorID, 5, L_DEFAULT_FLAG, 100);
1221: dbms_sql.define_column(l_CursorID, 6, L_LAST_UPDATE_DATE);
1222: dbms_sql.define_column(l_CursorID, 7, l_Short_Code, 150);
1223: dbms_sql.define_column(l_CursorID, 8, l_UNI_QUESTION_NOTE_FLAG, 1);
1224: dbms_sql.define_column(l_CursorID, 9, l_UNI_QUESTION_NOTE_TYPE, 30);
1225:
1226: l_total_attribute_num := dbms_sql.execute(l_CursorID);
1227: i:=0;

Line 1224: dbms_sql.define_column(l_CursorID, 9, l_UNI_QUESTION_NOTE_TYPE, 30);

1220: dbms_sql.define_column(l_CursorID, 5, L_DEFAULT_FLAG, 100);
1221: dbms_sql.define_column(l_CursorID, 6, L_LAST_UPDATE_DATE);
1222: dbms_sql.define_column(l_CursorID, 7, l_Short_Code, 150);
1223: dbms_sql.define_column(l_CursorID, 8, l_UNI_QUESTION_NOTE_FLAG, 1);
1224: dbms_sql.define_column(l_CursorID, 9, l_UNI_QUESTION_NOTE_TYPE, 30);
1225:
1226: l_total_attribute_num := dbms_sql.execute(l_CursorID);
1227: i:=0;
1228: While (dbms_sql.fetch_rows(l_CursorID) > 0) Loop

Line 1226: l_total_attribute_num := dbms_sql.execute(l_CursorID);

1222: dbms_sql.define_column(l_CursorID, 7, l_Short_Code, 150);
1223: dbms_sql.define_column(l_CursorID, 8, l_UNI_QUESTION_NOTE_FLAG, 1);
1224: dbms_sql.define_column(l_CursorID, 9, l_UNI_QUESTION_NOTE_TYPE, 30);
1225:
1226: l_total_attribute_num := dbms_sql.execute(l_CursorID);
1227: i:=0;
1228: While (dbms_sql.fetch_rows(l_CursorID) > 0) Loop
1229:
1230: dbms_sql.column_value(l_CursorID, 1, l_template_id);

Line 1228: While (dbms_sql.fetch_rows(l_CursorID) > 0) Loop

1224: dbms_sql.define_column(l_CursorID, 9, l_UNI_QUESTION_NOTE_TYPE, 30);
1225:
1226: l_total_attribute_num := dbms_sql.execute(l_CursorID);
1227: i:=0;
1228: While (dbms_sql.fetch_rows(l_CursorID) > 0) Loop
1229:
1230: dbms_sql.column_value(l_CursorID, 1, l_template_id);
1231: dbms_sql.column_value(l_CursorID, 2, l_template_name);
1232: dbms_sql.column_value(l_CursorID, 3, l_start_date);

Line 1230: dbms_sql.column_value(l_CursorID, 1, l_template_id);

1226: l_total_attribute_num := dbms_sql.execute(l_CursorID);
1227: i:=0;
1228: While (dbms_sql.fetch_rows(l_CursorID) > 0) Loop
1229:
1230: dbms_sql.column_value(l_CursorID, 1, l_template_id);
1231: dbms_sql.column_value(l_CursorID, 2, l_template_name);
1232: dbms_sql.column_value(l_CursorID, 3, l_start_date);
1233: dbms_sql.column_value(l_CursorID, 4, l_end_date);
1234: dbms_sql.column_value(l_CursorID, 5, l_default_flag);

Line 1231: dbms_sql.column_value(l_CursorID, 2, l_template_name);

1227: i:=0;
1228: While (dbms_sql.fetch_rows(l_CursorID) > 0) Loop
1229:
1230: dbms_sql.column_value(l_CursorID, 1, l_template_id);
1231: dbms_sql.column_value(l_CursorID, 2, l_template_name);
1232: dbms_sql.column_value(l_CursorID, 3, l_start_date);
1233: dbms_sql.column_value(l_CursorID, 4, l_end_date);
1234: dbms_sql.column_value(l_CursorID, 5, l_default_flag);
1235: dbms_sql.column_value(l_CursorID, 6, l_last_update_date);

Line 1232: dbms_sql.column_value(l_CursorID, 3, l_start_date);

1228: While (dbms_sql.fetch_rows(l_CursorID) > 0) Loop
1229:
1230: dbms_sql.column_value(l_CursorID, 1, l_template_id);
1231: dbms_sql.column_value(l_CursorID, 2, l_template_name);
1232: dbms_sql.column_value(l_CursorID, 3, l_start_date);
1233: dbms_sql.column_value(l_CursorID, 4, l_end_date);
1234: dbms_sql.column_value(l_CursorID, 5, l_default_flag);
1235: dbms_sql.column_value(l_CursorID, 6, l_last_update_date);
1236: dbms_sql.column_value(l_CursorID, 7, l_short_code);

Line 1233: dbms_sql.column_value(l_CursorID, 4, l_end_date);

1229:
1230: dbms_sql.column_value(l_CursorID, 1, l_template_id);
1231: dbms_sql.column_value(l_CursorID, 2, l_template_name);
1232: dbms_sql.column_value(l_CursorID, 3, l_start_date);
1233: dbms_sql.column_value(l_CursorID, 4, l_end_date);
1234: dbms_sql.column_value(l_CursorID, 5, l_default_flag);
1235: dbms_sql.column_value(l_CursorID, 6, l_last_update_date);
1236: dbms_sql.column_value(l_CursorID, 7, l_short_code);
1237: dbms_sql.column_value(l_CursorID, 8, l_uni_question_note_flag);

Line 1234: dbms_sql.column_value(l_CursorID, 5, l_default_flag);

1230: dbms_sql.column_value(l_CursorID, 1, l_template_id);
1231: dbms_sql.column_value(l_CursorID, 2, l_template_name);
1232: dbms_sql.column_value(l_CursorID, 3, l_start_date);
1233: dbms_sql.column_value(l_CursorID, 4, l_end_date);
1234: dbms_sql.column_value(l_CursorID, 5, l_default_flag);
1235: dbms_sql.column_value(l_CursorID, 6, l_last_update_date);
1236: dbms_sql.column_value(l_CursorID, 7, l_short_code);
1237: dbms_sql.column_value(l_CursorID, 8, l_uni_question_note_flag);
1238: dbms_sql.column_value(l_CursorID, 9, l_uni_question_note_type);

Line 1235: dbms_sql.column_value(l_CursorID, 6, l_last_update_date);

1231: dbms_sql.column_value(l_CursorID, 2, l_template_name);
1232: dbms_sql.column_value(l_CursorID, 3, l_start_date);
1233: dbms_sql.column_value(l_CursorID, 4, l_end_date);
1234: dbms_sql.column_value(l_CursorID, 5, l_default_flag);
1235: dbms_sql.column_value(l_CursorID, 6, l_last_update_date);
1236: dbms_sql.column_value(l_CursorID, 7, l_short_code);
1237: dbms_sql.column_value(l_CursorID, 8, l_uni_question_note_flag);
1238: dbms_sql.column_value(l_CursorID, 9, l_uni_question_note_type);
1239:

Line 1236: dbms_sql.column_value(l_CursorID, 7, l_short_code);

1232: dbms_sql.column_value(l_CursorID, 3, l_start_date);
1233: dbms_sql.column_value(l_CursorID, 4, l_end_date);
1234: dbms_sql.column_value(l_CursorID, 5, l_default_flag);
1235: dbms_sql.column_value(l_CursorID, 6, l_last_update_date);
1236: dbms_sql.column_value(l_CursorID, 7, l_short_code);
1237: dbms_sql.column_value(l_CursorID, 8, l_uni_question_note_flag);
1238: dbms_sql.column_value(l_CursorID, 9, l_uni_question_note_type);
1239:
1240: x_template_list(i).mTemplateID := l_template_id;

Line 1237: dbms_sql.column_value(l_CursorID, 8, l_uni_question_note_flag);

1233: dbms_sql.column_value(l_CursorID, 4, l_end_date);
1234: dbms_sql.column_value(l_CursorID, 5, l_default_flag);
1235: dbms_sql.column_value(l_CursorID, 6, l_last_update_date);
1236: dbms_sql.column_value(l_CursorID, 7, l_short_code);
1237: dbms_sql.column_value(l_CursorID, 8, l_uni_question_note_flag);
1238: dbms_sql.column_value(l_CursorID, 9, l_uni_question_note_type);
1239:
1240: x_template_list(i).mTemplateID := l_template_id;
1241: x_template_list(i).mTemplateName := l_template_name;

Line 1238: dbms_sql.column_value(l_CursorID, 9, l_uni_question_note_type);

1234: dbms_sql.column_value(l_CursorID, 5, l_default_flag);
1235: dbms_sql.column_value(l_CursorID, 6, l_last_update_date);
1236: dbms_sql.column_value(l_CursorID, 7, l_short_code);
1237: dbms_sql.column_value(l_CursorID, 8, l_uni_question_note_flag);
1238: dbms_sql.column_value(l_CursorID, 9, l_uni_question_note_type);
1239:
1240: x_template_list(i).mTemplateID := l_template_id;
1241: x_template_list(i).mTemplateName := l_template_name;
1242: x_template_list(i).mUniQuestionNoteFlag := l_uni_question_note_flag;

Line 1254: dbms_sql.close_cursor(l_CursorID);

1250: x_template_list(i).mEndDate
1251: := to_char(l_end_date, l_date_format);
1252: i:=i+1;
1253: End Loop;
1254: dbms_sql.close_cursor(l_CursorID);
1255:
1256: IF FND_API.To_Boolean( p_commit ) THEN
1257: COMMIT WORK;
1258: END IF;

Line 1401: l_CursorID := dbms_sql.open_cursor;

1397: || ' ORDER BY JTFO.'
1398: || l_ORDER_BY_CLAUSE;
1399: End If;
1400:
1401: l_CursorID := dbms_sql.open_cursor;
1402: dbms_sql.parse(l_CursorID, l_statement, dbms_sql.NATIVE);
1403:
1404: dbms_sql.bind_variable(l_CursorID, 'P_Template_ID', P_Template_ID);
1405: dbms_sql.bind_variable(l_CursorID, 'P_JTF_OBJECT_CODE', P_JTF_OBJECT_CODE);

Line 1402: dbms_sql.parse(l_CursorID, l_statement, dbms_sql.NATIVE);

1398: || l_ORDER_BY_CLAUSE;
1399: End If;
1400:
1401: l_CursorID := dbms_sql.open_cursor;
1402: dbms_sql.parse(l_CursorID, l_statement, dbms_sql.NATIVE);
1403:
1404: dbms_sql.bind_variable(l_CursorID, 'P_Template_ID', P_Template_ID);
1405: dbms_sql.bind_variable(l_CursorID, 'P_JTF_OBJECT_CODE', P_JTF_OBJECT_CODE);
1406:

Line 1404: dbms_sql.bind_variable(l_CursorID, 'P_Template_ID', P_Template_ID);

1400:
1401: l_CursorID := dbms_sql.open_cursor;
1402: dbms_sql.parse(l_CursorID, l_statement, dbms_sql.NATIVE);
1403:
1404: dbms_sql.bind_variable(l_CursorID, 'P_Template_ID', P_Template_ID);
1405: dbms_sql.bind_variable(l_CursorID, 'P_JTF_OBJECT_CODE', P_JTF_OBJECT_CODE);
1406:
1407: dbms_sql.define_column(l_CursorID, 1, l_template_attribute_id);
1408: dbms_sql.define_column(l_CursorID, 2, l_attribute_name, 300);

Line 1405: dbms_sql.bind_variable(l_CursorID, 'P_JTF_OBJECT_CODE', P_JTF_OBJECT_CODE);

1401: l_CursorID := dbms_sql.open_cursor;
1402: dbms_sql.parse(l_CursorID, l_statement, dbms_sql.NATIVE);
1403:
1404: dbms_sql.bind_variable(l_CursorID, 'P_Template_ID', P_Template_ID);
1405: dbms_sql.bind_variable(l_CursorID, 'P_JTF_OBJECT_CODE', P_JTF_OBJECT_CODE);
1406:
1407: dbms_sql.define_column(l_CursorID, 1, l_template_attribute_id);
1408: dbms_sql.define_column(l_CursorID, 2, l_attribute_name, 300);
1409: dbms_sql.define_column(l_CursorID, 3, l_start_threshold);

Line 1407: dbms_sql.define_column(l_CursorID, 1, l_template_attribute_id);

1403:
1404: dbms_sql.bind_variable(l_CursorID, 'P_Template_ID', P_Template_ID);
1405: dbms_sql.bind_variable(l_CursorID, 'P_JTF_OBJECT_CODE', P_JTF_OBJECT_CODE);
1406:
1407: dbms_sql.define_column(l_CursorID, 1, l_template_attribute_id);
1408: dbms_sql.define_column(l_CursorID, 2, l_attribute_name, 300);
1409: dbms_sql.define_column(l_CursorID, 3, l_start_threshold);
1410: dbms_sql.define_column(l_CursorID, 4, l_end_threshold);
1411: dbms_sql.define_column(l_CursorID, 5, l_other_id);

Line 1408: dbms_sql.define_column(l_CursorID, 2, l_attribute_name, 300);

1404: dbms_sql.bind_variable(l_CursorID, 'P_Template_ID', P_Template_ID);
1405: dbms_sql.bind_variable(l_CursorID, 'P_JTF_OBJECT_CODE', P_JTF_OBJECT_CODE);
1406:
1407: dbms_sql.define_column(l_CursorID, 1, l_template_attribute_id);
1408: dbms_sql.define_column(l_CursorID, 2, l_attribute_name, 300);
1409: dbms_sql.define_column(l_CursorID, 3, l_start_threshold);
1410: dbms_sql.define_column(l_CursorID, 4, l_end_threshold);
1411: dbms_sql.define_column(l_CursorID, 5, l_other_id);
1412: dbms_sql.define_column(l_CursorID, 6, l_last_update_date);

Line 1409: dbms_sql.define_column(l_CursorID, 3, l_start_threshold);

1405: dbms_sql.bind_variable(l_CursorID, 'P_JTF_OBJECT_CODE', P_JTF_OBJECT_CODE);
1406:
1407: dbms_sql.define_column(l_CursorID, 1, l_template_attribute_id);
1408: dbms_sql.define_column(l_CursorID, 2, l_attribute_name, 300);
1409: dbms_sql.define_column(l_CursorID, 3, l_start_threshold);
1410: dbms_sql.define_column(l_CursorID, 4, l_end_threshold);
1411: dbms_sql.define_column(l_CursorID, 5, l_other_id);
1412: dbms_sql.define_column(l_CursorID, 6, l_last_update_date);
1413: dbms_sql.define_column(l_CursorID, 7, l_defaultflag, 30);

Line 1410: dbms_sql.define_column(l_CursorID, 4, l_end_threshold);

1406:
1407: dbms_sql.define_column(l_CursorID, 1, l_template_attribute_id);
1408: dbms_sql.define_column(l_CursorID, 2, l_attribute_name, 300);
1409: dbms_sql.define_column(l_CursorID, 3, l_start_threshold);
1410: dbms_sql.define_column(l_CursorID, 4, l_end_threshold);
1411: dbms_sql.define_column(l_CursorID, 5, l_other_id);
1412: dbms_sql.define_column(l_CursorID, 6, l_last_update_date);
1413: dbms_sql.define_column(l_CursorID, 7, l_defaultflag, 30);
1414:

Line 1411: dbms_sql.define_column(l_CursorID, 5, l_other_id);

1407: dbms_sql.define_column(l_CursorID, 1, l_template_attribute_id);
1408: dbms_sql.define_column(l_CursorID, 2, l_attribute_name, 300);
1409: dbms_sql.define_column(l_CursorID, 3, l_start_threshold);
1410: dbms_sql.define_column(l_CursorID, 4, l_end_threshold);
1411: dbms_sql.define_column(l_CursorID, 5, l_other_id);
1412: dbms_sql.define_column(l_CursorID, 6, l_last_update_date);
1413: dbms_sql.define_column(l_CursorID, 7, l_defaultflag, 30);
1414:
1415: l_total_attribute_num := dbms_sql.execute(l_CursorID);

Line 1412: dbms_sql.define_column(l_CursorID, 6, l_last_update_date);

1408: dbms_sql.define_column(l_CursorID, 2, l_attribute_name, 300);
1409: dbms_sql.define_column(l_CursorID, 3, l_start_threshold);
1410: dbms_sql.define_column(l_CursorID, 4, l_end_threshold);
1411: dbms_sql.define_column(l_CursorID, 5, l_other_id);
1412: dbms_sql.define_column(l_CursorID, 6, l_last_update_date);
1413: dbms_sql.define_column(l_CursorID, 7, l_defaultflag, 30);
1414:
1415: l_total_attribute_num := dbms_sql.execute(l_CursorID);
1416:

Line 1413: dbms_sql.define_column(l_CursorID, 7, l_defaultflag, 30);

1409: dbms_sql.define_column(l_CursorID, 3, l_start_threshold);
1410: dbms_sql.define_column(l_CursorID, 4, l_end_threshold);
1411: dbms_sql.define_column(l_CursorID, 5, l_other_id);
1412: dbms_sql.define_column(l_CursorID, 6, l_last_update_date);
1413: dbms_sql.define_column(l_CursorID, 7, l_defaultflag, 30);
1414:
1415: l_total_attribute_num := dbms_sql.execute(l_CursorID);
1416:
1417: i:=0;

Line 1415: l_total_attribute_num := dbms_sql.execute(l_CursorID);

1411: dbms_sql.define_column(l_CursorID, 5, l_other_id);
1412: dbms_sql.define_column(l_CursorID, 6, l_last_update_date);
1413: dbms_sql.define_column(l_CursorID, 7, l_defaultflag, 30);
1414:
1415: l_total_attribute_num := dbms_sql.execute(l_CursorID);
1416:
1417: i:=0;
1418: While (dbms_sql.fetch_rows(l_CursorID) > 0) Loop
1419: dbms_sql.column_value(l_CursorID, 1, l_template_attribute_id);

Line 1418: While (dbms_sql.fetch_rows(l_CursorID) > 0) Loop

1414:
1415: l_total_attribute_num := dbms_sql.execute(l_CursorID);
1416:
1417: i:=0;
1418: While (dbms_sql.fetch_rows(l_CursorID) > 0) Loop
1419: dbms_sql.column_value(l_CursorID, 1, l_template_attribute_id);
1420: dbms_sql.column_value(l_CursorID, 2, l_attribute_name);
1421: dbms_sql.column_value(l_CursorID, 3, l_start_threshold);
1422: dbms_sql.column_value(l_CursorID, 4, l_end_threshold);

Line 1419: dbms_sql.column_value(l_CursorID, 1, l_template_attribute_id);

1415: l_total_attribute_num := dbms_sql.execute(l_CursorID);
1416:
1417: i:=0;
1418: While (dbms_sql.fetch_rows(l_CursorID) > 0) Loop
1419: dbms_sql.column_value(l_CursorID, 1, l_template_attribute_id);
1420: dbms_sql.column_value(l_CursorID, 2, l_attribute_name);
1421: dbms_sql.column_value(l_CursorID, 3, l_start_threshold);
1422: dbms_sql.column_value(l_CursorID, 4, l_end_threshold);
1423: dbms_sql.column_value(l_CursorID, 5, l_other_id);

Line 1420: dbms_sql.column_value(l_CursorID, 2, l_attribute_name);

1416:
1417: i:=0;
1418: While (dbms_sql.fetch_rows(l_CursorID) > 0) Loop
1419: dbms_sql.column_value(l_CursorID, 1, l_template_attribute_id);
1420: dbms_sql.column_value(l_CursorID, 2, l_attribute_name);
1421: dbms_sql.column_value(l_CursorID, 3, l_start_threshold);
1422: dbms_sql.column_value(l_CursorID, 4, l_end_threshold);
1423: dbms_sql.column_value(l_CursorID, 5, l_other_id);
1424: dbms_sql.column_value(l_CursorID, 6, l_last_update_date);

Line 1421: dbms_sql.column_value(l_CursorID, 3, l_start_threshold);

1417: i:=0;
1418: While (dbms_sql.fetch_rows(l_CursorID) > 0) Loop
1419: dbms_sql.column_value(l_CursorID, 1, l_template_attribute_id);
1420: dbms_sql.column_value(l_CursorID, 2, l_attribute_name);
1421: dbms_sql.column_value(l_CursorID, 3, l_start_threshold);
1422: dbms_sql.column_value(l_CursorID, 4, l_end_threshold);
1423: dbms_sql.column_value(l_CursorID, 5, l_other_id);
1424: dbms_sql.column_value(l_CursorID, 6, l_last_update_date);
1425: dbms_sql.column_value(l_CursorID, 7, l_defaultflag);

Line 1422: dbms_sql.column_value(l_CursorID, 4, l_end_threshold);

1418: While (dbms_sql.fetch_rows(l_CursorID) > 0) Loop
1419: dbms_sql.column_value(l_CursorID, 1, l_template_attribute_id);
1420: dbms_sql.column_value(l_CursorID, 2, l_attribute_name);
1421: dbms_sql.column_value(l_CursorID, 3, l_start_threshold);
1422: dbms_sql.column_value(l_CursorID, 4, l_end_threshold);
1423: dbms_sql.column_value(l_CursorID, 5, l_other_id);
1424: dbms_sql.column_value(l_CursorID, 6, l_last_update_date);
1425: dbms_sql.column_value(l_CursorID, 7, l_defaultflag);
1426: x_template_attributes (i).mAttributeID := l_template_attribute_id;

Line 1423: dbms_sql.column_value(l_CursorID, 5, l_other_id);

1419: dbms_sql.column_value(l_CursorID, 1, l_template_attribute_id);
1420: dbms_sql.column_value(l_CursorID, 2, l_attribute_name);
1421: dbms_sql.column_value(l_CursorID, 3, l_start_threshold);
1422: dbms_sql.column_value(l_CursorID, 4, l_end_threshold);
1423: dbms_sql.column_value(l_CursorID, 5, l_other_id);
1424: dbms_sql.column_value(l_CursorID, 6, l_last_update_date);
1425: dbms_sql.column_value(l_CursorID, 7, l_defaultflag);
1426: x_template_attributes (i).mAttributeID := l_template_attribute_id;
1427: x_template_attributes (i).mAttributeName := l_attribute_name;

Line 1424: dbms_sql.column_value(l_CursorID, 6, l_last_update_date);

1420: dbms_sql.column_value(l_CursorID, 2, l_attribute_name);
1421: dbms_sql.column_value(l_CursorID, 3, l_start_threshold);
1422: dbms_sql.column_value(l_CursorID, 4, l_end_threshold);
1423: dbms_sql.column_value(l_CursorID, 5, l_other_id);
1424: dbms_sql.column_value(l_CursorID, 6, l_last_update_date);
1425: dbms_sql.column_value(l_CursorID, 7, l_defaultflag);
1426: x_template_attributes (i).mAttributeID := l_template_attribute_id;
1427: x_template_attributes (i).mAttributeName := l_attribute_name;
1428: x_template_attributes (i).mStartThreshold := l_start_threshold;

Line 1425: dbms_sql.column_value(l_CursorID, 7, l_defaultflag);

1421: dbms_sql.column_value(l_CursorID, 3, l_start_threshold);
1422: dbms_sql.column_value(l_CursorID, 4, l_end_threshold);
1423: dbms_sql.column_value(l_CursorID, 5, l_other_id);
1424: dbms_sql.column_value(l_CursorID, 6, l_last_update_date);
1425: dbms_sql.column_value(l_CursorID, 7, l_defaultflag);
1426: x_template_attributes (i).mAttributeID := l_template_attribute_id;
1427: x_template_attributes (i).mAttributeName := l_attribute_name;
1428: x_template_attributes (i).mStartThreshold := l_start_threshold;
1429: x_template_attributes (i).mEndThreshold := l_end_threshold;

Line 1438: dbms_sql.close_cursor(l_CursorID);

1434: := to_char (l_last_update_date, l_default_last_up_date_format);
1435:
1436: i:= i+1;
1437: End Loop;
1438: dbms_sql.close_cursor(l_CursorID);
1439:
1440: IF FND_API.To_Boolean( p_commit ) THEN
1441: COMMIT WORK;
1442: END IF;

Line 1603: l_CursorID := dbms_sql.open_cursor;

1599: || l_ORDER_BY_CLAUSE;
1600: End If;
1601: End If;
1602:
1603: l_CursorID := dbms_sql.open_cursor;
1604: dbms_sql.parse(l_CursorID, l_statement, dbms_sql.NATIVE);
1605: dbms_sql.define_column(l_CursorID, 1, L_LINK_ID);
1606: dbms_sql.define_column(l_CursorID, 2, L_LINK_NAME, 300);
1607: dbms_sql.define_column(l_CursorID, 3, L_LINK_DESC, 1000);

Line 1604: dbms_sql.parse(l_CursorID, l_statement, dbms_sql.NATIVE);

1600: End If;
1601: End If;
1602:
1603: l_CursorID := dbms_sql.open_cursor;
1604: dbms_sql.parse(l_CursorID, l_statement, dbms_sql.NATIVE);
1605: dbms_sql.define_column(l_CursorID, 1, L_LINK_ID);
1606: dbms_sql.define_column(l_CursorID, 2, L_LINK_NAME, 300);
1607: dbms_sql.define_column(l_CursorID, 3, L_LINK_DESC, 1000);
1608:

Line 1605: dbms_sql.define_column(l_CursorID, 1, L_LINK_ID);

1601: End If;
1602:
1603: l_CursorID := dbms_sql.open_cursor;
1604: dbms_sql.parse(l_CursorID, l_statement, dbms_sql.NATIVE);
1605: dbms_sql.define_column(l_CursorID, 1, L_LINK_ID);
1606: dbms_sql.define_column(l_CursorID, 2, L_LINK_NAME, 300);
1607: dbms_sql.define_column(l_CursorID, 3, L_LINK_DESC, 1000);
1608:
1609: If(P_JTF_OBJECT_CODE <> 'IBU_TP_SR_PROBCODE') Then

Line 1606: dbms_sql.define_column(l_CursorID, 2, L_LINK_NAME, 300);

1602:
1603: l_CursorID := dbms_sql.open_cursor;
1604: dbms_sql.parse(l_CursorID, l_statement, dbms_sql.NATIVE);
1605: dbms_sql.define_column(l_CursorID, 1, L_LINK_ID);
1606: dbms_sql.define_column(l_CursorID, 2, L_LINK_NAME, 300);
1607: dbms_sql.define_column(l_CursorID, 3, L_LINK_DESC, 1000);
1608:
1609: If(P_JTF_OBJECT_CODE <> 'IBU_TP_SR_PROBCODE') Then
1610: dbms_sql.define_column(l_CursorID, 4, L_OTHER_ID);

Line 1607: dbms_sql.define_column(l_CursorID, 3, L_LINK_DESC, 1000);

1603: l_CursorID := dbms_sql.open_cursor;
1604: dbms_sql.parse(l_CursorID, l_statement, dbms_sql.NATIVE);
1605: dbms_sql.define_column(l_CursorID, 1, L_LINK_ID);
1606: dbms_sql.define_column(l_CursorID, 2, L_LINK_NAME, 300);
1607: dbms_sql.define_column(l_CursorID, 3, L_LINK_DESC, 1000);
1608:
1609: If(P_JTF_OBJECT_CODE <> 'IBU_TP_SR_PROBCODE') Then
1610: dbms_sql.define_column(l_CursorID, 4, L_OTHER_ID);
1611: Else

Line 1610: dbms_sql.define_column(l_CursorID, 4, L_OTHER_ID);

1606: dbms_sql.define_column(l_CursorID, 2, L_LINK_NAME, 300);
1607: dbms_sql.define_column(l_CursorID, 3, L_LINK_DESC, 1000);
1608:
1609: If(P_JTF_OBJECT_CODE <> 'IBU_TP_SR_PROBCODE') Then
1610: dbms_sql.define_column(l_CursorID, 4, L_OTHER_ID);
1611: Else
1612: dbms_sql.define_column(l_CursorID, 4, L_OTHER_CODE, 30);
1613: End If;
1614:

Line 1612: dbms_sql.define_column(l_CursorID, 4, L_OTHER_CODE, 30);

1608:
1609: If(P_JTF_OBJECT_CODE <> 'IBU_TP_SR_PROBCODE') Then
1610: dbms_sql.define_column(l_CursorID, 4, L_OTHER_ID);
1611: Else
1612: dbms_sql.define_column(l_CursorID, 4, L_OTHER_CODE, 30);
1613: End If;
1614:
1615: dbms_sql.define_column(l_CursorID, 5, L_LAST_UPDATE_DATE);
1616:

Line 1615: dbms_sql.define_column(l_CursorID, 5, L_LAST_UPDATE_DATE);

1611: Else
1612: dbms_sql.define_column(l_CursorID, 4, L_OTHER_CODE, 30);
1613: End If;
1614:
1615: dbms_sql.define_column(l_CursorID, 5, L_LAST_UPDATE_DATE);
1616:
1617: dbms_sql.bind_variable(l_CursorID, 'P_Template_ID', P_Template_ID);
1618: l_total_attribute_num := dbms_sql.execute(l_CursorID);
1619:

Line 1617: dbms_sql.bind_variable(l_CursorID, 'P_Template_ID', P_Template_ID);

1613: End If;
1614:
1615: dbms_sql.define_column(l_CursorID, 5, L_LAST_UPDATE_DATE);
1616:
1617: dbms_sql.bind_variable(l_CursorID, 'P_Template_ID', P_Template_ID);
1618: l_total_attribute_num := dbms_sql.execute(l_CursorID);
1619:
1620: i:=0;
1621: While (dbms_sql.fetch_rows(l_CursorID) > 0) Loop

Line 1618: l_total_attribute_num := dbms_sql.execute(l_CursorID);

1614:
1615: dbms_sql.define_column(l_CursorID, 5, L_LAST_UPDATE_DATE);
1616:
1617: dbms_sql.bind_variable(l_CursorID, 'P_Template_ID', P_Template_ID);
1618: l_total_attribute_num := dbms_sql.execute(l_CursorID);
1619:
1620: i:=0;
1621: While (dbms_sql.fetch_rows(l_CursorID) > 0) Loop
1622: dbms_sql.column_value(l_CursorID, 1, l_link_id);

Line 1621: While (dbms_sql.fetch_rows(l_CursorID) > 0) Loop

1617: dbms_sql.bind_variable(l_CursorID, 'P_Template_ID', P_Template_ID);
1618: l_total_attribute_num := dbms_sql.execute(l_CursorID);
1619:
1620: i:=0;
1621: While (dbms_sql.fetch_rows(l_CursorID) > 0) Loop
1622: dbms_sql.column_value(l_CursorID, 1, l_link_id);
1623: dbms_sql.column_value(l_CursorID, 2, l_link_name);
1624: dbms_sql.column_value(l_CursorID, 3, l_link_desc);
1625:

Line 1622: dbms_sql.column_value(l_CursorID, 1, l_link_id);

1618: l_total_attribute_num := dbms_sql.execute(l_CursorID);
1619:
1620: i:=0;
1621: While (dbms_sql.fetch_rows(l_CursorID) > 0) Loop
1622: dbms_sql.column_value(l_CursorID, 1, l_link_id);
1623: dbms_sql.column_value(l_CursorID, 2, l_link_name);
1624: dbms_sql.column_value(l_CursorID, 3, l_link_desc);
1625:
1626: If(P_JTF_OBJECT_CODE <> 'IBU_TP_SR_PROBCODE') Then

Line 1623: dbms_sql.column_value(l_CursorID, 2, l_link_name);

1619:
1620: i:=0;
1621: While (dbms_sql.fetch_rows(l_CursorID) > 0) Loop
1622: dbms_sql.column_value(l_CursorID, 1, l_link_id);
1623: dbms_sql.column_value(l_CursorID, 2, l_link_name);
1624: dbms_sql.column_value(l_CursorID, 3, l_link_desc);
1625:
1626: If(P_JTF_OBJECT_CODE <> 'IBU_TP_SR_PROBCODE') Then
1627: dbms_sql.column_value(l_CursorID, 4, l_other_id);

Line 1624: dbms_sql.column_value(l_CursorID, 3, l_link_desc);

1620: i:=0;
1621: While (dbms_sql.fetch_rows(l_CursorID) > 0) Loop
1622: dbms_sql.column_value(l_CursorID, 1, l_link_id);
1623: dbms_sql.column_value(l_CursorID, 2, l_link_name);
1624: dbms_sql.column_value(l_CursorID, 3, l_link_desc);
1625:
1626: If(P_JTF_OBJECT_CODE <> 'IBU_TP_SR_PROBCODE') Then
1627: dbms_sql.column_value(l_CursorID, 4, l_other_id);
1628: Else

Line 1627: dbms_sql.column_value(l_CursorID, 4, l_other_id);

1623: dbms_sql.column_value(l_CursorID, 2, l_link_name);
1624: dbms_sql.column_value(l_CursorID, 3, l_link_desc);
1625:
1626: If(P_JTF_OBJECT_CODE <> 'IBU_TP_SR_PROBCODE') Then
1627: dbms_sql.column_value(l_CursorID, 4, l_other_id);
1628: Else
1629: dbms_sql.column_value(l_CursorID, 4, l_other_code);
1630: End If;
1631:

Line 1629: dbms_sql.column_value(l_CursorID, 4, l_other_code);

1625:
1626: If(P_JTF_OBJECT_CODE <> 'IBU_TP_SR_PROBCODE') Then
1627: dbms_sql.column_value(l_CursorID, 4, l_other_id);
1628: Else
1629: dbms_sql.column_value(l_CursorID, 4, l_other_code);
1630: End If;
1631:
1632: dbms_sql.column_value(l_CursorID, 5, l_last_update_date);
1633: x_template_links (i).mLinkID := l_link_id;

Line 1632: dbms_sql.column_value(l_CursorID, 5, l_last_update_date);

1628: Else
1629: dbms_sql.column_value(l_CursorID, 4, l_other_code);
1630: End If;
1631:
1632: dbms_sql.column_value(l_CursorID, 5, l_last_update_date);
1633: x_template_links (i).mLinkID := l_link_id;
1634: x_template_links (i).mLinkName := l_link_name;
1635: x_template_links (i).mLinkDesc := l_link_desc;
1636: x_template_links (i).mJTF_OBJECT_CODE := p_jtf_object_code;

Line 1648: dbms_sql.close_cursor(l_CursorID);

1644: to_char (l_last_update_date, l_default_last_up_date_format);
1645:
1646: i:= i+1;
1647: End Loop;
1648: dbms_sql.close_cursor(l_CursorID);
1649:
1650: IF FND_API.To_Boolean( p_commit ) THEN
1651: COMMIT WORK;
1652: END IF;

Line 1818: l_CursorID := dbms_sql.open_cursor;

1814: || l_ORDER_BY_CLAUSE;
1815: End If;
1816: End If;
1817:
1818: l_CursorID := dbms_sql.open_cursor;
1819: dbms_sql.parse(l_CursorID, l_statement, dbms_sql.NATIVE);
1820:
1821: If(P_JTF_OBJECT_CODE <> 'IBU_TP_SR_PROBCODE') Then
1822: dbms_sql.define_column(l_CursorID, 1, l_other_id);

Line 1819: dbms_sql.parse(l_CursorID, l_statement, dbms_sql.NATIVE);

1815: End If;
1816: End If;
1817:
1818: l_CursorID := dbms_sql.open_cursor;
1819: dbms_sql.parse(l_CursorID, l_statement, dbms_sql.NATIVE);
1820:
1821: If(P_JTF_OBJECT_CODE <> 'IBU_TP_SR_PROBCODE') Then
1822: dbms_sql.define_column(l_CursorID, 1, l_other_id);
1823: Else

Line 1822: dbms_sql.define_column(l_CursorID, 1, l_other_id);

1818: l_CursorID := dbms_sql.open_cursor;
1819: dbms_sql.parse(l_CursorID, l_statement, dbms_sql.NATIVE);
1820:
1821: If(P_JTF_OBJECT_CODE <> 'IBU_TP_SR_PROBCODE') Then
1822: dbms_sql.define_column(l_CursorID, 1, l_other_id);
1823: Else
1824: dbms_sql.define_column(l_CursorID, 1, l_other_code, 30);
1825: End If;
1826: dbms_sql.define_column(l_CursorID, 2, l_link_name, 300);

Line 1824: dbms_sql.define_column(l_CursorID, 1, l_other_code, 30);

1820:
1821: If(P_JTF_OBJECT_CODE <> 'IBU_TP_SR_PROBCODE') Then
1822: dbms_sql.define_column(l_CursorID, 1, l_other_id);
1823: Else
1824: dbms_sql.define_column(l_CursorID, 1, l_other_code, 30);
1825: End If;
1826: dbms_sql.define_column(l_CursorID, 2, l_link_name, 300);
1827: dbms_sql.define_column(l_CursorID, 3, l_link_detail, 1000);
1828:

Line 1826: dbms_sql.define_column(l_CursorID, 2, l_link_name, 300);

1822: dbms_sql.define_column(l_CursorID, 1, l_other_id);
1823: Else
1824: dbms_sql.define_column(l_CursorID, 1, l_other_code, 30);
1825: End If;
1826: dbms_sql.define_column(l_CursorID, 2, l_link_name, 300);
1827: dbms_sql.define_column(l_CursorID, 3, l_link_detail, 1000);
1828:
1829: dbms_sql.bind_variable(l_CursorID, 'P_Template_ID', P_Template_ID);
1830: l_total_attribute_num := dbms_sql.execute(l_CursorID);

Line 1827: dbms_sql.define_column(l_CursorID, 3, l_link_detail, 1000);

1823: Else
1824: dbms_sql.define_column(l_CursorID, 1, l_other_code, 30);
1825: End If;
1826: dbms_sql.define_column(l_CursorID, 2, l_link_name, 300);
1827: dbms_sql.define_column(l_CursorID, 3, l_link_detail, 1000);
1828:
1829: dbms_sql.bind_variable(l_CursorID, 'P_Template_ID', P_Template_ID);
1830: l_total_attribute_num := dbms_sql.execute(l_CursorID);
1831: i:=0;

Line 1829: dbms_sql.bind_variable(l_CursorID, 'P_Template_ID', P_Template_ID);

1825: End If;
1826: dbms_sql.define_column(l_CursorID, 2, l_link_name, 300);
1827: dbms_sql.define_column(l_CursorID, 3, l_link_detail, 1000);
1828:
1829: dbms_sql.bind_variable(l_CursorID, 'P_Template_ID', P_Template_ID);
1830: l_total_attribute_num := dbms_sql.execute(l_CursorID);
1831: i:=0;
1832: While (dbms_sql.fetch_rows(l_CursorID) > 0) Loop
1833: If(P_JTF_OBJECT_CODE <> 'IBU_TP_SR_PROBCODE') Then

Line 1830: l_total_attribute_num := dbms_sql.execute(l_CursorID);

1826: dbms_sql.define_column(l_CursorID, 2, l_link_name, 300);
1827: dbms_sql.define_column(l_CursorID, 3, l_link_detail, 1000);
1828:
1829: dbms_sql.bind_variable(l_CursorID, 'P_Template_ID', P_Template_ID);
1830: l_total_attribute_num := dbms_sql.execute(l_CursorID);
1831: i:=0;
1832: While (dbms_sql.fetch_rows(l_CursorID) > 0) Loop
1833: If(P_JTF_OBJECT_CODE <> 'IBU_TP_SR_PROBCODE') Then
1834: dbms_sql.column_value(l_CursorID, 1, l_other_id);

Line 1832: While (dbms_sql.fetch_rows(l_CursorID) > 0) Loop

1828:
1829: dbms_sql.bind_variable(l_CursorID, 'P_Template_ID', P_Template_ID);
1830: l_total_attribute_num := dbms_sql.execute(l_CursorID);
1831: i:=0;
1832: While (dbms_sql.fetch_rows(l_CursorID) > 0) Loop
1833: If(P_JTF_OBJECT_CODE <> 'IBU_TP_SR_PROBCODE') Then
1834: dbms_sql.column_value(l_CursorID, 1, l_other_id);
1835: Else
1836: dbms_sql.column_value(l_CursorID, 1, l_other_code);

Line 1834: dbms_sql.column_value(l_CursorID, 1, l_other_id);

1830: l_total_attribute_num := dbms_sql.execute(l_CursorID);
1831: i:=0;
1832: While (dbms_sql.fetch_rows(l_CursorID) > 0) Loop
1833: If(P_JTF_OBJECT_CODE <> 'IBU_TP_SR_PROBCODE') Then
1834: dbms_sql.column_value(l_CursorID, 1, l_other_id);
1835: Else
1836: dbms_sql.column_value(l_CursorID, 1, l_other_code);
1837: End If;
1838: dbms_sql.column_value(l_CursorID, 2, l_link_name);

Line 1836: dbms_sql.column_value(l_CursorID, 1, l_other_code);

1832: While (dbms_sql.fetch_rows(l_CursorID) > 0) Loop
1833: If(P_JTF_OBJECT_CODE <> 'IBU_TP_SR_PROBCODE') Then
1834: dbms_sql.column_value(l_CursorID, 1, l_other_id);
1835: Else
1836: dbms_sql.column_value(l_CursorID, 1, l_other_code);
1837: End If;
1838: dbms_sql.column_value(l_CursorID, 2, l_link_name);
1839: dbms_sql.column_value(l_CursorID, 3, l_link_detail);
1840: If(P_JTF_OBJECT_CODE <> 'IBU_TP_SR_PROBCODE') Then

Line 1838: dbms_sql.column_value(l_CursorID, 2, l_link_name);

1834: dbms_sql.column_value(l_CursorID, 1, l_other_id);
1835: Else
1836: dbms_sql.column_value(l_CursorID, 1, l_other_code);
1837: End If;
1838: dbms_sql.column_value(l_CursorID, 2, l_link_name);
1839: dbms_sql.column_value(l_CursorID, 3, l_link_detail);
1840: If(P_JTF_OBJECT_CODE <> 'IBU_TP_SR_PROBCODE') Then
1841: x_template_link_list (i).mOther_ID := l_other_id;
1842: Else

Line 1839: dbms_sql.column_value(l_CursorID, 3, l_link_detail);

1835: Else
1836: dbms_sql.column_value(l_CursorID, 1, l_other_code);
1837: End If;
1838: dbms_sql.column_value(l_CursorID, 2, l_link_name);
1839: dbms_sql.column_value(l_CursorID, 3, l_link_detail);
1840: If(P_JTF_OBJECT_CODE <> 'IBU_TP_SR_PROBCODE') Then
1841: x_template_link_list (i).mOther_ID := l_other_id;
1842: Else
1843: x_template_link_list (i).LOOKUP_CODE := l_other_code;

Line 1851: dbms_sql.close_cursor(l_CursorID);

1847:
1848: i:= i+1;
1849: End Loop;
1850:
1851: dbms_sql.close_cursor(l_CursorID);
1852:
1853: IF FND_API.To_Boolean( p_commit ) THEN
1854: COMMIT WORK;
1855: END IF;

Line 2635: l_CursorID := dbms_sql.open_cursor;

2631: || l_ORDER_BY_CLAUSE;
2632: End If;
2633: End If;
2634:
2635: l_CursorID := dbms_sql.open_cursor;
2636: dbms_sql.parse(l_CursorID, l_statement, dbms_sql.NATIVE);
2637: dbms_sql.define_column(l_CursorID, 1, L_LINK_ID);
2638: dbms_sql.define_column(l_CursorID, 2, L_LINK_NAME, 300);
2639: dbms_sql.define_column(l_CursorID, 3, L_LINK_DESC, 1000);

Line 2636: dbms_sql.parse(l_CursorID, l_statement, dbms_sql.NATIVE);

2632: End If;
2633: End If;
2634:
2635: l_CursorID := dbms_sql.open_cursor;
2636: dbms_sql.parse(l_CursorID, l_statement, dbms_sql.NATIVE);
2637: dbms_sql.define_column(l_CursorID, 1, L_LINK_ID);
2638: dbms_sql.define_column(l_CursorID, 2, L_LINK_NAME, 300);
2639: dbms_sql.define_column(l_CursorID, 3, L_LINK_DESC, 1000);
2640:

Line 2637: dbms_sql.define_column(l_CursorID, 1, L_LINK_ID);

2633: End If;
2634:
2635: l_CursorID := dbms_sql.open_cursor;
2636: dbms_sql.parse(l_CursorID, l_statement, dbms_sql.NATIVE);
2637: dbms_sql.define_column(l_CursorID, 1, L_LINK_ID);
2638: dbms_sql.define_column(l_CursorID, 2, L_LINK_NAME, 300);
2639: dbms_sql.define_column(l_CursorID, 3, L_LINK_DESC, 1000);
2640:
2641: If(P_JTF_OBJECT_CODE <> 'IBU_TP_SR_PROBCODE') Then

Line 2638: dbms_sql.define_column(l_CursorID, 2, L_LINK_NAME, 300);

2634:
2635: l_CursorID := dbms_sql.open_cursor;
2636: dbms_sql.parse(l_CursorID, l_statement, dbms_sql.NATIVE);
2637: dbms_sql.define_column(l_CursorID, 1, L_LINK_ID);
2638: dbms_sql.define_column(l_CursorID, 2, L_LINK_NAME, 300);
2639: dbms_sql.define_column(l_CursorID, 3, L_LINK_DESC, 1000);
2640:
2641: If(P_JTF_OBJECT_CODE <> 'IBU_TP_SR_PROBCODE') Then
2642: dbms_sql.define_column(l_CursorID, 4, L_OTHER_ID);

Line 2639: dbms_sql.define_column(l_CursorID, 3, L_LINK_DESC, 1000);

2635: l_CursorID := dbms_sql.open_cursor;
2636: dbms_sql.parse(l_CursorID, l_statement, dbms_sql.NATIVE);
2637: dbms_sql.define_column(l_CursorID, 1, L_LINK_ID);
2638: dbms_sql.define_column(l_CursorID, 2, L_LINK_NAME, 300);
2639: dbms_sql.define_column(l_CursorID, 3, L_LINK_DESC, 1000);
2640:
2641: If(P_JTF_OBJECT_CODE <> 'IBU_TP_SR_PROBCODE') Then
2642: dbms_sql.define_column(l_CursorID, 4, L_OTHER_ID);
2643: Else

Line 2642: dbms_sql.define_column(l_CursorID, 4, L_OTHER_ID);

2638: dbms_sql.define_column(l_CursorID, 2, L_LINK_NAME, 300);
2639: dbms_sql.define_column(l_CursorID, 3, L_LINK_DESC, 1000);
2640:
2641: If(P_JTF_OBJECT_CODE <> 'IBU_TP_SR_PROBCODE') Then
2642: dbms_sql.define_column(l_CursorID, 4, L_OTHER_ID);
2643: Else
2644: dbms_sql.define_column(l_CursorID, 4, L_OTHER_CODE, 30);
2645: End If;
2646:

Line 2644: dbms_sql.define_column(l_CursorID, 4, L_OTHER_CODE, 30);

2640:
2641: If(P_JTF_OBJECT_CODE <> 'IBU_TP_SR_PROBCODE') Then
2642: dbms_sql.define_column(l_CursorID, 4, L_OTHER_ID);
2643: Else
2644: dbms_sql.define_column(l_CursorID, 4, L_OTHER_CODE, 30);
2645: End If;
2646:
2647: dbms_sql.define_column(l_CursorID, 5, L_LAST_UPDATE_DATE);
2648:

Line 2647: dbms_sql.define_column(l_CursorID, 5, L_LAST_UPDATE_DATE);

2643: Else
2644: dbms_sql.define_column(l_CursorID, 4, L_OTHER_CODE, 30);
2645: End If;
2646:
2647: dbms_sql.define_column(l_CursorID, 5, L_LAST_UPDATE_DATE);
2648:
2649: dbms_sql.bind_variable(l_CursorID, 'P_Template_ID', P_Template_ID);
2650:
2651: l_total_attribute_num := dbms_sql.execute(l_CursorID);

Line 2649: dbms_sql.bind_variable(l_CursorID, 'P_Template_ID', P_Template_ID);

2645: End If;
2646:
2647: dbms_sql.define_column(l_CursorID, 5, L_LAST_UPDATE_DATE);
2648:
2649: dbms_sql.bind_variable(l_CursorID, 'P_Template_ID', P_Template_ID);
2650:
2651: l_total_attribute_num := dbms_sql.execute(l_CursorID);
2652:
2653: i:=1;

Line 2651: l_total_attribute_num := dbms_sql.execute(l_CursorID);

2647: dbms_sql.define_column(l_CursorID, 5, L_LAST_UPDATE_DATE);
2648:
2649: dbms_sql.bind_variable(l_CursorID, 'P_Template_ID', P_Template_ID);
2650:
2651: l_total_attribute_num := dbms_sql.execute(l_CursorID);
2652:
2653: i:=1;
2654: j:=0;
2655:

Line 2656: While (dbms_sql.fetch_rows(l_CursorID) > 0) Loop

2652:
2653: i:=1;
2654: j:=0;
2655:
2656: While (dbms_sql.fetch_rows(l_CursorID) > 0) Loop
2657: If (i >= l_start_link and i <= l_end_link) Then
2658: dbms_sql.column_value(l_CursorID, 1, l_link_id);
2659: dbms_sql.column_value(l_CursorID, 2, l_link_name);
2660: dbms_sql.column_value(l_CursorID, 3, l_link_desc);

Line 2658: dbms_sql.column_value(l_CursorID, 1, l_link_id);

2654: j:=0;
2655:
2656: While (dbms_sql.fetch_rows(l_CursorID) > 0) Loop
2657: If (i >= l_start_link and i <= l_end_link) Then
2658: dbms_sql.column_value(l_CursorID, 1, l_link_id);
2659: dbms_sql.column_value(l_CursorID, 2, l_link_name);
2660: dbms_sql.column_value(l_CursorID, 3, l_link_desc);
2661:
2662: If(P_JTF_OBJECT_CODE <> 'IBU_TP_SR_PROBCODE') Then

Line 2659: dbms_sql.column_value(l_CursorID, 2, l_link_name);

2655:
2656: While (dbms_sql.fetch_rows(l_CursorID) > 0) Loop
2657: If (i >= l_start_link and i <= l_end_link) Then
2658: dbms_sql.column_value(l_CursorID, 1, l_link_id);
2659: dbms_sql.column_value(l_CursorID, 2, l_link_name);
2660: dbms_sql.column_value(l_CursorID, 3, l_link_desc);
2661:
2662: If(P_JTF_OBJECT_CODE <> 'IBU_TP_SR_PROBCODE') Then
2663: dbms_sql.column_value(l_CursorID, 4, l_other_id);

Line 2660: dbms_sql.column_value(l_CursorID, 3, l_link_desc);

2656: While (dbms_sql.fetch_rows(l_CursorID) > 0) Loop
2657: If (i >= l_start_link and i <= l_end_link) Then
2658: dbms_sql.column_value(l_CursorID, 1, l_link_id);
2659: dbms_sql.column_value(l_CursorID, 2, l_link_name);
2660: dbms_sql.column_value(l_CursorID, 3, l_link_desc);
2661:
2662: If(P_JTF_OBJECT_CODE <> 'IBU_TP_SR_PROBCODE') Then
2663: dbms_sql.column_value(l_CursorID, 4, l_other_id);
2664: Else

Line 2663: dbms_sql.column_value(l_CursorID, 4, l_other_id);

2659: dbms_sql.column_value(l_CursorID, 2, l_link_name);
2660: dbms_sql.column_value(l_CursorID, 3, l_link_desc);
2661:
2662: If(P_JTF_OBJECT_CODE <> 'IBU_TP_SR_PROBCODE') Then
2663: dbms_sql.column_value(l_CursorID, 4, l_other_id);
2664: Else
2665: dbms_sql.column_value(l_CursorID, 4, l_other_code);
2666: End If;
2667:

Line 2665: dbms_sql.column_value(l_CursorID, 4, l_other_code);

2661:
2662: If(P_JTF_OBJECT_CODE <> 'IBU_TP_SR_PROBCODE') Then
2663: dbms_sql.column_value(l_CursorID, 4, l_other_id);
2664: Else
2665: dbms_sql.column_value(l_CursorID, 4, l_other_code);
2666: End If;
2667:
2668: dbms_sql.column_value(l_CursorID, 5, l_last_update_date);
2669: x_template_links (j).mLinkID := l_link_id;

Line 2668: dbms_sql.column_value(l_CursorID, 5, l_last_update_date);

2664: Else
2665: dbms_sql.column_value(l_CursorID, 4, l_other_code);
2666: End If;
2667:
2668: dbms_sql.column_value(l_CursorID, 5, l_last_update_date);
2669: x_template_links (j).mLinkID := l_link_id;
2670: x_template_links (j).mLinkName := l_link_name;
2671: x_template_links (j).mLinkDesc := l_link_desc;
2672: x_template_links (j).mJTF_OBJECT_CODE := p_jtf_object_code;

Line 2687: dbms_sql.close_cursor(l_CursorID);

2683: null;
2684: end if;
2685: i:= i+1;
2686: End Loop;
2687: dbms_sql.close_cursor(l_CursorID);
2688:
2689: X_Total_Link_Number := i-1;
2690: X_Retrieved_Link_Number := j;
2691:

Line 2997: l_CursorID := dbms_sql.open_cursor;

2993: if(l_orderby_number > 0) then
2994: l_statement_two := substr(l_statement_two, 1, l_orderby_number-1);
2995: end if;
2996:
2997: l_CursorID := dbms_sql.open_cursor;
2998: l_CursorID_2 := dbms_sql.open_cursor;
2999: dbms_sql.parse(l_CursorID, l_statement, dbms_sql.NATIVE);
3000: dbms_sql.parse(l_CursorID_2, l_statement_two, dbms_sql.NATIVE);
3001:

Line 2998: l_CursorID_2 := dbms_sql.open_cursor;

2994: l_statement_two := substr(l_statement_two, 1, l_orderby_number-1);
2995: end if;
2996:
2997: l_CursorID := dbms_sql.open_cursor;
2998: l_CursorID_2 := dbms_sql.open_cursor;
2999: dbms_sql.parse(l_CursorID, l_statement, dbms_sql.NATIVE);
3000: dbms_sql.parse(l_CursorID_2, l_statement_two, dbms_sql.NATIVE);
3001:
3002:

Line 2999: dbms_sql.parse(l_CursorID, l_statement, dbms_sql.NATIVE);

2995: end if;
2996:
2997: l_CursorID := dbms_sql.open_cursor;
2998: l_CursorID_2 := dbms_sql.open_cursor;
2999: dbms_sql.parse(l_CursorID, l_statement, dbms_sql.NATIVE);
3000: dbms_sql.parse(l_CursorID_2, l_statement_two, dbms_sql.NATIVE);
3001:
3002:
3003: If(P_JTF_OBJECT_CODE <> 'IBU_TP_SR_PROBCODE') Then

Line 3000: dbms_sql.parse(l_CursorID_2, l_statement_two, dbms_sql.NATIVE);

2996:
2997: l_CursorID := dbms_sql.open_cursor;
2998: l_CursorID_2 := dbms_sql.open_cursor;
2999: dbms_sql.parse(l_CursorID, l_statement, dbms_sql.NATIVE);
3000: dbms_sql.parse(l_CursorID_2, l_statement_two, dbms_sql.NATIVE);
3001:
3002:
3003: If(P_JTF_OBJECT_CODE <> 'IBU_TP_SR_PROBCODE') Then
3004: dbms_sql.define_column(l_CursorID, 1, l_other_id);

Line 3004: dbms_sql.define_column(l_CursorID, 1, l_other_id);

3000: dbms_sql.parse(l_CursorID_2, l_statement_two, dbms_sql.NATIVE);
3001:
3002:
3003: If(P_JTF_OBJECT_CODE <> 'IBU_TP_SR_PROBCODE') Then
3004: dbms_sql.define_column(l_CursorID, 1, l_other_id);
3005: Else
3006: dbms_sql.define_column(l_CursorID, 1, l_other_code, 30);
3007: End If;
3008: dbms_sql.define_column(l_CursorID, 2, l_link_name, 300);

Line 3006: dbms_sql.define_column(l_CursorID, 1, l_other_code, 30);

3002:
3003: If(P_JTF_OBJECT_CODE <> 'IBU_TP_SR_PROBCODE') Then
3004: dbms_sql.define_column(l_CursorID, 1, l_other_id);
3005: Else
3006: dbms_sql.define_column(l_CursorID, 1, l_other_code, 30);
3007: End If;
3008: dbms_sql.define_column(l_CursorID, 2, l_link_name, 300);
3009: dbms_sql.define_column(l_CursorID, 3, l_link_detail, 1000);
3010:

Line 3008: dbms_sql.define_column(l_CursorID, 2, l_link_name, 300);

3004: dbms_sql.define_column(l_CursorID, 1, l_other_id);
3005: Else
3006: dbms_sql.define_column(l_CursorID, 1, l_other_code, 30);
3007: End If;
3008: dbms_sql.define_column(l_CursorID, 2, l_link_name, 300);
3009: dbms_sql.define_column(l_CursorID, 3, l_link_detail, 1000);
3010:
3011: dbms_sql.define_column(l_CursorID_2, 1, l_total_number);
3012:

Line 3009: dbms_sql.define_column(l_CursorID, 3, l_link_detail, 1000);

3005: Else
3006: dbms_sql.define_column(l_CursorID, 1, l_other_code, 30);
3007: End If;
3008: dbms_sql.define_column(l_CursorID, 2, l_link_name, 300);
3009: dbms_sql.define_column(l_CursorID, 3, l_link_detail, 1000);
3010:
3011: dbms_sql.define_column(l_CursorID_2, 1, l_total_number);
3012:
3013: dbms_sql.bind_variable(l_CursorID, 'P_Template_ID', P_Template_ID);

Line 3011: dbms_sql.define_column(l_CursorID_2, 1, l_total_number);

3007: End If;
3008: dbms_sql.define_column(l_CursorID, 2, l_link_name, 300);
3009: dbms_sql.define_column(l_CursorID, 3, l_link_detail, 1000);
3010:
3011: dbms_sql.define_column(l_CursorID_2, 1, l_total_number);
3012:
3013: dbms_sql.bind_variable(l_CursorID, 'P_Template_ID', P_Template_ID);
3014: dbms_sql.bind_variable(l_CursorID_2, 'P_Template_ID', P_Template_ID);
3015:

Line 3013: dbms_sql.bind_variable(l_CursorID, 'P_Template_ID', P_Template_ID);

3009: dbms_sql.define_column(l_CursorID, 3, l_link_detail, 1000);
3010:
3011: dbms_sql.define_column(l_CursorID_2, 1, l_total_number);
3012:
3013: dbms_sql.bind_variable(l_CursorID, 'P_Template_ID', P_Template_ID);
3014: dbms_sql.bind_variable(l_CursorID_2, 'P_Template_ID', P_Template_ID);
3015:
3016: /* If(P_JTF_OBJECT_CODE = 'IBU_PRODUCT') Then
3017: l_inv_org_id := cs_std.get_item_valdn_orgzn_id();

Line 3014: dbms_sql.bind_variable(l_CursorID_2, 'P_Template_ID', P_Template_ID);

3010:
3011: dbms_sql.define_column(l_CursorID_2, 1, l_total_number);
3012:
3013: dbms_sql.bind_variable(l_CursorID, 'P_Template_ID', P_Template_ID);
3014: dbms_sql.bind_variable(l_CursorID_2, 'P_Template_ID', P_Template_ID);
3015:
3016: /* If(P_JTF_OBJECT_CODE = 'IBU_PRODUCT') Then
3017: l_inv_org_id := cs_std.get_item_valdn_orgzn_id();
3018: dbms_sql.bind_variable(l_CursorID, 'organizationID', l_inv_org_id);

Line 3018: dbms_sql.bind_variable(l_CursorID, 'organizationID', l_inv_org_id);

3014: dbms_sql.bind_variable(l_CursorID_2, 'P_Template_ID', P_Template_ID);
3015:
3016: /* If(P_JTF_OBJECT_CODE = 'IBU_PRODUCT') Then
3017: l_inv_org_id := cs_std.get_item_valdn_orgzn_id();
3018: dbms_sql.bind_variable(l_CursorID, 'organizationID', l_inv_org_id);
3019: dbms_sql.bind_variable(l_CursorID_2, 'organizationID', l_inv_org_id);
3020: end if; */
3021:
3022: If (l_ORDER_BY_CLAUSE Is not Null and

Line 3019: dbms_sql.bind_variable(l_CursorID_2, 'organizationID', l_inv_org_id);

3015:
3016: /* If(P_JTF_OBJECT_CODE = 'IBU_PRODUCT') Then
3017: l_inv_org_id := cs_std.get_item_valdn_orgzn_id();
3018: dbms_sql.bind_variable(l_CursorID, 'organizationID', l_inv_org_id);
3019: dbms_sql.bind_variable(l_CursorID_2, 'organizationID', l_inv_org_id);
3020: end if; */
3021:
3022: If (l_ORDER_BY_CLAUSE Is not Null and
3023: l_ORDER_BY_CLAUSE <> FND_API.G_MISS_CHAR

Line 3027: dbms_sql.bind_variable(l_CursorID, 'p_link_name', p_link_name||'%');

3023: l_ORDER_BY_CLAUSE <> FND_API.G_MISS_CHAR
3024: and length(l_ORDER_BY_CLAUSE) > 0 )then
3025: If (p_link_name Is Not Null and p_link_name <> FND_API.G_MISS_CHAR
3026: and length(p_link_name) > 0) Then
3027: dbms_sql.bind_variable(l_CursorID, 'p_link_name', p_link_name||'%');
3028: dbms_sql.bind_variable(l_CursorID_2, 'p_link_name', p_link_name||'%');
3029: end if ;
3030: end if ;
3031:

Line 3028: dbms_sql.bind_variable(l_CursorID_2, 'p_link_name', p_link_name||'%');

3024: and length(l_ORDER_BY_CLAUSE) > 0 )then
3025: If (p_link_name Is Not Null and p_link_name <> FND_API.G_MISS_CHAR
3026: and length(p_link_name) > 0) Then
3027: dbms_sql.bind_variable(l_CursorID, 'p_link_name', p_link_name||'%');
3028: dbms_sql.bind_variable(l_CursorID_2, 'p_link_name', p_link_name||'%');
3029: end if ;
3030: end if ;
3031:
3032: -- wei ma change

Line 3035: dbms_sql.bind_variable(l_CursorID, 'p_product_name_case_1', l_product_name_case_1);

3031:
3032: -- wei ma change
3033: if(P_JTF_OBJECT_CODE = 'IBU_PRODUCT') then
3034: if(l_link_name_length = 1) then
3035: dbms_sql.bind_variable(l_CursorID, 'p_product_name_case_1', l_product_name_case_1);
3036: dbms_sql.bind_variable(l_CursorID, 'p_product_name_case_2', l_product_name_case_2);
3037: dbms_sql.bind_variable(l_CursorID_2, 'p_product_name_case_1', l_product_name_case_1);
3038: dbms_sql.bind_variable(l_CursorID_2, 'p_product_name_case_2', l_product_name_case_2);
3039: end if;

Line 3036: dbms_sql.bind_variable(l_CursorID, 'p_product_name_case_2', l_product_name_case_2);

3032: -- wei ma change
3033: if(P_JTF_OBJECT_CODE = 'IBU_PRODUCT') then
3034: if(l_link_name_length = 1) then
3035: dbms_sql.bind_variable(l_CursorID, 'p_product_name_case_1', l_product_name_case_1);
3036: dbms_sql.bind_variable(l_CursorID, 'p_product_name_case_2', l_product_name_case_2);
3037: dbms_sql.bind_variable(l_CursorID_2, 'p_product_name_case_1', l_product_name_case_1);
3038: dbms_sql.bind_variable(l_CursorID_2, 'p_product_name_case_2', l_product_name_case_2);
3039: end if;
3040: if(l_link_name_length = 2) then

Line 3037: dbms_sql.bind_variable(l_CursorID_2, 'p_product_name_case_1', l_product_name_case_1);

3033: if(P_JTF_OBJECT_CODE = 'IBU_PRODUCT') then
3034: if(l_link_name_length = 1) then
3035: dbms_sql.bind_variable(l_CursorID, 'p_product_name_case_1', l_product_name_case_1);
3036: dbms_sql.bind_variable(l_CursorID, 'p_product_name_case_2', l_product_name_case_2);
3037: dbms_sql.bind_variable(l_CursorID_2, 'p_product_name_case_1', l_product_name_case_1);
3038: dbms_sql.bind_variable(l_CursorID_2, 'p_product_name_case_2', l_product_name_case_2);
3039: end if;
3040: if(l_link_name_length = 2) then
3041: dbms_sql.bind_variable(l_CursorID, 'p_product_name_case_1', l_product_name_case_1);

Line 3038: dbms_sql.bind_variable(l_CursorID_2, 'p_product_name_case_2', l_product_name_case_2);

3034: if(l_link_name_length = 1) then
3035: dbms_sql.bind_variable(l_CursorID, 'p_product_name_case_1', l_product_name_case_1);
3036: dbms_sql.bind_variable(l_CursorID, 'p_product_name_case_2', l_product_name_case_2);
3037: dbms_sql.bind_variable(l_CursorID_2, 'p_product_name_case_1', l_product_name_case_1);
3038: dbms_sql.bind_variable(l_CursorID_2, 'p_product_name_case_2', l_product_name_case_2);
3039: end if;
3040: if(l_link_name_length = 2) then
3041: dbms_sql.bind_variable(l_CursorID, 'p_product_name_case_1', l_product_name_case_1);
3042: dbms_sql.bind_variable(l_CursorID, 'p_product_name_case_2', l_product_name_case_2);

Line 3041: dbms_sql.bind_variable(l_CursorID, 'p_product_name_case_1', l_product_name_case_1);

3037: dbms_sql.bind_variable(l_CursorID_2, 'p_product_name_case_1', l_product_name_case_1);
3038: dbms_sql.bind_variable(l_CursorID_2, 'p_product_name_case_2', l_product_name_case_2);
3039: end if;
3040: if(l_link_name_length = 2) then
3041: dbms_sql.bind_variable(l_CursorID, 'p_product_name_case_1', l_product_name_case_1);
3042: dbms_sql.bind_variable(l_CursorID, 'p_product_name_case_2', l_product_name_case_2);
3043: dbms_sql.bind_variable(l_CursorID, 'p_product_name_case_3', l_product_name_case_3);
3044: dbms_sql.bind_variable(l_CursorID, 'p_product_name_case_4', l_product_name_case_4);
3045: dbms_sql.bind_variable(l_CursorID_2, 'p_product_name_case_1', l_product_name_case_1);

Line 3042: dbms_sql.bind_variable(l_CursorID, 'p_product_name_case_2', l_product_name_case_2);

3038: dbms_sql.bind_variable(l_CursorID_2, 'p_product_name_case_2', l_product_name_case_2);
3039: end if;
3040: if(l_link_name_length = 2) then
3041: dbms_sql.bind_variable(l_CursorID, 'p_product_name_case_1', l_product_name_case_1);
3042: dbms_sql.bind_variable(l_CursorID, 'p_product_name_case_2', l_product_name_case_2);
3043: dbms_sql.bind_variable(l_CursorID, 'p_product_name_case_3', l_product_name_case_3);
3044: dbms_sql.bind_variable(l_CursorID, 'p_product_name_case_4', l_product_name_case_4);
3045: dbms_sql.bind_variable(l_CursorID_2, 'p_product_name_case_1', l_product_name_case_1);
3046: dbms_sql.bind_variable(l_CursorID_2, 'p_product_name_case_2', l_product_name_case_2);

Line 3043: dbms_sql.bind_variable(l_CursorID, 'p_product_name_case_3', l_product_name_case_3);

3039: end if;
3040: if(l_link_name_length = 2) then
3041: dbms_sql.bind_variable(l_CursorID, 'p_product_name_case_1', l_product_name_case_1);
3042: dbms_sql.bind_variable(l_CursorID, 'p_product_name_case_2', l_product_name_case_2);
3043: dbms_sql.bind_variable(l_CursorID, 'p_product_name_case_3', l_product_name_case_3);
3044: dbms_sql.bind_variable(l_CursorID, 'p_product_name_case_4', l_product_name_case_4);
3045: dbms_sql.bind_variable(l_CursorID_2, 'p_product_name_case_1', l_product_name_case_1);
3046: dbms_sql.bind_variable(l_CursorID_2, 'p_product_name_case_2', l_product_name_case_2);
3047: dbms_sql.bind_variable(l_CursorID_2, 'p_product_name_case_3', l_product_name_case_3);

Line 3044: dbms_sql.bind_variable(l_CursorID, 'p_product_name_case_4', l_product_name_case_4);

3040: if(l_link_name_length = 2) then
3041: dbms_sql.bind_variable(l_CursorID, 'p_product_name_case_1', l_product_name_case_1);
3042: dbms_sql.bind_variable(l_CursorID, 'p_product_name_case_2', l_product_name_case_2);
3043: dbms_sql.bind_variable(l_CursorID, 'p_product_name_case_3', l_product_name_case_3);
3044: dbms_sql.bind_variable(l_CursorID, 'p_product_name_case_4', l_product_name_case_4);
3045: dbms_sql.bind_variable(l_CursorID_2, 'p_product_name_case_1', l_product_name_case_1);
3046: dbms_sql.bind_variable(l_CursorID_2, 'p_product_name_case_2', l_product_name_case_2);
3047: dbms_sql.bind_variable(l_CursorID_2, 'p_product_name_case_3', l_product_name_case_3);
3048: dbms_sql.bind_variable(l_CursorID_2, 'p_product_name_case_4', l_product_name_case_4);

Line 3045: dbms_sql.bind_variable(l_CursorID_2, 'p_product_name_case_1', l_product_name_case_1);

3041: dbms_sql.bind_variable(l_CursorID, 'p_product_name_case_1', l_product_name_case_1);
3042: dbms_sql.bind_variable(l_CursorID, 'p_product_name_case_2', l_product_name_case_2);
3043: dbms_sql.bind_variable(l_CursorID, 'p_product_name_case_3', l_product_name_case_3);
3044: dbms_sql.bind_variable(l_CursorID, 'p_product_name_case_4', l_product_name_case_4);
3045: dbms_sql.bind_variable(l_CursorID_2, 'p_product_name_case_1', l_product_name_case_1);
3046: dbms_sql.bind_variable(l_CursorID_2, 'p_product_name_case_2', l_product_name_case_2);
3047: dbms_sql.bind_variable(l_CursorID_2, 'p_product_name_case_3', l_product_name_case_3);
3048: dbms_sql.bind_variable(l_CursorID_2, 'p_product_name_case_4', l_product_name_case_4);
3049: end if;

Line 3046: dbms_sql.bind_variable(l_CursorID_2, 'p_product_name_case_2', l_product_name_case_2);

3042: dbms_sql.bind_variable(l_CursorID, 'p_product_name_case_2', l_product_name_case_2);
3043: dbms_sql.bind_variable(l_CursorID, 'p_product_name_case_3', l_product_name_case_3);
3044: dbms_sql.bind_variable(l_CursorID, 'p_product_name_case_4', l_product_name_case_4);
3045: dbms_sql.bind_variable(l_CursorID_2, 'p_product_name_case_1', l_product_name_case_1);
3046: dbms_sql.bind_variable(l_CursorID_2, 'p_product_name_case_2', l_product_name_case_2);
3047: dbms_sql.bind_variable(l_CursorID_2, 'p_product_name_case_3', l_product_name_case_3);
3048: dbms_sql.bind_variable(l_CursorID_2, 'p_product_name_case_4', l_product_name_case_4);
3049: end if;
3050: end if;

Line 3047: dbms_sql.bind_variable(l_CursorID_2, 'p_product_name_case_3', l_product_name_case_3);

3043: dbms_sql.bind_variable(l_CursorID, 'p_product_name_case_3', l_product_name_case_3);
3044: dbms_sql.bind_variable(l_CursorID, 'p_product_name_case_4', l_product_name_case_4);
3045: dbms_sql.bind_variable(l_CursorID_2, 'p_product_name_case_1', l_product_name_case_1);
3046: dbms_sql.bind_variable(l_CursorID_2, 'p_product_name_case_2', l_product_name_case_2);
3047: dbms_sql.bind_variable(l_CursorID_2, 'p_product_name_case_3', l_product_name_case_3);
3048: dbms_sql.bind_variable(l_CursorID_2, 'p_product_name_case_4', l_product_name_case_4);
3049: end if;
3050: end if;
3051:

Line 3048: dbms_sql.bind_variable(l_CursorID_2, 'p_product_name_case_4', l_product_name_case_4);

3044: dbms_sql.bind_variable(l_CursorID, 'p_product_name_case_4', l_product_name_case_4);
3045: dbms_sql.bind_variable(l_CursorID_2, 'p_product_name_case_1', l_product_name_case_1);
3046: dbms_sql.bind_variable(l_CursorID_2, 'p_product_name_case_2', l_product_name_case_2);
3047: dbms_sql.bind_variable(l_CursorID_2, 'p_product_name_case_3', l_product_name_case_3);
3048: dbms_sql.bind_variable(l_CursorID_2, 'p_product_name_case_4', l_product_name_case_4);
3049: end if;
3050: end if;
3051:
3052: l_total_attribute_num := dbms_sql.execute(l_CursorID);

Line 3052: l_total_attribute_num := dbms_sql.execute(l_CursorID);

3048: dbms_sql.bind_variable(l_CursorID_2, 'p_product_name_case_4', l_product_name_case_4);
3049: end if;
3050: end if;
3051:
3052: l_total_attribute_num := dbms_sql.execute(l_CursorID);
3053: l_total_number := dbms_sql.execute(l_CursorID_2);
3054:
3055: i:=1;
3056: j:=0;

Line 3053: l_total_number := dbms_sql.execute(l_CursorID_2);

3049: end if;
3050: end if;
3051:
3052: l_total_attribute_num := dbms_sql.execute(l_CursorID);
3053: l_total_number := dbms_sql.execute(l_CursorID_2);
3054:
3055: i:=1;
3056: j:=0;
3057:

Line 3058: While (dbms_sql.fetch_rows(l_CursorID) > 0) Loop

3054:
3055: i:=1;
3056: j:=0;
3057:
3058: While (dbms_sql.fetch_rows(l_CursorID) > 0) Loop
3059:
3060: if(i > l_end_link) then
3061: exit;
3062: end if;

Line 3065: dbms_sql.column_value(l_CursorID, 1, l_other_id);

3061: exit;
3062: end if;
3063: If (i >= l_start_link and i <= l_end_link) Then
3064: If(P_JTF_OBJECT_CODE <> 'IBU_TP_SR_PROBCODE') Then
3065: dbms_sql.column_value(l_CursorID, 1, l_other_id);
3066: Else
3067: dbms_sql.column_value(l_CursorID, 1, l_other_code);
3068: End If;
3069: dbms_sql.column_value(l_CursorID, 2, l_link_name);

Line 3067: dbms_sql.column_value(l_CursorID, 1, l_other_code);

3063: If (i >= l_start_link and i <= l_end_link) Then
3064: If(P_JTF_OBJECT_CODE <> 'IBU_TP_SR_PROBCODE') Then
3065: dbms_sql.column_value(l_CursorID, 1, l_other_id);
3066: Else
3067: dbms_sql.column_value(l_CursorID, 1, l_other_code);
3068: End If;
3069: dbms_sql.column_value(l_CursorID, 2, l_link_name);
3070: dbms_sql.column_value(l_CursorID, 3, l_link_detail);
3071: If(P_JTF_OBJECT_CODE <> 'IBU_TP_SR_PROBCODE') Then

Line 3069: dbms_sql.column_value(l_CursorID, 2, l_link_name);

3065: dbms_sql.column_value(l_CursorID, 1, l_other_id);
3066: Else
3067: dbms_sql.column_value(l_CursorID, 1, l_other_code);
3068: End If;
3069: dbms_sql.column_value(l_CursorID, 2, l_link_name);
3070: dbms_sql.column_value(l_CursorID, 3, l_link_detail);
3071: If(P_JTF_OBJECT_CODE <> 'IBU_TP_SR_PROBCODE') Then
3072: x_template_link_list (i).mOther_ID := l_other_id;
3073: Else

Line 3070: dbms_sql.column_value(l_CursorID, 3, l_link_detail);

3066: Else
3067: dbms_sql.column_value(l_CursorID, 1, l_other_code);
3068: End If;
3069: dbms_sql.column_value(l_CursorID, 2, l_link_name);
3070: dbms_sql.column_value(l_CursorID, 3, l_link_detail);
3071: If(P_JTF_OBJECT_CODE <> 'IBU_TP_SR_PROBCODE') Then
3072: x_template_link_list (i).mOther_ID := l_other_id;
3073: Else
3074: x_template_link_list (i).LOOKUP_CODE := l_other_code;

Line 3086: dbms_sql.close_cursor(l_CursorID);

3082:
3083: i:= i+1;
3084: End Loop;
3085:
3086: dbms_sql.close_cursor(l_CursorID);
3087:
3088: While (dbms_sql.fetch_rows(l_CursorID_2) > 0) Loop
3089: dbms_sql.column_value(l_CursorID_2, 1, l_total_number);
3090: end loop;

Line 3088: While (dbms_sql.fetch_rows(l_CursorID_2) > 0) Loop

3084: End Loop;
3085:
3086: dbms_sql.close_cursor(l_CursorID);
3087:
3088: While (dbms_sql.fetch_rows(l_CursorID_2) > 0) Loop
3089: dbms_sql.column_value(l_CursorID_2, 1, l_total_number);
3090: end loop;
3091: dbms_sql.close_cursor(l_CursorID_2);
3092:

Line 3089: dbms_sql.column_value(l_CursorID_2, 1, l_total_number);

3085:
3086: dbms_sql.close_cursor(l_CursorID);
3087:
3088: While (dbms_sql.fetch_rows(l_CursorID_2) > 0) Loop
3089: dbms_sql.column_value(l_CursorID_2, 1, l_total_number);
3090: end loop;
3091: dbms_sql.close_cursor(l_CursorID_2);
3092:
3093: --X_Total_Link_Number := i-1;'

Line 3091: dbms_sql.close_cursor(l_CursorID_2);

3087:
3088: While (dbms_sql.fetch_rows(l_CursorID_2) > 0) Loop
3089: dbms_sql.column_value(l_CursorID_2, 1, l_total_number);
3090: end loop;
3091: dbms_sql.close_cursor(l_CursorID_2);
3092:
3093: --X_Total_Link_Number := i-1;'
3094: X_Total_Link_Number := l_total_number;
3095: X_Retrieved_Link_Number := j;