DBA Data[Home] [Help]

APPS.CTO_MATCH_AND_RESERVE dependencies on FND_PROFILE

Line 142: PG_DEBUG Number := NVL(FND_PROFILE.value('ONT_DEBUG_LEVEL'), 0);

138: 05/01/00: Modifying match_inquiry to work for multilevel
139: configurations.
140: *****************************************************************************/
141:
142: PG_DEBUG Number := NVL(FND_PROFILE.value('ONT_DEBUG_LEVEL'), 0);
143:
144: function match_inquiry(
145: p_model_line_id in NUMBER,
146: p_automatic_reservation in BOOLEAN,

Line 254: l_match_profile := FND_PROFILE.Value('BOM:MATCH_CONFIG');

250: x_config_id := NULL;
251: x_quantity_reserved := 0;
252:
253: l_stmt_num := 50;
254: l_match_profile := FND_PROFILE.Value('BOM:MATCH_CONFIG');
255: l_custom_match_profile := FND_PROFILE.Value('BOM:CUSTOM_MATCH');
256:
257: IF PG_DEBUG <> 0 THEN
258: oe_debug_pub.add('MATCH_CONFIG: ' || l_match_profile, 1);

Line 255: l_custom_match_profile := FND_PROFILE.Value('BOM:CUSTOM_MATCH');

251: x_quantity_reserved := 0;
252:
253: l_stmt_num := 50;
254: l_match_profile := FND_PROFILE.Value('BOM:MATCH_CONFIG');
255: l_custom_match_profile := FND_PROFILE.Value('BOM:CUSTOM_MATCH');
256:
257: IF PG_DEBUG <> 0 THEN
258: oe_debug_pub.add('MATCH_CONFIG: ' || l_match_profile, 1);
259: oe_debug_pub.add('CUSTOM_MATCH: ' || l_custom_match_profile, 1);

Line 581: lPerformPPRollup := nvl( FND_PROFILE.Value('CTO_PERFORM_PURCHASE_PRICE_ROLLUP'), 1 ) ;

577: else
578:
579: oe_debug_pub.add('CTOMCRSB: ' || 'Getting Profile Values ' , 1);
580:
581: lPerformPPRollup := nvl( FND_PROFILE.Value('CTO_PERFORM_PURCHASE_PRICE_ROLLUP'), 1 ) ;
582: lPerformCSTRollup := nvl( FND_PROFILE.Value('CTO_PERFORM_COST_ROLLUP') , 1 ) ;
583: --Bugfix 6716677
584: --lPerformFWCalc := nvl( FND_PROFILE.Value('CTO_PERFORM_FLOW_CALC') , 1 );
585: lPerformFWCalc := nvl( FND_PROFILE.Value('CTO_PERFORM_FLOW_CALC') , 2 );

Line 582: lPerformCSTRollup := nvl( FND_PROFILE.Value('CTO_PERFORM_COST_ROLLUP') , 1 ) ;

578:
579: oe_debug_pub.add('CTOMCRSB: ' || 'Getting Profile Values ' , 1);
580:
581: lPerformPPRollup := nvl( FND_PROFILE.Value('CTO_PERFORM_PURCHASE_PRICE_ROLLUP'), 1 ) ;
582: lPerformCSTRollup := nvl( FND_PROFILE.Value('CTO_PERFORM_COST_ROLLUP') , 1 ) ;
583: --Bugfix 6716677
584: --lPerformFWCalc := nvl( FND_PROFILE.Value('CTO_PERFORM_FLOW_CALC') , 1 );
585: lPerformFWCalc := nvl( FND_PROFILE.Value('CTO_PERFORM_FLOW_CALC') , 2 );
586:

Line 584: --lPerformFWCalc := nvl( FND_PROFILE.Value('CTO_PERFORM_FLOW_CALC') , 1 );

580:
581: lPerformPPRollup := nvl( FND_PROFILE.Value('CTO_PERFORM_PURCHASE_PRICE_ROLLUP'), 1 ) ;
582: lPerformCSTRollup := nvl( FND_PROFILE.Value('CTO_PERFORM_COST_ROLLUP') , 1 ) ;
583: --Bugfix 6716677
584: --lPerformFWCalc := nvl( FND_PROFILE.Value('CTO_PERFORM_FLOW_CALC') , 1 );
585: lPerformFWCalc := nvl( FND_PROFILE.Value('CTO_PERFORM_FLOW_CALC') , 2 );
586:
587: oe_debug_pub.add('CTOMCRSB: ' || 'Done Getting Profile Values ' , 1);
588:

Line 585: lPerformFWCalc := nvl( FND_PROFILE.Value('CTO_PERFORM_FLOW_CALC') , 2 );

581: lPerformPPRollup := nvl( FND_PROFILE.Value('CTO_PERFORM_PURCHASE_PRICE_ROLLUP'), 1 ) ;
582: lPerformCSTRollup := nvl( FND_PROFILE.Value('CTO_PERFORM_COST_ROLLUP') , 1 ) ;
583: --Bugfix 6716677
584: --lPerformFWCalc := nvl( FND_PROFILE.Value('CTO_PERFORM_FLOW_CALC') , 1 );
585: lPerformFWCalc := nvl( FND_PROFILE.Value('CTO_PERFORM_FLOW_CALC') , 2 );
586:
587: oe_debug_pub.add('CTOMCRSB: ' || 'Done Getting Profile Values ' , 1);
588:
589: IF PG_DEBUG <> 0 THEN

Line 1368: lSourceCode := fnd_profile.value('ONT_SOURCE_CODE');

1364: The reservation against the configuration item is made against the
1365: configuration line, not the model line.
1366: +------------------------------------------------------------------*/
1367: l_stmt_num := 140;
1368: lSourceCode := fnd_profile.value('ONT_SOURCE_CODE');
1369: IF PG_DEBUG <> 0 THEN
1370: oe_debug_pub.add('create_config_reservation: ' || 'lSourceCode is '||lSourceCode, 2);
1371: END IF;
1372: select mso.sales_order_id,