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 712: lSourceCode := FND_PROFILE.VALUE('ONT_SOURCE_CODE');

708:
709: -- Set the return code to success
710: RETCODE := 0;
711:
712: lSourceCode := FND_PROFILE.VALUE('ONT_SOURCE_CODE');
713: IF PG_DEBUG <> 0 THEN
714: oe_debug_pub.add('auto_create_pur_req_cr: ' || 'l_source_code = '||lsourcecode,1);
715: END IF;
716:

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

1923: -- we shall populate this only if the profile INV:Purchasing by Revision is set to Yes (value = 1)
1924:
1925: -- rkaza. 05/10/2005. No need to find item rev for int reqs.
1926: -- default valuye is null.
1927: if FND_PROFILE.value('INV_PURCHASING_BY_REVISION') = 1
1928: and p_req_interface_input_data.source_type <> 1 then
1929: l_stmt_num := 130;
1930: select ato_line_id into l_ato_line_id
1931: from oe_order_lines_all

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

2990: l_buy_found Varchar(1);
2991: l_config_creation Number;
2992: begin
2993: x_return_status := FND_API.G_RET_STS_SUCCESS;
2994: l_assgn_set_id := to_number(FND_PROFILE.VALUE('MRP_DEFAULT_ASSIGNMENT_SET'));
2995: lStmtNumber := 10;
2996:
2997: g_pg_level := g_pg_level + 3;
2998: If pg_debug <> 0 then

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

4052: l_vendor_site_list Num_table;
4053:
4054:
4055: begin
4056: l_assg_set_id := to_number(FND_PROFILE.VALUE('MRP_DEFAULT_ASSIGNMENT_SET'));
4057: /*
4058: This API will remove unwanted blankets from rolluping up.
4059: There is a seperate logic exists for this
4060: */

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

4332: -- Set the return code to success
4333: retcode := 0;
4334:
4335: -- Get the ONT source code
4336: lSourceCode := FND_PROFILE.VALUE('ONT_SOURCE_CODE');
4337:
4338:
4339: -- for all the sales order lines (entered, booked )
4340: -- Given parameters.

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

4860: --- Launch the concurrent program
4861: oe_debug_pub.add('Submit_pdoi_conc_prog: '||'Launching program for oper unit ='||to_char(p_oper_unit_list(i).oper_unit));
4862: oe_debug_pub.add('Submit_pdoi_conc_prog: '||'Batch id = '||to_char(p_batch_id),1);
4863:
4864: l_release_method := FND_PROFILE.VALUE('CTO_PRICING_RELEASE_METHOD');
4865: If l_release_method is null then
4866: l_rel_method_value := null;
4867: oe_debug_pub.add('Submit_pdoi_conc_prog: '||' Release method is null...',1);
4868: elsif l_release_method = 2 then