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.CSD_BULK_RECEIVE_UTIL dependencies on JTF_NUMBER_TABLE

Line 2658: l_in_progress_ro JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();

2654: l_repair_line_ids_in varchar2(2000);
2655:
2656: lc_api_name varchar2(200) := 'csd.plsql.csd_bulk_receive_util.get_sr_ro_rma_details';
2657:
2658: l_in_progress_ro JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
2659:
2660: l_check_loaner_sn varchar2(3) := 'N';
2661: l_check_loaner_non_sn varchar2(3) := 'N';
2662:

Line 2801: select * from TABLE(cast(get_num_in_list(l_repair_line_ids_in) as JTF_NUMBER_TABLE))

2797: and cpt.action_type = 'RMA'
2798: and cpt.prod_txn_status in ('RECEIVED','CANCELLED'))
2799: and cr.quantity = x_sr_ro_rma_tbl(l_counter).quantity
2800: and cr.repair_line_id not in (
2801: select * from TABLE(cast(get_num_in_list(l_repair_line_ids_in) as JTF_NUMBER_TABLE))
2802: union all select * from table(cast(l_in_progress_ro as JTF_NUMBER_TABLE)))
2803: order by cr.creation_date desc ) where rownum = 1;
2804:
2805: l_repair_line_ids_in := x_sr_ro_rma_tbl(l_counter).repair_line_id||',';

Line 2802: union all select * from table(cast(l_in_progress_ro as JTF_NUMBER_TABLE)))

2798: and cpt.prod_txn_status in ('RECEIVED','CANCELLED'))
2799: and cr.quantity = x_sr_ro_rma_tbl(l_counter).quantity
2800: and cr.repair_line_id not in (
2801: select * from TABLE(cast(get_num_in_list(l_repair_line_ids_in) as JTF_NUMBER_TABLE))
2802: union all select * from table(cast(l_in_progress_ro as JTF_NUMBER_TABLE)))
2803: order by cr.creation_date desc ) where rownum = 1;
2804:
2805: l_repair_line_ids_in := x_sr_ro_rma_tbl(l_counter).repair_line_id||',';
2806:

Line 2858: select * from TABLE(cast(get_num_in_list(l_repair_line_ids_in) as JTF_NUMBER_TABLE))

2854: and cpt1.action_code = 'LOANER'
2855: and cpt1.prod_txn_status in ('RECEIVED','CANCELLED')
2856: )
2857: and cr.repair_line_id not in (
2858: select * from TABLE(cast(get_num_in_list(l_repair_line_ids_in) as JTF_NUMBER_TABLE))
2859: union all select * from table(cast(l_in_progress_ro as JTF_NUMBER_TABLE)));
2860:
2861: l_check_loaner_non_sn := 'N';
2862: l_repair_line_ids_in := x_sr_ro_rma_tbl(l_counter).repair_line_id||',';

Line 2859: union all select * from table(cast(l_in_progress_ro as JTF_NUMBER_TABLE)));

2855: and cpt1.prod_txn_status in ('RECEIVED','CANCELLED')
2856: )
2857: and cr.repair_line_id not in (
2858: select * from TABLE(cast(get_num_in_list(l_repair_line_ids_in) as JTF_NUMBER_TABLE))
2859: union all select * from table(cast(l_in_progress_ro as JTF_NUMBER_TABLE)));
2860:
2861: l_check_loaner_non_sn := 'N';
2862: l_repair_line_ids_in := x_sr_ro_rma_tbl(l_counter).repair_line_id||',';
2863: exception

Line 2898: select * from TABLE(cast(get_num_in_list(l_repair_line_ids_in) as JTF_NUMBER_TABLE))

2894: where cpt.repair_line_id = cr.repair_line_id
2895: and cpt.action_type = 'RMA'
2896: and cpt.prod_txn_status in ('RECEIVED','CANCELLED'))
2897: and cr.repair_line_id not in (
2898: select * from TABLE(cast(get_num_in_list(l_repair_line_ids_in) as JTF_NUMBER_TABLE))
2899: union all select * from table(cast(l_in_progress_ro as JTF_NUMBER_TABLE)))
2900: order by cr.creation_date desc) where rownum = 1;
2901: -- bug#8978204, subhat.
2902: l_repair_line_ids_in := x_sr_ro_rma_tbl(l_counter).repair_line_id||',';

