DBA Data[Home] [Help]

APPS.CSI_ORDER_FULFILL_PUB dependencies on OE_ORDER_LINES_ALL

Line 208: ( p_order_line_rec IN oe_order_lines_all%rowtype,

204:
205:
206: -- added for the bug 5464761
207: PROCEDURE check_and_explode_bom
208: ( p_order_line_rec IN oe_order_lines_all%rowtype,
209: l_u_instance_rec IN OUT NOCOPY csi_datastructures_pub.instance_rec,
210: px_csi_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec,
211: x_return_status OUT NOCOPY varchar2)
212:

Line 235: l_order_line_rec oe_order_lines_all%rowtype;

231: l_bom_explode_flag BOOLEAN := FALSE;
232: l_split_flag varchar2(10);
233: l_auto_split_instances csi_datastructures_pub.instance_tbl;
234: l_ship_order_line_rec csi_order_ship_pub.order_line_rec;
235: l_order_line_rec oe_order_lines_all%rowtype;
236:
237:
238: begin
239:

Line 421: p_order_line_rec IN oe_order_lines_all%rowtype,

417: END check_and_explode_bom;
418:
419:
420: PROCEDURE create_dflt_txn_dtls(
421: p_order_line_rec IN oe_order_lines_all%rowtype,
422: px_default_info_rec IN OUT nocopy default_info_rec,
423: x_txn_line_rec OUT nocopy csi_t_datastructures_grp.txn_line_rec,
424: x_tld_tbl OUT nocopy csi_t_datastructures_grp.txn_line_detail_tbl,
425: x_tiir_tbl OUT nocopy csi_t_datastructures_grp.txn_ii_rltns_tbl,

Line 461: c_tl_rec.source_transaction_table := 'OE_ORDER_LINES_ALL';

457: l_bom_expl_org_flag := nvl(FND_PROFILE.VALUE('CSI_BOM_EXPLOSION_ORG'), 'N');
458: --csi_gen_utility_pvt.put_line('Group Explode BOM - l_bom_expl_org_flag - ' || l_bom_expl_org_flag);
459:
460: c_tl_rec.source_transaction_type_id := 51;
461: c_tl_rec.source_transaction_table := 'OE_ORDER_LINES_ALL';
462: c_tl_rec.source_transaction_id := p_order_line_rec.line_id;
463:
464: l_loop_count := 1;
465: l_quantity := p_order_line_rec.ordered_quantity;

Line 581: WHERE source_transaction_table = 'OE_ORDER_LINES_ALL'

577:
578: SELECT processing_status
579: INTO l_processing_status
580: FROM csi_t_transaction_lines
581: WHERE source_transaction_table = 'OE_ORDER_LINES_ALL'
582: AND source_transaction_id = p_parent_line_id;
583:
584: EXCEPTION
585: WHEN no_data_found THEN

Line 1313: FROM oe_order_lines_all

1309: l_line_rec oe_order_pub.line_rec_type := oe_order_pub.g_miss_line_rec;
1310:
1311: CURSOR op_cur is
1312: SELECT line_id
1313: FROM oe_order_lines_all
1314: WHERE link_to_line_id = p_parent_line_id
1315: and nvl(cancelled_flag, 'N') <> 'Y' -- added for Bug 2946778. shegde
1316: ORDER BY line_number, shipment_number, option_number;
1317:

Line 1936: FROM oe_order_lines_all

1932: IF p_ato_line_id = p_line_id THEN
1933:
1934: SELECT ato_line_id
1935: INTO l_ato_line_id
1936: FROM oe_order_lines_all
1937: WHERE line_id=p_top_model_line_id;
1938:
1939: IF l_ato_line_id IS NULL THEN
1940: x_item_type := 'ATO_MODEL';

Line 1991: FROM oe_order_lines_all

1987: SELECT link_to_line_id ,
1988: org_id
1989: INTO l_parent_line_id,
1990: l_org_id
1991: FROM oe_order_lines_all
1992: WHERE line_id = p_current_line_id;
1993:
1994: <>
1995:

Line 2002: FROM oe_order_lines_all

1998: SELECT inventory_item_id ,
1999: link_to_line_id
2000: INTO l_inventory_item_id ,
2001: l_next_parent_line_id
2002: FROM oe_order_lines_all
2003: WHERE line_id = l_parent_line_id;
2004:
2005: SELECT nvl(msi.comms_nl_trackable_flag, 'N')
2006: INTO l_ib_trackable_flag

Line 2316: p_order_line_rec IN oe_order_lines_all%rowtype,

2312:
2313: END get_parent_instances;
2314:
2315: PROCEDURE get_partner_order_info(
2316: p_order_line_rec IN oe_order_lines_all%rowtype,
2317: x_end_customer_id OUT nocopy number,
2318: x_current_site_use_id OUT nocopy number,
2319: x_install_site_use_id OUT nocopy number,
2320: x_return_status OUT nocopy varchar2)

Line 2440: p_order_line_rec IN oe_order_lines_all%rowtype,

2436:
2437: PROCEDURE convert_wip_instance_to_cp(
2438: p_instance_id IN number,
2439: p_order_hdr_rec IN oe_order_headers_all%rowtype,
2440: p_order_line_rec IN oe_order_lines_all%rowtype,
2441: p_tld_tbl IN csi_t_datastructures_grp.txn_line_detail_tbl,
2442: px_default_info_rec IN OUT nocopy default_info_rec,
2443: px_csi_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec,
2444: x_return_status OUT NOCOPY varchar2)

Line 2451: l_order_line_rec oe_order_lines_all%rowtype;

2447: l_party_site_id number;
2448: l_owner_party_id number;
2449: l_owner_account_id number;
2450:
2451: l_order_line_rec oe_order_lines_all%rowtype;
2452: l_order_header_rec oe_order_headers_all%rowtype;
2453:
2454: l_location_type_code varchar2(80);
2455: l_inst_object_ver_num number;

Line 3078: p_option_line_rec IN oe_order_lines_all%rowtype,

3074: x_return_status := fnd_api.g_ret_sts_error;
3075: END get_wip_instances;
3076:
3077: PROCEDURE get_wip_instances_for_line(
3078: p_option_line_rec IN oe_order_lines_all%rowtype,
3079: p_parent_line_rec IN oe_order_pub.line_rec_type,
3080: p_option_serial_code IN number,
3081: p_class_option_ratio IN number,
3082: p_config_rec IN config_rec,

Line 3856: FROM oe_order_lines_all oel

3852: l_config_rec.item_id,
3853: l_config_rec.ship_organization_id,
3854: l_config_rec.order_quantity,
3855: l_config_rec.split_from_line_id
3856: FROM oe_order_lines_all oel
3857: WHERE oel.header_id = p_ato_header_id
3858: AND oel.link_to_line_id = p_ato_line_id
3859: AND oel.item_type_code = 'CONFIG';
3860: EXCEPTION

Line 3874: FROM oe_order_lines_all oel

3870: l_config_rec.item_id,
3871: l_config_rec.ship_organization_id,
3872: l_config_rec.order_quantity,
3873: l_config_rec.split_from_line_id
3874: FROM oe_order_lines_all oel
3875: WHERE oel.header_id = p_ato_header_id
3876: AND oel.link_to_line_id = p_ato_line_id
3877: AND oel.item_type_code = 'CONFIG'
3878: AND oel.split_from_line_id is null;

Line 4111: l_order_line_rec oe_order_lines_all%rowtype;

4107: l_c_ind binary_integer := 0;
4108: l_config_instances config_serial_inst_tbl;
4109:
4110: l_order_hdr_rec oe_order_headers_all%rowtype;
4111: l_order_line_rec oe_order_lines_all%rowtype;
4112: l_tld_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
4113:
4114: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
4115:

Line 4219: FROM oe_order_lines_all

4215: END IF;
4216: ELSE -- sub models
4217:
4218: SELECT * INTO l_order_line_rec
4219: FROM oe_order_lines_all
4220: WHERE line_id = p_config_rec.sub_model_line_id;
4221:
4222: SELECT * INTO l_order_hdr_rec
4223: FROM oe_order_headers_all

Line 4529: p_order_line_rec IN oe_order_lines_all%rowtype,

4525: END stamp_om_line;
4526:
4527: PROCEDURE stamp_om_line_for_options(
4528: p_order_hdr_rec IN oe_order_headers_all%rowtype,
4529: p_order_line_rec IN oe_order_lines_all%rowtype,
4530: p_wip_instances IN wip_instances,
4531: p_tld_tbl IN csi_t_datastructures_grp.txn_line_detail_tbl,
4532: px_default_info_rec IN OUT nocopy default_info_rec,
4533: px_csi_txn_rec IN OUT nocopy csi_datastructures_pub.transaction_rec,

Line 4590: oe_order_lines_all oel

4586: IS
4587: CURSOR config_cur IS
4588: SELECT msi.serial_number_control_code
4589: FROM mtl_system_items msi,
4590: oe_order_lines_all oel
4591: WHERE oel.link_to_line_id = p_ato_line_id
4592: AND oel.item_type_code = 'CONFIG'
4593: AND msi.organization_id = oel.ship_from_org_id
4594: AND msi.inventory_item_id = oel.inventory_item_id;

Line 5097: FROM mtl_system_items_b msi, oe_order_lines_all eol

5093: --Changes for Bug 12568983
5094: BEGIN
5095: SELECT msi.SHIPPABLE_ITEM_FLAG
5096: INTO l_shippable_item_flag
5097: FROM mtl_system_items_b msi, oe_order_lines_all eol
5098: WHERE msi.ORGANIZATION_ID = eol.SHIP_FROM_ORG_ID
5099: AND msi.INVENTORY_ITEM_ID = p_option_item_id
5100: AND eol.LINE_ID = p_line_id;
5101: EXCEPTION

Line 5412: p_order_line_rec IN oe_order_lines_all%rowtype,

5408: END get_trackable_bom_comp_count;
5409:
5410: /* routine to plug in the option classes in between the build option relation at WIP */
5411: PROCEDURE rebuild_relation_for_ato(
5412: p_order_line_rec IN oe_order_lines_all%rowtype,
5413: p_config_rec IN config_rec,
5414: p_config_instances IN config_serial_inst_tbl,
5415: px_default_info_rec IN OUT NOCOPY default_info_rec,
5416: px_csi_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec,

Line 5570: p_source_table => 'OE_ORDER_LINES_ALL',

5566:
5567: IF p_order_line_rec.item_type_code = 'CLASS' OR (l_option_flag = 'Y' AND
5568: p_order_line_rec.item_type_code = 'OPTION') THEN --Added Option item condition for bug 10329599
5569: get_tld(
5570: p_source_table => 'OE_ORDER_LINES_ALL',
5571: p_source_id => p_order_line_rec.line_id,
5572: p_source_flag => 'Y',
5573: p_processing_status => 'IN_PROCESS',
5574: x_line_dtl_tbl => l_src_tld_tbl,

Line 6205: p_order_line_rec IN oe_order_lines_all%rowtype,

6201: END rebuild_relation_for_ato;
6202:
6203: -- child order line instances should get hooked in to the ib trackable parent order line
6204: PROCEDURE build_parent_relation(
6205: p_order_line_rec IN oe_order_lines_all%rowtype,
6206: p_txn_line_rec IN csi_t_datastructures_grp.txn_line_rec,
6207: p_split_flag IN varchar2,
6208: p_identified_item_type IN varchar2,
6209: p_config_rec IN config_rec,

Line 6272: p_source_table => 'OE_ORDER_LINES_ALL',

6268:
6269: IF nvl(l_parent_line_rec.line_id, fnd_api.g_miss_num) <> fnd_api.g_miss_num THEN
6270:
6271: get_tld(
6272: p_source_table => 'OE_ORDER_LINES_ALL',
6273: p_source_id => p_order_line_rec.line_id,
6274: p_source_flag => 'Y',
6275: p_processing_status => 'IN_PROCESS',
6276: x_line_dtl_tbl => l_line_dtl_tbl,

Line 6594: p_order_line_rec IN oe_order_lines_all%ROWTYPE,

6590: END mark_and_get_instances;
6591:
6592: -- Bug 10248175
6593: PROCEDURE build_child_relation_lines (
6594: p_order_line_rec IN oe_order_lines_all%ROWTYPE,
6595: p_child_line_tbl IN oe_order_pub.line_tbl_type,
6596: px_default_info_rec IN OUT NOCOPY default_info_rec,
6597: px_csi_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec,
6598: x_return_status OUT NOCOPY varchar2)

Line 6660: p_source_table => 'OE_ORDER_LINES_ALL',

6656:
6657: IF l_child_line_tbl.COUNT > 0 THEN
6658: debug('Get source details for the Parent order line id - ' || p_order_line_rec.line_id);
6659: get_tld(
6660: p_source_table => 'OE_ORDER_LINES_ALL',
6661: p_source_id => p_order_line_rec.line_id,
6662: p_source_flag => 'Y',
6663: p_processing_status => 'IN_PROCESS',
6664: x_line_dtl_tbl => l_tld_tbl,

Line 6685: from oe_order_lines_all

6681: IF l_child_line_tbl(l_ind).inventory_item_id <> l_next_item_id THEN
6682: BEGIN
6683: select sum(ordered_quantity)
6684: into l_order_line_qty
6685: from oe_order_lines_all
6686: where link_to_line_id = l_child_line_tbl(l_ind).link_to_line_id
6687: and inventory_item_id = l_child_line_tbl(l_ind).inventory_item_id
6688: and model_remnant_flag = 'Y';
6689: EXCEPTION

Line 6867: p_order_line_rec IN oe_order_lines_all%ROWTYPE,

6863:
6864:
6865: -- builds relation to the next level
6866: PROCEDURE build_child_relation(
6867: p_order_line_rec IN oe_order_lines_all%ROWTYPE,
6868: p_txn_line_rec IN csi_t_datastructures_grp.txn_line_rec,
6869: p_identified_item_type IN varchar2,
6870: px_default_info_rec IN OUT NOCOPY default_info_rec,
6871: px_csi_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec,

Line 6952: p_source_table => 'OE_ORDER_LINES_ALL',

6948:
6949: IF l_child_line_tbl.COUNT > 0 THEN
6950:
6951: get_tld(
6952: p_source_table => 'OE_ORDER_LINES_ALL',
6953: p_source_id => p_order_line_rec.line_id,
6954: p_source_flag => 'Y',
6955: p_processing_status => 'IN_PROCESS',
6956: x_line_dtl_tbl => l_tld_tbl,

Line 6979: from oe_order_lines_all

6975: IF l_child_line_tbl(l_ind).inventory_item_id <> l_next_item_id THEN
6976: BEGIN
6977: select sum(ordered_quantity)
6978: into l_order_line_qty
6979: from oe_order_lines_all
6980: where link_to_line_id = l_child_line_tbl(l_ind).link_to_line_id
6981: and inventory_item_id = l_child_line_tbl(l_ind).inventory_item_id
6982: and model_remnant_flag = 'Y';
6983: EXCEPTION

Line 7151: p_order_line_rec IN oe_order_lines_all%rowtype,

7147: /* component of relationship with the parent (ato oc or the config item) */
7148:
7149: PROCEDURE process_ato_option_nsrl(
7150: p_order_hdr_rec IN oe_order_headers_all%rowtype,
7151: p_order_line_rec IN oe_order_lines_all%rowtype,
7152: p_config_rec IN config_rec,
7153: p_tld_tbl IN csi_t_datastructures_grp.txn_line_detail_tbl,
7154: px_default_info_rec IN OUT nocopy default_info_rec,
7155: x_return_status OUT nocopy Varchar2)

Line 7531: p_order_line_rec IN oe_order_lines_all%rowtype,

7527: /* serialized config and re-builds the relation with the OC if OC is IB */
7528: /* trackable. Assy Component Relations are build at the WIP completion event*/
7529: PROCEDURE process_ato_option_srl(
7530: p_order_hdr_rec IN oe_order_headers_all%rowtype,
7531: p_order_line_rec IN oe_order_lines_all%rowtype,
7532: p_config_rec IN config_rec,
7533: p_config_instances IN config_serial_inst_tbl,
7534: p_tld_tbl IN csi_t_datastructures_grp.txn_line_detail_tbl,
7535: px_default_info_rec IN OUT nocopy default_info_rec,

Line 7877: p_order_line_rec IN oe_order_lines_all%rowtype,

7873:
7874: -- for ato options that are processed from wip
7875: PROCEDURE process_ato_option_from_wip(
7876: p_order_header_rec IN oe_order_headers_all%rowtype,
7877: p_order_line_rec IN oe_order_lines_all%rowtype,
7878: p_config_rec IN config_rec,
7879: p_config_instances IN config_serial_inst_tbl,
7880: px_default_info_rec IN OUT nocopy default_info_rec,
7881: x_wip_processing OUT NOCOPY boolean,

Line 7934: WHERE source_transaction_table = 'OE_ORDER_LINES_ALL'

7930: BEGIN
7931: SELECT transaction_line_id
7932: INTO l_transaction_line_id
7933: FROM csi_t_transaction_lines
7934: WHERE source_transaction_table = 'OE_ORDER_LINES_ALL'
7935: AND source_transaction_id = p_order_line_rec.line_id;
7936: EXCEPTION
7937: WHEN no_data_found THEN
7938: BEGIN

Line 7942: WHERE source_transaction_table = 'OE_ORDER_LINES_ALL'

7938: BEGIN
7939: SELECT transaction_line_id
7940: INTO l_transaction_line_id
7941: FROM csi_t_transaction_lines
7942: WHERE source_transaction_table = 'OE_ORDER_LINES_ALL'
7943: AND source_transaction_id = p_order_line_rec.top_model_line_id;
7944:
7945: SELECT ordered_quantity
7946: INTO l_mdl_ordered_qty

Line 7947: FROM oe_order_lines_all

7943: AND source_transaction_id = p_order_line_rec.top_model_line_id;
7944:
7945: SELECT ordered_quantity
7946: INTO l_mdl_ordered_qty
7947: FROM oe_order_lines_all
7948: WHERE line_id = p_order_line_rec.top_model_line_id;
7949:
7950: --Fix for bug5096435
7951: SELECT sum(ordered_quantity)/l_mdl_ordered_qty

Line 7953: FROM oe_order_lines_all

7949:
7950: --Fix for bug5096435
7951: SELECT sum(ordered_quantity)/l_mdl_ordered_qty
7952: INTO l_qty_ratio
7953: FROM oe_order_lines_all
7954: WHERE link_to_line_id = p_order_line_rec.link_to_line_id
7955: AND inventory_item_id = p_order_line_rec.inventory_item_id;
7956:
7957: SELECT to_char(p_order_line_rec.top_model_line_id)||':'||

Line 7985: p_source_table => 'OE_ORDER_LINES_ALL',

7981: END;
7982:
7983: IF l_transaction_line_id is not null THEN
7984: get_tld(
7985: p_source_table => 'OE_ORDER_LINES_ALL',
7986: p_source_id => p_order_line_rec.line_id,
7987: p_source_flag => 'Y',
7988: p_processing_status => 'UNPROCESSED',
7989: x_line_dtl_tbl => l_src_tld_tbl,

Line 8061: p_order_line_rec IN oe_order_lines_all%rowtype,

8057: -- bug 4966316 - item instance ownership conversion...
8058:
8059: PROCEDURE demo_fulfillment(
8060: p_txn_type_id IN number,
8061: p_order_line_rec IN oe_order_lines_all%rowtype,
8062: p_line_dtl_tbl IN csi_t_datastructures_grp.txn_line_detail_tbl,
8063: px_csi_txn_rec IN OUT nocopy csi_datastructures_pub.transaction_rec,
8064: x_return_status OUT nocopy varchar2)
8065: IS

Line 8735: l_p_tl_rec.source_transaction_table := 'OE_ORDER_LINES_ALL';

8731:
8732: api_log('query_tld_and_update_ib');
8733:
8734: l_p_tl_rec.transaction_line_id := px_default_info_rec.transaction_line_id;
8735: l_p_tl_rec.source_transaction_table := 'OE_ORDER_LINES_ALL';
8736: l_p_tl_rec.source_transaction_id := p_order_line_rec.order_line_id;
8737: l_p_tl_rec.source_transaction_type_id := 51;
8738:
8739: debug('get transaction details for the final process. IN_PROCESS Details');

Line 8742: l_tl_query_rec.source_transaction_table := 'OE_ORDER_LINES_ALL';

8738:
8739: debug('get transaction details for the final process. IN_PROCESS Details');
8740:
8741: l_tl_query_rec.transaction_line_id := px_default_info_rec.transaction_line_id;
8742: l_tl_query_rec.source_transaction_table := 'OE_ORDER_LINES_ALL';
8743: l_tl_query_rec.source_transaction_id := p_order_line_rec.order_line_id;
8744:
8745: l_tld_query_rec.processing_status := 'IN_PROCESS';
8746: l_tld_query_rec.source_transaction_flag := fnd_api.g_miss_char;

Line 8990: FROM OE_ORDER_LINES_ALL OOL,

8986: RETURN VARCHAR2
8987: IS
8988: CURSOR shippable_order_cur IS
8989: SELECT OOL.LINE_ID
8990: FROM OE_ORDER_LINES_ALL OOL,
8991: MTL_SYSTEM_ITEMS MSI
8992: WHERE OOL.HEADER_ID = p_header_id
8993: AND OOL.top_model_line_id = p_top_model_line_id
8994: AND OOL.FLOW_STATUS_CODE NOT IN ('CANCELLED')

Line 9038: l_src_txn_table varchar2(30) := 'OE_ORDER_LINES_ALL';

9034: l_txn_line_id number;
9035: l_txn_type_id number := 51;
9036: l_txn_sub_type_id number ;
9037: l_sub_type_rec sub_type_rec;
9038: l_src_txn_table varchar2(30) := 'OE_ORDER_LINES_ALL';
9039: l_transaction_line_id number;
9040:
9041: l_cascade_eligible varchar2(1) := 'N';
9042: l_model_hierarchy varchar2(300);

Line 9113: l_order_line_rec oe_order_lines_all%rowtype;

9109:
9110: l_cascaded_flag varchar2(1) := 'N';
9111: l_shippable_item_flag varchar2(1) := 'N';
9112:
9113: l_order_line_rec oe_order_lines_all%rowtype;
9114: l_order_header_rec oe_order_headers_all%rowtype;
9115:
9116: l_p_order_line_rec csi_order_ship_pub.order_line_rec;
9117: l_csi_txn_rec csi_datastructures_pub.transaction_rec;

Line 9253: FROM oe_order_lines_all

9249: BEGIN
9250:
9251: SELECT *
9252: INTO l_order_line_rec
9253: FROM oe_order_lines_all
9254: WHERE line_id = p_order_line_id;
9255:
9256: SELECT *
9257: INTO l_order_header_rec

Line 9732: FROM oe_order_lines_all

9728: IF l_order_line_rec.ato_line_id=l_order_line_rec.line_id THEN
9729:
9730: SELECT ato_line_id
9731: INTO l_ato_line_id
9732: FROM oe_order_lines_all
9733: WHERE line_id=l_order_line_rec.link_to_line_id;
9734:
9735: IF l_ato_line_id IS NULL THEN
9736: l_ato_rebuild_flag :='N';

Line 9970: from oe_order_lines_all

9966: IF l_order_line_rec.model_remnant_flag = 'Y' THEN
9967: BEGIN
9968: select sum(ordered_quantity)
9969: into l_order_line_qty
9970: from oe_order_lines_all
9971: where link_to_line_id = l_order_line_rec.link_to_line_id
9972: and inventory_item_id = l_order_line_rec.inventory_item_id
9973: and model_remnant_flag = 'Y';
9974: EXCEPTION

Line 10062: FROM oe_order_lines_all

10058: debug('top model line ('||l_order_line_rec.top_model_line_id||') has transaction details.');
10059:
10060: SELECT ordered_quantity
10061: INTO l_mdl_ordered_qty
10062: FROM oe_order_lines_all
10063: WHERE line_id = l_order_line_rec.top_model_line_id;
10064:
10065: --fix for bug5096435
10066: SELECT sum(ordered_quantity)/l_mdl_ordered_qty

Line 10068: FROM oe_order_lines_all

10064:
10065: --fix for bug5096435
10066: SELECT sum(ordered_quantity)/l_mdl_ordered_qty
10067: INTO l_qty_ratio
10068: FROM oe_order_lines_all
10069: WHERE link_to_line_id = l_order_line_rec.link_to_line_id
10070: AND inventory_item_id = l_order_line_rec.inventory_item_id;
10071:
10072:

Line 10422: AND source_transaction_table = 'OE_ORDER_LINES_ALL';

10418:
10419: UPDATE csi_t_transaction_lines
10420: SET processing_status = 'ERROR'
10421: WHERE source_transaction_id = p_order_line_id
10422: AND source_transaction_table = 'OE_ORDER_LINES_ALL';
10423:
10424: csi_utl_pkg.update_txn_line_dtl (
10425: p_source_trx_id => p_order_line_id,
10426: p_source_trx_table => 'OE_ORDER_LINES_ALL',

Line 10426: p_source_trx_table => 'OE_ORDER_LINES_ALL',

10422: AND source_transaction_table = 'OE_ORDER_LINES_ALL';
10423:
10424: csi_utl_pkg.update_txn_line_dtl (
10425: p_source_trx_id => p_order_line_id,
10426: p_source_trx_table => 'OE_ORDER_LINES_ALL',
10427: p_api_name => l_api_name,
10428: p_error_message => l_error_message );
10429:
10430: WHEN others THEN

Line 10445: AND source_transaction_table = 'OE_ORDER_LINES_ALL';

10441:
10442: UPDATE csi_t_transaction_lines
10443: SET processing_status = 'ERROR'
10444: WHERE source_transaction_id = p_order_line_id
10445: AND source_transaction_table = 'OE_ORDER_LINES_ALL';
10446:
10447: csi_utl_pkg.update_txn_line_dtl (
10448: p_source_trx_id => p_order_line_id,
10449: p_source_trx_table => 'OE_ORDER_LINES_ALL',

Line 10449: p_source_trx_table => 'OE_ORDER_LINES_ALL',

10445: AND source_transaction_table = 'OE_ORDER_LINES_ALL';
10446:
10447: csi_utl_pkg.update_txn_line_dtl (
10448: p_source_trx_id => p_order_line_id,
10449: p_source_trx_table => 'OE_ORDER_LINES_ALL',
10450: p_api_name => l_api_name,
10451: p_error_message => l_error_message );
10452:
10453: END order_fulfillment;

Line 10502: l_c_tl_rec.source_transaction_table := 'OE_ORDER_LINES_ALL';

10498: api_log('construct_txn_dtls');
10499:
10500: /* assign values for the columns in Txn_line_rec */
10501: l_c_tl_rec.source_transaction_id := p_order_line_rec.order_line_id ;
10502: l_c_tl_rec.source_transaction_table := 'OE_ORDER_LINES_ALL';
10503: l_c_tl_rec.source_transaction_type_id := 51;
10504: l_c_tl_rec.processing_status := 'IN_PROCESS';
10505: l_c_tl_rec.object_version_number := 1;
10506:

Line 10833: l_src_txn_table varchar2(30) := 'OE_ORDER_LINES_ALL';

10829: l_api_name varchar2(30) := 'logical_drop_ship';
10830: l_txn_line_id number;
10831: l_txn_type_id number := 51;
10832: l_txn_sub_type_id number ;
10833: l_src_txn_table varchar2(30) := 'OE_ORDER_LINES_ALL';
10834: p_order_line_id number;
10835:
10836: l_debug_level number;
10837: l_error_message varchar2(2000);

Line 10932: oe_order_lines_all ool,

10928: to_number(null) ib_install_loc_id,
10929: to_char(null) ib_current_loc,
10930: to_number(null) ib_current_loc_id
10931: FROM oe_order_headers_all ooh,
10932: oe_order_lines_all ool,
10933: mtl_system_items msi,
10934: mtl_unit_transactions mut,
10935: mtl_material_transactions mmt,
10936: mtl_secondary_inventories msei,

Line 10990: oe_order_lines_all ool,

10986: to_number(null) ib_install_loc_id,
10987: to_char(null) ib_current_loc,
10988: to_number(null) ib_current_loc_id
10989: FROM oe_order_headers_all ooh,
10990: oe_order_lines_all ool,
10991: mtl_system_items msi,
10992: mtl_unit_transactions mut,
10993: mtl_transaction_lot_numbers mtln,
10994: mtl_material_transactions mmt,

Line 11055: FROM oe_order_lines_all

11051: dbms_application_info.set_client_info(l_order_line_rec.org_id);
11052:
11053: SELECT ship_from_org_id
11054: INTO l_ship_from_org_id
11055: FROM oe_order_lines_all
11056: WHERE line_id = p_order_line_id;
11057:
11058: SELECT nvl(shippable_item_flag ,'N'),
11059: nvl(mtl_transactions_enabled_flag, 'N'),

Line 11097: l_txn_line_rec.source_transaction_table := 'OE_ORDER_LINES_ALL';

11093: l_error_rec.inventory_item_id := l_order_line_rec.inv_item_id;
11094:
11095: -- Assign parameters for txn_line_rec
11096: l_txn_line_rec.source_transaction_id := l_order_line_rec.order_line_id;
11097: l_txn_line_rec.source_transaction_table := 'OE_ORDER_LINES_ALL';
11098:
11099: -- Check If user entered Transaction Details Exists
11100: l_trx_detail_exist := csi_t_txn_details_grp.check_txn_details_exist(
11101: p_txn_line_rec => l_txn_line_rec );

Line 12260: FROM OE_ORDER_LINES_ALL

12256: retcode OUT NOCOPY NUMBER)
12257: IS
12258: CURSOR OE_LINE_CUR(p_freeze_date DATE) IS
12259: SELECT line_id,inventory_item_id,org_id,shippable_flag
12260: FROM OE_ORDER_LINES_ALL
12261: WHERE creation_date <= p_freeze_date
12262: AND nvl(fulfilled_flag,'N') <> 'Y'
12263: AND open_flag = 'Y';
12264: --