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.OE_ORDER_COPY_UTIL dependencies on OE_GLOBALS

Line 30: PROCEDURE sort_line_tbl(p_line_id_tbl IN OE_GLOBALS.Selected_Record_Tbl,

26: PROCEDURE EXTEND_TBL(p_num IN NUMBER);
27:
28: PROCEDURE DELETE_TBL;
29:
30: PROCEDURE sort_line_tbl(p_line_id_tbl IN OE_GLOBALS.Selected_Record_Tbl,
31: p_version_number IN NUMBER,
32: p_phase_change_flag IN VARCHAR2,
33: p_num_lines IN NUMBER,
34: x_line_tbl IN OUT NOCOPY OE_ORDER_PUB.Line_Tbl_Type);

Line 567: x_header_rec.operation := OE_GLOBALS.G_OPR_CREATE;

563: END IF;
564:
565: x_header_rec.header_id := FND_API.G_MISS_NUM;
566: x_header_rec.version_number := FND_API.G_MISS_NUM;
567: x_header_rec.operation := OE_GLOBALS.G_OPR_CREATE;
568:
569: IF (x_header_rec.ordered_date < sysdate) THEN
570: x_header_rec.ordered_date := FND_API.G_MISS_DATE;
571: END IF;

Line 891: x_header_scredit_tbl(k).operation := OE_GLOBALS.G_OPR_CREATE;

887: IF x_header_scredit_tbl.COUNT > 0 THEN
888:
889: FOR k IN x_header_scredit_tbl.FIRST .. x_header_scredit_tbl.LAST LOOP
890:
891: x_header_scredit_tbl(k).operation := OE_GLOBALS.G_OPR_CREATE;
892: x_header_scredit_tbl(k).header_id := FND_API.G_MISS_NUM;
893: x_header_scredit_tbl(k).sales_credit_id := FND_API.G_MISS_NUM;
894: x_header_scredit_tbl(k).orig_sys_credit_ref := FND_API.G_MISS_CHAR;--bug 13980051
895: END LOOP;

Line 972: IF NOT OE_GLOBALS.EQUAL(l_v_number,p_version_number) THEN

968: INTO l_v_number
969: FROM oe_order_headers_all /*Modified to base table for bug 9701486 */
970: WHERE header_id = p_header_id;
971:
972: IF NOT OE_GLOBALS.EQUAL(l_v_number,p_version_number) THEN
973: RETURN l_action_request_tbl;
974: END IF;
975: END IF;
976:

Line 1009: l_action_request_tbl(k).entity_code := OE_GLOBALS.G_ENTITY_HEADER;

1005: IF l_debug_level > 0 THEN
1006: oe_debug_pub.add( 'LOADING HOLD SOURCE '|| TO_CHAR ( L_HOLD_SOURCE_TBL ( CURR ) .HOLD_ID ) , 2 ) ;
1007: END IF;
1008:
1009: l_action_request_tbl(k).entity_code := OE_GLOBALS.G_ENTITY_HEADER;
1010: l_action_request_tbl(k).request_type:= OE_Globals.G_APPLY_HOLD;
1011: l_action_request_tbl(k).param1 := l_hold_source_tbl(curr).hold_id;
1012: l_action_request_tbl(k).param2 := 'O';
1013:

Line 1010: l_action_request_tbl(k).request_type:= OE_Globals.G_APPLY_HOLD;

1006: oe_debug_pub.add( 'LOADING HOLD SOURCE '|| TO_CHAR ( L_HOLD_SOURCE_TBL ( CURR ) .HOLD_ID ) , 2 ) ;
1007: END IF;
1008:
1009: l_action_request_tbl(k).entity_code := OE_GLOBALS.G_ENTITY_HEADER;
1010: l_action_request_tbl(k).request_type:= OE_Globals.G_APPLY_HOLD;
1011: l_action_request_tbl(k).param1 := l_hold_source_tbl(curr).hold_id;
1012: l_action_request_tbl(k).param2 := 'O';
1013:
1014: -- load other source fields

Line 1113: x_header_payment_tbl(k).operation := OE_GLOBALS.G_OPR_CREATE;

1109:
1110: IF x_header_payment_tbl.COUNT > 0 THEN
1111: -- assign G_MISS to those attributes that are not copied.
1112: FOR k IN x_header_payment_tbl.FIRST .. x_header_payment_tbl.LAST LOOP
1113: x_header_payment_tbl(k).operation := OE_GLOBALS.G_OPR_CREATE;
1114: x_header_payment_tbl(k).header_id := FND_API.G_MISS_NUM;
1115: x_header_payment_tbl(k).line_id := FND_API.G_MISS_NUM;
1116: x_header_payment_tbl(k).prepaid_amount := FND_API.G_MISS_NUM;
1117: x_header_payment_tbl(k).commitment_applied_amount:= FND_API.G_MISS_NUM;

Line 1235: p_action_request_tbl(k).entity_code := OE_GLOBALS.G_ENTITY_LINE;

1231: IF l_debug_level > 0 THEN
1232: oe_debug_pub.add( 'LOADING HOLD SOURCE '|| TO_CHAR ( L_HOLD_SOURCE_TBL ( CURR ) .HOLD_ID ) , 2 ) ;
1233: END IF;
1234:
1235: p_action_request_tbl(k).entity_code := OE_GLOBALS.G_ENTITY_LINE;
1236: p_action_request_tbl(k).entity_id := p_new_line_id;
1237: p_action_request_tbl(k).request_type:= OE_Globals.G_APPLY_HOLD;
1238: p_action_request_tbl(k).param1 := l_hold_source_tbl(curr).hold_id;
1239: p_action_request_tbl(k).param2 := 'O';

Line 1237: p_action_request_tbl(k).request_type:= OE_Globals.G_APPLY_HOLD;

1233: END IF;
1234:
1235: p_action_request_tbl(k).entity_code := OE_GLOBALS.G_ENTITY_LINE;
1236: p_action_request_tbl(k).entity_id := p_new_line_id;
1237: p_action_request_tbl(k).request_type:= OE_Globals.G_APPLY_HOLD;
1238: p_action_request_tbl(k).param1 := l_hold_source_tbl(curr).hold_id;
1239: p_action_request_tbl(k).param2 := 'O';
1240:
1241: -- load other source fields

Line 1357: IF l_line_tbl(k).item_type_code IN (OE_GLOBALS.G_ITEM_STANDARD,

1353:
1354: END IF;
1355:
1356: -- If Model or Standard then do nothing.
1357: IF l_line_tbl(k).item_type_code IN (OE_GLOBALS.G_ITEM_STANDARD,
1358: OE_GLOBALS.G_ITEM_MODEL) THEN
1359:
1360: GOTO Leave_record_as_is;
1361:

Line 1358: OE_GLOBALS.G_ITEM_MODEL) THEN

1354: END IF;
1355:
1356: -- If Model or Standard then do nothing.
1357: IF l_line_tbl(k).item_type_code IN (OE_GLOBALS.G_ITEM_STANDARD,
1358: OE_GLOBALS.G_ITEM_MODEL) THEN
1359:
1360: GOTO Leave_record_as_is;
1361:
1362: END IF;

Line 1372: (OE_GLOBALS.G_ITEM_CONFIG,

1368: -- passed in. It gets deleted if parent is passed in since
1369: -- Process Order will re-exploded based on Freeze date.
1370:
1371: IF l_line_tbl(k).item_type_code IN
1372: (OE_GLOBALS.G_ITEM_CONFIG,
1373: OE_GLOBALS.G_ITEM_INCLUDED,
1374: OE_GLOBALS.G_ITEM_OPTION) THEN
1375:
1376: -- Find if Parent Line has been passed In

Line 1373: OE_GLOBALS.G_ITEM_INCLUDED,

1369: -- Process Order will re-exploded based on Freeze date.
1370:
1371: IF l_line_tbl(k).item_type_code IN
1372: (OE_GLOBALS.G_ITEM_CONFIG,
1373: OE_GLOBALS.G_ITEM_INCLUDED,
1374: OE_GLOBALS.G_ITEM_OPTION) THEN
1375:
1376: -- Find if Parent Line has been passed In
1377: IF l_line_tbl(k).top_model_line_id IS NOT NULL THEN

Line 1374: OE_GLOBALS.G_ITEM_OPTION) THEN

1370:
1371: IF l_line_tbl(k).item_type_code IN
1372: (OE_GLOBALS.G_ITEM_CONFIG,
1373: OE_GLOBALS.G_ITEM_INCLUDED,
1374: OE_GLOBALS.G_ITEM_OPTION) THEN
1375:
1376: -- Find if Parent Line has been passed In
1377: IF l_line_tbl(k).top_model_line_id IS NOT NULL THEN
1378: l_top_model_index := Find_LineIndex(l_line_tbl,

Line 1381: l_line_tbl(k).item_type_code := OE_GLOBALS.G_ITEM_STANDARD;

1377: IF l_line_tbl(k).top_model_line_id IS NOT NULL THEN
1378: l_top_model_index := Find_LineIndex(l_line_tbl,
1379: l_line_tbl(k).top_model_line_id);
1380: IF l_top_model_index = FND_API.G_MISS_NUM THEN
1381: l_line_tbl(k).item_type_code := OE_GLOBALS.G_ITEM_STANDARD;
1382: GOTO Leave_record_as_is;
1383: END IF;
1384: END IF;
1385:

Line 1394: IF l_line_tbl(k).item_type_code = OE_GLOBALS.G_ITEM_CLASS THEN

1390: GOTO Leave_record_as_is;
1391: END IF; -- End Included, Option or Config Item
1392:
1393: -- Delete class lines.
1394: IF l_line_tbl(k).item_type_code = OE_GLOBALS.G_ITEM_CLASS THEN
1395:
1396: l_line_tbl.DELETE(k);
1397: GOTO Leave_record_as_is;
1398:

Line 1403: IF l_line_tbl(k).item_type_code = OE_GLOBALS.G_ITEM_SERVICE THEN

1399: END IF;
1400:
1401: -- Delete Service Line if the Line category is Return
1402: -- Delete service lines.
1403: IF l_line_tbl(k).item_type_code = OE_GLOBALS.G_ITEM_SERVICE THEN
1404: l_line_tbl.DELETE(k);
1405: GOTO Leave_record_as_is;
1406: END IF;
1407:

Line 1409: IF (l_line_tbl(k).item_type_code = OE_GLOBALS.G_ITEM_KIT) AND

1405: GOTO Leave_record_as_is;
1406: END IF;
1407:
1408: /* Following If condition added to fix the bug 2012594 */
1409: IF (l_line_tbl(k).item_type_code = OE_GLOBALS.G_ITEM_KIT) AND
1410: (l_line_tbl(k).top_model_line_id IS NOT NULL) AND
1411: (l_line_tbl(k).top_model_line_id <>l_line_tbl(k).line_id) THEN
1412: l_top_model_index := Find_LineIndex(l_line_tbl,l_line_tbl(k).top_model_line_id);
1413: IF l_top_model_index <> FND_API.G_MISS_NUM THEN

Line 1634: IF l_line_tbl(k).item_type_code IN (OE_GLOBALS.G_ITEM_STANDARD,

1630:
1631: END IF;
1632:
1633: -- If Model or Standard or KIT then do nothing.
1634: IF l_line_tbl(k).item_type_code IN (OE_GLOBALS.G_ITEM_STANDARD,
1635: OE_GLOBALS.G_ITEM_MODEL,
1636: OE_GLOBALS.G_ITEM_KIT) THEN
1637:
1638: GOTO Leave_record_as_is;

Line 1635: OE_GLOBALS.G_ITEM_MODEL,

1631: END IF;
1632:
1633: -- If Model or Standard or KIT then do nothing.
1634: IF l_line_tbl(k).item_type_code IN (OE_GLOBALS.G_ITEM_STANDARD,
1635: OE_GLOBALS.G_ITEM_MODEL,
1636: OE_GLOBALS.G_ITEM_KIT) THEN
1637:
1638: GOTO Leave_record_as_is;
1639:

Line 1636: OE_GLOBALS.G_ITEM_KIT) THEN

1632:
1633: -- If Model or Standard or KIT then do nothing.
1634: IF l_line_tbl(k).item_type_code IN (OE_GLOBALS.G_ITEM_STANDARD,
1635: OE_GLOBALS.G_ITEM_MODEL,
1636: OE_GLOBALS.G_ITEM_KIT) THEN
1637:
1638: GOTO Leave_record_as_is;
1639:
1640: END IF;

Line 1658: IF l_line_tbl(k).item_type_code IN (OE_GLOBALS.G_ITEM_CONFIG,

1654: -- Included item gets copied over as Standard if parent is not
1655: -- passed in. It gets deleted if parent is passed in since
1656: -- Process Order will re-exploded based on Freeze date.
1657:
1658: IF l_line_tbl(k).item_type_code IN (OE_GLOBALS.G_ITEM_CONFIG,
1659: OE_GLOBALS.G_ITEM_INCLUDED) THEN
1660:
1661:
1662: -- Find if Link to Line has been passed in.

Line 1659: OE_GLOBALS.G_ITEM_INCLUDED) THEN

1655: -- passed in. It gets deleted if parent is passed in since
1656: -- Process Order will re-exploded based on Freeze date.
1657:
1658: IF l_line_tbl(k).item_type_code IN (OE_GLOBALS.G_ITEM_CONFIG,
1659: OE_GLOBALS.G_ITEM_INCLUDED) THEN
1660:
1661:
1662: -- Find if Link to Line has been passed in.
1663:

Line 1668: l_line_tbl(k).item_type_code := OE_GLOBALS.G_ITEM_STANDARD;

1664: IF l_line_tbl(k).link_to_line_id IS NOT NULL THEN
1665: l_link_to_index := Find_LineIndex(l_line_tbl,l_line_tbl(k).link_to_line_id);
1666: IF l_link_to_index = FND_API.G_MISS_NUM THEN
1667:
1668: l_line_tbl(k).item_type_code := OE_GLOBALS.G_ITEM_STANDARD;
1669: l_line_tbl(k).option_number := NULL;
1670: l_line_tbl(k).component_number := NULL;
1671: l_line_tbl(k).split_from_line_id := NULL;
1672: l_line_tbl(k).split_by := NULL;

Line 1690: IF l_line_tbl(k).item_type_code = (OE_GLOBALS.G_ITEM_OPTION) THEN

1686:
1687: -- Option gets copied over as such if parent is passed in
1688: -- else it gets converted to a Standard item.
1689:
1690: IF l_line_tbl(k).item_type_code = (OE_GLOBALS.G_ITEM_OPTION) THEN
1691:
1692: IF l_debug_level > 0 THEN
1693: oe_debug_pub.add( ' OPTION 1' || TO_CHAR ( L_LINE_TBL ( K ) .LINE_ID ) , 1 ) ;
1694: END IF;

Line 1703: l_line_tbl(k).item_type_code := OE_GLOBALS.G_ITEM_STANDARD;

1699: l_line_tbl(k).top_model_line_id);
1700:
1701: IF l_top_model_index = FND_API.G_MISS_NUM THEN
1702:
1703: l_line_tbl(k).item_type_code := OE_GLOBALS.G_ITEM_STANDARD;
1704: l_line_tbl(k).option_number := NULL;
1705: l_line_tbl(k).component_number := NULL;
1706: l_line_tbl(k).split_from_line_id := NULL;
1707: l_line_tbl(k).split_by := NULL;

Line 1720: l_line_tbl(k).item_type_code := OE_GLOBALS.G_ITEM_STANDARD;

1716: l_line_tbl(k).link_to_line_id);
1717:
1718: IF l_link_to_index = FND_API.G_MISS_NUM THEN
1719:
1720: l_line_tbl(k).item_type_code := OE_GLOBALS.G_ITEM_STANDARD;
1721: l_line_tbl(k).option_number := NULL;
1722: l_line_tbl(k).component_number := NULL;
1723: l_line_tbl(k).split_from_line_id := NULL;
1724: l_line_tbl(k).split_by := NULL;