Line 2899: union all select * from table(cast(l_in_progress_ro as JTF_NUMBER_TABLE)))

2895: and cpt.action_type = 'RMA'
2896: and cpt.prod_txn_status in ('RECEIVED','CANCELLED'))
2897: and cr.repair_line_id not in (
2898: select * from TABLE(cast(get_num_in_list(l_repair_line_ids_in) as JTF_NUMBER_TABLE))
2899: union all select * from table(cast(l_in_progress_ro as JTF_NUMBER_TABLE)))
2900: order by cr.creation_date desc) where rownum = 1;
2901: -- bug#8978204, subhat.
2902: l_repair_line_ids_in := x_sr_ro_rma_tbl(l_counter).repair_line_id||',';
2903:

Line 2954: select * from TABLE(cast(get_num_in_list(l_repair_line_ids_in) as JTF_NUMBER_TABLE))

2950: AND cpt1.action_code = 'LOANER'
2951: AND cpt1.prod_txn_status in ('RECEIVED','CANCELLED')
2952: )
2953: and cr.repair_line_id not in (
2954: select * from TABLE(cast(get_num_in_list(l_repair_line_ids_in) as JTF_NUMBER_TABLE))
2955: union all select * from table(cast(l_in_progress_ro as JTF_NUMBER_TABLE)));
2956:
2957: l_check_loaner_sn := 'N';
2958: l_repair_line_ids_in := x_sr_ro_rma_tbl(l_counter).repair_line_id||',';

Line 2955: union all select * from table(cast(l_in_progress_ro as JTF_NUMBER_TABLE)));

2951: AND cpt1.prod_txn_status in ('RECEIVED','CANCELLED')
2952: )
2953: and cr.repair_line_id not in (
2954: select * from TABLE(cast(get_num_in_list(l_repair_line_ids_in) as JTF_NUMBER_TABLE))
2955: union all select * from table(cast(l_in_progress_ro as JTF_NUMBER_TABLE)));
2956:
2957: l_check_loaner_sn := 'N';
2958: l_repair_line_ids_in := x_sr_ro_rma_tbl(l_counter).repair_line_id||',';
2959:

Line 3333: x_repair_line_id OUT NOCOPY JTF_NUMBER_TABLE,

3329: PROCEDURE link_sr_ro_rma_oa_wrapper(
3330: p_bulk_rcv_dtls_tbl IN VARCHAR2_TABLE_200,
3331: p_mode IN VARCHAR2,
3332: p_incident_id IN NUMBER DEFAULT NULL,
3333: x_repair_line_id OUT NOCOPY JTF_NUMBER_TABLE,
3334: x_incident_id OUT NOCOPY JTF_NUMBER_TABLE,
3335: x_unplanned_receipt_flag OUT NOCOPY VARCHAR2_TABLE_100,
3336: x_over_receipt_flag OUT NOCOPY VARCHAR2_TABLE_100,
3337: x_under_receipt_flag OUT NOCOPY VARCHAR2_TABLE_100,

Line 3334: x_incident_id OUT NOCOPY JTF_NUMBER_TABLE,

3330: p_bulk_rcv_dtls_tbl IN VARCHAR2_TABLE_200,
3331: p_mode IN VARCHAR2,
3332: p_incident_id IN NUMBER DEFAULT NULL,
3333: x_repair_line_id OUT NOCOPY JTF_NUMBER_TABLE,
3334: x_incident_id OUT NOCOPY JTF_NUMBER_TABLE,
3335: x_unplanned_receipt_flag OUT NOCOPY VARCHAR2_TABLE_100,
3336: x_over_receipt_flag OUT NOCOPY VARCHAR2_TABLE_100,
3337: x_under_receipt_flag OUT NOCOPY VARCHAR2_TABLE_100,
3338: x_order_header_id OUT NOCOPY JTF_NUMBER_TABLE,

Line 3338: x_order_header_id OUT NOCOPY JTF_NUMBER_TABLE,

3334: x_incident_id OUT NOCOPY JTF_NUMBER_TABLE,
3335: x_unplanned_receipt_flag OUT NOCOPY VARCHAR2_TABLE_100,
3336: x_over_receipt_flag OUT NOCOPY VARCHAR2_TABLE_100,
3337: x_under_receipt_flag OUT NOCOPY VARCHAR2_TABLE_100,
3338: x_order_header_id OUT NOCOPY JTF_NUMBER_TABLE,
3339: x_order_line_id OUT NOCOPY JTF_NUMBER_TABLE,
3340: x_over_receipt_qty OUT NOCOPY JTF_NUMBER_TABLE,
3341: x_under_receipt_qty OUT NOCOPY JTF_NUMBER_TABLE
3342: ) IS

