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_SD_BATCH_PVT dependencies on OZF_SD_BATCH_PVT

Line 1: PACKAGE BODY OZF_SD_BATCH_PVT AS

1: PACKAGE BODY OZF_SD_BATCH_PVT AS
2: /* $Header: ozfvsdbb.pls 120.101.12020000.2 2012/07/21 12:38:20 sariff ship $ */
3:
4: -- Start of Comments
5: -- Package name : OZF_SD_BATCH_PVT

Line 5: -- Package name : OZF_SD_BATCH_PVT

1: PACKAGE BODY OZF_SD_BATCH_PVT AS
2: /* $Header: ozfvsdbb.pls 120.101.12020000.2 2012/07/21 12:38:20 sariff ship $ */
3:
4: -- Start of Comments
5: -- Package name : OZF_SD_BATCH_PVT
6: -- Purpose : This package contains procedures and functions for batch creation concurrent program
7: -- Also contains executable procedure for auto claim concurrent program
8: -- Author : MBHATT
9: -- Created : 11/16/2007 2:39:16 PM

Line 39: G_PKG_NAME CONSTANT VARCHAR2(30) := 'OZF_SD_BATCH_PVT';

35: -- 07-SEP-2010 - RSATYAVA - Changes For Bug#10047209: bobfwd: fp12.1.4 9798553: snd process not creating negative claim
36: -- NOTE :
37: -- End of Comments
38:
39: G_PKG_NAME CONSTANT VARCHAR2(30) := 'OZF_SD_BATCH_PVT';
40: G_FILE_NAME CONSTANT VARCHAR2(12) := 'ozfvsdbb.pls';
41: OZF_DEBUG_HIGH_ON CONSTANT BOOLEAN := FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_high);
42: OZF_DEBUG_LOW_ON CONSTANT BOOLEAN := FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low);
43: OZF_ERROR_ON CONSTANT BOOLEAN := FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error);

Line 79: x_to_amount := OZF_SD_BATCH_PVT.CURR_ROUND_EXT_PREC(p_amt_val, p_offer_currency);

75: ,x_rate => x_rate
76: );
77:
78: ELSE
79: x_to_amount := OZF_SD_BATCH_PVT.CURR_ROUND_EXT_PREC(p_amt_val, p_offer_currency);
80: END IF;
81: ELSE
82: x_to_amount := p_amt_val;
83: END IF;

Line 1827: OZF_SD_BATCH_PVT.CONV_AMT_TO_OFFER_CURR_AMOUNT(FU.PLAN_CURRENCY_CODE ,FU.COST_PRICE_CURRENCY_CODE, FU.COST_PRICE, FU.EXCHANGE_RATE_DATE, FU.EXCHANGE_RATE_TYPE ))' ;

1823: -- Type of Conversion FU.EXCHANGE_RATE_TYPE
1824:
1825: l_cost_price_offer_string := 'decode(FU.DISCOUNT_TYPE,
1826: ''AMT'', NULL,
1827: OZF_SD_BATCH_PVT.CONV_AMT_TO_OFFER_CURR_AMOUNT(FU.PLAN_CURRENCY_CODE ,FU.COST_PRICE_CURRENCY_CODE, FU.COST_PRICE, FU.EXCHANGE_RATE_DATE, FU.EXCHANGE_RATE_TYPE ))' ;
1828: l_func_call_string := 'OZF_SD_BATCH_PVT.CONV_AMT_TO_OFFER_CURR_AMOUNT(FU.PLAN_CURRENCY_CODE ,FU.DISCOUNT_AMOUNT_CURRENCY_CODE, FU.DISCOUNT_AMOUNT, FU.EXCHANGE_RATE_DATE, FU.EXCHANGE_RATE_TYPE )' ;
1829: l_shipped_qty_string := 'DECODE(OEL.LINE_CATEGORY_CODE, ''RETURN'' , -1 * abs(NVL(oel.shipped_quantity, NVL(oel.invoiced_quantity, NVL(oel.ordered_quantity, 1)))) ,
1830: NVL(oel.shipped_quantity, NVL(oel.invoiced_quantity, NVL(oel.ordered_quantity, 1))) ) ' ;
1831:

Line 1828: l_func_call_string := 'OZF_SD_BATCH_PVT.CONV_AMT_TO_OFFER_CURR_AMOUNT(FU.PLAN_CURRENCY_CODE ,FU.DISCOUNT_AMOUNT_CURRENCY_CODE, FU.DISCOUNT_AMOUNT, FU.EXCHANGE_RATE_DATE, FU.EXCHANGE_RATE_TYPE )' ;

1824:
1825: l_cost_price_offer_string := 'decode(FU.DISCOUNT_TYPE,
1826: ''AMT'', NULL,
1827: OZF_SD_BATCH_PVT.CONV_AMT_TO_OFFER_CURR_AMOUNT(FU.PLAN_CURRENCY_CODE ,FU.COST_PRICE_CURRENCY_CODE, FU.COST_PRICE, FU.EXCHANGE_RATE_DATE, FU.EXCHANGE_RATE_TYPE ))' ;
1828: l_func_call_string := 'OZF_SD_BATCH_PVT.CONV_AMT_TO_OFFER_CURR_AMOUNT(FU.PLAN_CURRENCY_CODE ,FU.DISCOUNT_AMOUNT_CURRENCY_CODE, FU.DISCOUNT_AMOUNT, FU.EXCHANGE_RATE_DATE, FU.EXCHANGE_RATE_TYPE )' ;
1829: l_shipped_qty_string := 'DECODE(OEL.LINE_CATEGORY_CODE, ''RETURN'' , -1 * abs(NVL(oel.shipped_quantity, NVL(oel.invoiced_quantity, NVL(oel.ordered_quantity, 1)))) ,
1830: NVL(oel.shipped_quantity, NVL(oel.invoiced_quantity, NVL(oel.ordered_quantity, 1))) ) ' ;
1831:
1832: IF l_ozf_gl_entries = 'SHIPPED' then

Line 1833: l_cost_price_string:= ('NVL( '|| l_cost_price_offer_string ||',OZF_SD_BATCH_PVT.CURR_ROUND_EXT_PREC(decode (FU.DISCOUNT_TYPE,

1829: l_shipped_qty_string := 'DECODE(OEL.LINE_CATEGORY_CODE, ''RETURN'' , -1 * abs(NVL(oel.shipped_quantity, NVL(oel.invoiced_quantity, NVL(oel.ordered_quantity, 1)))) ,
1830: NVL(oel.shipped_quantity, NVL(oel.invoiced_quantity, NVL(oel.ordered_quantity, 1))) ) ' ;
1831:
1832: IF l_ozf_gl_entries = 'SHIPPED' then
1833: l_cost_price_string:= ('NVL( '|| l_cost_price_offer_string ||',OZF_SD_BATCH_PVT.CURR_ROUND_EXT_PREC(decode (FU.DISCOUNT_TYPE,
1834: ''%'', ( FU.PLAN_CURR_AMOUNT_REMAINING/' || l_shipped_qty_string || ' * (100/FU.DISCOUNT_AMOUNT) ),
1835: ''AMT'', null,
1836: ''NEWPRICE'', '|| l_func_call_string ||' + FU.PLAN_CURR_AMOUNT_REMAINING/ ' || l_shipped_qty_string || ' ),FU.PLAN_CURRENCY_CODE ) )');
1837: END IF;

Line 1840: l_cost_price_string:= ('NVL( '|| l_cost_price_offer_string ||', OZF_SD_BATCH_PVT.CURR_ROUND_EXT_PREC(decode (FU.DISCOUNT_TYPE,

1836: ''NEWPRICE'', '|| l_func_call_string ||' + FU.PLAN_CURR_AMOUNT_REMAINING/ ' || l_shipped_qty_string || ' ),FU.PLAN_CURRENCY_CODE ) )');
1837: END IF;
1838:
1839: IF l_ozf_gl_entries = 'INVOICED' then
1840: l_cost_price_string:= ('NVL( '|| l_cost_price_offer_string ||', OZF_SD_BATCH_PVT.CURR_ROUND_EXT_PREC(decode (FU.DISCOUNT_TYPE,
1841: ''%'', ( FU.PLAN_CURR_AMOUNT_REMAINING/NVL(oel.invoiced_quantity, NVL('|| l_shipped_qty_string ||',1)) * (100/FU.DISCOUNT_AMOUNT) ),
1842: ''AMT'', null,
1843: ''NEWPRICE'', '|| l_func_call_string ||' + FU.PLAN_CURR_AMOUNT_REMAINING/NVL(oel.invoiced_quantity, NVL('|| l_shipped_qty_string || ' , 1)) ),FU.PLAN_CURRENCY_CODE) )');
1844: END IF;

Line 1856: l_agmt_price_string:= 'OZF_SD_BATCH_PVT.CURR_ROUND_EXT_PREC('||l_agmt_price_string||', FU.PLAN_CURRENCY_CODE)';

1852: ''AMT'', null,
1853: ''NEWPRICE'', '|| l_func_call_string || ', ' ||
1854: l_func_call_string || ') ');
1855:
1856: l_agmt_price_string:= 'OZF_SD_BATCH_PVT.CURR_ROUND_EXT_PREC('||l_agmt_price_string||', FU.PLAN_CURRENCY_CODE)';
1857:
1858: FND_DSQL.add_text(l_agmt_price_string || 'APPROVED_DISCOUNT_VALUE' );
1859:
1860: FND_DSQL.add_text(', FU.PLAN_CURR_AMOUNT_REMAINING, '); -- for claim_amount

Line 1868: FND_DSQL.add_text(' ) THEN FU.ACCTD_AMOUNT_REMAINING ELSE OZF_SD_BATCH_PVT.GET_BATCH_CURRENCY_AMOUNT(');

