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 1403: /*OZF_OFFER_PVT.process_qp_list_lines

1399: x_listLineId := x_modifier_line_tbl(i).list_line_id;
1400: END IF;
1401: END LOOP;
1402: END IF;
1403: /*OZF_OFFER_PVT.process_qp_list_lines
1404: (
1405: x_return_status OUT NOCOPY VARCHAR2
1406: ,x_msg_count OUT NOCOPY NUMBER
1407: ,x_msg_data OUT NOCOPY VARCHAR2

Line 2017: px_modifier_line_rec IN OUT NOCOPY ozf_offer_pvt.MODIFIER_LINE_REC_TYPE

2013:
2014:
2015: PROCEDURE populateTdPricingAttr
2016: (
2017: px_modifier_line_rec IN OUT NOCOPY ozf_offer_pvt.MODIFIER_LINE_REC_TYPE
2018: , p_listLineId IN NUMBER
2019: ,x_return_status OUT NOCOPY VARCHAR2
2020: ,x_msg_count OUT NOCOPY NUMBER
2021: ,x_msg_data OUT NOCOPY VARCHAR2

Line 2041: x_modifier_line_rec OUT NOCOPY ozf_offer_pvt.MODIFIER_LINE_REC_TYPE

2037: END populateTdPricingAttr;
2038:
2039: PROCEDURE populateTdCrtLines
2040: (
2041: x_modifier_line_rec OUT NOCOPY ozf_offer_pvt.MODIFIER_LINE_REC_TYPE
2042: , p_listLineId IN NUMBER
2043: , x_return_status OUT NOCOPY VARCHAR2
2044: , x_msg_count OUT NOCOPY NUMBER
2045: , x_msg_data OUT NOCOPY VARCHAR2

Line 2063: l_modifier_line_rec ozf_offer_pvt.MODIFIER_LINE_REC_TYPE;

2059: a.list_line_id = b.MODIFIER_ID
2060: AND b.RELATED_MODIFIER_ID = c.list_line_id(+)
2061: AND a.list_line_id =cp_listLineId;
2062:
2063: l_modifier_line_rec ozf_offer_pvt.MODIFIER_LINE_REC_TYPE;
2064: BEGIN
2065: x_return_status := FND_API.G_RET_STS_SUCCESS;
2066: FOR l_tdAdjustmentLines IN c_tdAdjustmentLines(cp_listLineId => p_listLineId )
2067: LOOP

Line 2093: px_modifier_line_rec IN OUT NOCOPY ozf_offer_pvt.MODIFIER_LINE_REC_TYPE

2089: END populateTdCrtLines;
2090:
2091: PROCEDURE processTdCrtLines
2092: (
2093: px_modifier_line_rec IN OUT NOCOPY ozf_offer_pvt.MODIFIER_LINE_REC_TYPE
2094: , p_offerAdjustmentId IN NUMBER
2095: , p_listLineId IN NUMBER
2096: , x_return_status OUT NOCOPY VARCHAR2
2097: , x_msg_count OUT NOCOPY NUMBER

Line 2153: x_modifier_line_rec OUT NOCOPY ozf_offer_pvt.MODIFIER_LINE_REC_TYPE

2149: END processTdCrtLines;
2150:
2151: PROCEDURE populateTdUpdLines
2152: (
2153: x_modifier_line_rec OUT NOCOPY ozf_offer_pvt.MODIFIER_LINE_REC_TYPE
2154: , p_listLineId IN NUMBER
2155: ,x_return_status OUT NOCOPY VARCHAR2
2156: ,x_msg_count OUT NOCOPY NUMBER
2157: ,x_msg_data OUT NOCOPY VARCHAR2

Line 2185: l_modifier_line_rec ozf_offer_pvt.MODIFIER_LINE_REC_TYPE;

2181: AND b.related_modifier_id = c.list_line_id(+)
2182: AND a.list_header_id = d.list_header_id
2183: AND a.list_line_id = cp_listLineId;
2184:
2185: l_modifier_line_rec ozf_offer_pvt.MODIFIER_LINE_REC_TYPE;
2186: BEGIN
2187: x_return_status := FND_API.G_RET_STS_SUCCESS;
2188: FOR l_tdUpdAdjustmentLines IN c_tdUpdAdjustmentLines(cp_listLineId => p_listLineId)
2189: LOOP

Line 2208: px_modifier_line_rec IN OUT NOCOPY ozf_offer_pvt.MODIFIER_LINE_REC_TYPE

2204: END populateTdUpdLines;
2205:
2206: PROCEDURE processTdUpdLines
2207: (
2208: px_modifier_line_rec IN OUT NOCOPY ozf_offer_pvt.MODIFIER_LINE_REC_TYPE
2209: , p_offerAdjustmentId IN NUMBER
2210: , p_listLineId IN NUMBER
2211: ,x_return_status OUT NOCOPY VARCHAR2
2212: ,x_msg_count OUT NOCOPY NUMBER

Line 2233: l_modifier_line_tbl ozf_offer_pvt.MODIFIER_LINE_Tbl_TYPE;

2229: , x_modifier_tbl OUT NOCOPY QP_MODIFIERS_PUB.modifiers_tbl_type
2230: )
2231:
2232: IS
2233: l_modifier_line_tbl ozf_offer_pvt.MODIFIER_LINE_Tbl_TYPE;
2234: lx_modifier_tbl QP_MODIFIERS_PUB.modifiers_tbl_type;
2235: l_errorLocation NUMBER;
2236: BEGIN
2237: -- initialize

Line 2276: ozf_offer_pvt.process_qp_list_lines

2272: RAISE FND_API.G_EXC_ERROR;
2273: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2274: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2275: END IF;
2276: ozf_offer_pvt.process_qp_list_lines
2277: (
2278: x_return_status => x_return_status
2279: ,x_msg_count => x_msg_count
2280: ,x_msg_data => x_msg_data

Line 2312: ,x_pricing_attr_tbl OUT NOCOPY OZF_OFFER_PVT.PRICING_ATTR_TBL_TYPE

2308: x_return_status OUT NOCOPY VARCHAR2
2309: ,x_msg_count OUT NOCOPY NUMBER
2310: ,x_msg_data OUT NOCOPY VARCHAR2
2311: , p_fromListLineId IN NUMBER
2312: ,x_pricing_attr_tbl OUT NOCOPY OZF_OFFER_PVT.PRICING_ATTR_TBL_TYPE
2313: )
2314: IS
2315: i NUMBER;
2316: CURSOR c_productAttributes(cp_listLineId NUMBER)

Line 2346: ,px_pricing_attr_tbl IN OUT NOCOPY OZF_OFFER_PVT.PRICING_ATTR_TBL_TYPE

2342: x_return_status OUT NOCOPY VARCHAR2
2343: ,x_msg_count OUT NOCOPY NUMBER
2344: ,x_msg_data OUT NOCOPY VARCHAR2
2345: ,p_toListLineId IN NUMBER
2346: ,px_pricing_attr_tbl IN OUT NOCOPY OZF_OFFER_PVT.PRICING_ATTR_TBL_TYPE
2347: )
2348: IS
2349: BEGIN
2350: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 2371: l_pricing_attr_tbl OZF_OFFER_PVT.PRICING_ATTR_TBL_TYPE;

2367: ,p_fromListLineId IN NUMBER
2368: ,p_toListLineId IN NUMBER
2369: )
2370: IS
2371: l_pricing_attr_tbl OZF_OFFER_PVT.PRICING_ATTR_TBL_TYPE;
2372: l_errorLocation NUMBER;
2373: BEGIN
2374: -- initialize
2375: -- populate records

Line 2406: OZF_OFFER_PVT.process_exclusions

2402: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2403: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2404: END IF;
2405: --dbms_output.put_line('Table cnt is :'||nvl(l_pricing_attr_tbl.count,0));
2406: OZF_OFFER_PVT.process_exclusions
2407: (
2408: p_init_msg_list => FND_API.G_FALSE
2409: ,p_api_version => 1.0
2410: ,p_commit => FND_API.G_FALSE

Line 2722: l_modifier_line_tbl ozf_offer_pvt.MODIFIER_LINE_Tbl_TYPE;

2718: ,p_offerAdjustmentId IN NUMBER
2719: , p_listLineId IN NUMBER
2720: )
2721: IS
2722: l_modifier_line_tbl ozf_offer_pvt.MODIFIER_LINE_Tbl_TYPE;
2723: lx_modifier_tbl QP_MODIFIERS_PUB.modifiers_tbl_type;
2724: l_errorLocation NUMBER;
2725: BEGIN
2726: -- initialize

Line 2764: ozf_offer_pvt.process_qp_list_lines

2760: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2761: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2762: END IF;
2763: ozf_utility_pvt.debug_message('before process_qp_list_lines :'||x_return_status);
2764: ozf_offer_pvt.process_qp_list_lines
2765: (
2766: x_return_status => x_return_status
2767: ,x_msg_count => x_msg_count
2768: ,x_msg_data => x_msg_data

Line 2985: , x_modifier_line_tbl OUT NOCOPY ozf_offer_pvt.MODIFIER_LINE_Tbl_TYPE

2981: x_return_status OUT NOCOPY VARCHAR2
2982: ,x_msg_count OUT NOCOPY NUMBER
2983: ,x_msg_data OUT NOCOPY VARCHAR2
2984: ,p_offerAdjNewLineId IN NUMBER
2985: , x_modifier_line_tbl OUT NOCOPY ozf_offer_pvt.MODIFIER_LINE_Tbl_TYPE
2986: )
2987: IS
2988: CURSOR c_newBuy(cp_offerAdjNewLineId NUMBER) IS
2989: SELECT

Line 3030: ,px_modifier_line_tbl IN OUT NOCOPY ozf_offer_pvt.MODIFIER_LINE_Tbl_TYPE

3026: x_return_status OUT NOCOPY VARCHAR2
3027: ,x_msg_count OUT NOCOPY NUMBER
3028: ,x_msg_data OUT NOCOPY VARCHAR2
3029: ,p_offerAdjNewLineId IN NUMBER
3030: ,px_modifier_line_tbl IN OUT NOCOPY ozf_offer_pvt.MODIFIER_LINE_Tbl_TYPE
3031: )
3032: IS
3033: BEGIN
3034: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 3060: l_modifier_line_tbl ozf_offer_pvt.MODIFIER_LINE_Tbl_TYPE;

3056: ,p_offerAdjNewLineId IN NUMBER
3057: , x_modifier_tbl OUT NOCOPY QP_MODIFIERS_PUB.modifiers_tbl_type
3058: )
3059: IS
3060: l_modifier_line_tbl ozf_offer_pvt.MODIFIER_LINE_Tbl_TYPE;
3061: lx_modifier_tbl QP_MODIFIERS_PUB.modifiers_tbl_type;
3062: l_errorLocation NUMBER;
3063: BEGIN
3064: -- initilize

Line 3099: OZF_OFFER_PVT.process_qp_list_lines

3095: RAISE FND_API.G_EXC_ERROR;
3096: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3097: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3098: END IF;
3099: OZF_OFFER_PVT.process_qp_list_lines
3100: (
3101: x_return_status => x_return_status
3102: ,x_msg_count => x_msg_count
3103: ,x_msg_data => x_msg_data

Line 3214: ,x_modifier_line_tbl OUT NOCOPY ozf_offer_pvt.MODIFIER_LINE_Tbl_TYPE

3210: x_return_status OUT NOCOPY VARCHAR2
3211: ,x_msg_count OUT NOCOPY NUMBER
3212: ,x_msg_data OUT NOCOPY VARCHAR2
3213: ,p_offerAdjNewLineId IN NUMBER
3214: ,x_modifier_line_tbl OUT NOCOPY ozf_offer_pvt.MODIFIER_LINE_Tbl_TYPE
3215: )
3216: IS
3217: CURSOR c_newGet(cp_offerAdjNewLineId NUMBER) IS
3218: SELECT

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 3289: l_modifier_line_tbl ozf_offer_pvt.MODIFIER_LINE_Tbl_TYPE;

3285: ,p_offerAdjNewLineId IN NUMBER
3286: ,x_modifier_tbl OUT NOCOPY QP_MODIFIERS_PUB.modifiers_tbl_type
3287: )
3288: IS
3289: l_modifier_line_tbl ozf_offer_pvt.MODIFIER_LINE_Tbl_TYPE;
3290: lx_modifier_tbl QP_MODIFIERS_PUB.modifiers_tbl_type;
3291: l_errorLocation NUMBER;
3292: BEGIN
3293: -- initialize

Line 3327: OZF_OFFER_PVT.process_qp_list_lines

3323: RAISE FND_API.G_EXC_ERROR;
3324: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3325: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3326: END IF;
3327: OZF_OFFER_PVT.process_qp_list_lines
3328: (
3329: x_return_status => x_return_status
3330: ,x_msg_count => x_msg_count
3331: ,x_msg_data => x_msg_data

Line 3482: ,x_modifier_line_tbl OUT NOCOPY ozf_offer_pvt.modifier_line_tbl_type

3478: x_return_status OUT NOCOPY VARCHAR2
3479: ,x_msg_count OUT NOCOPY NUMBER
3480: ,x_msg_data OUT NOCOPY VARCHAR2
3481: ,p_offerAdjNewLineId IN NUMBER
3482: ,x_modifier_line_tbl OUT NOCOPY ozf_offer_pvt.modifier_line_tbl_type
3483: )
3484: IS
3485: CURSOR c_offerAdjustmentLines(cp_offerAdjNewLineId NUMBER)
3486: IS

Line 3547: ,px_modifier_line_tbl IN OUT NOCOPY ozf_offer_pvt.modifier_line_tbl_type

3543: x_return_status OUT NOCOPY VARCHAR2
3544: ,x_msg_count OUT NOCOPY NUMBER
3545: ,x_msg_data OUT NOCOPY VARCHAR2
3546: ,p_offerAdjNewLineId IN NUMBER
3547: ,px_modifier_line_tbl IN OUT NOCOPY ozf_offer_pvt.modifier_line_tbl_type
3548: )
3549: IS
3550: l_endDate DATE;
3551:

Line 3607: PROCEDURE populate_new_sdr_line_rec(px_modifier_line_tbl IN OUT NOCOPY ozf_offer_pvt.modifier_line_tbl_type,

3603: p_SDR_hdr_pub_rec.request_end_date := l_end_date_active;
3604:
3605: END populate_sdr_hdr_rec;
3606:
3607: PROCEDURE populate_new_sdr_line_rec(px_modifier_line_tbl IN OUT NOCOPY ozf_offer_pvt.modifier_line_tbl_type,
3608: px_SDR_lines_tbl IN OUT NOCOPY OZF_SD_REQUEST_PUB.SDR_lines_tbl_type,
3609: p_SDR_hdr_pub_rec IN OZF_SD_REQUEST_PUB.SDR_Hdr_rec_type)
3610: IS
3611: CURSOR c_reqest_lines_seq IS

Line 3765: l_modifier_line_tbl ozf_offer_pvt.modifier_line_tbl_type;

3761: ,x_msg_data OUT NOCOPY VARCHAR2
3762: ,p_offerAdjNewLineId IN NUMBER
3763: )
3764: IS
3765: l_modifier_line_tbl ozf_offer_pvt.modifier_line_tbl_type;
3766: l_modifiers_tbl qp_modifiers_pub.modifiers_tbl_type;
3767: l_errorLocation NUMBER;
3768: l_custom_setup_id NUMBER;
3769: l_SDR_hdr_pub_rec OZF_SD_REQUEST_PUB.SDR_Hdr_rec_type;

Line 3842: OZF_OFFER_PVT.process_qp_list_lines

3838: END IF;
3839:
3840: END IF;
3841:
3842: OZF_OFFER_PVT.process_qp_list_lines
3843: (
3844: x_return_status => x_return_status
3845: ,x_msg_count => x_msg_count
3846: ,x_msg_data => x_msg_data

Line 4671: l_modifier_rec ozf_offer_pvt.Modifier_LIST_Rec_Type;

4667:
4668: l_offerType VARCHAR2(30);
4669: l_qpListHeaderId NUMBER;
4670: l_errorLocation NUMBER;
4671: l_modifier_rec ozf_offer_pvt.Modifier_LIST_Rec_Type;
4672: l_modifier_line_tbl ozf_offer_pvt.MODIFIER_LINE_TBL_TYPE;
4673: BEGIN
4674: x_return_status := FND_API.G_RET_STS_SUCCESS;
4675: FOR l_dates in c_dates(p_offerAdjustmentId) LOOP

Line 4672: l_modifier_line_tbl ozf_offer_pvt.MODIFIER_LINE_TBL_TYPE;

4668: l_offerType VARCHAR2(30);
4669: l_qpListHeaderId NUMBER;
4670: l_errorLocation NUMBER;
4671: l_modifier_rec ozf_offer_pvt.Modifier_LIST_Rec_Type;
4672: l_modifier_line_tbl ozf_offer_pvt.MODIFIER_LINE_TBL_TYPE;
4673: BEGIN
4674: x_return_status := FND_API.G_RET_STS_SUCCESS;
4675: FOR l_dates in c_dates(p_offerAdjustmentId) LOOP
4676:

Line 4688: OZF_OFFER_PVT.process_modifiers

4684: l_modifier_rec.OFFER_OPERATION := Qp_Globals.G_OPR_UPDATE;
4685: l_modifier_rec.MODIFIER_OPERATION := Qp_Globals.G_OPR_UPDATE;
4686: l_modifier_rec.object_version_number := l_dates.object_version_number;
4687: l_offerType := l_dates.offer_type;
4688: OZF_OFFER_PVT.process_modifiers
4689: (
4690: p_init_msg_list => FND_API.g_false
4691: ,p_api_version => 1.0
4692: ,p_commit => FND_API.g_false