Line 3339: x_order_line_id OUT NOCOPY JTF_NUMBER_TABLE,

3335: x_unplanned_receipt_flag OUT NOCOPY VARCHAR2_TABLE_100,
3336: x_over_receipt_flag OUT NOCOPY VARCHAR2_TABLE_100,
3337: x_under_receipt_flag OUT NOCOPY VARCHAR2_TABLE_100,
3338: x_order_header_id OUT NOCOPY JTF_NUMBER_TABLE,
3339: x_order_line_id OUT NOCOPY JTF_NUMBER_TABLE,
3340: x_over_receipt_qty OUT NOCOPY JTF_NUMBER_TABLE,
3341: x_under_receipt_qty OUT NOCOPY JTF_NUMBER_TABLE
3342: ) IS
3343:

Line 3340: x_over_receipt_qty OUT NOCOPY JTF_NUMBER_TABLE,

3336: x_over_receipt_flag OUT NOCOPY VARCHAR2_TABLE_100,
3337: x_under_receipt_flag OUT NOCOPY VARCHAR2_TABLE_100,
3338: x_order_header_id OUT NOCOPY JTF_NUMBER_TABLE,
3339: x_order_line_id OUT NOCOPY JTF_NUMBER_TABLE,
3340: x_over_receipt_qty OUT NOCOPY JTF_NUMBER_TABLE,
3341: x_under_receipt_qty OUT NOCOPY JTF_NUMBER_TABLE
3342: ) IS
3343:
3344: x_sr_ro_rma_tbl SR_RO_RMA_TBL;

Line 3341: x_under_receipt_qty OUT NOCOPY JTF_NUMBER_TABLE

3337: x_under_receipt_flag OUT NOCOPY VARCHAR2_TABLE_100,
3338: x_order_header_id OUT NOCOPY JTF_NUMBER_TABLE,
3339: x_order_line_id OUT NOCOPY JTF_NUMBER_TABLE,
3340: x_over_receipt_qty OUT NOCOPY JTF_NUMBER_TABLE,
3341: x_under_receipt_qty OUT NOCOPY JTF_NUMBER_TABLE
3342: ) IS
3343:
3344: x_sr_ro_rma_tbl SR_RO_RMA_TBL;
3345: l_sr_ro_rma_tbl SR_RO_RMA_TBL;

Line 3353: x_repair_line_id := JTF_NUMBER_TABLE() ;

3349:
3350: begin
3351: l_count := l_bulk_rcv_dtls_tbl.COUNT;
3352: -- initialize the out collection types;
3353: x_repair_line_id := JTF_NUMBER_TABLE() ;
3354: x_incident_id := JTF_NUMBER_TABLE();
3355: x_unplanned_receipt_flag := VARCHAR2_TABLE_100();
3356: x_over_receipt_flag := VARCHAR2_TABLE_100();
3357: x_under_receipt_flag := VARCHAR2_TABLE_100();

Line 3354: x_incident_id := JTF_NUMBER_TABLE();

3350: begin
3351: l_count := l_bulk_rcv_dtls_tbl.COUNT;
3352: -- initialize the out collection types;
3353: x_repair_line_id := JTF_NUMBER_TABLE() ;
3354: x_incident_id := JTF_NUMBER_TABLE();
3355: x_unplanned_receipt_flag := VARCHAR2_TABLE_100();
3356: x_over_receipt_flag := VARCHAR2_TABLE_100();
3357: x_under_receipt_flag := VARCHAR2_TABLE_100();
3358: x_order_header_id := JTF_NUMBER_TABLE();

