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 1516: oe_debug_pub.add ('CTOCBOMB: REQUEST ID : ' || fnd_global.conc_request_id , 1 );

1512: -- g_t_dropped_item_type(v_table_count).MFG_REL_DATE := to_char( lEstRelDate , 'DD-MON-YYYY' ) ;
1513: g_t_dropped_item_type(v_table_count).MFG_REL_DATE := lEstRelDate ;
1514:
1515: IF PG_DEBUG <> 0 THEN
1516: oe_debug_pub.add ('CTOCBOMB: REQUEST ID : ' || fnd_global.conc_request_id , 1 );
1517: END IF;
1518:
1519: g_t_dropped_item_type(v_table_count).REQUEST_ID := to_char( fnd_global.conc_request_id ) ;
1520:

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

1515: IF PG_DEBUG <> 0 THEN
1516: oe_debug_pub.add ('CTOCBOMB: REQUEST ID : ' || fnd_global.conc_request_id , 1 );
1517: END IF;
1518:
1519: g_t_dropped_item_type(v_table_count).REQUEST_ID := to_char( fnd_global.conc_request_id ) ;
1520:
1521: else
1522: IF PG_DEBUG <> 0 THEN
1523: oe_debug_pub.add ('Create Item profile set to Do Not Create Item ' , 1 );

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

1561: g_t_dropped_item_type(v_table_count).ERROR_ORG_ID := pOrgId ;
1562: g_t_dropped_item_type(v_table_count).MFG_REL_DATE := lEstRelDate ;
1563:
1564: IF PG_DEBUG <> 0 THEN
1565: oe_debug_pub.add ('CTOCBOMB: REQUEST ID : ' || fnd_global.conc_request_id , 1 );
1566: END IF;
1567:
1568: g_t_dropped_item_type(v_table_count).REQUEST_ID := to_char( fnd_global.conc_request_id ) ;
1569:

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

1564: IF PG_DEBUG <> 0 THEN
1565: oe_debug_pub.add ('CTOCBOMB: REQUEST ID : ' || fnd_global.conc_request_id , 1 );
1566: END IF;
1567:
1568: g_t_dropped_item_type(v_table_count).REQUEST_ID := to_char( fnd_global.conc_request_id ) ;
1569:
1570:
1571:
1572: raise fnd_api.g_exc_error;

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

1654: g_t_dropped_item_type(v_table_count).ERROR_ORG_ID := pOrgId ;
1655: g_t_dropped_item_type(v_table_count).MFG_REL_DATE := lEstRelDate ;
1656:
1657: IF PG_DEBUG <> 0 THEN
1658: oe_debug_pub.add ('CTOCBOMB: REQUEST ID : ' || fnd_global.conc_request_id , 1 );
1659: END IF;
1660:
1661: g_t_dropped_item_type(v_table_count).REQUEST_ID := to_char(fnd_global.conc_request_id) ;
1662:

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

1657: IF PG_DEBUG <> 0 THEN
1658: oe_debug_pub.add ('CTOCBOMB: REQUEST ID : ' || fnd_global.conc_request_id , 1 );
1659: END IF;
1660:
1661: g_t_dropped_item_type(v_table_count).REQUEST_ID := to_char(fnd_global.conc_request_id) ;
1662:
1663:
1664:
1665:

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

1793: g_t_dropped_item_type(v_table_count).ERROR_ORG_ID := pOrgId ;
1794: g_t_dropped_item_type(v_table_count).MFG_REL_DATE := lEstRelDate ;
1795:
1796: IF PG_DEBUG <> 0 THEN
1797: oe_debug_pub.add ('CTOCBOMB: REQUEST ID : ' || fnd_global.conc_request_id , 1 );
1798: END IF;
1799:
1800: g_t_dropped_item_type(v_table_count).REQUEST_ID := to_char( fnd_global.conc_request_id ) ;
1801:

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

1796: IF PG_DEBUG <> 0 THEN
1797: oe_debug_pub.add ('CTOCBOMB: REQUEST ID : ' || fnd_global.conc_request_id , 1 );
1798: END IF;
1799:
1800: g_t_dropped_item_type(v_table_count).REQUEST_ID := to_char( fnd_global.conc_request_id ) ;
1801:
1802:
1803:
1804: /* IDENTIFY NOTIFY_USER for DROPPED COMPONENT NOTIFICATION */

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

2273:
2274: v_diff_basis_string varchar2(2000);
2275: v_sub_diff_basis_string varchar2(2000);
2276:
2277: l_new_line varchar2(10) := fnd_global.local_chr(10);
2278:
2279: l_token CTO_MSG_PUB.token_tbl;
2280: basis_model_comp_seq_id_arr seq_tab;
2281: basis_component_item_id_arr seq_tab;

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

2334: -- end 3674833
2335:
2336:
2337:
2338: gUserId := nvl(fnd_global.user_id, -1);
2339: gLoginId := nvl(fnd_global.login_id, -1);
2340:
2341: -- Start new code 3222932
2342:

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

2335:
2336:
2337:
2338: gUserId := nvl(fnd_global.user_id, -1);
2339: gLoginId := nvl(fnd_global.login_id, -1);
2340:
2341: -- Start new code 3222932
2342:
2343: -- Execute following code for each clubbed components

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

3255: ,s.attribute14
3256: ,s.attribute15
3257: ,s.original_system_reference
3258: ,s.enforce_int_requirements
3259: ,FND_GLOBAL.CONC_REQUEST_ID /* REQUEST_ID */
3260: ,FND_GLOBAL.PROG_APPL_ID /* PROGRAM_APPLICATION_ID */
3261: ,FND_GLOBAL.CONC_PROGRAM_ID /* PROGRAM_ID */
3262: ,sysdate /* PROGRAM_UPDATE_DATE */
3263: ,sysdate /* LAST_UPDATE_DATE */

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

3256: ,s.attribute15
3257: ,s.original_system_reference
3258: ,s.enforce_int_requirements
3259: ,FND_GLOBAL.CONC_REQUEST_ID /* REQUEST_ID */
3260: ,FND_GLOBAL.PROG_APPL_ID /* PROGRAM_APPLICATION_ID */
3261: ,FND_GLOBAL.CONC_PROGRAM_ID /* PROGRAM_ID */
3262: ,sysdate /* PROGRAM_UPDATE_DATE */
3263: ,sysdate /* LAST_UPDATE_DATE */
3264: ,gUserId /* LAST_UPDATED_BY */

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

3257: ,s.original_system_reference
3258: ,s.enforce_int_requirements
3259: ,FND_GLOBAL.CONC_REQUEST_ID /* REQUEST_ID */
3260: ,FND_GLOBAL.PROG_APPL_ID /* PROGRAM_APPLICATION_ID */
3261: ,FND_GLOBAL.CONC_PROGRAM_ID /* PROGRAM_ID */
3262: ,sysdate /* PROGRAM_UPDATE_DATE */
3263: ,sysdate /* LAST_UPDATE_DATE */
3264: ,gUserId /* LAST_UPDATED_BY */
3265: ,sysdate /* CREATION_DATE */

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

5532: pline_no number := 1111 ;
5533:
5534: lstmt_num number ;
5535:
5536: l_new_line varchar2(10) := fnd_global.local_chr(10);
5537: begin
5538: lstmt_num := 10 ;
5539:
5540: