APPS.CTO_AUTO_PROCURE_PK dependencies on FND_PROFILE

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

203:
204: ---------------------------------------------------------------------------------------------------------
205: ---------------------------------------------------------------------------------------------------------
206:
207: PG_DEBUG Number := NVL(FND_PROFILE.value('ONT_DEBUG_LEVEL'), 0);
208:
209: g_pg_level Number;
210: Function config_exists_in_blanket(
211: p_config_item_id IN Number,

Line 614: lSourceCode := FND_PROFILE.VALUE('ONT_SOURCE_CODE');

610:
611: -- Set the return code to success
612: RETCODE := 0;
613:
614: lSourceCode := FND_PROFILE.VALUE('ONT_SOURCE_CODE');
615: IF PG_DEBUG <> 0 THEN
616: oe_debug_pub.add('auto_create_pur_req_cr: ' || 'l_source_code = '||lsourcecode,1);
617: END IF;
618:

Line 1604: if FND_PROFILE.value('INV_PURCHASING_BY_REVISION') = 1

1600: -- we shall populate this only if the profile INV:Purchasing by Revision is set to Yes (value = 1)
1601:
1602: -- rkaza. 05/10/2005. No need to find item rev for int reqs.
1603: -- default valuye is null.
1604: if FND_PROFILE.value('INV_PURCHASING_BY_REVISION') = 1
1605: and p_req_interface_input_data.source_type <> 1 then
1606: l_stmt_num := 130;
1607: select ato_line_id into l_ato_line_id
1608: from oe_order_lines_all

Line 2609: l_assgn_set_id := to_number(FND_PROFILE.VALUE('MRP_DEFAULT_ASSIGNMENT_SET'));

2605: l_buy_found Varchar(1);
2606: l_config_creation Number;
2607: begin
2608: x_return_status := FND_API.G_RET_STS_SUCCESS;
2609: l_assgn_set_id := to_number(FND_PROFILE.VALUE('MRP_DEFAULT_ASSIGNMENT_SET'));
2610: lStmtNumber := 10;
2611:
2612: g_pg_level := g_pg_level + 3;
2613: If pg_debug <> 0 then

Line 3646: l_assg_set_id := to_number(FND_PROFILE.VALUE('MRP_DEFAULT_ASSIGNMENT_SET'));

3642: l_vendor_site_list Num_table;
3643:
3644:
3645: begin
3646: l_assg_set_id := to_number(FND_PROFILE.VALUE('MRP_DEFAULT_ASSIGNMENT_SET'));
3647: /*
3648: This API will remove unwanted blankets from rolluping up.
3649: There is a seperate logic exists for this
3650: */

Line 3926: lSourceCode := FND_PROFILE.VALUE('ONT_SOURCE_CODE');

3922: -- Set the return code to success
3923: retcode := 0;
3924:
3925: -- Get the ONT source code
3926: lSourceCode := FND_PROFILE.VALUE('ONT_SOURCE_CODE');
3927:
3928:
3929: -- for all the sales order lines (entered, booked )
3930: -- Given parameters.

Line 4452: l_release_method := FND_PROFILE.VALUE('CTO_PRICING_RELEASE_METHOD');

4448: --- Launch the concurrent program
4449: oe_debug_pub.add('Submit_pdoi_conc_prog: '||'Launching program for oper unit ='||to_char(p_oper_unit_list(i).oper_unit));
4450: oe_debug_pub.add('Submit_pdoi_conc_prog: '||'Batch id = '||to_char(p_batch_id),1);
4451:
4452: l_release_method := FND_PROFILE.VALUE('CTO_PRICING_RELEASE_METHOD');
4453: If l_release_method is null then
4454: l_rel_method_value := null;
4455: oe_debug_pub.add('Submit_pdoi_conc_prog: '||' Release method is null...',1);
4456: elsif l_release_method = 2 then