Line 3358: x_order_header_id := JTF_NUMBER_TABLE();

3354: x_incident_id := JTF_NUMBER_TABLE();
3355: x_unplanned_receipt_flag := VARCHAR2_TABLE_100();
3356: x_over_receipt_flag := VARCHAR2_TABLE_100();
3357: x_under_receipt_flag := VARCHAR2_TABLE_100();
3358: x_order_header_id := JTF_NUMBER_TABLE();
3359: x_order_line_id := JTF_NUMBER_TABLE();
3360: x_under_receipt_qty := JTF_NUMBER_TABLE();
3361: x_over_receipt_qty := JTF_NUMBER_TABLE();
3362:

Line 3359: x_order_line_id := JTF_NUMBER_TABLE();

3355: x_unplanned_receipt_flag := VARCHAR2_TABLE_100();
3356: x_over_receipt_flag := VARCHAR2_TABLE_100();
3357: x_under_receipt_flag := VARCHAR2_TABLE_100();
3358: x_order_header_id := JTF_NUMBER_TABLE();
3359: x_order_line_id := JTF_NUMBER_TABLE();
3360: x_under_receipt_qty := JTF_NUMBER_TABLE();
3361: x_over_receipt_qty := JTF_NUMBER_TABLE();
3362:
3363: for i in 1 ..l_count

Line 3360: x_under_receipt_qty := JTF_NUMBER_TABLE();

3356: x_over_receipt_flag := VARCHAR2_TABLE_100();
3357: x_under_receipt_flag := VARCHAR2_TABLE_100();
3358: x_order_header_id := JTF_NUMBER_TABLE();
3359: x_order_line_id := JTF_NUMBER_TABLE();
3360: x_under_receipt_qty := JTF_NUMBER_TABLE();
3361: x_over_receipt_qty := JTF_NUMBER_TABLE();
3362:
3363: for i in 1 ..l_count
3364: loop

Line 3361: x_over_receipt_qty := JTF_NUMBER_TABLE();

3357: x_under_receipt_flag := VARCHAR2_TABLE_100();
3358: x_order_header_id := JTF_NUMBER_TABLE();
3359: x_order_line_id := JTF_NUMBER_TABLE();
3360: x_under_receipt_qty := JTF_NUMBER_TABLE();
3361: x_over_receipt_qty := JTF_NUMBER_TABLE();
3362:
3363: for i in 1 ..l_count
3364: loop
3365: -- extend the collections

Line 3416: (select * from table(cast(get_num_in_list(l_bulk_receive_ids)as JTF_NUMBER_TABLE)) ) )

3412: if p_mode = 'UPDATE' then
3413: l_count := 1;
3414: for k in (select bulk_receive_id,serial_number,inventory_item_id,quantity
3415: from csd_bulk_receive_items_b where bulk_receive_id in
3416: (select * from table(cast(get_num_in_list(l_bulk_receive_ids)as JTF_NUMBER_TABLE)) ) )
3417: LOOP
3418: if (k.bulk_receive_id = x_sr_ro_rma_tbl(l_count).bulk_receive_id and
3419: nvl(k.serial_number,1) = nvl(x_sr_ro_rma_tbl(l_count).serial_number,1) and
3420: k.inventory_item_id = x_sr_ro_rma_tbl(l_count).inventory_item_id and

Line 4310: RETURN JTF_NUMBER_TABLE

4306: return l_incident_id;
4307: end get_latest_open_sr;
4308:
4309: FUNCTION get_num_in_list(p_in_string IN varchar2)
4310: RETURN JTF_NUMBER_TABLE
4311: IS
4312:
4313: l_in_string long default p_in_string;
4314: l_return_type JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();

Line 4314: l_return_type JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();

4310: RETURN JTF_NUMBER_TABLE
4311: IS
4312:
4313: l_in_string long default p_in_string;
4314: l_return_type JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
4315: n number;
4316: BEGIN
4317: loop
4318: exit when l_in_string is null;