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 80: x_return_status := FND_API.G_RET_STS_SUCCESS;

76: l_credit_card_expiration_date DATE;
77:
78: BEGIN
79: -- Initialize API return status to success
80: x_return_status := FND_API.G_RET_STS_SUCCESS;
81:
82: -- If the call is made just to create PHASE_CHANGE history then caller will
83: -- send in p_version_number as NULL.
84: IF p_version_number IS NULL and p_phase_change_flag = 'Y' THEN

Line 1628: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1624: ( G_PKG_NAME
1625: , l_api_name
1626: );
1627: END IF;
1628: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1629:
1630: END Create_Version_History;
1631:
1632:

Line 1643: IF p_price_adjustment_id <> FND_API.G_MISS_NUM THEN

1639:
1640: l_current_version_number NUMBER := NULL;
1641: BEGIN
1642:
1643: IF p_price_adjustment_id <> FND_API.G_MISS_NUM THEN
1644:
1645: BEGIN
1646: SELECT h.version_number INTO l_current_version_number
1647: FROM OE_ORDER_HEADERS_ALL h, OE_PRICE_ADJUSTMENTS p

Line 1658: ELSIF p_sales_credit_id <> FND_API.G_MISS_NUM THEN

1654: AND p.price_adjustment_id = p_price_adjustment_id
1655: AND rownum = 1;
1656: END;
1657:
1658: ELSIF p_sales_credit_id <> FND_API.G_MISS_NUM THEN
1659:
1660: BEGIN
1661: SELECT h.version_number INTO l_current_version_number
1662: FROM OE_ORDER_HEADERS_ALL h, OE_SALES_CREDITS s

Line 1672: ELSIF p_line_id <> FND_API.G_MISS_NUM THEN

1668: WHERE h.header_id = s.header_id
1669: AND s.sales_credit_id = p_sales_credit_id
1670: AND rownum = 1;
1671: END;
1672: ELSIF p_line_id <> FND_API.G_MISS_NUM THEN
1673:
1674: BEGIN
1675: SELECT h.version_number INTO l_current_version_number
1676: FROM OE_ORDER_HEADERS_ALL h, OE_ORDER_LINES_ALL l

Line 1687: ELSIF p_header_id <> FND_API.G_MISS_NUM THEN

1683: AND l.line_id = p_line_id
1684: AND rownum = 1;
1685: END;
1686:
1687: ELSIF p_header_id <> FND_API.G_MISS_NUM THEN
1688:
1689: SELECT version_number INTO l_current_version_number
1690: FROM OE_ORDER_HEADERS_ALL WHERE header_id = p_header_id;
1691:

Line 1771: RAISE FND_API.G_EXC_ERROR;

1767:
1768: EXCEPTION
1769: WHEN NO_DATA_FOUND THEN
1770: G_INTERNAL_QUERY := FALSE;
1771: RAISE FND_API.G_EXC_ERROR;
1772:
1773: WHEN OTHERS THEN
1774: G_INTERNAL_QUERY := FALSE;
1775:

Line 1782: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1778: ( G_PKG_NAME
1779: , 'Get_Transaction_Version'
1780: );
1781: END IF;
1782: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1783: END Get_Transaction_Version;
1784:
1785: -- Query_Rows with version_number to query from history tables
1786: -- Header Query_Row

Line 2239: FND_API.G_MISS_NUM

2235:
2236: -- Header Adj Query_Rows
2237: PROCEDURE Query_Rows
2238: ( p_price_adjustment_id IN NUMBER :=
2239: FND_API.G_MISS_NUM
2240: , p_header_id IN NUMBER :=
2241: FND_API.G_MISS_NUM
2242: , p_version_number IN NUMBER := NULL
2243: , p_phase_change_flag IN VARCHAR2 := NULL

Line 2241: FND_API.G_MISS_NUM

2237: PROCEDURE Query_Rows
2238: ( p_price_adjustment_id IN NUMBER :=
2239: FND_API.G_MISS_NUM
2240: , p_header_id IN NUMBER :=
2241: FND_API.G_MISS_NUM
2242: , p_version_number IN NUMBER := NULL
2243: , p_phase_change_flag IN VARCHAR2 := NULL
2244: , x_Header_Adj_Tbl IN OUT NOCOPY OE_Order_PUB.Header_Adj_Tbl_Type
2245: )

Line 2488: p_price_adjustment_id <> FND_API.G_MISS_NUM)

2484:
2485: IF
2486: (p_price_adjustment_id IS NOT NULL
2487: AND
2488: p_price_adjustment_id <> FND_API.G_MISS_NUM)
2489: AND
2490: (p_header_id IS NOT NULL
2491: AND
2492: p_header_id <> FND_API.G_MISS_NUM)

Line 2492: p_header_id <> FND_API.G_MISS_NUM)

2488: p_price_adjustment_id <> FND_API.G_MISS_NUM)
2489: AND
2490: (p_header_id IS NOT NULL
2491: AND
2492: p_header_id <> FND_API.G_MISS_NUM)
2493: THEN
2494:
2495: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2496:

Line 2495: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2491: AND
2492: p_header_id <> FND_API.G_MISS_NUM)
2493: THEN
2494:
2495: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2496:
2497: END IF;
2498:
2499: IF nvl(p_price_adjustment_id,FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN

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

2495: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2496:
2497: END IF;
2498:
2499: IF nvl(p_price_adjustment_id,FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
2500: l_entity := 1;
2501: OPEN l_header_adj_csr_p;
2502: ELSIF nvl(p_header_id,FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
2503: l_entity := 2;

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

2498:
2499: IF nvl(p_price_adjustment_id,FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
2500: l_entity := 1;
2501: OPEN l_header_adj_csr_p;
2502: ELSIF nvl(p_header_id,FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
2503: l_entity := 2;
2504: OPEN l_header_adj_csr_h;
2505: END IF;
2506:

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

2623:
2624: x_Header_Adj_tbl(l_count).lock_control := l_rec.LOCK_CONTROL;
2625:
2626: -- set values for non-DB fields
2627: x_Header_Adj_tbl(l_count).db_flag := FND_API.G_TRUE;
2628: x_Header_Adj_tbl(l_count).operation := FND_API.G_MISS_CHAR;
2629: x_Header_Adj_tbl(l_count).return_status := FND_API.G_MISS_CHAR;
2630:
2631: l_count := l_count + 1;

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

2624: x_Header_Adj_tbl(l_count).lock_control := l_rec.LOCK_CONTROL;
2625:
2626: -- set values for non-DB fields
2627: x_Header_Adj_tbl(l_count).db_flag := FND_API.G_TRUE;
2628: x_Header_Adj_tbl(l_count).operation := FND_API.G_MISS_CHAR;
2629: x_Header_Adj_tbl(l_count).return_status := FND_API.G_MISS_CHAR;
2630:
2631: l_count := l_count + 1;
2632: END LOOP;

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

2625:
2626: -- set values for non-DB fields
2627: x_Header_Adj_tbl(l_count).db_flag := FND_API.G_TRUE;
2628: x_Header_Adj_tbl(l_count).operation := FND_API.G_MISS_CHAR;
2629: x_Header_Adj_tbl(l_count).return_status := FND_API.G_MISS_CHAR;
2630:
2631: l_count := l_count + 1;
2632: END LOOP;
2633:

Line 2645: p_price_adjustment_id <> FND_API.G_MISS_NUM)

2641:
2642: IF
2643: (p_price_adjustment_id IS NOT NULL
2644: AND
2645: p_price_adjustment_id <> FND_API.G_MISS_NUM)
2646: AND
2647: (x_Header_Adj_tbl.COUNT = 0)
2648: THEN
2649: RAISE NO_DATA_FOUND;

Line 2658: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2654: END IF;
2655:
2656: EXCEPTION
2657:
2658: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2659:
2660: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2661:
2662: WHEN OTHERS THEN

Line 2660: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2656: EXCEPTION
2657:
2658: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2659:
2660: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2661:
2662: WHEN OTHERS THEN
2663:
2664: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

Line 2670: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2666: ( G_PKG_NAME
2667: , 'Header Adj Query_Rows'
2668: );
2669: END IF;
2670: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2671:
2672: END;
2673:
2674:

Line 2725: FND_API.G_MISS_NUM

2721:
2722: -- Header SCredit Query_Rows
2723: PROCEDURE Query_Rows
2724: ( p_sales_credit_id IN NUMBER :=
2725: FND_API.G_MISS_NUM
2726: , p_header_id IN NUMBER :=
2727: FND_API.G_MISS_NUM
2728: , p_version_number IN NUMBER := NULL
2729: , p_phase_change_flag IN VARCHAR2 := NULL

Line 2727: FND_API.G_MISS_NUM

2723: PROCEDURE Query_Rows
2724: ( p_sales_credit_id IN NUMBER :=
2725: FND_API.G_MISS_NUM
2726: , p_header_id IN NUMBER :=
2727: FND_API.G_MISS_NUM
2728: , p_version_number IN NUMBER := NULL
2729: , p_phase_change_flag IN VARCHAR2 := NULL
2730: , x_Header_Scredit_tbl IN OUT NOCOPY OE_Order_PUB.Header_Scredit_tbl_Type
2731: )

Line 2841: p_sales_credit_id <> FND_API.G_MISS_NUM)

2837:
2838: IF
2839: (p_sales_credit_id IS NOT NULL
2840: AND
2841: p_sales_credit_id <> FND_API.G_MISS_NUM)
2842: AND
2843: (p_header_id IS NOT NULL
2844: AND
2845: p_header_id <> FND_API.G_MISS_NUM)

Line 2845: p_header_id <> FND_API.G_MISS_NUM)

2841: p_sales_credit_id <> FND_API.G_MISS_NUM)
2842: AND
2843: (p_header_id IS NOT NULL
2844: AND
2845: p_header_id <> FND_API.G_MISS_NUM)
2846: THEN
2847: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2848:
2849: END IF;

Line 2847: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2843: (p_header_id IS NOT NULL
2844: AND
2845: p_header_id <> FND_API.G_MISS_NUM)
2846: THEN
2847: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2848:
2849: END IF;
2850:
2851: IF nvl(p_sales_credit_id,FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN

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

2847: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2848:
2849: END IF;
2850:
2851: IF nvl(p_sales_credit_id,FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
2852: l_entity := 1;
2853: OPEN l_header_scredit_csr_s;
2854: ELSIF nvl(p_header_id,FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
2855: l_entity := 2;

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

2850:
2851: IF nvl(p_sales_credit_id,FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
2852: l_entity := 1;
2853: OPEN l_header_scredit_csr_s;
2854: ELSIF nvl(p_header_id,FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
2855: l_entity := 2;
2856: OPEN l_header_scredit_csr_h;
2857: END IF;
2858:

Line 2923: p_sales_credit_id <> FND_API.G_MISS_NUM)

2919:
2920: IF
2921: (p_sales_credit_id IS NOT NULL
2922: AND
2923: p_sales_credit_id <> FND_API.G_MISS_NUM)
2924: AND
2925: (x_Header_Scredit_tbl.COUNT = 0)
2926: THEN
2927: RAISE NO_DATA_FOUND;

Line 2992: FND_API.G_MISS_NUM

2988:
2989: -- Line Query_Rows
2990: PROCEDURE Query_Rows
2991: ( p_line_id IN NUMBER :=
2992: FND_API.G_MISS_NUM
2993: , p_header_id IN NUMBER :=
2994: FND_API.G_MISS_NUM
2995: , p_line_set_id IN NUMBER :=
2996: FND_API.G_MISS_NUM

Line 2994: FND_API.G_MISS_NUM

2990: PROCEDURE Query_Rows
2991: ( p_line_id IN NUMBER :=
2992: FND_API.G_MISS_NUM
2993: , p_header_id IN NUMBER :=
2994: FND_API.G_MISS_NUM
2995: , p_line_set_id IN NUMBER :=
2996: FND_API.G_MISS_NUM
2997: , p_version_number IN NUMBER := NULL
2998: , p_phase_change_flag IN VARCHAR2 := NULL

Line 2996: FND_API.G_MISS_NUM

2992: FND_API.G_MISS_NUM
2993: , p_header_id IN NUMBER :=
2994: FND_API.G_MISS_NUM
2995: , p_line_set_id IN NUMBER :=
2996: FND_API.G_MISS_NUM
2997: , p_version_number IN NUMBER := NULL
2998: , p_phase_change_flag IN VARCHAR2 := NULL
2999: , x_line_tbl IN OUT NOCOPY OE_Order_PUB.Line_Tbl_Type
3000: )

Line 4068: p_line_id <> FND_API.G_MISS_NUM)

4064:
4065: IF
4066: (p_line_id IS NOT NULL
4067: AND
4068: p_line_id <> FND_API.G_MISS_NUM)
4069: AND
4070: (p_header_id IS NOT NULL
4071: AND
4072: p_header_id <> FND_API.G_MISS_NUM)

Line 4072: p_header_id <> FND_API.G_MISS_NUM)

4068: p_line_id <> FND_API.G_MISS_NUM)
4069: AND
4070: (p_header_id IS NOT NULL
4071: AND
4072: p_header_id <> FND_API.G_MISS_NUM)
4073: THEN
4074:
4075: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4076:

Line 4075: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4071: AND
4072: p_header_id <> FND_API.G_MISS_NUM)
4073: THEN
4074:
4075: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4076:
4077: END IF;
4078:
4079: -----------------------------------------------------------------

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

4080: -- Fix bug 1275972: Setup the l_entity variable based on the ID
4081: -- variable that is passed.
4082: -----------------------------------------------------------------
4083:
4084: IF nvl(p_line_id,FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
4085: l_entity := 1;
4086: OPEN l_line_csr_l;
4087: ELSIF nvl(p_header_id,FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
4088: l_entity := 2;

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

4083:
4084: IF nvl(p_line_id,FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
4085: l_entity := 1;
4086: OPEN l_line_csr_l;
4087: ELSIF nvl(p_header_id,FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
4088: l_entity := 2;
4089: OPEN l_line_csr_h;
4090: ELSIF nvl(p_line_set_id,FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
4091: l_entity := 3;

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

4086: OPEN l_line_csr_l;
4087: ELSIF nvl(p_header_id,FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
4088: l_entity := 2;
4089: OPEN l_line_csr_h;
4090: ELSIF nvl(p_line_set_id,FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
4091: l_entity := 3;
4092: OPEN l_line_csr_s;
4093: END IF;
4094:

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

4476: --l_SVN := l_rec.SVN;
4477:
4478:
4479: -- set values for non-DB fields
4480: x_line_tbl(l_count).db_flag := FND_API.G_TRUE;
4481: x_line_tbl(l_count).operation := FND_API.G_MISS_CHAR;
4482: x_line_tbl(l_count).return_status := FND_API.G_MISS_CHAR;
4483:
4484: x_line_tbl(l_count).schedule_action_code := FND_API.G_MISS_CHAR;

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

4477:
4478:
4479: -- set values for non-DB fields
4480: x_line_tbl(l_count).db_flag := FND_API.G_TRUE;
4481: x_line_tbl(l_count).operation := FND_API.G_MISS_CHAR;
4482: x_line_tbl(l_count).return_status := FND_API.G_MISS_CHAR;
4483:
4484: x_line_tbl(l_count).schedule_action_code := FND_API.G_MISS_CHAR;
4485: x_line_tbl(l_count).reserved_quantity := FND_API.G_MISS_NUM;

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

4478:
4479: -- set values for non-DB fields
4480: x_line_tbl(l_count).db_flag := FND_API.G_TRUE;
4481: x_line_tbl(l_count).operation := FND_API.G_MISS_CHAR;
4482: x_line_tbl(l_count).return_status := FND_API.G_MISS_CHAR;
4483:
4484: x_line_tbl(l_count).schedule_action_code := FND_API.G_MISS_CHAR;
4485: x_line_tbl(l_count).reserved_quantity := FND_API.G_MISS_NUM;
4486: x_line_tbl(l_count).change_reason := FND_API.G_MISS_CHAR;

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

4480: x_line_tbl(l_count).db_flag := FND_API.G_TRUE;
4481: x_line_tbl(l_count).operation := FND_API.G_MISS_CHAR;
4482: x_line_tbl(l_count).return_status := FND_API.G_MISS_CHAR;
4483:
4484: x_line_tbl(l_count).schedule_action_code := FND_API.G_MISS_CHAR;
4485: x_line_tbl(l_count).reserved_quantity := FND_API.G_MISS_NUM;
4486: x_line_tbl(l_count).change_reason := FND_API.G_MISS_CHAR;
4487: x_line_tbl(l_count).change_comments := FND_API.G_MISS_CHAR;
4488: x_line_tbl(l_count).arrival_set := FND_API.G_MISS_CHAR;

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

4481: x_line_tbl(l_count).operation := FND_API.G_MISS_CHAR;
4482: x_line_tbl(l_count).return_status := FND_API.G_MISS_CHAR;
4483:
4484: x_line_tbl(l_count).schedule_action_code := FND_API.G_MISS_CHAR;
4485: x_line_tbl(l_count).reserved_quantity := FND_API.G_MISS_NUM;
4486: x_line_tbl(l_count).change_reason := FND_API.G_MISS_CHAR;
4487: x_line_tbl(l_count).change_comments := FND_API.G_MISS_CHAR;
4488: x_line_tbl(l_count).arrival_set := FND_API.G_MISS_CHAR;
4489: x_line_tbl(l_count).ship_set := FND_API.G_MISS_CHAR;

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

4482: x_line_tbl(l_count).return_status := FND_API.G_MISS_CHAR;
4483:
4484: x_line_tbl(l_count).schedule_action_code := FND_API.G_MISS_CHAR;
4485: x_line_tbl(l_count).reserved_quantity := FND_API.G_MISS_NUM;
4486: x_line_tbl(l_count).change_reason := FND_API.G_MISS_CHAR;
4487: x_line_tbl(l_count).change_comments := FND_API.G_MISS_CHAR;
4488: x_line_tbl(l_count).arrival_set := FND_API.G_MISS_CHAR;
4489: x_line_tbl(l_count).ship_set := FND_API.G_MISS_CHAR;
4490: x_line_tbl(l_count).fulfillment_set := FND_API.G_MISS_CHAR;

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

4483:
4484: x_line_tbl(l_count).schedule_action_code := FND_API.G_MISS_CHAR;
4485: x_line_tbl(l_count).reserved_quantity := FND_API.G_MISS_NUM;
4486: x_line_tbl(l_count).change_reason := FND_API.G_MISS_CHAR;
4487: x_line_tbl(l_count).change_comments := FND_API.G_MISS_CHAR;
4488: x_line_tbl(l_count).arrival_set := FND_API.G_MISS_CHAR;
4489: x_line_tbl(l_count).ship_set := FND_API.G_MISS_CHAR;
4490: x_line_tbl(l_count).fulfillment_set := FND_API.G_MISS_CHAR;
4491: x_line_tbl(l_count).split_action_code := FND_API.G_MISS_CHAR;

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

4484: x_line_tbl(l_count).schedule_action_code := FND_API.G_MISS_CHAR;
4485: x_line_tbl(l_count).reserved_quantity := FND_API.G_MISS_NUM;
4486: x_line_tbl(l_count).change_reason := FND_API.G_MISS_CHAR;
4487: x_line_tbl(l_count).change_comments := FND_API.G_MISS_CHAR;
4488: x_line_tbl(l_count).arrival_set := FND_API.G_MISS_CHAR;
4489: x_line_tbl(l_count).ship_set := FND_API.G_MISS_CHAR;
4490: x_line_tbl(l_count).fulfillment_set := FND_API.G_MISS_CHAR;
4491: x_line_tbl(l_count).split_action_code := FND_API.G_MISS_CHAR;
4492: l_count := l_count + 1;

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

4485: x_line_tbl(l_count).reserved_quantity := FND_API.G_MISS_NUM;
4486: x_line_tbl(l_count).change_reason := FND_API.G_MISS_CHAR;
4487: x_line_tbl(l_count).change_comments := FND_API.G_MISS_CHAR;
4488: x_line_tbl(l_count).arrival_set := FND_API.G_MISS_CHAR;
4489: x_line_tbl(l_count).ship_set := FND_API.G_MISS_CHAR;
4490: x_line_tbl(l_count).fulfillment_set := FND_API.G_MISS_CHAR;
4491: x_line_tbl(l_count).split_action_code := FND_API.G_MISS_CHAR;
4492: l_count := l_count + 1;
4493:

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

4486: x_line_tbl(l_count).change_reason := FND_API.G_MISS_CHAR;
4487: x_line_tbl(l_count).change_comments := FND_API.G_MISS_CHAR;
4488: x_line_tbl(l_count).arrival_set := FND_API.G_MISS_CHAR;
4489: x_line_tbl(l_count).ship_set := FND_API.G_MISS_CHAR;
4490: x_line_tbl(l_count).fulfillment_set := FND_API.G_MISS_CHAR;
4491: x_line_tbl(l_count).split_action_code := FND_API.G_MISS_CHAR;
4492: l_count := l_count + 1;
4493:
4494: END LOOP;

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

4487: x_line_tbl(l_count).change_comments := FND_API.G_MISS_CHAR;
4488: x_line_tbl(l_count).arrival_set := FND_API.G_MISS_CHAR;
4489: x_line_tbl(l_count).ship_set := FND_API.G_MISS_CHAR;
4490: x_line_tbl(l_count).fulfillment_set := FND_API.G_MISS_CHAR;
4491: x_line_tbl(l_count).split_action_code := FND_API.G_MISS_CHAR;
4492: l_count := l_count + 1;
4493:
4494: END LOOP;
4495:

Line 4509: p_line_id <> FND_API.G_MISS_NUM)

4505:
4506: IF
4507: (p_line_id IS NOT NULL
4508: AND
4509: p_line_id <> FND_API.G_MISS_NUM)
4510: AND
4511: (x_line_tbl.COUNT = 0)
4512: THEN
4513: RAISE NO_DATA_FOUND;

Line 4577: FND_API.G_MISS_NUM

4573:
4574: -- Line Adj Query_Rows
4575: PROCEDURE Query_Rows
4576: ( p_price_adjustment_id IN NUMBER :=
4577: FND_API.G_MISS_NUM
4578: , p_line_id IN NUMBER :=
4579: FND_API.G_MISS_NUM
4580: , p_Header_id IN NUMBER :=
4581: FND_API.G_MISS_NUM

Line 4579: FND_API.G_MISS_NUM

4575: PROCEDURE Query_Rows
4576: ( p_price_adjustment_id IN NUMBER :=
4577: FND_API.G_MISS_NUM
4578: , p_line_id IN NUMBER :=
4579: FND_API.G_MISS_NUM
4580: , p_Header_id IN NUMBER :=
4581: FND_API.G_MISS_NUM
4582: , p_version_number IN NUMBER := NULL
4583: , p_phase_change_flag IN VARCHAR2 := NULL

Line 4581: FND_API.G_MISS_NUM

4577: FND_API.G_MISS_NUM
4578: , p_line_id IN NUMBER :=
4579: FND_API.G_MISS_NUM
4580: , p_Header_id IN NUMBER :=
4581: FND_API.G_MISS_NUM
4582: , p_version_number IN NUMBER := NULL
4583: , p_phase_change_flag IN VARCHAR2 := NULL
4584: , x_Line_Adj_Tbl IN OUT NOCOPY OE_Order_PUB.Line_Adj_Tbl_Type
4585: )

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

4943: --bug3392650 (passing the parameter p_header_id instead of p_line_level_header_id)
4944: 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);
4945: ELSE
4946:
4947: IF nvl(p_price_adjustment_id,FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
4948: l_entity := 1;
4949: OPEN l_line_adj_csr_p;
4950: ELSIF nvl(p_line_id,FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
4951: l_entity := 2;

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

4946:
4947: IF nvl(p_price_adjustment_id,FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
4948: l_entity := 1;
4949: OPEN l_line_adj_csr_p;
4950: ELSIF nvl(p_line_id,FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
4951: l_entity := 2;
4952: OPEN l_line_adj_csr_l;
4953: ELSIF nvl(p_header_id,FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
4954: l_entity := 3;

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

4949: OPEN l_line_adj_csr_p;
4950: ELSIF nvl(p_line_id,FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
4951: l_entity := 2;
4952: OPEN l_line_adj_csr_l;
4953: ELSIF nvl(p_header_id,FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
4954: l_entity := 3;
4955: OPEN l_line_adj_csr_h;
4956: END IF;
4957:

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

5076: --uom end
5077: x_Line_Adj_tbl(l_count).lock_control := l_rec.LOCK_CONTROL;
5078:
5079: -- set values for non-DB fields
5080: x_Line_Adj_tbl(l_count).db_flag := FND_API.G_TRUE;
5081: x_Line_Adj_tbl(l_count).operation := FND_API.G_MISS_CHAR;
5082: x_Line_Adj_tbl(l_count).return_status := FND_API.G_MISS_CHAR;
5083: -- eBTax changes
5084: x_Line_Adj_tbl(l_count).tax_rate_id := l_rec.tax_rate_id;

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

5077: x_Line_Adj_tbl(l_count).lock_control := l_rec.LOCK_CONTROL;
5078:
5079: -- set values for non-DB fields
5080: x_Line_Adj_tbl(l_count).db_flag := FND_API.G_TRUE;
5081: x_Line_Adj_tbl(l_count).operation := FND_API.G_MISS_CHAR;
5082: x_Line_Adj_tbl(l_count).return_status := FND_API.G_MISS_CHAR;
5083: -- eBTax changes
5084: x_Line_Adj_tbl(l_count).tax_rate_id := l_rec.tax_rate_id;
5085:

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

5078:
5079: -- set values for non-DB fields
5080: x_Line_Adj_tbl(l_count).db_flag := FND_API.G_TRUE;
5081: x_Line_Adj_tbl(l_count).operation := FND_API.G_MISS_CHAR;
5082: x_Line_Adj_tbl(l_count).return_status := FND_API.G_MISS_CHAR;
5083: -- eBTax changes
5084: x_Line_Adj_tbl(l_count).tax_rate_id := l_rec.tax_rate_id;
5085:
5086: l_count := l_count + 1;

Line 5103: p_price_adjustment_id <> FND_API.G_MISS_NUM)

5099:
5100: IF
5101: (p_price_adjustment_id IS NOT NULL
5102: AND
5103: p_price_adjustment_id <> FND_API.G_MISS_NUM)
5104: AND
5105: (x_Line_Adj_tbl.COUNT = 0)
5106: THEN
5107: RAISE NO_DATA_FOUND;

Line 5181: FND_API.G_MISS_NUM

5177:
5178: -- Line Scredit Query_Rows
5179: PROCEDURE Query_Rows
5180: ( p_sales_credit_id IN NUMBER :=
5181: FND_API.G_MISS_NUM
5182: , p_line_id IN NUMBER :=
5183: FND_API.G_MISS_NUM
5184: , p_header_id IN NUMBER :=
5185: FND_API.G_MISS_NUM

Line 5183: FND_API.G_MISS_NUM

5179: PROCEDURE Query_Rows
5180: ( p_sales_credit_id IN NUMBER :=
5181: FND_API.G_MISS_NUM
5182: , p_line_id IN NUMBER :=
5183: FND_API.G_MISS_NUM
5184: , p_header_id IN NUMBER :=
5185: FND_API.G_MISS_NUM
5186: , p_version_number IN NUMBER := NULL
5187: , p_phase_change_flag IN VARCHAR2 := NULL

Line 5185: FND_API.G_MISS_NUM

5181: FND_API.G_MISS_NUM
5182: , p_line_id IN NUMBER :=
5183: FND_API.G_MISS_NUM
5184: , p_header_id IN NUMBER :=
5185: FND_API.G_MISS_NUM
5186: , p_version_number IN NUMBER := NULL
5187: , p_phase_change_flag IN VARCHAR2 := NULL
5188: , x_Line_Scredit_tbl IN OUT NOCOPY OE_Order_PUB.Line_Scredit_Tbl_Type
5189: )

Line 5332: p_sales_credit_id <> FND_API.G_MISS_NUM)

5328:
5329: IF
5330: (p_sales_credit_id IS NOT NULL
5331: AND
5332: p_sales_credit_id <> FND_API.G_MISS_NUM)
5333: AND
5334: (p_line_id IS NOT NULL
5335: AND
5336: p_line_id <> FND_API.G_MISS_NUM)

Line 5336: p_line_id <> FND_API.G_MISS_NUM)

5332: p_sales_credit_id <> FND_API.G_MISS_NUM)
5333: AND
5334: (p_line_id IS NOT NULL
5335: AND
5336: p_line_id <> FND_API.G_MISS_NUM)
5337: THEN
5338:
5339: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5340:

Line 5339: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5335: AND
5336: p_line_id <> FND_API.G_MISS_NUM)
5337: THEN
5338:
5339: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5340:
5341: END IF;
5342:
5343:

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

5340:
5341: END IF;
5342:
5343:
5344: IF nvl(p_sales_credit_id,FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
5345: l_entity := 1;
5346: OPEN l_line_scredit_csr_s;
5347: ELSIF nvl(p_line_id,FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
5348: l_entity := 2;

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

5343:
5344: IF nvl(p_sales_credit_id,FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
5345: l_entity := 1;
5346: OPEN l_line_scredit_csr_s;
5347: ELSIF nvl(p_line_id,FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
5348: l_entity := 2;
5349: OPEN l_line_scredit_csr_l;
5350: ELSIF nvl(p_header_id,FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
5351: l_entity := 3;

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

5346: OPEN l_line_scredit_csr_s;
5347: ELSIF nvl(p_line_id,FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
5348: l_entity := 2;
5349: OPEN l_line_scredit_csr_l;
5350: ELSIF nvl(p_header_id,FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
5351: l_entity := 3;
5352: OPEN l_line_scredit_csr_h;
5353: END IF;
5354:

Line 5420: p_sales_credit_id <> FND_API.G_MISS_NUM)

5416:
5417: IF
5418: (p_sales_credit_id IS NOT NULL
5419: AND
5420: p_sales_credit_id <> FND_API.G_MISS_NUM)
5421: AND
5422: (x_Line_Scredit_tbl.COUNT = 0)
5423: THEN
5424: RAISE NO_DATA_FOUND;