APPS.AHL_PRD_PRINT_PVT dependencies on FND_FLEX_EXT

Line 37: x_mti_seglist OUT NOCOPY fnd_flex_ext.SegmentArray,

33: );
34:
35: PROCEDURE Get_Route_KFF_Desc (
36: p_concat_segs IN VARCHAR2,
37: x_mti_seglist OUT NOCOPY fnd_flex_ext.SegmentArray,
38: x_return_status OUT NOCOPY VARCHAR2);
39:
40: PROCEDURE Get_job_card_det ( l_merged_lob IN OUT NOCOPY CLOB,
41: l_wo_id_tbl IN OUT NOCOPY workorder_id_tbl_type,

Line 1956: l_mti_seglist fnd_flex_ext.SegmentArray;

1952: l_dummy_return BOOLEAN;
1953: l_counter_value NUMBER := null;
1954: l_net_reading NUMBER := null;
1955: l_concat_segment VARCHAR2(100);
1956: l_mti_seglist fnd_flex_ext.SegmentArray;
1957: kff_return_status VARCHAR2(1);
1958: l_nr_flag VARCHAR2(1);
1959:
1960: l_merged_lob CLOB;

Line 2963: || fnd_flex_ext.get_delimiter(''INV'', ''MTLL'', 101)

2959: BDPT.DESCRIPTION "Department",
2960: -- (Select INCIDENT_NUMBER from CS_INCIDENTS_ALL_B where INCIDENT_ID = AVB.SERVICE_REQUEST_ID) "NonRoutineTitle",
2961: MTLI.subinventory_code "SubInventory",
2962: DECODE(MSI.segment19, NULL, MTLI.concatenated_segments, INV_PROJECT.GET_LOCSEGS(MTLI.concatenated_segments)
2963: || fnd_flex_ext.get_delimiter(''INV'', ''MTLL'', 101)
2964: || INV_ProjectLocator_PUB.get_project_number(MSI.segment19)
2965: || fnd_flex_ext.get_delimiter(''INV'', ''MTLL'', 101)
2966: || INV_ProjectLocator_PUB.get_task_number(MSI.segment20)) "Locator",
2967: (Select INCIDENT_NUMBER from CS_INCIDENTS_ALL_B where INCIDENT_ID = AVB.SERVICE_REQUEST_ID) "NonRoutineTitle"

Line 2965: || fnd_flex_ext.get_delimiter(''INV'', ''MTLL'', 101)

2961: MTLI.subinventory_code "SubInventory",
2962: DECODE(MSI.segment19, NULL, MTLI.concatenated_segments, INV_PROJECT.GET_LOCSEGS(MTLI.concatenated_segments)
2963: || fnd_flex_ext.get_delimiter(''INV'', ''MTLL'', 101)
2964: || INV_ProjectLocator_PUB.get_project_number(MSI.segment19)
2965: || fnd_flex_ext.get_delimiter(''INV'', ''MTLL'', 101)
2966: || INV_ProjectLocator_PUB.get_task_number(MSI.segment20)) "Locator",
2967: (Select INCIDENT_NUMBER from CS_INCIDENTS_ALL_B where INCIDENT_ID = AVB.SERVICE_REQUEST_ID) "NonRoutineTitle"
2968: FROM AHL_VISITS_B AVB,
2969: MTL_SYSTEM_ITEMS_B_KFV MTSB,

Line 7639: x_mti_seglist OUT NOCOPY fnd_flex_ext.SegmentArray,

7635:
7636: END build_xml_qa_query;
7637:
7638: PROCEDURE Get_Route_KFF_Desc (p_concat_segs IN VARCHAR2,
7639: x_mti_seglist OUT NOCOPY fnd_flex_ext.SegmentArray,
7640: x_return_status OUT NOCOPY VARCHAR2)
7641: IS
7642: l_flex_nseg NUMBER;
7643: l_flex_seglist fnd_flex_key_api.segment_list;

Line 7650: l_loc_seglist fnd_flex_ext.SegmentArray;

7646: l_segment_type fnd_flex_key_api.segment_type;
7647: l_delim VARCHAR2(1);
7648:
7649: l_loc_nseg number;
7650: l_loc_seglist fnd_flex_ext.SegmentArray;
7651: l_mti_seglist fnd_flex_ext.SegmentArray;
7652: l_concat_seg_desc VARCHAR2(4000);
7653:
7654: l_valid_flag BOOLEAN;

Line 7651: l_mti_seglist fnd_flex_ext.SegmentArray;

7647: l_delim VARCHAR2(1);
7648:
7649: l_loc_nseg number;
7650: l_loc_seglist fnd_flex_ext.SegmentArray;
7651: l_mti_seglist fnd_flex_ext.SegmentArray;
7652: l_concat_seg_desc VARCHAR2(4000);
7653:
7654: l_valid_flag BOOLEAN;
7655: l_temp_string VARCHAR2(1000);

Line 7721: l_loc_nseg := fnd_flex_ext.breakup_segments (l_concat_seg_desc, l_delim, l_loc_seglist);

7717: -- get values for the concatenated segment descriptions
7718: l_concat_seg_desc := fnd_flex_keyval.concatenated_descriptions;
7719:
7720: -- breakup locator concat values into segments.
7721: l_loc_nseg := fnd_flex_ext.breakup_segments (l_concat_seg_desc, l_delim, l_loc_seglist);
7722:
7723: FOR l_loop IN 1..l_flex_nseg LOOP
7724:
7725: l_segment_type := fnd_flex_key_api.find_segment(l_fftype, l_ffstru, l_flex_seglist(l_loop));

Line 7782: l_mti_seglist fnd_flex_ext.SegmentArray;

7778: l_dummy_return BOOLEAN;
7779: l_counter_value NUMBER := null;
7780: l_net_reading NUMBER := null;
7781: l_concat_segment VARCHAR2(100);
7782: l_mti_seglist fnd_flex_ext.SegmentArray;
7783: kff_return_status VARCHAR2(1);
7784:
7785: --l_merged_lob CLOB;
7786: l_wo_mat_lob CLOB;