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.OZF_OFFER_ADJ_PVT dependencies on OZF_OFFER_PVT

Line 1169: /*OZF_OFFER_PVT.process_qp_list_lines

1165: x_listLineId := x_modifier_line_tbl(i).list_line_id;
1166: END IF;
1167: END LOOP;
1168: END IF;
1169: /*OZF_OFFER_PVT.process_qp_list_lines
1170: (
1171: x_return_status OUT NOCOPY VARCHAR2
1172: ,x_msg_count OUT NOCOPY NUMBER
1173: ,x_msg_data OUT NOCOPY VARCHAR2

Line 1766: px_modifier_line_rec IN OUT NOCOPY ozf_offer_pvt.MODIFIER_LINE_REC_TYPE

1762:
1763:
1764: PROCEDURE populateTdPricingAttr
1765: (
1766: px_modifier_line_rec IN OUT NOCOPY ozf_offer_pvt.MODIFIER_LINE_REC_TYPE
1767: , p_listLineId IN NUMBER
1768: ,x_return_status OUT NOCOPY VARCHAR2
1769: ,x_msg_count OUT NOCOPY NUMBER
1770: ,x_msg_data OUT NOCOPY VARCHAR2

Line 1790: x_modifier_line_rec OUT NOCOPY ozf_offer_pvt.MODIFIER_LINE_REC_TYPE

1786: END populateTdPricingAttr;
1787:
1788: PROCEDURE populateTdCrtLines
1789: (
1790: x_modifier_line_rec OUT NOCOPY ozf_offer_pvt.MODIFIER_LINE_REC_TYPE
1791: , p_listLineId IN NUMBER
1792: , x_return_status OUT NOCOPY VARCHAR2
1793: , x_msg_count OUT NOCOPY NUMBER
1794: , x_msg_data OUT NOCOPY VARCHAR2

Line 1812: l_modifier_line_rec ozf_offer_pvt.MODIFIER_LINE_REC_TYPE;

1808: a.list_line_id = b.MODIFIER_ID
1809: AND b.RELATED_MODIFIER_ID = c.list_line_id(+)
1810: AND a.list_line_id =cp_listLineId;
1811:
1812: l_modifier_line_rec ozf_offer_pvt.MODIFIER_LINE_REC_TYPE;
1813: BEGIN
1814: x_return_status := FND_API.G_RET_STS_SUCCESS;
1815: FOR l_tdAdjustmentLines IN c_tdAdjustmentLines(cp_listLineId => p_listLineId )
1816: LOOP

Line 1842: px_modifier_line_rec IN OUT NOCOPY ozf_offer_pvt.MODIFIER_LINE_REC_TYPE

1838: END populateTdCrtLines;
1839:
1840: PROCEDURE processTdCrtLines
1841: (
1842: px_modifier_line_rec IN OUT NOCOPY ozf_offer_pvt.MODIFIER_LINE_REC_TYPE
1843: , p_offerAdjustmentId IN NUMBER
1844: , p_listLineId IN NUMBER
1845: , x_return_status OUT NOCOPY VARCHAR2
1846: , x_msg_count OUT NOCOPY NUMBER

Line 1869: x_modifier_line_rec OUT NOCOPY ozf_offer_pvt.MODIFIER_LINE_REC_TYPE

1865: END processTdCrtLines;
1866:
1867: PROCEDURE populateTdUpdLines
1868: (
1869: x_modifier_line_rec OUT NOCOPY ozf_offer_pvt.MODIFIER_LINE_REC_TYPE
1870: , p_listLineId IN NUMBER
1871: ,x_return_status OUT NOCOPY VARCHAR2
1872: ,x_msg_count OUT NOCOPY NUMBER
1873: ,x_msg_data OUT NOCOPY VARCHAR2

Line 1901: l_modifier_line_rec ozf_offer_pvt.MODIFIER_LINE_REC_TYPE;

1897: AND b.related_modifier_id = c.list_line_id(+)
1898: AND a.list_header_id = d.list_header_id
1899: AND a.list_line_id = cp_listLineId;
1900:
1901: l_modifier_line_rec ozf_offer_pvt.MODIFIER_LINE_REC_TYPE;
1902: BEGIN
1903: x_return_status := FND_API.G_RET_STS_SUCCESS;
1904: FOR l_tdUpdAdjustmentLines IN c_tdUpdAdjustmentLines(cp_listLineId => p_listLineId)
1905: LOOP

Line 1924: px_modifier_line_rec IN OUT NOCOPY ozf_offer_pvt.MODIFIER_LINE_REC_TYPE

1920: END populateTdUpdLines;
1921:
1922: PROCEDURE processTdUpdLines
1923: (
1924: px_modifier_line_rec IN OUT NOCOPY ozf_offer_pvt.MODIFIER_LINE_REC_TYPE
1925: , p_offerAdjustmentId IN NUMBER
1926: , p_listLineId IN NUMBER
1927: ,x_return_status OUT NOCOPY VARCHAR2
1928: ,x_msg_count OUT NOCOPY NUMBER

Line 1949: l_modifier_line_tbl ozf_offer_pvt.MODIFIER_LINE_Tbl_TYPE;

1945: , x_modifier_tbl OUT NOCOPY QP_MODIFIERS_PUB.modifiers_tbl_type
1946: )
1947:
1948: IS
1949: l_modifier_line_tbl ozf_offer_pvt.MODIFIER_LINE_Tbl_TYPE;
1950: lx_modifier_tbl QP_MODIFIERS_PUB.modifiers_tbl_type;
1951: l_errorLocation NUMBER;
1952: BEGIN
1953: -- initialize

Line 1992: ozf_offer_pvt.process_qp_list_lines

1988: RAISE FND_API.G_EXC_ERROR;
1989: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1990: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1991: END IF;
1992: ozf_offer_pvt.process_qp_list_lines
1993: (
1994: x_return_status => x_return_status
1995: ,x_msg_count => x_msg_count
1996: ,x_msg_data => x_msg_data

Line 2028: ,x_pricing_attr_tbl OUT NOCOPY OZF_OFFER_PVT.PRICING_ATTR_TBL_TYPE

2024: x_return_status OUT NOCOPY VARCHAR2
2025: ,x_msg_count OUT NOCOPY NUMBER
2026: ,x_msg_data OUT NOCOPY VARCHAR2
2027: , p_fromListLineId IN NUMBER
2028: ,x_pricing_attr_tbl OUT NOCOPY OZF_OFFER_PVT.PRICING_ATTR_TBL_TYPE
2029: )
2030: IS
2031: i NUMBER;
2032: CURSOR c_productAttributes(cp_listLineId NUMBER)

Line 2062: ,px_pricing_attr_tbl IN OUT NOCOPY OZF_OFFER_PVT.PRICING_ATTR_TBL_TYPE

2058: x_return_status OUT NOCOPY VARCHAR2
2059: ,x_msg_count OUT NOCOPY NUMBER
2060: ,x_msg_data OUT NOCOPY VARCHAR2
2061: ,p_toListLineId IN NUMBER
2062: ,px_pricing_attr_tbl IN OUT NOCOPY OZF_OFFER_PVT.PRICING_ATTR_TBL_TYPE
2063: )
2064: IS
2065: BEGIN
2066: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 2087: l_pricing_attr_tbl OZF_OFFER_PVT.PRICING_ATTR_TBL_TYPE;

2083: ,p_fromListLineId IN NUMBER
2084: ,p_toListLineId IN NUMBER
2085: )
2086: IS
2087: l_pricing_attr_tbl OZF_OFFER_PVT.PRICING_ATTR_TBL_TYPE;
2088: l_errorLocation NUMBER;
2089: BEGIN
2090: -- initialize
2091: -- populate records

Line 2122: OZF_OFFER_PVT.process_exclusions

2118: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2119: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2120: END IF;
2121: --dbms_output.put_line('Table cnt is :'||nvl(l_pricing_attr_tbl.count,0));
2122: OZF_OFFER_PVT.process_exclusions
2123: (
2124: p_init_msg_list => FND_API.G_FALSE
2125: ,p_api_version => 1.0
2126: ,p_commit => FND_API.G_FALSE

Line 2438: l_modifier_line_tbl ozf_offer_pvt.MODIFIER_LINE_Tbl_TYPE;

2434: ,p_offerAdjustmentId IN NUMBER
2435: , p_listLineId IN NUMBER
2436: )
2437: IS
2438: l_modifier_line_tbl ozf_offer_pvt.MODIFIER_LINE_Tbl_TYPE;
2439: lx_modifier_tbl QP_MODIFIERS_PUB.modifiers_tbl_type;
2440: l_errorLocation NUMBER;
2441: BEGIN
2442: -- initialize

Line 2480: ozf_offer_pvt.process_qp_list_lines

2476: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2477: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2478: END IF;
2479: ozf_utility_pvt.debug_message('before process_qp_list_lines :'||x_return_status);
2480: ozf_offer_pvt.process_qp_list_lines
2481: (
2482: x_return_status => x_return_status
2483: ,x_msg_count => x_msg_count
2484: ,x_msg_data => x_msg_data

Line 2701: , x_modifier_line_tbl OUT NOCOPY ozf_offer_pvt.MODIFIER_LINE_Tbl_TYPE

2697: x_return_status OUT NOCOPY VARCHAR2
2698: ,x_msg_count OUT NOCOPY NUMBER
2699: ,x_msg_data OUT NOCOPY VARCHAR2
2700: ,p_offerAdjNewLineId IN NUMBER
2701: , x_modifier_line_tbl OUT NOCOPY ozf_offer_pvt.MODIFIER_LINE_Tbl_TYPE
2702: )
2703: IS
2704: CURSOR c_newBuy(cp_offerAdjNewLineId NUMBER) IS
2705: SELECT

Line 2746: ,px_modifier_line_tbl IN OUT NOCOPY ozf_offer_pvt.MODIFIER_LINE_Tbl_TYPE

2742: x_return_status OUT NOCOPY VARCHAR2
2743: ,x_msg_count OUT NOCOPY NUMBER
2744: ,x_msg_data OUT NOCOPY VARCHAR2
2745: ,p_offerAdjNewLineId IN NUMBER
2746: ,px_modifier_line_tbl IN OUT NOCOPY ozf_offer_pvt.MODIFIER_LINE_Tbl_TYPE
2747: )
2748: IS
2749: BEGIN
2750: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 2776: l_modifier_line_tbl ozf_offer_pvt.MODIFIER_LINE_Tbl_TYPE;

2772: ,p_offerAdjNewLineId IN NUMBER
2773: , x_modifier_tbl OUT NOCOPY QP_MODIFIERS_PUB.modifiers_tbl_type
2774: )
2775: IS
2776: l_modifier_line_tbl ozf_offer_pvt.MODIFIER_LINE_Tbl_TYPE;
2777: lx_modifier_tbl QP_MODIFIERS_PUB.modifiers_tbl_type;
2778: l_errorLocation NUMBER;
2779: BEGIN
2780: -- initilize

Line 2815: OZF_OFFER_PVT.process_qp_list_lines

2811: RAISE FND_API.G_EXC_ERROR;
2812: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2813: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2814: END IF;
2815: OZF_OFFER_PVT.process_qp_list_lines
2816: (
2817: x_return_status => x_return_status
2818: ,x_msg_count => x_msg_count
2819: ,x_msg_data => x_msg_data

Line 2930: ,x_modifier_line_tbl OUT NOCOPY ozf_offer_pvt.MODIFIER_LINE_Tbl_TYPE

2926: x_return_status OUT NOCOPY VARCHAR2
2927: ,x_msg_count OUT NOCOPY NUMBER
2928: ,x_msg_data OUT NOCOPY VARCHAR2
2929: ,p_offerAdjNewLineId IN NUMBER
2930: ,x_modifier_line_tbl OUT NOCOPY ozf_offer_pvt.MODIFIER_LINE_Tbl_TYPE
2931: )
2932: IS
2933: CURSOR c_newGet(cp_offerAdjNewLineId NUMBER) IS
2934: SELECT

Line 2979: ,px_modifier_line_tbl IN OUT NOCOPY ozf_offer_pvt.MODIFIER_LINE_Tbl_TYPE

2975: x_return_status OUT NOCOPY VARCHAR2
2976: ,x_msg_count OUT NOCOPY NUMBER
2977: ,x_msg_data OUT NOCOPY VARCHAR2
2978: ,p_offerAdjNewLineId IN NUMBER
2979: ,px_modifier_line_tbl IN OUT NOCOPY ozf_offer_pvt.MODIFIER_LINE_Tbl_TYPE
2980: )
2981: IS
2982: BEGIN
2983: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 3005: l_modifier_line_tbl ozf_offer_pvt.MODIFIER_LINE_Tbl_TYPE;

3001: ,p_offerAdjNewLineId IN NUMBER
3002: ,x_modifier_tbl OUT NOCOPY QP_MODIFIERS_PUB.modifiers_tbl_type
3003: )
3004: IS
3005: l_modifier_line_tbl ozf_offer_pvt.MODIFIER_LINE_Tbl_TYPE;
3006: lx_modifier_tbl QP_MODIFIERS_PUB.modifiers_tbl_type;
3007: l_errorLocation NUMBER;
3008: BEGIN
3009: -- initialize

Line 3043: OZF_OFFER_PVT.process_qp_list_lines

3039: RAISE FND_API.G_EXC_ERROR;
3040: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3041: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3042: END IF;
3043: OZF_OFFER_PVT.process_qp_list_lines
3044: (
3045: x_return_status => x_return_status
3046: ,x_msg_count => x_msg_count
3047: ,x_msg_data => x_msg_data

Line 3198: ,x_modifier_line_tbl OUT NOCOPY ozf_offer_pvt.modifier_line_tbl_type

3194: x_return_status OUT NOCOPY VARCHAR2
3195: ,x_msg_count OUT NOCOPY NUMBER
3196: ,x_msg_data OUT NOCOPY VARCHAR2
3197: ,p_offerAdjNewLineId IN NUMBER
3198: ,x_modifier_line_tbl OUT NOCOPY ozf_offer_pvt.modifier_line_tbl_type
3199: )
3200: IS
3201: CURSOR c_offerAdjustmentLines(cp_offerAdjNewLineId NUMBER)
3202: IS

Line 3263: ,px_modifier_line_tbl IN OUT NOCOPY ozf_offer_pvt.modifier_line_tbl_type

3259: x_return_status OUT NOCOPY VARCHAR2
3260: ,x_msg_count OUT NOCOPY NUMBER
3261: ,x_msg_data OUT NOCOPY VARCHAR2
3262: ,p_offerAdjNewLineId IN NUMBER
3263: ,px_modifier_line_tbl IN OUT NOCOPY ozf_offer_pvt.modifier_line_tbl_type
3264: )
3265: IS
3266: BEGIN
3267: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 3286: l_modifier_line_tbl ozf_offer_pvt.modifier_line_tbl_type;

3282: ,x_msg_data OUT NOCOPY VARCHAR2
3283: ,p_offerAdjNewLineId IN NUMBER
3284: )
3285: IS
3286: l_modifier_line_tbl ozf_offer_pvt.modifier_line_tbl_type;
3287: l_modifiers_tbl qp_modifiers_pub.modifiers_tbl_type;
3288: l_errorLocation NUMBER;
3289: BEGIN
3290: -- initialize

Line 3323: OZF_OFFER_PVT.process_qp_list_lines

3319: RAISE FND_API.G_EXC_ERROR;
3320: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3321: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3322: END IF;
3323: OZF_OFFER_PVT.process_qp_list_lines
3324: (
3325: x_return_status => x_return_status
3326: ,x_msg_count => x_msg_count
3327: ,x_msg_data => x_msg_data

Line 4123: l_modifier_rec ozf_offer_pvt.Modifier_LIST_Rec_Type;

4119:
4120: l_offerType VARCHAR2(30);
4121: l_qpListHeaderId NUMBER;
4122: l_errorLocation NUMBER;
4123: l_modifier_rec ozf_offer_pvt.Modifier_LIST_Rec_Type;
4124: l_modifier_line_tbl ozf_offer_pvt.MODIFIER_LINE_TBL_TYPE;
4125: BEGIN
4126: x_return_status := FND_API.G_RET_STS_SUCCESS;
4127: FOR l_dates in c_dates(p_offerAdjustmentId) LOOP

Line 4124: l_modifier_line_tbl ozf_offer_pvt.MODIFIER_LINE_TBL_TYPE;

4120: l_offerType VARCHAR2(30);
4121: l_qpListHeaderId NUMBER;
4122: l_errorLocation NUMBER;
4123: l_modifier_rec ozf_offer_pvt.Modifier_LIST_Rec_Type;
4124: l_modifier_line_tbl ozf_offer_pvt.MODIFIER_LINE_TBL_TYPE;
4125: BEGIN
4126: x_return_status := FND_API.G_RET_STS_SUCCESS;
4127: FOR l_dates in c_dates(p_offerAdjustmentId) LOOP
4128:

Line 4140: OZF_OFFER_PVT.process_modifiers

4136: l_modifier_rec.OFFER_OPERATION := Qp_Globals.G_OPR_UPDATE;
4137: l_modifier_rec.MODIFIER_OPERATION := Qp_Globals.G_OPR_UPDATE;
4138: l_modifier_rec.object_version_number := l_dates.object_version_number;
4139: l_offerType := l_dates.offer_type;
4140: OZF_OFFER_PVT.process_modifiers
4141: (
4142: p_init_msg_list => FND_API.g_false
4143: ,p_api_version => 1.0
4144: ,p_commit => FND_API.g_false