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.OTA_WF dependencies on OE_ORDER_LINES

Line 66: l_Line_id oe_order_lines.Line_Id%type;

62: )
63: IS
64: l_proc varchar2(72) := g_package||'cancel_order';
65:
66: l_Line_id oe_order_lines.Line_Id%type;
67: l_header_id oe_order_lines.header_id%type;
68: l_control_rec OE_GLOBALS.Control_Rec_Type:=
69: OE_GLOBALS.G_MISS_CONTROL_REC;
70:

Line 67: l_header_id oe_order_lines.header_id%type;

63: IS
64: l_proc varchar2(72) := g_package||'cancel_order';
65:
66: l_Line_id oe_order_lines.Line_Id%type;
67: l_header_id oe_order_lines.header_id%type;
68: l_control_rec OE_GLOBALS.Control_Rec_Type:=
69: OE_GLOBALS.G_MISS_CONTROL_REC;
70:
71: --Declare all local variable.

Line 128: l_org_id oe_order_lines.org_id%type;

124: l_old_Lot_Serial_val_tbl OE_Order_PUB.Lot_Serial_Val_Tbl_Type ;
125:
126: l_message_data varchar2(2000);
127:
128: l_org_id oe_order_lines.org_id%type;
129: BEGIN
130:
131: hr_utility.set_location('Entering:'||l_proc, 5);
132:

Line 304: l_Line_id oe_order_lines.Line_Id%type;

300:
301: )IS
302: l_proc varchar2(72) := g_package||'create_rma';
303:
304: l_Line_id oe_order_lines.Line_Id%type;
305: l_header_id oe_order_lines.header_id%type;
306: l_control_rec OE_GLOBALS.Control_Rec_Type ;
307:
308: --Declare all local variable.

Line 305: l_header_id oe_order_lines.header_id%type;

301: )IS
302: l_proc varchar2(72) := g_package||'create_rma';
303:
304: l_Line_id oe_order_lines.Line_Id%type;
305: l_header_id oe_order_lines.header_id%type;
306: l_control_rec OE_GLOBALS.Control_Rec_Type ;
307:
308: --Declare all local variable.
309: l_api_version_number CONSTANT NUMBER := 1.0;

Line 364: l_org_id oe_order_lines.org_id%type;

360: l_old_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type ;
361: l_old_Lot_Serial_val_tbl OE_Order_PUB.Lot_Serial_Val_Tbl_Type ;
362:
363: l_message_data varchar2(2000);
364: l_org_id oe_order_lines.org_id%type;
365:
366:
367: BEGIN
368: hr_utility.set_location('Entering:'||l_proc, 5);

Line 566: l_header_id oe_order_lines.header_id%type;

562: ,resultout OUT NOCOPY VARCHAR2
563:
564: ) Is
565: l_proc varchar2(72) := g_package||'update_fulfill_date';
566: l_header_id oe_order_lines.header_id%type;
567:
568: l_Line_id OE_ORDER_LINES.line_id%type := to_number(itemkey) ;
569: l_control_rec OE_GLOBALS.Control_Rec_Type:=
570: OE_GLOBALS.G_MISS_CONTROL_REC;

Line 568: l_Line_id OE_ORDER_LINES.line_id%type := to_number(itemkey) ;

564: ) Is
565: l_proc varchar2(72) := g_package||'update_fulfill_date';
566: l_header_id oe_order_lines.header_id%type;
567:
568: l_Line_id OE_ORDER_LINES.line_id%type := to_number(itemkey) ;
569: l_control_rec OE_GLOBALS.Control_Rec_Type:=
570: OE_GLOBALS.G_MISS_CONTROL_REC;
571:
572:

Line 627: l_org_id oe_order_lines.org_id%type;

623: l_old_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type ;
624: l_old_Lot_Serial_val_tbl OE_Order_PUB.Lot_Serial_Val_Tbl_Type ;
625:
626: l_message_data varchar2(2000);
627: l_org_id oe_order_lines.org_id%type;
628:
629:
630: CURSOR C_EVENT
631: IS

Line 635: Line_id OE_ORDER_LINES.line_id%type;

631: IS
632: SELECT Course_End_date
633: FROM OTA_EVENTS
634: WHERE LINE_ID = l_line_id;
635: Line_id OE_ORDER_LINES.line_id%type;
636: l_course_end_date OTA_EVENTS.course_end_date%type;
637:
638: CURSOR C_ORDER IS
639: SELECT HEADER_ID,ORG_ID

Line 640: FROM OE_ORDER_LINES_ALL

636: l_course_end_date OTA_EVENTS.course_end_date%type;
637:
638: CURSOR C_ORDER IS
639: SELECT HEADER_ID,ORG_ID
640: FROM OE_ORDER_LINES_ALL
641: WHERE LINE_ID = l_line_id;
642:
643: BEGIN
644: hr_utility.set_location('Entering:'||l_proc, 5);

Line 814: l_line_id oe_order_lines.line_id%type := to_number(itemkey);

810: resultout OUT NOCOPY VARCHAR2
811: )
812: IS
813:
814: l_line_id oe_order_lines.line_id%type := to_number(itemkey);
815: l_proc varchar2(72) := g_package||'chk_invoice_exists';
816: l_invoice_quantity oe_order_lines.invoiced_quantity%type;
817:
818:

Line 816: l_invoice_quantity oe_order_lines.invoiced_quantity%type;

