DBA Data[Home] [Help]

APPS.CTO_CONFIG_BOM_PK dependencies on FND_GLOBAL

Line 297: l_new_line varchar2(10) := fnd_global.local_chr(10);

293: v_zero_qty_count number ;
294:
295: v_option_num number := 0 ;
296:
297: l_new_line varchar2(10) := fnd_global.local_chr(10);
298:
299: l_aname wf_engine.nametabtyp;
300: l_anumvalue wf_engine.numtabtyp;
301: l_atxtvalue wf_engine.texttabtyp;

Line 1490: oe_debug_pub.add ('CTOCBOMB: REQUEST ID : ' || fnd_global.conc_request_id , 1 );

1486: -- g_t_dropped_item_type(v_table_count).MFG_REL_DATE := to_char( lEstRelDate , 'DD-MON-YYYY' ) ;
1487: g_t_dropped_item_type(v_table_count).MFG_REL_DATE := lEstRelDate ;
1488:
1489: IF PG_DEBUG <> 0 THEN
1490: oe_debug_pub.add ('CTOCBOMB: REQUEST ID : ' || fnd_global.conc_request_id , 1 );
1491: END IF;
1492:
1493: g_t_dropped_item_type(v_table_count).REQUEST_ID := to_char( fnd_global.conc_request_id ) ;
1494:

Line 1493: g_t_dropped_item_type(v_table_count).REQUEST_ID := to_char( fnd_global.conc_request_id ) ;

1489: IF PG_DEBUG <> 0 THEN
1490: oe_debug_pub.add ('CTOCBOMB: REQUEST ID : ' || fnd_global.conc_request_id , 1 );
1491: END IF;
1492:
1493: g_t_dropped_item_type(v_table_count).REQUEST_ID := to_char( fnd_global.conc_request_id ) ;
1494:
1495: else
1496: IF PG_DEBUG <> 0 THEN
1497: oe_debug_pub.add ('Create Item profile set to Do Not Create Item ' , 1 );

Line 1539: oe_debug_pub.add ('CTOCBOMB: REQUEST ID : ' || fnd_global.conc_request_id , 1 );

1535: g_t_dropped_item_type(v_table_count).ERROR_ORG_ID := pOrgId ;
1536: g_t_dropped_item_type(v_table_count).MFG_REL_DATE := lEstRelDate ;
1537:
1538: IF PG_DEBUG <> 0 THEN
1539: oe_debug_pub.add ('CTOCBOMB: REQUEST ID : ' || fnd_global.conc_request_id , 1 );
1540: END IF;
1541:
1542: g_t_dropped_item_type(v_table_count).REQUEST_ID := to_char( fnd_global.conc_request_id ) ;
1543:

Line 1542: g_t_dropped_item_type(v_table_count).REQUEST_ID := to_char( fnd_global.conc_request_id ) ;

1538: IF PG_DEBUG <> 0 THEN
1539: oe_debug_pub.add ('CTOCBOMB: REQUEST ID : ' || fnd_global.conc_request_id , 1 );
1540: END IF;
1541:
1542: g_t_dropped_item_type(v_table_count).REQUEST_ID := to_char( fnd_global.conc_request_id ) ;
1543:
1544:
1545:
1546: raise fnd_api.g_exc_error;

Line 1632: oe_debug_pub.add ('CTOCBOMB: REQUEST ID : ' || fnd_global.conc_request_id , 1 );

1628: g_t_dropped_item_type(v_table_count).ERROR_ORG_ID := pOrgId ;
1629: g_t_dropped_item_type(v_table_count).MFG_REL_DATE := lEstRelDate ;
1630:
1631: IF PG_DEBUG <> 0 THEN
1632: oe_debug_pub.add ('CTOCBOMB: REQUEST ID : ' || fnd_global.conc_request_id , 1 );
1633: END IF;
1634:
1635: g_t_dropped_item_type(v_table_count).REQUEST_ID := to_char(fnd_global.conc_request_id) ;
1636:

Line 1635: g_t_dropped_item_type(v_table_count).REQUEST_ID := to_char(fnd_global.conc_request_id) ;

1631: IF PG_DEBUG <> 0 THEN
1632: oe_debug_pub.add ('CTOCBOMB: REQUEST ID : ' || fnd_global.conc_request_id , 1 );
1633: END IF;
1634:
1635: g_t_dropped_item_type(v_table_count).REQUEST_ID := to_char(fnd_global.conc_request_id) ;
1636:
1637:
1638:
1639:

Line 1771: oe_debug_pub.add ('CTOCBOMB: REQUEST ID : ' || fnd_global.conc_request_id , 1 );