1864: FND_DSQL.add_text(' ) THEN FU.PLAN_CURR_AMOUNT_REMAINING WHEN (');
1865: FND_DSQL.add_bind(''||l_func_currency||'' );
1866: FND_DSQL.add_text('=');
1867: FND_DSQL.add_bind(''||p_batch_currency||'' );
1868: FND_DSQL.add_text(' ) THEN FU.ACCTD_AMOUNT_REMAINING ELSE OZF_SD_BATCH_PVT.GET_BATCH_CURRENCY_AMOUNT(');
1869: FND_DSQL.add_bind(''||l_func_currency||'' );
1870: FND_DSQL.add_text(',');
1871: FND_DSQL.add_bind(''||p_batch_currency||'' );
1872: FND_DSQL.add_text(', FU.ACCTD_AMOUNT_REMAINING, FU.EXCHANGE_RATE_TYPE, NULL,');

Line 2694: OZF_SD_BATCH_PVT.CONV_AMT_TO_OFFER_CURR_AMOUNT(FU.PLAN_CURRENCY_CODE ,

2690: -- Date Of conversion FU.EXCHANGE_RATE_DATE
2691: -- Type of Conversion FU.EXCHANGE_RATE_TYPE
2692:
2693: l_cost_price_offer_string := 'decode(FU.DISCOUNT_TYPE, ''AMT'', NULL,
2694: OZF_SD_BATCH_PVT.CONV_AMT_TO_OFFER_CURR_AMOUNT(FU.PLAN_CURRENCY_CODE ,
2695: FU.COST_PRICE_CURRENCY_CODE,
2696: FU.COST_PRICE,
2697: FU.EXCHANGE_RATE_DATE,
2698: FU.EXCHANGE_RATE_TYPE ))';

Line 2701: l_discount_amount_string := 'OZF_SD_BATCH_PVT.CONV_AMT_TO_OFFER_CURR_AMOUNT(FU.PLAN_CURRENCY_CODE ,

2697: FU.EXCHANGE_RATE_DATE,
2698: FU.EXCHANGE_RATE_TYPE ))';
2699: FND_DSQL.add_text(l_cost_price_offer_string || 'COST_PRICE' );
2700:
2701: l_discount_amount_string := 'OZF_SD_BATCH_PVT.CONV_AMT_TO_OFFER_CURR_AMOUNT(FU.PLAN_CURRENCY_CODE ,
2702: FU.DISCOUNT_AMOUNT_CURRENCY_CODE,
2703: FU.DISCOUNT_AMOUNT,
2704: FU.EXCHANGE_RATE_DATE,
2705: FU.EXCHANGE_RATE_TYPE )' ;

Line 2721: l_agmt_price_string:= 'OZF_SD_BATCH_PVT.CURR_ROUND_EXT_PREC('||l_agmt_price_string||', FU.PLAN_CURRENCY_CODE)';

2717: ''AMT'', null,
2718: ''NEWPRICE'', '|| l_discount_amount_string || ', ' ||
2719: l_discount_amount_string || ') ');
2720:
2721: l_agmt_price_string:= 'OZF_SD_BATCH_PVT.CURR_ROUND_EXT_PREC('||l_agmt_price_string||', FU.PLAN_CURRENCY_CODE)';
2722:
2723: FND_DSQL.add_text(l_agmt_price_string || 'AGREEMENT_PRICE' );
2724:
2725: FND_DSQL.add_text(', FU.PLAN_CURR_AMOUNT_REMAINING, '); -- for claim_amount

Line 2733: FND_DSQL.add_text(' ) THEN FU.ACCTD_AMOUNT_REMAINING ELSE OZF_SD_BATCH_PVT.GET_BATCH_CURRENCY_AMOUNT(');

2729: FND_DSQL.add_text(' ) THEN FU.PLAN_CURR_AMOUNT_REMAINING WHEN (');
2730: FND_DSQL.add_bind(''||l_func_currency||'' );
2731: FND_DSQL.add_text('=');
2732: FND_DSQL.add_bind(''||p_batch_currency||'' );
2733: FND_DSQL.add_text(' ) THEN FU.ACCTD_AMOUNT_REMAINING ELSE OZF_SD_BATCH_PVT.GET_BATCH_CURRENCY_AMOUNT(');
2734: FND_DSQL.add_bind(''||l_func_currency||'' );
2735: FND_DSQL.add_text(',');
2736: FND_DSQL.add_bind(''||p_batch_currency||'' );
2737: FND_DSQL.add_text(', FU.ACCTD_AMOUNT_REMAINING, FU.EXCHANGE_RATE_TYPE, NULL,');

Line 3931: END OZF_SD_BATCH_PVT;

3927: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Exception in INVOKE_CLAIM' || sqlerrm);
3928: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Exception in INVOKE_CLAIM' || sqlerrm);
3929: END; -- INVOKE_CLAIM;
3930:
3931: END OZF_SD_BATCH_PVT;