748: l_count NUMBER;
749:
750: /*CURSOR Cur_get_folder_cols IS
751: SELECT c.*, b.sequence
752: FROM fnd_folders a, fnd_folder_columns b, lm_tech_hdr c
753: WHERE a.folder_id = b.folder_id
754: AND b.item_prompt = c.tech_parm_name
755: AND a.name = V_folder_name
756: AND a.OBJECT = 'SPREAD_DTL_SUB'
760: -- if item parameters sequence is not defined.
761: CURSOR Cur_get_folder_cols IS
762: SELECT c.*, b.sequence
763: FROM fnd_folders a,
764: fnd_folder_columns b, lm_tech_hdr c, gmd_technical_sequence_vl s
765: WHERE a.folder_id(+) = b.folder_id
766: AND c.tech_parm_name = b.item_prompt(+)
767: AND a.name(+) = V_folder_name --- Bug 4254315 ....
768: AND a.OBJECT(+) = 'SPREAD_DTL_SUB'
773: AND NVL(s.category_id, 1) = NVL(l_category_id ,1)
774: UNION
775: SELECT c.*, b.sequence
776: FROM fnd_folders a,
777: fnd_folder_columns b, lm_tech_hdr c, gmd_technical_sequence_vl s
778: WHERE a.folder_id(+) = b.folder_id
779: AND c.tech_parm_name = b.item_prompt(+)
780: AND a.name(+) = V_folder_name --- Bug 4254315 ....
781: AND a.OBJECT(+) = 'SPREAD_DTL_SUB'