Line 1757: IF l_line_tbl(k).item_type_code = (OE_GLOBALS.G_ITEM_CLASS) THEN

1753:
1754: -- Classes get copied over as such if the parent is passed in
1755: -- else it gets deleted(Classes cannot be conveted to STANDARD)
1756:
1757: IF l_line_tbl(k).item_type_code = (OE_GLOBALS.G_ITEM_CLASS) THEN
1758:
1759: IF l_debug_level > 0 THEN
1760: oe_debug_pub.add( 'CLASS 1' || TO_CHAR ( L_LINE_TBL ( K ) .LINE_ID ) , 1 ) ;
1761: END IF;

Line 1808: IF l_line_tbl(k).item_type_code = (OE_GLOBALS.G_ITEM_SERVICE) THEN

1804: END IF; -- Class
1805:
1806: -- For the Service Lines
1807:
1808: IF l_line_tbl(k).item_type_code = (OE_GLOBALS.G_ITEM_SERVICE) THEN
1809:
1810: IF l_debug_level > 0 THEN
1811: oe_debug_pub.add( 'SERVICE ' || TO_CHAR ( L_LINE_TBL ( K ) .LINE_ID ) , 2 ) ;
1812: END IF;

Line 1827: (OE_GLOBALS.G_ITEM_CLASS) THEN

1823: l_line_tbl.delete(k);
1824: GOTO Leave_record_as_is;
1825: ELSE
1826: IF l_line_tbl(l_service_index).item_type_code =
1827: (OE_GLOBALS.G_ITEM_CLASS) THEN
1828:
1829: IF l_line_tbl(l_service_index).top_model_line_id
1830: IS NOT NULL THEN
1831:

Line 1924: ,p_line_id_tbl IN OE_GLOBALS.Selected_Record_Tbl

1920: END Handle_NonStandard_Lines;
1921:
1922: Procedure Load_Lines
1923: ( p_num_lines IN NUMBER
1924: ,p_line_id_tbl IN OE_GLOBALS.Selected_Record_Tbl
1925: ,p_all_lines IN VARCHAR2
1926: ,p_incl_cancelled IN VARCHAR2
1927: ,p_header_id IN NUMBER
1928: ,p_hdr_type_id IN NUMBER

Line 2060: IF x_line_tbl(I).item_type_code = OE_GLOBALS.G_ITEM_OPTION

2056: FOR I in x_line_tbl.FIRST .. x_line_tbl.LAST LOOP
2057:
2058: l_top_model_index := FND_API.G_MISS_NUM;
2059:
2060: IF x_line_tbl(I).item_type_code = OE_GLOBALS.G_ITEM_OPTION
2061: OR x_line_tbl(I).item_type_code = OE_GLOBALS.G_ITEM_CLASS THEN
2062:
2063:
2064: l_top_model_index := Find_LineIndex(x_line_tbl,

Line 2061: OR x_line_tbl(I).item_type_code = OE_GLOBALS.G_ITEM_CLASS THEN

2057:
2058: l_top_model_index := FND_API.G_MISS_NUM;
2059:
2060: IF x_line_tbl(I).item_type_code = OE_GLOBALS.G_ITEM_OPTION
2061: OR x_line_tbl(I).item_type_code = OE_GLOBALS.G_ITEM_CLASS THEN
2062:
2063:
2064: l_top_model_index := Find_LineIndex(x_line_tbl,
2065: x_line_tbl(I).top_model_line_id);

Line 2068: ELSIF x_line_tbl(I).item_type_code = OE_GLOBALS.G_ITEM_KIT

2064: l_top_model_index := Find_LineIndex(x_line_tbl,
2065: x_line_tbl(I).top_model_line_id);
2066: x_line_tbl(I).top_model_line_index := l_top_model_index;
2067:
2068: ELSIF x_line_tbl(I).item_type_code = OE_GLOBALS.G_ITEM_KIT
2069: THEN
2070:
2071: IF x_line_tbl(I).top_model_line_id <> x_line_tbl(I).line_id THEN
2072:

Line 2083: ELSIF x_line_tbl(I).item_type_code = OE_GLOBALS.G_ITEM_MODEL

2079: -- ## fixed as a prt of 1826688, however we need to always
2080: -- populate the top_model_line_index on the model line,
2081: -- irrespective of this bug fix.
2082:
2083: ELSIF x_line_tbl(I).item_type_code = OE_GLOBALS.G_ITEM_MODEL
2084: THEN
2085: x_line_tbl(I).top_model_line_index := I;
2086:
2087: /* Start 3923574 */

Line 2236: ELSIF x_line_tbl(I).item_type_code = OE_GLOBALS.G_ITEM_SERVICE

2232: END IF;
2233: /* End - Code for bug 1923460 */
2234:
2235: -- Set service line index for service lines.
2236: ELSIF x_line_tbl(I).item_type_code = OE_GLOBALS.G_ITEM_SERVICE
2237: THEN
2238:
2239: l_top_model_index := Find_LineIndex(x_line_tbl,
2240: x_line_tbl(I).service_reference_line_id);

Line 3258: p_x_line_tbl(k).operation := OE_GLOBALS.G_OPR_CREATE;

3254: p_x_line_tbl(k).calculate_price_flag := 'P';
3255: END IF;
3256:
3257: -- Set operation
3258: p_x_line_tbl(k).operation := OE_GLOBALS.G_OPR_CREATE;
3259:
3260: -- Set source Information
3261: p_x_line_tbl(k).source_document_type_id := 2;
3262: p_x_line_tbl(k).source_document_id := l_temp_line_rec.header_id;

Line 3388: x_line_scredit_tbl(I).operation := OE_GLOBALS.G_OPR_CREATE;

3384:
3385: x_Line_scredit_tbl(I) := l_sub_scredit_tbl(j);
3386:
3387: -- Init columns
3388: x_line_scredit_tbl(I).operation := OE_GLOBALS.G_OPR_CREATE;
3389: x_Line_scredit_tbl(I).line_index := k;
3390: x_Line_scredit_tbl(I).header_id := FND_API.G_MISS_NUM;
3391: x_Line_scredit_tbl(I).line_id := FND_API.G_MISS_NUM;
3392: x_Line_scredit_tbl(I).sales_credit_id := FND_API.G_MISS_NUM;

Line 3515: x_line_payment_tbl(I).operation := OE_GLOBALS.G_OPR_CREATE;

3511: goto Next_Payment;
3512: END IF;
3513: x_Line_payment_tbl(I) := l_sub_payment_tbl(j);
3514: -- Init columns
3515: x_line_payment_tbl(I).operation := OE_GLOBALS.G_OPR_CREATE;
3516: x_Line_payment_tbl(I).header_id := FND_API.G_MISS_NUM;
3517: x_Line_payment_tbl(I).line_id := FND_API.G_MISS_NUM;
3518: x_Line_payment_tbl(I).line_index := k;
3519: --bug5741708 setting the payment_number to G_MISS_NUM since we aren't copying commitments

Line 3703: ,p_hdr_id_tbl IN OE_GLOBALS.Selected_Record_Tbl

3699:
3700:
3701: PROCEDURE Copy_Order
3702: ( p_copy_rec IN copy_rec_type
3703: ,p_hdr_id_tbl IN OE_GLOBALS.Selected_Record_Tbl
3704: ,p_line_id_tbl IN OE_GLOBALS.Selected_Record_Tbl
3705: ,x_header_id OUT NOCOPY NUMBER
3706: ,x_return_status OUT NOCOPY VARCHAR2
3707: ,x_msg_count OUT NOCOPY NUMBER

Line 3704: ,p_line_id_tbl IN OE_GLOBALS.Selected_Record_Tbl

3700:
3701: PROCEDURE Copy_Order
3702: ( p_copy_rec IN copy_rec_type
3703: ,p_hdr_id_tbl IN OE_GLOBALS.Selected_Record_Tbl
3704: ,p_line_id_tbl IN OE_GLOBALS.Selected_Record_Tbl
3705: ,x_header_id OUT NOCOPY NUMBER
3706: ,x_return_status OUT NOCOPY VARCHAR2
3707: ,x_msg_count OUT NOCOPY NUMBER
3708: ,x_msg_data OUT NOCOPY VARCHAR2)

Line 3728: l_control_rec OE_GLOBALS.Control_Rec_Type;

3724: k NUMBER; -- Used as loop index.
3725: j NUMBER; -- Used as loop index.
3726:
3727: l_header_rec OE_Order_PUB.Header_Rec_Type;
3728: l_control_rec OE_GLOBALS.Control_Rec_Type;
3729: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
3730: /* Added the following line to fix the bug 1923460 */
3731: l_top_model_tbl top_model_tbl_type;
3732: l_line_final_tbl OE_Order_PUB.Line_Tbl_Type;

Line 3791: l_hdr_id_sets_tbl OE_GLOBALS.Selected_Record_Tbl;

3787: l_cc_line_payments NUMBER;
3788:
3789: -- Copy Sets ER #2830872 , #1566254 Begin.
3790: l_sets_result VARCHAR2(1);
3791: l_hdr_id_sets_tbl OE_GLOBALS.Selected_Record_Tbl;
3792: l_sets_found_flag BOOLEAN := FALSE;
3793: l_sets NUMBER := 0;
3794: l_sets_header_id NUMBER;
3795: l_copy_fulfill_sets BOOLEAN := FALSE;

Line 3898: l_header_rec.operation := OE_GLOBALS.G_OPR_CREATE;

3894: p_copy_rec,
3895: l_header_rec);
3896:
3897: ---- Creating New Sales Order or Quoted Order
3898: l_header_rec.operation := OE_GLOBALS.G_OPR_CREATE;
3899: l_header_rec.transaction_phase_code := p_copy_rec.new_phase;
3900:
3901: IF l_debug_level > 0 THEN
3902: oe_debug_pub.add( 'AK1 HEADER ID ' || TO_CHAR ( L_HEADER_ID ) , 2 ) ;

Line 4000: l_header_rec.operation := OE_GLOBALS.G_OPR_CREATE;

3996:
3997: END IF;
3998:
3999: END IF; -- l_line_header_id
4000: l_header_rec.operation := OE_GLOBALS.G_OPR_CREATE;
4001: END IF; -- IF FND_API.to_Boolean(p_copy_rec.hdr_info)
4002:
4003: -- Copy Header Sales Credits if desired.
4004: IF FND_API.to_Boolean(p_copy_rec.hdr_scredits) THEN

Line 4142: l_header_rec.operation := OE_GLOBALS.G_OPR_NONE; -- Add Lines to Existing Order

4138: -- R12 CC Encryption
4139: ELSE -- Append to Existing Order
4140: l_destination_header_id := p_copy_rec.append_to_header_id;
4141: l_header_rec.header_id := p_copy_rec.append_to_header_id;
4142: l_header_rec.operation := OE_GLOBALS.G_OPR_NONE; -- Add Lines to Existing Order
4143: -- May need to explode config for line level COPY.
4144: IF p_copy_rec.source_block_type = 'LINE' AND
4145: p_copy_rec.copy_complete_config = FND_API.G_TRUE
4146: THEN

Line 4275: l_control_rec.process_entity := OE_GLOBALS.G_ENTITY_ALL;

4271: l_control_rec.clear_dependents := FALSE;
4272: l_control_rec.validate_entity := TRUE;
4273: l_control_rec.write_to_DB := TRUE;
4274: l_control_rec.process := TRUE;
4275: l_control_rec.process_entity := OE_GLOBALS.G_ENTITY_ALL;
4276:
4277: -- Instruct API to process as many records as it can
4278:
4279: l_control_rec.Process_Partial := TRUE;

Line 4321: ,p_validation_level => OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF

4317: OE_Order_PVT.Process_Order(
4318: p_api_version_number => 1
4319: ,p_init_msg_list => FND_API.G_FALSE
4320: -- to keep messages between calls
4321: ,p_validation_level => OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF
4322: -- to miss out invalid attrs.
4323: ,p_control_rec => l_control_rec
4324: ,p_x_header_rec => l_header_rec
4325: ,p_x_header_Adj_tbl => l_header_Adj_out_tbl

Line 4482: (p_entity_code => OE_GLOBALS.G_ENTITY_HEADER

4478:
4479: IF FND_API.to_Boolean( p_copy_rec.hdr_attchmnts ) THEN
4480:
4481: OE_Atchmt_Util.Copy_Attachments
4482: (p_entity_code => OE_GLOBALS.G_ENTITY_HEADER
4483: ,p_from_entity_id => G_ATT_HEADER_ID
4484: ,p_to_entity_id => l_header_rec.header_id
4485: ,p_manual_attachments_only => 'Y'
4486: ,x_return_status => l_return_status);

Line 4515: (p_entity_code => OE_GLOBALS.G_ENTITY_LINE

4511: IF ( l_line_tbl(k).return_status = FND_API.g_ret_sts_success ) THEN
4512:
4513: IF FND_API.to_Boolean( p_copy_rec.line_attchmnts ) THEN
4514: OE_Atchmt_Util.Copy_Attachments
4515: (p_entity_code => OE_GLOBALS.G_ENTITY_LINE
4516: ,p_from_entity_id => l_line_tbl(k).source_document_line_id
4517: ,p_to_entity_id => l_line_tbl(k).line_id
4518: ,p_manual_attachments_only => 'Y'
4519: ,x_return_status => l_return_status);

Line 5072: IF NOT OE_GLOBALS.EQUAL(l_copied_rec.source_document_type_id(i),2) THEN

5068:
5069: -- Ignore the line if it is not created by COPY. This may also include
5070: -- lines which are created as a part of the COPY call.
5071:
5072: IF NOT OE_GLOBALS.EQUAL(l_copied_rec.source_document_type_id(i),2) THEN
5073: IF l_debug_level > 0 THEN
5074: oe_debug_pub.add( 'THIS IS NON COPIED LINE' , 1 ) ;
5075: END IF;
5076: GOTO NOT_COPIED_LINE;

Line 5183: NOT OE_GLOBALS.EQUAL(l_line_number_ctr,l_copied_rec.line_number(i))

5179: <>
5180:
5181:
5182: IF l_copied_rec.line_number(i) IS NOT NULL AND
5183: NOT OE_GLOBALS.EQUAL(l_line_number_ctr,l_copied_rec.line_number(i))
5184: AND NOT OE_GLOBALS.EQUAL(l_copied_rec.line_number(i),
5185: l_prev_line_number)
5186: THEN
5187: l_line_number_ctr := NVL(l_line_number_ctr,0) + 1;

Line 5184: AND NOT OE_GLOBALS.EQUAL(l_copied_rec.line_number(i),

5180:
5181:
5182: IF l_copied_rec.line_number(i) IS NOT NULL AND
5183: NOT OE_GLOBALS.EQUAL(l_line_number_ctr,l_copied_rec.line_number(i))
5184: AND NOT OE_GLOBALS.EQUAL(l_copied_rec.line_number(i),
5185: l_prev_line_number)
5186: THEN
5187: l_line_number_ctr := NVL(l_line_number_ctr,0) + 1;
5188: l_shipment_number_ctr := NULL;

Line 5200: NOT OE_GLOBALS.EQUAL(l_shipment_number_ctr,

5196:
5197: l_copied_rec.line_number(i) := l_line_number_ctr;
5198:
5199: IF l_copied_rec.shipment_number(i) IS NOT NULL AND
5200: NOT OE_GLOBALS.EQUAL(l_shipment_number_ctr,
5201: l_copied_rec.shipment_number(i))
5202: THEN
5203: -- l_shipment_number_ctr := NVL(l_shipment_number_ctr,0) + 1;
5204: IF l_shipment_number_ctr IS NULL

Line 5220: NOT OE_GLOBALS.EQUAL(l_option_number_ctr,

5216: l_copied_rec.shipment_number(i) := l_shipment_number_ctr;
5217:
5218: <> --Bug5757050
5219: IF l_copied_rec.option_number(i) IS NOT NULL AND
5220: NOT OE_GLOBALS.EQUAL(l_option_number_ctr,
5221: l_copied_rec.option_number(i))
5222: THEN
5223: l_option_number_ctr := NVL(l_option_number_ctr,0) + 1;
5224: l_comp_number_ctr := NULL;

Line 5235: NOT OE_GLOBALS.EQUAL(l_comp_number_ctr,

5231: l_copied_rec.option_number(i) := l_option_number_ctr;
5232:
5233: <>
5234: IF l_copied_rec.component_number(i) IS NOT NULL AND
5235: NOT OE_GLOBALS.EQUAL(l_comp_number_ctr,
5236: l_copied_rec.component_number(i))
5237: THEN
5238: l_comp_number_ctr := NVL(l_comp_number_ctr,0) + 1;
5239: l_service_number_ctr := NULL;

Line 5249: NOT OE_GLOBALS.EQUAL(l_service_number_ctr,

5245: l_copied_rec.component_number(i) := l_comp_number_ctr;
5246:
5247: <>
5248: IF l_copied_rec.service_number(i) IS NOT NULL AND
5249: NOT OE_GLOBALS.EQUAL(l_service_number_ctr,
5250: l_copied_rec.service_number(i))
5251: THEN
5252: l_service_number_ctr := NVL(l_service_number_ctr,0) + 1;
5253: IF l_debug_level > 0 THEN

Line 5390: PROCEDURE sort_line_tbl(p_line_id_tbl IN OE_GLOBALS.Selected_Record_Tbl,

5386: -- This is called from the Load Lines procedure if any
5387: -- lines are being copied.
5388: ---------------------------------------------------------------------------------
5389:
5390: PROCEDURE sort_line_tbl(p_line_id_tbl IN OE_GLOBALS.Selected_Record_Tbl,
5391: p_version_number IN NUMBER,
5392: p_phase_change_flag IN VARCHAR2,
5393: p_num_lines IN NUMBER,
5394: x_line_tbl IN OUT NOCOPY OE_ORDER_PUB.Line_Tbl_Type)

Line 6005: l_selected_line_tbl OE_GLOBALS.Selected_Record_Tbl;

6001: x_result OUT NOCOPY VARCHAR2)
6002: IS
6003:
6004: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
6005: l_selected_line_tbl OE_GLOBALS.Selected_Record_Tbl;
6006: I NUMBER := 0;
6007: l_set_id NUMBER;
6008: l_return_status VARCHAR2(30);
6009: l_msg_count NUMBER :=0;