DBA Data[Home] [Help]

APPS.OE_SCHEDULE_UTIL dependencies on OE_LINE_SECURITY

Line 13501: OE_Line_Security.Attributes

13497:
13498:
13499: OE_ORDER_SCH_UTIL.OESCH_PERFORM_SCHEDULING := 'N';
13500:
13501: OE_Line_Security.Attributes
13502: ( p_line_rec => p_x_line_rec
13503: , p_old_line_rec => p_old_line_rec
13504: , x_result => l_sec_result
13505: , x_return_status => x_return_status

Line 18686: AND SOURCE_LINE_ID = OE_LINE_SECURITY.g_record.line_id

18682: IS
18683: SELECT PICK_STATUS
18684: FROM WSH_DELIVERY_LINE_STATUS_V
18685: WHERE SOURCE_CODE = 'OE'
18686: AND SOURCE_LINE_ID = OE_LINE_SECURITY.g_record.line_id
18687: AND PICK_STATUS NOT IN ('N', 'R', 'X', 'B'); --Added 'B', (Backordered Status) for bug 8521082
18688:
18689: l_pick_status VARCHAR2(1);
18690:

Line 18777: oe_debug_pub.add('Header :'||OE_LINE_SECURITY.g_record.header_id);

18773:
18774: If p_validation_entity_short_name = 'LINE' Then
18775:
18776: oe_debug_pub.add('Getting Reservation Details:');
18777: oe_debug_pub.add('Header :'||OE_LINE_SECURITY.g_record.header_id);
18778: oe_debug_pub.add('Line :'||OE_LINE_SECURITY.g_record.line_id);
18779:
18780: l_reservation_rec.reservation_id := fnd_api.g_miss_num;
18781: l_reservation_rec.demand_source_header_id :=

Line 18778: oe_debug_pub.add('Line :'||OE_LINE_SECURITY.g_record.line_id);

18774: If p_validation_entity_short_name = 'LINE' Then
18775:
18776: oe_debug_pub.add('Getting Reservation Details:');
18777: oe_debug_pub.add('Header :'||OE_LINE_SECURITY.g_record.header_id);
18778: oe_debug_pub.add('Line :'||OE_LINE_SECURITY.g_record.line_id);
18779:
18780: l_reservation_rec.reservation_id := fnd_api.g_miss_num;
18781: l_reservation_rec.demand_source_header_id :=
18782: oe_schedule_util.Get_mtl_sales_order_id(OE_LINE_SECURITY.g_record.header_id);

Line 18782: oe_schedule_util.Get_mtl_sales_order_id(OE_LINE_SECURITY.g_record.header_id);

18778: oe_debug_pub.add('Line :'||OE_LINE_SECURITY.g_record.line_id);
18779:
18780: l_reservation_rec.reservation_id := fnd_api.g_miss_num;
18781: l_reservation_rec.demand_source_header_id :=
18782: oe_schedule_util.Get_mtl_sales_order_id(OE_LINE_SECURITY.g_record.header_id);
18783: l_reservation_rec.demand_source_line_id := OE_LINE_SECURITY.g_record.line_id;
18784: l_reservation_rec.organization_id := OE_LINE_SECURITY.g_record.ship_from_org_id;
18785:
18786: inv_reservation_pub.query_reservation

Line 18783: l_reservation_rec.demand_source_line_id := OE_LINE_SECURITY.g_record.line_id;

18779:
18780: l_reservation_rec.reservation_id := fnd_api.g_miss_num;
18781: l_reservation_rec.demand_source_header_id :=
18782: oe_schedule_util.Get_mtl_sales_order_id(OE_LINE_SECURITY.g_record.header_id);
18783: l_reservation_rec.demand_source_line_id := OE_LINE_SECURITY.g_record.line_id;
18784: l_reservation_rec.organization_id := OE_LINE_SECURITY.g_record.ship_from_org_id;
18785:
18786: inv_reservation_pub.query_reservation
18787: ( p_api_version_number => 1.0

Line 18784: l_reservation_rec.organization_id := OE_LINE_SECURITY.g_record.ship_from_org_id;

18780: l_reservation_rec.reservation_id := fnd_api.g_miss_num;
18781: l_reservation_rec.demand_source_header_id :=
18782: oe_schedule_util.Get_mtl_sales_order_id(OE_LINE_SECURITY.g_record.header_id);
18783: l_reservation_rec.demand_source_line_id := OE_LINE_SECURITY.g_record.line_id;
18784: l_reservation_rec.organization_id := OE_LINE_SECURITY.g_record.ship_from_org_id;
18785:
18786: inv_reservation_pub.query_reservation
18787: ( p_api_version_number => 1.0
18788: , p_init_msg_lst => fnd_api.g_true