1767: g_t_dropped_item_type(v_table_count).ERROR_ORG_ID := pOrgId ;
1768: g_t_dropped_item_type(v_table_count).MFG_REL_DATE := lEstRelDate ;
1769:
1770: IF PG_DEBUG <> 0 THEN
1771: oe_debug_pub.add ('CTOCBOMB: REQUEST ID : ' || fnd_global.conc_request_id , 1 );
1772: END IF;
1773:
1774: g_t_dropped_item_type(v_table_count).REQUEST_ID := to_char( fnd_global.conc_request_id ) ;
1775:

Line 1774: g_t_dropped_item_type(v_table_count).REQUEST_ID := to_char( fnd_global.conc_request_id ) ;

1770: IF PG_DEBUG <> 0 THEN
1771: oe_debug_pub.add ('CTOCBOMB: REQUEST ID : ' || fnd_global.conc_request_id , 1 );
1772: END IF;
1773:
1774: g_t_dropped_item_type(v_table_count).REQUEST_ID := to_char( fnd_global.conc_request_id ) ;
1775:
1776:
1777:
1778: /* IDENTIFY NOTIFY_USER for DROPPED COMPONENT NOTIFICATION */

Line 2237: l_new_line varchar2(10) := fnd_global.local_chr(10);

2233:
2234: v_diff_basis_string varchar2(2000);
2235: v_sub_diff_basis_string varchar2(2000);
2236:
2237: l_new_line varchar2(10) := fnd_global.local_chr(10);
2238:
2239: l_token CTO_MSG_PUB.token_tbl;
2240: basis_model_comp_seq_id_arr seq_tab;
2241: basis_component_item_id_arr seq_tab;

Line 2295: gUserId := nvl(fnd_global.user_id, -1);

2291: -- end 3674833
2292:
2293:
2294:
2295: gUserId := nvl(fnd_global.user_id, -1);
2296: gLoginId := nvl(fnd_global.login_id, -1);
2297:
2298: -- Start new code 3222932
2299:

Line 2296: gLoginId := nvl(fnd_global.login_id, -1);

2292:
2293:
2294:
2295: gUserId := nvl(fnd_global.user_id, -1);
2296: gLoginId := nvl(fnd_global.login_id, -1);
2297:
2298: -- Start new code 3222932
2299:
2300: -- Execute following code for each clubbed components

Line 3183: ,FND_GLOBAL.CONC_REQUEST_ID /* REQUEST_ID */

3179: ,s.attribute14
3180: ,s.attribute15
3181: ,s.original_system_reference
3182: ,s.enforce_int_requirements
3183: ,FND_GLOBAL.CONC_REQUEST_ID /* REQUEST_ID */
3184: ,FND_GLOBAL.PROG_APPL_ID /* PROGRAM_APPLICATION_ID */
3185: ,FND_GLOBAL.CONC_PROGRAM_ID /* PROGRAM_ID */
3186: ,sysdate /* PROGRAM_UPDATE_DATE */
3187: ,sysdate /* LAST_UPDATE_DATE */

Line 3184: ,FND_GLOBAL.PROG_APPL_ID /* PROGRAM_APPLICATION_ID */

3180: ,s.attribute15
3181: ,s.original_system_reference
3182: ,s.enforce_int_requirements
3183: ,FND_GLOBAL.CONC_REQUEST_ID /* REQUEST_ID */
3184: ,FND_GLOBAL.PROG_APPL_ID /* PROGRAM_APPLICATION_ID */
3185: ,FND_GLOBAL.CONC_PROGRAM_ID /* PROGRAM_ID */
3186: ,sysdate /* PROGRAM_UPDATE_DATE */
3187: ,sysdate /* LAST_UPDATE_DATE */
3188: ,gUserId /* LAST_UPDATED_BY */

Line 3185: ,FND_GLOBAL.CONC_PROGRAM_ID /* PROGRAM_ID */

3181: ,s.original_system_reference
3182: ,s.enforce_int_requirements
3183: ,FND_GLOBAL.CONC_REQUEST_ID /* REQUEST_ID */
3184: ,FND_GLOBAL.PROG_APPL_ID /* PROGRAM_APPLICATION_ID */
3185: ,FND_GLOBAL.CONC_PROGRAM_ID /* PROGRAM_ID */
3186: ,sysdate /* PROGRAM_UPDATE_DATE */
3187: ,sysdate /* LAST_UPDATE_DATE */
3188: ,gUserId /* LAST_UPDATED_BY */
3189: ,sysdate /* CREATION_DATE */

Line 5224: l_new_line varchar2(10) := fnd_global.local_chr(10);

5220: pline_no number := 1111 ;
5221:
5222: lstmt_num number ;
5223:
5224: l_new_line varchar2(10) := fnd_global.local_chr(10);
5225: begin
5226: lstmt_num := 10 ;
5227:
5228: