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_VERSION_HISTORY_UTIL dependencies on FND_API

Line 33: x_return_status := FND_API.G_RET_STS_SUCCESS;

29: l_credit_card_expiration_date DATE;
30:
31: BEGIN
32: -- Initialize API return status to success
33: x_return_status := FND_API.G_RET_STS_SUCCESS;
34:
35: -- If the call is made just to create PHASE_CHANGE history then caller will
36: -- send in p_version_number as NULL.
37: IF p_version_number IS NULL and p_phase_change_flag = 'Y' THEN

Line 1565: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1561: ( G_PKG_NAME
1562: , l_api_name
1563: );
1564: END IF;
1565: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1566:
1567: END Create_Version_History;
1568:
1569:

Line 1580: IF p_price_adjustment_id <> FND_API.G_MISS_NUM THEN

1576:
1577: l_current_version_number NUMBER := NULL;
1578: BEGIN
1579:
1580: IF p_price_adjustment_id <> FND_API.G_MISS_NUM THEN
1581:
1582: BEGIN
1583: SELECT h.version_number INTO l_current_version_number
1584: FROM OE_ORDER_HEADERS_ALL h, OE_PRICE_ADJUSTMENTS p

Line 1595: ELSIF p_sales_credit_id <> FND_API.G_MISS_NUM THEN

1591: AND p.price_adjustment_id = p_price_adjustment_id
1592: AND rownum = 1;
1593: END;
1594:
1595: ELSIF p_sales_credit_id <> FND_API.G_MISS_NUM THEN
1596:
1597: BEGIN
1598: SELECT h.version_number INTO l_current_version_number
1599: FROM OE_ORDER_HEADERS_ALL h, OE_SALES_CREDITS s

Line 1609: ELSIF p_line_id <> FND_API.G_MISS_NUM THEN

1605: WHERE h.header_id = s.header_id
1606: AND s.sales_credit_id = p_sales_credit_id
1607: AND rownum = 1;
1608: END;
1609: ELSIF p_line_id <> FND_API.G_MISS_NUM THEN
1610:
1611: BEGIN
1612: SELECT h.version_number INTO l_current_version_number
1613: FROM OE_ORDER_HEADERS_ALL h, OE_ORDER_LINES_ALL l

Line 1624: ELSIF p_header_id <> FND_API.G_MISS_NUM THEN

1620: AND l.line_id = p_line_id
1621: AND rownum = 1;
1622: END;
1623:
1624: ELSIF p_header_id <> FND_API.G_MISS_NUM THEN
1625:
1626: SELECT version_number INTO l_current_version_number
1627: FROM OE_ORDER_HEADERS_ALL WHERE header_id = p_header_id;
1628:

Line 1708: RAISE FND_API.G_EXC_ERROR;

1704:
1705: EXCEPTION
1706: WHEN NO_DATA_FOUND THEN
1707: G_INTERNAL_QUERY := FALSE;
1708: RAISE FND_API.G_EXC_ERROR;
1709:
1710: WHEN OTHERS THEN
1711: G_INTERNAL_QUERY := FALSE;
1712:

Line 1719: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1715: ( G_PKG_NAME
1716: , 'Get_Transaction_Version'
1717: );
1718: END IF;
1719: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1720: END Get_Transaction_Version;
1721:
1722: -- Query_Rows with version_number to query from history tables
1723: -- Header Query_Row

Line 2176: FND_API.G_MISS_NUM

2172:
2173: -- Header Adj Query_Rows
2174: PROCEDURE Query_Rows
2175: ( p_price_adjustment_id IN NUMBER :=
2176: FND_API.G_MISS_NUM
2177: , p_header_id IN NUMBER :=
2178: FND_API.G_MISS_NUM
2179: , p_version_number IN NUMBER := NULL
2180: , p_phase_change_flag IN VARCHAR2 := NULL

Line 2178: FND_API.G_MISS_NUM

2174: PROCEDURE Query_Rows
2175: ( p_price_adjustment_id IN NUMBER :=
2176: FND_API.G_MISS_NUM
2177: , p_header_id IN NUMBER :=
2178: FND_API.G_MISS_NUM
2179: , p_version_number IN NUMBER := NULL
2180: , p_phase_change_flag IN VARCHAR2 := NULL
2181: , x_Header_Adj_Tbl IN OUT NOCOPY OE_Order_PUB.Header_Adj_Tbl_Type
2182: )

Line 2425: p_price_adjustment_id <> FND_API.G_MISS_NUM)

2421:
2422: IF
2423: (p_price_adjustment_id IS NOT NULL
2424: AND
2425: p_price_adjustment_id <> FND_API.G_MISS_NUM)
2426: AND
2427: (p_header_id IS NOT NULL
2428: AND
2429: p_header_id <> FND_API.G_MISS_NUM)

Line 2429: p_header_id <> FND_API.G_MISS_NUM)

2425: p_price_adjustment_id <> FND_API.G_MISS_NUM)
2426: AND
2427: (p_header_id IS NOT NULL
2428: AND
2429: p_header_id <> FND_API.G_MISS_NUM)
2430: THEN
2431:
2432: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2433:

Line 2432: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2428: AND
2429: p_header_id <> FND_API.G_MISS_NUM)
2430: THEN
2431:
2432: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2433:
2434: END IF;
2435:
2436: IF nvl(p_price_adjustment_id,FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN

Line 2436: IF nvl(p_price_adjustment_id,FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN

2432: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2433:
2434: END IF;
2435:
2436: IF nvl(p_price_adjustment_id,FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
2437: l_entity := 1;
2438: OPEN l_header_adj_csr_p;
2439: ELSIF nvl(p_header_id,FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
2440: l_entity := 2;

Line 2439: ELSIF nvl(p_header_id,FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN

2435:
2436: IF nvl(p_price_adjustment_id,FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
2437: l_entity := 1;
2438: OPEN l_header_adj_csr_p;
2439: ELSIF nvl(p_header_id,FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
2440: l_entity := 2;
2441: OPEN l_header_adj_csr_h;
2442: END IF;
2443:

Line 2564: x_Header_Adj_tbl(l_count).db_flag := FND_API.G_TRUE;

2560:
2561: x_Header_Adj_tbl(l_count).lock_control := l_rec.LOCK_CONTROL;
2562:
2563: -- set values for non-DB fields
2564: x_Header_Adj_tbl(l_count).db_flag := FND_API.G_TRUE;
2565: x_Header_Adj_tbl(l_count).operation := FND_API.G_MISS_CHAR;
2566: x_Header_Adj_tbl(l_count).return_status := FND_API.G_MISS_CHAR;
2567:
2568: l_count := l_count + 1;

Line 2565: x_Header_Adj_tbl(l_count).operation := FND_API.G_MISS_CHAR;

2561: x_Header_Adj_tbl(l_count).lock_control := l_rec.LOCK_CONTROL;
2562:
2563: -- set values for non-DB fields
2564: x_Header_Adj_tbl(l_count).db_flag := FND_API.G_TRUE;
2565: x_Header_Adj_tbl(l_count).operation := FND_API.G_MISS_CHAR;
2566: x_Header_Adj_tbl(l_count).return_status := FND_API.G_MISS_CHAR;
2567:
2568: l_count := l_count + 1;
2569: END LOOP;

Line 2566: x_Header_Adj_tbl(l_count).return_status := FND_API.G_MISS_CHAR;

2562:
2563: -- set values for non-DB fields
2564: x_Header_Adj_tbl(l_count).db_flag := FND_API.G_TRUE;
2565: x_Header_Adj_tbl(l_count).operation := FND_API.G_MISS_CHAR;
2566: x_Header_Adj_tbl(l_count).return_status := FND_API.G_MISS_CHAR;
2567:
2568: l_count := l_count + 1;
2569: END LOOP;
2570:

Line 2582: p_price_adjustment_id <> FND_API.G_MISS_NUM)

2578:
2579: IF
2580: (p_price_adjustment_id IS NOT NULL
2581: AND
2582: p_price_adjustment_id <> FND_API.G_MISS_NUM)
2583: AND
2584: (x_Header_Adj_tbl.COUNT = 0)
2585: THEN
2586: RAISE NO_DATA_FOUND;

Line 2595: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2591: END IF;
2592:
2593: EXCEPTION
2594:
2595: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2596:
2597: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2598:
2599: WHEN OTHERS THEN

Line 2597: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2593: EXCEPTION
2594:
2595: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2596:
2597: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2598:
2599: WHEN OTHERS THEN
2600:
2601: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

Line 2607: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2603: ( G_PKG_NAME
2604: , 'Header Adj Query_Rows'
2605: );
2606: END IF;
2607: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2608:
2609: END;
2610:
2611:

Line 2662: FND_API.G_MISS_NUM

2658:
2659: -- Header SCredit Query_Rows
2660: PROCEDURE Query_Rows
2661: ( p_sales_credit_id IN NUMBER :=
2662: FND_API.G_MISS_NUM
2663: , p_header_id IN NUMBER :=
2664: FND_API.G_MISS_NUM
2665: , p_version_number IN NUMBER := NULL
2666: , p_phase_change_flag IN VARCHAR2 := NULL

Line 2664: FND_API.G_MISS_NUM

2660: PROCEDURE Query_Rows
2661: ( p_sales_credit_id IN NUMBER :=
2662: FND_API.G_MISS_NUM
2663: , p_header_id IN NUMBER :=
2664: FND_API.G_MISS_NUM
2665: , p_version_number IN NUMBER := NULL
2666: , p_phase_change_flag IN VARCHAR2 := NULL
2667: , x_Header_Scredit_tbl IN OUT NOCOPY OE_Order_PUB.Header_Scredit_tbl_Type
2668: )

Line 2778: p_sales_credit_id <> FND_API.G_MISS_NUM)

2774:
2775: IF
2776: (p_sales_credit_id IS NOT NULL
2777: AND
2778: p_sales_credit_id <> FND_API.G_MISS_NUM)
2779: AND
2780: (p_header_id IS NOT NULL
2781: AND
2782: p_header_id <> FND_API.G_MISS_NUM)

Line 2782: p_header_id <> FND_API.G_MISS_NUM)

2778: p_sales_credit_id <> FND_API.G_MISS_NUM)
2779: AND
2780: (p_header_id IS NOT NULL
2781: AND
2782: p_header_id <> FND_API.G_MISS_NUM)
2783: THEN
2784: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2785:
2786: END IF;

Line 2784: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2780: (p_header_id IS NOT NULL
2781: AND
2782: p_header_id <> FND_API.G_MISS_NUM)
2783: THEN
2784: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2785:
2786: END IF;
2787:
2788: IF nvl(p_sales_credit_id,FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN

Line 2788: IF nvl(p_sales_credit_id,FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN

2784: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2785:
2786: END IF;
2787:
2788: IF nvl(p_sales_credit_id,FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
2789: l_entity := 1;
2790: OPEN l_header_scredit_csr_s;
2791: ELSIF nvl(p_header_id,FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
2792: l_entity := 2;

Line 2791: ELSIF nvl(p_header_id,FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN

2787:
2788: IF nvl(p_sales_credit_id,FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
2789: l_entity := 1;
2790: OPEN l_header_scredit_csr_s;
2791: ELSIF nvl(p_header_id,FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
2792: l_entity := 2;
2793: OPEN l_header_scredit_csr_h;
2794: END IF;
2795:

Line 2860: p_sales_credit_id <> FND_API.G_MISS_NUM)

2856:
2857: IF
2858: (p_sales_credit_id IS NOT NULL
2859: AND
2860: p_sales_credit_id <> FND_API.G_MISS_NUM)
2861: AND
2862: (x_Header_Scredit_tbl.COUNT = 0)
2863: THEN
2864: RAISE NO_DATA_FOUND;

Line 2929: FND_API.G_MISS_NUM

2925:
2926: -- Line Query_Rows
2927: PROCEDURE Query_Rows
2928: ( p_line_id IN NUMBER :=
2929: FND_API.G_MISS_NUM
2930: , p_header_id IN NUMBER :=
2931: FND_API.G_MISS_NUM
2932: , p_line_set_id IN NUMBER :=
2933: FND_API.G_MISS_NUM

Line 2931: FND_API.G_MISS_NUM

2927: PROCEDURE Query_Rows
2928: ( p_line_id IN NUMBER :=
2929: FND_API.G_MISS_NUM
2930: , p_header_id IN NUMBER :=
2931: FND_API.G_MISS_NUM
2932: , p_line_set_id IN NUMBER :=
2933: FND_API.G_MISS_NUM
2934: , p_version_number IN NUMBER := NULL
2935: , p_phase_change_flag IN VARCHAR2 := NULL

Line 2933: FND_API.G_MISS_NUM

2929: FND_API.G_MISS_NUM
2930: , p_header_id IN NUMBER :=
2931: FND_API.G_MISS_NUM
2932: , p_line_set_id IN NUMBER :=
2933: FND_API.G_MISS_NUM
2934: , p_version_number IN NUMBER := NULL
2935: , p_phase_change_flag IN VARCHAR2 := NULL
2936: , x_line_tbl IN OUT NOCOPY OE_Order_PUB.Line_Tbl_Type
2937: )

Line 3981: p_line_id <> FND_API.G_MISS_NUM)

3977:
3978: IF
3979: (p_line_id IS NOT NULL
3980: AND
3981: p_line_id <> FND_API.G_MISS_NUM)
3982: AND
3983: (p_header_id IS NOT NULL
3984: AND
3985: p_header_id <> FND_API.G_MISS_NUM)

Line 3985: p_header_id <> FND_API.G_MISS_NUM)

3981: p_line_id <> FND_API.G_MISS_NUM)
3982: AND
3983: (p_header_id IS NOT NULL
3984: AND
3985: p_header_id <> FND_API.G_MISS_NUM)
3986: THEN
3987:
3988: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3989:

Line 3988: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3984: AND
3985: p_header_id <> FND_API.G_MISS_NUM)
3986: THEN
3987:
3988: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3989:
3990: END IF;
3991:
3992: -----------------------------------------------------------------

Line 3997: IF nvl(p_line_id,FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN

3993: -- Fix bug 1275972: Setup the l_entity variable based on the ID
3994: -- variable that is passed.
3995: -----------------------------------------------------------------
3996:
3997: IF nvl(p_line_id,FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
3998: l_entity := 1;
3999: OPEN l_line_csr_l;
4000: ELSIF nvl(p_header_id,FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
4001: l_entity := 2;

Line 4000: ELSIF nvl(p_header_id,FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN

3996:
3997: IF nvl(p_line_id,FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
3998: l_entity := 1;
3999: OPEN l_line_csr_l;
4000: ELSIF nvl(p_header_id,FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
4001: l_entity := 2;
4002: OPEN l_line_csr_h;
4003: ELSIF nvl(p_line_set_id,FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
4004: l_entity := 3;

Line 4003: ELSIF nvl(p_line_set_id,FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN

3999: OPEN l_line_csr_l;
4000: ELSIF nvl(p_header_id,FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
4001: l_entity := 2;
4002: OPEN l_line_csr_h;
4003: ELSIF nvl(p_line_set_id,FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
4004: l_entity := 3;
4005: OPEN l_line_csr_s;
4006: END IF;
4007:

Line 4384: x_line_tbl(l_count).db_flag := FND_API.G_TRUE;

4380: --l_SVN := l_rec.SVN;
4381:
4382:
4383: -- set values for non-DB fields
4384: x_line_tbl(l_count).db_flag := FND_API.G_TRUE;
4385: x_line_tbl(l_count).operation := FND_API.G_MISS_CHAR;
4386: x_line_tbl(l_count).return_status := FND_API.G_MISS_CHAR;
4387:
4388: x_line_tbl(l_count).schedule_action_code := FND_API.G_MISS_CHAR;

Line 4385: x_line_tbl(l_count).operation := FND_API.G_MISS_CHAR;

4381:
4382:
4383: -- set values for non-DB fields
4384: x_line_tbl(l_count).db_flag := FND_API.G_TRUE;
4385: x_line_tbl(l_count).operation := FND_API.G_MISS_CHAR;
4386: x_line_tbl(l_count).return_status := FND_API.G_MISS_CHAR;
4387:
4388: x_line_tbl(l_count).schedule_action_code := FND_API.G_MISS_CHAR;
4389: x_line_tbl(l_count).reserved_quantity := FND_API.G_MISS_NUM;

Line 4386: x_line_tbl(l_count).return_status := FND_API.G_MISS_CHAR;

4382:
4383: -- set values for non-DB fields
4384: x_line_tbl(l_count).db_flag := FND_API.G_TRUE;
4385: x_line_tbl(l_count).operation := FND_API.G_MISS_CHAR;
4386: x_line_tbl(l_count).return_status := FND_API.G_MISS_CHAR;
4387:
4388: x_line_tbl(l_count).schedule_action_code := FND_API.G_MISS_CHAR;
4389: x_line_tbl(l_count).reserved_quantity := FND_API.G_MISS_NUM;
4390: x_line_tbl(l_count).change_reason := FND_API.G_MISS_CHAR;

Line 4388: x_line_tbl(l_count).schedule_action_code := FND_API.G_MISS_CHAR;

4384: x_line_tbl(l_count).db_flag := FND_API.G_TRUE;
4385: x_line_tbl(l_count).operation := FND_API.G_MISS_CHAR;
4386: x_line_tbl(l_count).return_status := FND_API.G_MISS_CHAR;
4387:
4388: x_line_tbl(l_count).schedule_action_code := FND_API.G_MISS_CHAR;
4389: x_line_tbl(l_count).reserved_quantity := FND_API.G_MISS_NUM;
4390: x_line_tbl(l_count).change_reason := FND_API.G_MISS_CHAR;
4391: x_line_tbl(l_count).change_comments := FND_API.G_MISS_CHAR;
4392: x_line_tbl(l_count).arrival_set := FND_API.G_MISS_CHAR;

Line 4389: x_line_tbl(l_count).reserved_quantity := FND_API.G_MISS_NUM;

4385: x_line_tbl(l_count).operation := FND_API.G_MISS_CHAR;
4386: x_line_tbl(l_count).return_status := FND_API.G_MISS_CHAR;
4387:
4388: x_line_tbl(l_count).schedule_action_code := FND_API.G_MISS_CHAR;
4389: x_line_tbl(l_count).reserved_quantity := FND_API.G_MISS_NUM;
4390: x_line_tbl(l_count).change_reason := FND_API.G_MISS_CHAR;
4391: x_line_tbl(l_count).change_comments := FND_API.G_MISS_CHAR;
4392: x_line_tbl(l_count).arrival_set := FND_API.G_MISS_CHAR;
4393: x_line_tbl(l_count).ship_set := FND_API.G_MISS_CHAR;

Line 4390: x_line_tbl(l_count).change_reason := FND_API.G_MISS_CHAR;

4386: x_line_tbl(l_count).return_status := FND_API.G_MISS_CHAR;
4387:
4388: x_line_tbl(l_count).schedule_action_code := FND_API.G_MISS_CHAR;
4389: x_line_tbl(l_count).reserved_quantity := FND_API.G_MISS_NUM;
4390: x_line_tbl(l_count).change_reason := FND_API.G_MISS_CHAR;
4391: x_line_tbl(l_count).change_comments := FND_API.G_MISS_CHAR;
4392: x_line_tbl(l_count).arrival_set := FND_API.G_MISS_CHAR;
4393: x_line_tbl(l_count).ship_set := FND_API.G_MISS_CHAR;
4394: x_line_tbl(l_count).fulfillment_set := FND_API.G_MISS_CHAR;

Line 4391: x_line_tbl(l_count).change_comments := FND_API.G_MISS_CHAR;

4387:
4388: x_line_tbl(l_count).schedule_action_code := FND_API.G_MISS_CHAR;
4389: x_line_tbl(l_count).reserved_quantity := FND_API.G_MISS_NUM;
4390: x_line_tbl(l_count).change_reason := FND_API.G_MISS_CHAR;
4391: x_line_tbl(l_count).change_comments := FND_API.G_MISS_CHAR;
4392: x_line_tbl(l_count).arrival_set := FND_API.G_MISS_CHAR;
4393: x_line_tbl(l_count).ship_set := FND_API.G_MISS_CHAR;
4394: x_line_tbl(l_count).fulfillment_set := FND_API.G_MISS_CHAR;
4395: x_line_tbl(l_count).split_action_code := FND_API.G_MISS_CHAR;

Line 4392: x_line_tbl(l_count).arrival_set := FND_API.G_MISS_CHAR;

4388: x_line_tbl(l_count).schedule_action_code := FND_API.G_MISS_CHAR;
4389: x_line_tbl(l_count).reserved_quantity := FND_API.G_MISS_NUM;
4390: x_line_tbl(l_count).change_reason := FND_API.G_MISS_CHAR;
4391: x_line_tbl(l_count).change_comments := FND_API.G_MISS_CHAR;
4392: x_line_tbl(l_count).arrival_set := FND_API.G_MISS_CHAR;
4393: x_line_tbl(l_count).ship_set := FND_API.G_MISS_CHAR;
4394: x_line_tbl(l_count).fulfillment_set := FND_API.G_MISS_CHAR;
4395: x_line_tbl(l_count).split_action_code := FND_API.G_MISS_CHAR;
4396: l_count := l_count + 1;

Line 4393: x_line_tbl(l_count).ship_set := FND_API.G_MISS_CHAR;

4389: x_line_tbl(l_count).reserved_quantity := FND_API.G_MISS_NUM;
4390: x_line_tbl(l_count).change_reason := FND_API.G_MISS_CHAR;
4391: x_line_tbl(l_count).change_comments := FND_API.G_MISS_CHAR;
4392: x_line_tbl(l_count).arrival_set := FND_API.G_MISS_CHAR;
4393: x_line_tbl(l_count).ship_set := FND_API.G_MISS_CHAR;
4394: x_line_tbl(l_count).fulfillment_set := FND_API.G_MISS_CHAR;
4395: x_line_tbl(l_count).split_action_code := FND_API.G_MISS_CHAR;
4396: l_count := l_count + 1;
4397:

Line 4394: x_line_tbl(l_count).fulfillment_set := FND_API.G_MISS_CHAR;

4390: x_line_tbl(l_count).change_reason := FND_API.G_MISS_CHAR;
4391: x_line_tbl(l_count).change_comments := FND_API.G_MISS_CHAR;
4392: x_line_tbl(l_count).arrival_set := FND_API.G_MISS_CHAR;
4393: x_line_tbl(l_count).ship_set := FND_API.G_MISS_CHAR;
4394: x_line_tbl(l_count).fulfillment_set := FND_API.G_MISS_CHAR;
4395: x_line_tbl(l_count).split_action_code := FND_API.G_MISS_CHAR;
4396: l_count := l_count + 1;
4397:
4398: END LOOP;

Line 4395: x_line_tbl(l_count).split_action_code := FND_API.G_MISS_CHAR;

4391: x_line_tbl(l_count).change_comments := FND_API.G_MISS_CHAR;
4392: x_line_tbl(l_count).arrival_set := FND_API.G_MISS_CHAR;
4393: x_line_tbl(l_count).ship_set := FND_API.G_MISS_CHAR;
4394: x_line_tbl(l_count).fulfillment_set := FND_API.G_MISS_CHAR;
4395: x_line_tbl(l_count).split_action_code := FND_API.G_MISS_CHAR;
4396: l_count := l_count + 1;
4397:
4398: END LOOP;
4399:

Line 4413: p_line_id <> FND_API.G_MISS_NUM)

4409:
4410: IF
4411: (p_line_id IS NOT NULL
4412: AND
4413: p_line_id <> FND_API.G_MISS_NUM)
4414: AND
4415: (x_line_tbl.COUNT = 0)
4416: THEN
4417: RAISE NO_DATA_FOUND;

Line 4481: FND_API.G_MISS_NUM

4477:
4478: -- Line Adj Query_Rows
4479: PROCEDURE Query_Rows
4480: ( p_price_adjustment_id IN NUMBER :=
4481: FND_API.G_MISS_NUM
4482: , p_line_id IN NUMBER :=
4483: FND_API.G_MISS_NUM
4484: , p_Header_id IN NUMBER :=
4485: FND_API.G_MISS_NUM

Line 4483: FND_API.G_MISS_NUM

4479: PROCEDURE Query_Rows
4480: ( p_price_adjustment_id IN NUMBER :=
4481: FND_API.G_MISS_NUM
4482: , p_line_id IN NUMBER :=
4483: FND_API.G_MISS_NUM
4484: , p_Header_id IN NUMBER :=
4485: FND_API.G_MISS_NUM
4486: , p_version_number IN NUMBER := NULL
4487: , p_phase_change_flag IN VARCHAR2 := NULL

Line 4485: FND_API.G_MISS_NUM

4481: FND_API.G_MISS_NUM
4482: , p_line_id IN NUMBER :=
4483: FND_API.G_MISS_NUM
4484: , p_Header_id IN NUMBER :=
4485: FND_API.G_MISS_NUM
4486: , p_version_number IN NUMBER := NULL
4487: , p_phase_change_flag IN VARCHAR2 := NULL
4488: , x_Line_Adj_Tbl IN OUT NOCOPY OE_Order_PUB.Line_Adj_Tbl_Type
4489: )

Line 4851: IF nvl(p_price_adjustment_id,FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN

4847: --bug3392650 (passing the parameter p_header_id instead of p_line_level_header_id)
4848: OE_Line_Adj_Util.Query_Rows(p_price_adjustment_id => p_price_adjustment_id, p_line_id => p_line_id, p_header_id => p_header_id, x_line_adj_tbl => x_line_adj_tbl);
4849: ELSE
4850:
4851: IF nvl(p_price_adjustment_id,FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
4852: l_entity := 1;
4853: OPEN l_line_adj_csr_p;
4854: ELSIF nvl(p_line_id,FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
4855: l_entity := 2;

Line 4854: ELSIF nvl(p_line_id,FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN

4850:
4851: IF nvl(p_price_adjustment_id,FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
4852: l_entity := 1;
4853: OPEN l_line_adj_csr_p;
4854: ELSIF nvl(p_line_id,FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
4855: l_entity := 2;
4856: OPEN l_line_adj_csr_l;
4857: ELSIF nvl(p_header_id,FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
4858: l_entity := 3;

Line 4857: ELSIF nvl(p_header_id,FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN

4853: OPEN l_line_adj_csr_p;
4854: ELSIF nvl(p_line_id,FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
4855: l_entity := 2;
4856: OPEN l_line_adj_csr_l;
4857: ELSIF nvl(p_header_id,FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
4858: l_entity := 3;
4859: OPEN l_line_adj_csr_h;
4860: END IF;
4861:

Line 4984: x_Line_Adj_tbl(l_count).db_flag := FND_API.G_TRUE;

4980: --uom end
4981: x_Line_Adj_tbl(l_count).lock_control := l_rec.LOCK_CONTROL;
4982:
4983: -- set values for non-DB fields
4984: x_Line_Adj_tbl(l_count).db_flag := FND_API.G_TRUE;
4985: x_Line_Adj_tbl(l_count).operation := FND_API.G_MISS_CHAR;
4986: x_Line_Adj_tbl(l_count).return_status := FND_API.G_MISS_CHAR;
4987: -- eBTax changes
4988: x_Line_Adj_tbl(l_count).tax_rate_id := l_rec.tax_rate_id;

Line 4985: x_Line_Adj_tbl(l_count).operation := FND_API.G_MISS_CHAR;

4981: x_Line_Adj_tbl(l_count).lock_control := l_rec.LOCK_CONTROL;
4982:
4983: -- set values for non-DB fields
4984: x_Line_Adj_tbl(l_count).db_flag := FND_API.G_TRUE;
4985: x_Line_Adj_tbl(l_count).operation := FND_API.G_MISS_CHAR;
4986: x_Line_Adj_tbl(l_count).return_status := FND_API.G_MISS_CHAR;
4987: -- eBTax changes
4988: x_Line_Adj_tbl(l_count).tax_rate_id := l_rec.tax_rate_id;
4989:

Line 4986: x_Line_Adj_tbl(l_count).return_status := FND_API.G_MISS_CHAR;

4982:
4983: -- set values for non-DB fields
4984: x_Line_Adj_tbl(l_count).db_flag := FND_API.G_TRUE;
4985: x_Line_Adj_tbl(l_count).operation := FND_API.G_MISS_CHAR;
4986: x_Line_Adj_tbl(l_count).return_status := FND_API.G_MISS_CHAR;
4987: -- eBTax changes
4988: x_Line_Adj_tbl(l_count).tax_rate_id := l_rec.tax_rate_id;
4989:
4990: l_count := l_count + 1;

Line 5007: p_price_adjustment_id <> FND_API.G_MISS_NUM)

5003:
5004: IF
5005: (p_price_adjustment_id IS NOT NULL
5006: AND
5007: p_price_adjustment_id <> FND_API.G_MISS_NUM)
5008: AND
5009: (x_Line_Adj_tbl.COUNT = 0)
5010: THEN
5011: RAISE NO_DATA_FOUND;

Line 5085: FND_API.G_MISS_NUM

5081:
5082: -- Line Scredit Query_Rows
5083: PROCEDURE Query_Rows
5084: ( p_sales_credit_id IN NUMBER :=
5085: FND_API.G_MISS_NUM
5086: , p_line_id IN NUMBER :=
5087: FND_API.G_MISS_NUM
5088: , p_header_id IN NUMBER :=
5089: FND_API.G_MISS_NUM

Line 5087: FND_API.G_MISS_NUM

5083: PROCEDURE Query_Rows
5084: ( p_sales_credit_id IN NUMBER :=
5085: FND_API.G_MISS_NUM
5086: , p_line_id IN NUMBER :=
5087: FND_API.G_MISS_NUM
5088: , p_header_id IN NUMBER :=
5089: FND_API.G_MISS_NUM
5090: , p_version_number IN NUMBER := NULL
5091: , p_phase_change_flag IN VARCHAR2 := NULL

Line 5089: FND_API.G_MISS_NUM

5085: FND_API.G_MISS_NUM
5086: , p_line_id IN NUMBER :=
5087: FND_API.G_MISS_NUM
5088: , p_header_id IN NUMBER :=
5089: FND_API.G_MISS_NUM
5090: , p_version_number IN NUMBER := NULL
5091: , p_phase_change_flag IN VARCHAR2 := NULL
5092: , x_Line_Scredit_tbl IN OUT NOCOPY OE_Order_PUB.Line_Scredit_Tbl_Type
5093: )

Line 5236: p_sales_credit_id <> FND_API.G_MISS_NUM)

5232:
5233: IF
5234: (p_sales_credit_id IS NOT NULL
5235: AND
5236: p_sales_credit_id <> FND_API.G_MISS_NUM)
5237: AND
5238: (p_line_id IS NOT NULL
5239: AND
5240: p_line_id <> FND_API.G_MISS_NUM)

Line 5240: p_line_id <> FND_API.G_MISS_NUM)

5236: p_sales_credit_id <> FND_API.G_MISS_NUM)
5237: AND
5238: (p_line_id IS NOT NULL
5239: AND
5240: p_line_id <> FND_API.G_MISS_NUM)
5241: THEN
5242:
5243: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5244:

Line 5243: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5239: AND
5240: p_line_id <> FND_API.G_MISS_NUM)
5241: THEN
5242:
5243: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5244:
5245: END IF;
5246:
5247:

Line 5248: IF nvl(p_sales_credit_id,FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN

5244:
5245: END IF;
5246:
5247:
5248: IF nvl(p_sales_credit_id,FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
5249: l_entity := 1;
5250: OPEN l_line_scredit_csr_s;
5251: ELSIF nvl(p_line_id,FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
5252: l_entity := 2;

Line 5251: ELSIF nvl(p_line_id,FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN

5247:
5248: IF nvl(p_sales_credit_id,FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
5249: l_entity := 1;
5250: OPEN l_line_scredit_csr_s;
5251: ELSIF nvl(p_line_id,FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
5252: l_entity := 2;
5253: OPEN l_line_scredit_csr_l;
5254: ELSIF nvl(p_header_id,FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
5255: l_entity := 3;

Line 5254: ELSIF nvl(p_header_id,FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN

5250: OPEN l_line_scredit_csr_s;
5251: ELSIF nvl(p_line_id,FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
5252: l_entity := 2;
5253: OPEN l_line_scredit_csr_l;
5254: ELSIF nvl(p_header_id,FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
5255: l_entity := 3;
5256: OPEN l_line_scredit_csr_h;
5257: END IF;
5258:

Line 5324: p_sales_credit_id <> FND_API.G_MISS_NUM)

5320:
5321: IF
5322: (p_sales_credit_id IS NOT NULL
5323: AND
5324: p_sales_credit_id <> FND_API.G_MISS_NUM)
5325: AND
5326: (x_Line_Scredit_tbl.COUNT = 0)
5327: THEN
5328: RAISE NO_DATA_FOUND;