812: IS
813:
814: l_line_id oe_order_lines.line_id%type := to_number(itemkey);
815: l_proc varchar2(72) := g_package||'chk_invoice_exists';
816: l_invoice_quantity oe_order_lines.invoiced_quantity%type;
817:
818:
819: CURSOR c_invoice IS
820: SELECT

Line 823: oe_order_lines

819: CURSOR c_invoice IS
820: SELECT
821: decode(invoiced_quantity,null,0,invoiced_quantity)
822: FROM
823: oe_order_lines
824: WHERE
825: line_id = l_line_id;
826:
827:

Line 933: l_uom oe_order_lines.order_quantity_uom%type;

929: resultout OUT NOCOPY VARCHAR2
930: )
931: IS
932:
933: l_uom oe_order_lines.order_quantity_uom%type;
934: l_proc varchar2(72) := g_package||'check_uom';
935: l_line_id oe_order_lines.line_id%type := to_number(itemkey);
936: l_order_number oe_order_headers.order_number%type;
937: l_line_number oe_order_lines.line_number%type;

Line 935: l_line_id oe_order_lines.line_id%type := to_number(itemkey);

931: IS
932:
933: l_uom oe_order_lines.order_quantity_uom%type;
934: l_proc varchar2(72) := g_package||'check_uom';
935: l_line_id oe_order_lines.line_id%type := to_number(itemkey);
936: l_order_number oe_order_headers.order_number%type;
937: l_line_number oe_order_lines.line_number%type;
938: l_email_address per_people_f.email_address%type;
939: l_description varchar2(200);

Line 937: l_line_number oe_order_lines.line_number%type;

933: l_uom oe_order_lines.order_quantity_uom%type;
934: l_proc varchar2(72) := g_package||'check_uom';
935: l_line_id oe_order_lines.line_id%type := to_number(itemkey);
936: l_order_number oe_order_headers.order_number%type;
937: l_line_number oe_order_lines.line_number%type;
938: l_email_address per_people_f.email_address%type;
939: l_description varchar2(200);
940:
941:

Line 948: oe_order_lines_all ol,

944: ol.order_quantity_uom ,
945: oh.order_number,
946: ol.line_number
947: FROM
948: oe_order_lines_all ol,
949: oe_order_headers_all oh
950: WHERE
951: oh.header_id = ol.header_id and
952: ol.line_id = l_line_id;

Line 1075: l_uom oe_order_lines.order_quantity_uom%type;

1071: )
1072:
1073: IS
1074:
1075: l_uom oe_order_lines.order_quantity_uom%type;
1076: l_proc varchar2(72) := g_package||'ota_creation_ck';
1077: l_line_id oe_order_lines.line_id%type := to_number(itemkey);
1078: l_exist varchar2(1);
1079:

Line 1077: l_line_id oe_order_lines.line_id%type := to_number(itemkey);

1073: IS
1074:
1075: l_uom oe_order_lines.order_quantity_uom%type;
1076: l_proc varchar2(72) := g_package||'ota_creation_ck';
1077: l_line_id oe_order_lines.line_id%type := to_number(itemkey);
1078: l_exist varchar2(1);
1079:
1080:
1081: CURSOR c_uom IS

Line 1085: oe_order_lines

1081: CURSOR c_uom IS
1082: SELECT
1083: order_quantity_uom
1084: FROM
1085: oe_order_lines
1086: WHERE
1087: line_id = l_line_id;
1088:
1089: CURSOR c_evt

Line 1457: oe_order_lines_all

1453: IS
1454: SELECT
1455: invoicing_rule_id
1456: FROM
1457: oe_order_lines_all
1458: WHERE
1459: line_id = to_number(itemkey);
1460:
1461: l_proc varchar2(72) := g_package||'check_invoice_rule';

Line 1462: l_rule_id oe_order_lines_all.invoicing_rule_id%type;

1458: WHERE
1459: line_id = to_number(itemkey);
1460:
1461: l_proc varchar2(72) := g_package||'check_invoice_rule';
1462: l_rule_id oe_order_lines_all.invoicing_rule_id%type;
1463:
1464: BEGIN
1465: hr_utility.set_location('Entering:'||l_proc, 5);
1466: IF (funcmode = 'RUN') THEN

Line 1549: l_org_id oe_order_lines.org_id%type;

1545: ,actid IN NUMBER
1546: ,funcmode IN VARCHAR2
1547: ,resultout OUT NOCOPY VARCHAR2)IS
1548:
1549: l_org_id oe_order_lines.org_id%type;
1550: l_proc varchar2(72) := g_package||'cancel_enrollment';
1551: l_return_status varchar2(1);
1552:
1553: l_booking_status_type_id ota_booking_status_types.booking_status_type_id%type;

Line 1700: l_line_id oe_order_lines.line_id%type := to_number(itemkey);

1696:
1697: IS
1698:
1699: l_proc varchar2(72) := g_package||'update_owner_email';
1700: l_line_id oe_order_lines.line_id%type := to_number(itemkey);
1701: l_user_name fnd_user.user_name%type;
1702:
1703:
1704: CURSOR c_uom IS

Line 1710: oe_order_lines_all ol,

1706: ol.order_quantity_uom ,
1707: oh.order_number,
1708: ol.line_number
1709: FROM
1710: oe_order_lines_all ol,
1711: oe_order_headers_all oh
1712: WHERE
1713: oh.header_id = ol.header_id and
1714: ol.line_id = l_line_id;