eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.MSD_LIABILITY dependencies on MSD_COMMON_UTILITIES_LB

Line 353: x_plan_start_date := MSD_COMMON_UTILITIES_LB.get_supply_plan_start_date( p_plan_id) ;

349:
350: clean_liability_level_values( errbuf , retcode ) ;
351:
352:
353: x_plan_start_date := MSD_COMMON_UTILITIES_LB.get_supply_plan_start_date( p_plan_id) ;
354:
355:
356: IF p_plan_id <> -1 THEN
357:

Line 358: x_plan_end_date := MSD_COMMON_UTILITIES_LB.get_supply_plan_end_date( p_plan_id) ;

354:
355:
356: IF p_plan_id <> -1 THEN
357:
358: x_plan_end_date := MSD_COMMON_UTILITIES_LB.get_supply_plan_end_date( p_plan_id) ;
359:
360: ELSE
361:
362: /* Weak Link */

Line 363: x_plan_end_date := MSD_COMMON_UTILITIES_LB.get_cp_end_date ;

359:
360: ELSE
361:
362: /* Weak Link */
363: x_plan_end_date := MSD_COMMON_UTILITIES_LB.get_cp_end_date ;
364:
365: END IF ;
366:
367: /* This preprocessor updates the Agreement details for the forecast liability views */

Line 369: MSD_COMMON_UTILITIES_LB. liability_preprocessor ( p_plan_id ) ;

365: END IF ;
366:
367: /* This preprocessor updates the Agreement details for the forecast liability views */
368:
369: MSD_COMMON_UTILITIES_LB. liability_preprocessor ( p_plan_id ) ;
370:
371:
372:
373:

Line 376: x_liab_plan_id := MSD_COMMON_UTILITIES_LB.get_demand_plan_id( p_plan_id) ;

372:
373:
374: /* Finding out if demand plan for the given Liability Plan Exists */
375:
376: x_liab_plan_id := MSD_COMMON_UTILITIES_LB.get_demand_plan_id( p_plan_id) ;
377:
378: IF x_liab_plan_id IS NULL THEN
379:
380: /* Inputs to Template */

Line 382: x_liab_plan_name := MSD_COMMON_UTILITIES_LB.get_supply_plan_name( p_plan_id ) ;

378: IF x_liab_plan_id IS NULL THEN
379:
380: /* Inputs to Template */
381:
382: x_liab_plan_name := MSD_COMMON_UTILITIES_LB.get_supply_plan_name( p_plan_id ) ;
383: x_plan_owning_org := MSD_COMMON_UTILITIES_LB.get_plan_owning_org(p_plan_id) ;
384: x_plan_owning_instance := MSD_COMMON_UTILITIES_LB.get_plan_owning_instance( p_plan_id) ;
385: x_default_mfg_cal := MSD_COMMON_UTILITIES_LB.get_default_mfg_cal( x_plan_owning_org ,x_plan_owning_instance) ;
386:

Line 383: x_plan_owning_org := MSD_COMMON_UTILITIES_LB.get_plan_owning_org(p_plan_id) ;

379:
380: /* Inputs to Template */
381:
382: x_liab_plan_name := MSD_COMMON_UTILITIES_LB.get_supply_plan_name( p_plan_id ) ;
383: x_plan_owning_org := MSD_COMMON_UTILITIES_LB.get_plan_owning_org(p_plan_id) ;
384: x_plan_owning_instance := MSD_COMMON_UTILITIES_LB.get_plan_owning_instance( p_plan_id) ;
385: x_default_mfg_cal := MSD_COMMON_UTILITIES_LB.get_default_mfg_cal( x_plan_owning_org ,x_plan_owning_instance) ;
386:
387: display_message( ' x_plan_owning_org:'|| x_plan_owning_org , DEBUG ) ;

Line 384: x_plan_owning_instance := MSD_COMMON_UTILITIES_LB.get_plan_owning_instance( p_plan_id) ;

380: /* Inputs to Template */
381:
382: x_liab_plan_name := MSD_COMMON_UTILITIES_LB.get_supply_plan_name( p_plan_id ) ;
383: x_plan_owning_org := MSD_COMMON_UTILITIES_LB.get_plan_owning_org(p_plan_id) ;
384: x_plan_owning_instance := MSD_COMMON_UTILITIES_LB.get_plan_owning_instance( p_plan_id) ;
385: x_default_mfg_cal := MSD_COMMON_UTILITIES_LB.get_default_mfg_cal( x_plan_owning_org ,x_plan_owning_instance) ;
386:
387: display_message( ' x_plan_owning_org:'|| x_plan_owning_org , DEBUG ) ;
388:

Line 385: x_default_mfg_cal := MSD_COMMON_UTILITIES_LB.get_default_mfg_cal( x_plan_owning_org ,x_plan_owning_instance) ;

381:
382: x_liab_plan_name := MSD_COMMON_UTILITIES_LB.get_supply_plan_name( p_plan_id ) ;
383: x_plan_owning_org := MSD_COMMON_UTILITIES_LB.get_plan_owning_org(p_plan_id) ;
384: x_plan_owning_instance := MSD_COMMON_UTILITIES_LB.get_plan_owning_instance( p_plan_id) ;
385: x_default_mfg_cal := MSD_COMMON_UTILITIES_LB.get_default_mfg_cal( x_plan_owning_org ,x_plan_owning_instance) ;
386:
387: display_message( ' x_plan_owning_org:'|| x_plan_owning_org , DEBUG ) ;
388:
389: display_message( ' x_plan_owning_instance :'||x_plan_owning_instance ,DEBUG );

Line 416: x_liab_plan_id := MSD_COMMON_UTILITIES_LB.get_demand_plan_id( p_plan_id) ;

412:
413:
414:
415:
416: x_liab_plan_id := MSD_COMMON_UTILITIES_LB.get_demand_plan_id( p_plan_id) ;
417:
418: /* Updating the output Levels of the Total Liability */
419: /* If there is a change of profile in two consecutive run the program will give a warning */
420: /* If the profile value is null then a warning will be given and the output level will be defaulted to Item */

Line 496: x_plan_end_date := MSD_COMMON_UTILITIES_LB.get_cp_end_date ;

492:
493: /* Set the Plan Start Date and End Date in MSD_DEMAND_PLAN */
494:
495: /* IF p_plan_id = -1 THEN
496: x_plan_end_date := MSD_COMMON_UTILITIES_LB.get_cp_end_date ;
497: END IF ;
498: */
499: ---display_message('CS_NAME ', x_liab_plan_name ) ;
500:

Line 543: retcode := MSD_COMMON_UTILITIES_LB.liability_plan_update( x_liab_plan_id ) ;

539: /* Set the Previous Plan dates */
540:
541: display_message('Set the Previous Plan dates' , DEBUG) ;
542:
543: retcode := MSD_COMMON_UTILITIES_LB.liability_plan_update( x_liab_plan_id ) ;
544:
545: commit ;
546:
547: /* IF LIABILITY run happens without intermediate ascp plan run and take the uploaded liability

Line 559: display_message('Plan Name: '||MSD_COMMON_UTILITIES_LB.get_supply_plan_name(p_plan_id), DEBUG );

555: display_message('Plan Details ' , DEBUG);
556:
557: display_message('Plan Id: '||p_plan_id, DEBUG );
558:
559: display_message('Plan Name: '||MSD_COMMON_UTILITIES_LB.get_supply_plan_name(p_plan_id), DEBUG );
560:
561: display_message('Plan Start Date : '||x_plan_start_date , DEBUG );
562:
563: display_message('Plan End Date : '||x_plan_end_date , DEBUG );

Line 581: x_plan_end_date := MSD_COMMON_UTILITIES_LB.get_cp_end_date ;

577:
578:
579: IF p_plan_id = -1 THEN
580:
581: x_plan_end_date := MSD_COMMON_UTILITIES_LB.get_cp_end_date ;
582:
583:
584:
585: UPDATE msd_dp_parameters set start_date = x_plan_start_date , end_date = x_plan_end_date

Line 623: x_liab_plan_id := MSD_COMMON_UTILITIES_LB.get_demand_plan_id( p_plan_id) ;

619:
620:
621: /* Validation of Demand Plan */
622:
623: x_liab_plan_id := MSD_COMMON_UTILITIES_LB.get_demand_plan_id( p_plan_id) ;
624:
625: /* The Demand Plan Plan Definition is locked so that the user cannot change any details */
626:
627:

Line 651: --- strCmd := 'aw attach FALIU_ODP ro; call BLD.LIABILITY(''' || MSD_COMMON_UTILITIES_LB.get_demand_plan_id(p_plan_id) || ''' ;)';

647: /* Start:DPE Download */
648: /* Place Holder for DPE API */
649: display_message('Before the call of Build API' ,DEBUG );
650:
651: --- strCmd := 'aw attach FALIU_ODP ro; call BLD.LIABILITY(''' || MSD_COMMON_UTILITIES_LB.get_demand_plan_id(p_plan_id) || ''' ;)';
652: strCodeAW := nvl( fnd_profile.value('MSD_CODE_AW'), 'ODPCODE') ;
653: strCmd := 'aw attach '|| strCodeAW ||' ro; call BLD.LIABILITY(''' || MSD_COMMON_UTILITIES_LB.get_demand_plan_id(p_plan_id) || ''');';
654:
655: display_message(strCmd ,DEBUG );

Line 653: strCmd := 'aw attach '|| strCodeAW ||' ro; call BLD.LIABILITY(''' || MSD_COMMON_UTILITIES_LB.get_demand_plan_id(p_plan_id) || ''');';

649: display_message('Before the call of Build API' ,DEBUG );
650:
651: --- strCmd := 'aw attach FALIU_ODP ro; call BLD.LIABILITY(''' || MSD_COMMON_UTILITIES_LB.get_demand_plan_id(p_plan_id) || ''' ;)';
652: strCodeAW := nvl( fnd_profile.value('MSD_CODE_AW'), 'ODPCODE') ;
653: strCmd := 'aw attach '|| strCodeAW ||' ro; call BLD.LIABILITY(''' || MSD_COMMON_UTILITIES_LB.get_demand_plan_id(p_plan_id) || ''');';
654:
655: display_message(strCmd ,DEBUG );
656:
657: dbms_aw.execute(strCmd);

Line 663: -- retcode := MSD_COMMON_UTILITIES_LB.liability_post_process( 97608 , 'TOTAL_LIABILITY', 1) ;

659: display_message('After the call of Build API' ,DEBUG );
660:
661: /* IF the build errors out then the error out handling is done */
662:
663: -- retcode := MSD_COMMON_UTILITIES_LB.liability_post_process( 97608 , 'TOTAL_LIABILITY', 1) ;
664: Select DP_BUILD_ERROR_FLAG into x_DP_BUILD_ERROR_FLAG
665: from msd_demand_plans
666: where demand_plan_id = MSD_COMMON_UTILITIES_LB.get_demand_plan_id(p_plan_id) ;
667:

Line 666: where demand_plan_id = MSD_COMMON_UTILITIES_LB.get_demand_plan_id(p_plan_id) ;

662:
663: -- retcode := MSD_COMMON_UTILITIES_LB.liability_post_process( 97608 , 'TOTAL_LIABILITY', 1) ;
664: Select DP_BUILD_ERROR_FLAG into x_DP_BUILD_ERROR_FLAG
665: from msd_demand_plans
666: where demand_plan_id = MSD_COMMON_UTILITIES_LB.get_demand_plan_id(p_plan_id) ;
667:
668: IF nvl( x_DP_BUILD_ERROR_FLAG , 'NO') = 'YES' THEN
669: display_message('Plan Build Unsuccessful' ,ERROR );
670: END IF ;

Line 680: Delete_duplicate(p_plan_id , MSD_COMMON_UTILITIES_LB.LEVEL_VALUES_STAGING_TABLE);

676: EXCEPTION
677:
678: WHEN others THEN
679: BEGIN
680: Delete_duplicate(p_plan_id , MSD_COMMON_UTILITIES_LB.LEVEL_VALUES_STAGING_TABLE);
681: Delete_duplicate_lvl_assoc(errbuf, retcode, p_plan_id);
682: COMMIT;
683: EXCEPTION
684: WHEN others THEN

Line 787: x_plan_id := MSD_COMMON_UTILITIES_LB.get_supply_plan_id( p_demand_plan_id) ;

783:
784: retcode := 0 ;
785:
786:
787: x_plan_id := MSD_COMMON_UTILITIES_LB.get_supply_plan_id( p_demand_plan_id) ;
788:
789: x_plan_name := MSD_COMMON_UTILITIES_LB.get_supply_plan_name( x_plan_id ) ;
790:
791: Lock_Row( p_demand_plan_id ) ;

Line 789: x_plan_name := MSD_COMMON_UTILITIES_LB.get_supply_plan_name( x_plan_id ) ;

785:
786:
787: x_plan_id := MSD_COMMON_UTILITIES_LB.get_supply_plan_id( p_demand_plan_id) ;
788:
789: x_plan_name := MSD_COMMON_UTILITIES_LB.get_supply_plan_name( x_plan_id ) ;
790:
791: Lock_Row( p_demand_plan_id ) ;
792:
793: /* Loop through the levels that do not have Level Value data in the level Values Table */

Line 1026: x_dest_table := MSD_COMMON_UTILITIES_LB.LEVEL_VALUES_STAGING_TABLE ;

1022:
1023:
1024:
1025: /* Always 2 step collection */
1026: x_dest_table := MSD_COMMON_UTILITIES_LB.LEVEL_VALUES_STAGING_TABLE ;
1027: v_dest_ass_table := MSD_COMMON_UTILITIES_LB.LEVEL_ASSOC_STAGING_TABLE;
1028:
1029:
1030: /* Relationship LOOP */

Line 1027: v_dest_ass_table := MSD_COMMON_UTILITIES_LB.LEVEL_ASSOC_STAGING_TABLE;

1023:
1024:
1025: /* Always 2 step collection */
1026: x_dest_table := MSD_COMMON_UTILITIES_LB.LEVEL_VALUES_STAGING_TABLE ;
1027: v_dest_ass_table := MSD_COMMON_UTILITIES_LB.LEVEL_ASSOC_STAGING_TABLE;
1028:
1029:
1030: /* Relationship LOOP */
1031: For Relationship_Rec IN Relationship(p_level_id, p_parent_level_id) LOOP

Line 1209: Delete_duplicate(p_plan_id, MSD_COMMON_UTILITIES_LB.LEVEL_VALUES_STAGING_TABLE);

1205:
1206: end loop ;
1207:
1208: /* delete duplicate data */
1209: Delete_duplicate(p_plan_id, MSD_COMMON_UTILITIES_LB.LEVEL_VALUES_STAGING_TABLE);
1210:
1211: /* Delete duplicate level association from staging table */
1212: Delete_duplicate_lvl_assoc(errbuf, retcode, p_plan_id);
1213:

Line 1236: if p_dest_table = MSD_COMMON_UTILITIES_LB.LEVEL_VALUES_STAGING_TABLE then

1232: /* This procedure deletes duplicate records from staging level_values
1233: Key - Plan_id + Level_Id + SR_LEVEL_PK
1234: */
1235:
1236: if p_dest_table = MSD_COMMON_UTILITIES_LB.LEVEL_VALUES_STAGING_TABLE then
1237: delete from msd_st_level_values_lb a where
1238: a.plan_id = p_plan_id and
1239: rowid <> (select max(rowid) from msd_st_level_values_lb b
1240: where a.plan_id = b.plan_id and a.level_id = b.level_id and a.sr_level_pk = b.sr_level_pk);

Line 1345: IF (p_dest_table = MSD_COMMON_UTILITIES_LB.LEVEL_VALUES_FACT_TABLE) THEN

1341: Savepoint Before_Delete ;
1342:
1343: /* Beginning of IF 1 */
1344: -- fnd_file.put_line(fnd_file.log,'***********'||p_dest_table );
1345: IF (p_dest_table = MSD_COMMON_UTILITIES_LB.LEVEL_VALUES_FACT_TABLE) THEN
1346: -- fnd_file.put_line(fnd_file.log,'***********'||p_dest_table );
1347: v_dest_ass_table := MSD_COMMON_UTILITIES_LB.LEVEL_ASSOC_FACT_TABLE ;
1348: v_sr_ass_table := MSD_COMMON_UTILITIES_LB.LEVEL_ASSOC_STAGING_TABLE ;
1349:

Line 1347: v_dest_ass_table := MSD_COMMON_UTILITIES_LB.LEVEL_ASSOC_FACT_TABLE ;

1343: /* Beginning of IF 1 */
1344: -- fnd_file.put_line(fnd_file.log,'***********'||p_dest_table );
1345: IF (p_dest_table = MSD_COMMON_UTILITIES_LB.LEVEL_VALUES_FACT_TABLE) THEN
1346: -- fnd_file.put_line(fnd_file.log,'***********'||p_dest_table );
1347: v_dest_ass_table := MSD_COMMON_UTILITIES_LB.LEVEL_ASSOC_FACT_TABLE ;
1348: v_sr_ass_table := MSD_COMMON_UTILITIES_LB.LEVEL_ASSOC_STAGING_TABLE ;
1349:
1350: /* First time to process this level_id */
1351: IF (p_update_lvl_table = 1) THEN

Line 1348: v_sr_ass_table := MSD_COMMON_UTILITIES_LB.LEVEL_ASSOC_STAGING_TABLE ;

1344: -- fnd_file.put_line(fnd_file.log,'***********'||p_dest_table );
1345: IF (p_dest_table = MSD_COMMON_UTILITIES_LB.LEVEL_VALUES_FACT_TABLE) THEN
1346: -- fnd_file.put_line(fnd_file.log,'***********'||p_dest_table );
1347: v_dest_ass_table := MSD_COMMON_UTILITIES_LB.LEVEL_ASSOC_FACT_TABLE ;
1348: v_sr_ass_table := MSD_COMMON_UTILITIES_LB.LEVEL_ASSOC_STAGING_TABLE ;
1349:
1350: /* First time to process this level_id */
1351: IF (p_update_lvl_table = 1) THEN
1352: /* Insert deleted level values into deleted_level_value table and delete it

Line 1379: ELSIF (p_dest_table = MSD_COMMON_UTILITIES_LB.LEVEL_VALUES_STAGING_TABLE) THEN

1375: p_parent_level_id,
1376: p_seq_num);
1377:
1378: /* ELSE for IF 1. COLLECTION */
1379: ELSIF (p_dest_table = MSD_COMMON_UTILITIES_LB.LEVEL_VALUES_STAGING_TABLE) THEN
1380: --- fnd_file.put_line(fnd_file.log,'5:translate Level Values ' );
1381: v_dest_ass_table := MSD_COMMON_UTILITIES_LB.LEVEL_ASSOC_STAGING_TABLE;
1382:
1383: /* Delete Staging Table only if delete flag = Yes */

Line 1381: v_dest_ass_table := MSD_COMMON_UTILITIES_LB.LEVEL_ASSOC_STAGING_TABLE;

1377:
1378: /* ELSE for IF 1. COLLECTION */
1379: ELSIF (p_dest_table = MSD_COMMON_UTILITIES_LB.LEVEL_VALUES_STAGING_TABLE) THEN
1380: --- fnd_file.put_line(fnd_file.log,'5:translate Level Values ' );
1381: v_dest_ass_table := MSD_COMMON_UTILITIES_LB.LEVEL_ASSOC_STAGING_TABLE;
1382:
1383: /* Delete Staging Table only if delete flag = Yes */
1384: IF (p_delete_flag = 'Y') THEN
1385: /* First time to process this level_id */

Line 1599: a_level_pk( k ) := MSD_COMMON_UTILITIES_LB.get_level_pk( p_level_id , a_sr_level_pk(k)) ;

1595: /* Generate Level_pk */
1596: FOR k IN a_sr_level_pk.FIRST..a_sr_level_pk.LAST LOOP
1597: -- fnd_file.put_line(fnd_file.log,'**Inside level_pk generation 1********');
1598: a_level_pk.extend ;
1599: a_level_pk( k ) := MSD_COMMON_UTILITIES_LB.get_level_pk( p_level_id , a_sr_level_pk(k)) ;
1600: --- fnd_file.put_line(fnd_file.log,'**Inside level_pk generation 2********');
1601: END LOOP ;
1602:
1603: ---fnd_file.put_line(fnd_file.log,'**inserting into fact********');

Line 1813: IF (p_dest_table = MSD_COMMON_UTILITIES_LB.LEVEL_VALUES_FACT_TABLE) THEN

1809: /* Note that we will not be able to get the attributes 1 - 5 for the
1810: Top level as we will not have a separate view for the top level */
1811: ---fnd_file.put_line(fnd_file.log,'2:PROCESS_TOP_LEVEL_VALUES '||p_parent_level_id );
1812: /* For PULL */
1813: IF (p_dest_table = MSD_COMMON_UTILITIES_LB.LEVEL_VALUES_FACT_TABLE) THEN
1814: PROCESS_LEVEL_VALUE_PER_ROW( errbuf,
1815: retcode,
1816: p_plan_id,
1817: p_parent_level_id,

Line 1876: x_source_table VARCHAR2(50) := MSD_COMMON_UTILITIES_LB.LEVEL_VALUES_STAGING_TABLE ;

1872: retcode OUT NOCOPY VARCHAR2,
1873: p_plan_id IN NUMBER)
1874: IS
1875:
1876: x_source_table VARCHAR2(50) := MSD_COMMON_UTILITIES_LB.LEVEL_VALUES_STAGING_TABLE ;
1877: x_dest_table VARCHAR2(50) := MSD_COMMON_UTILITIES_LB.LEVEL_VALUES_FACT_TABLE ;
1878: x_plan_id NUMBER := 0;
1879: x_level_id NUMBER := 0;
1880: v_sql_stmt varchar2(4000);

Line 1877: x_dest_table VARCHAR2(50) := MSD_COMMON_UTILITIES_LB.LEVEL_VALUES_FACT_TABLE ;

1873: p_plan_id IN NUMBER)
1874: IS
1875:
1876: x_source_table VARCHAR2(50) := MSD_COMMON_UTILITIES_LB.LEVEL_VALUES_STAGING_TABLE ;
1877: x_dest_table VARCHAR2(50) := MSD_COMMON_UTILITIES_LB.LEVEL_VALUES_FACT_TABLE ;
1878: x_plan_id NUMBER := 0;
1879: x_level_id NUMBER := 0;
1880: v_sql_stmt varchar2(4000);
1881: g_retcode varchar2(5) := '0';

Line 1928: p_level_value_column => MSD_COMMON_UTILITIES_LB.LEVEL_VALUE_COLUMN,

1924: p_source_table => x_source_table,
1925: p_dest_table => x_dest_table,
1926: p_plan_id => Relationship_Rec.plan_id,
1927: p_level_id => Relationship_Rec.level_id,
1928: p_level_value_column => MSD_COMMON_UTILITIES_LB.LEVEL_VALUE_COLUMN,
1929: p_level_value_pk_column => MSD_COMMON_UTILITIES_LB.LEVEL_VALUE_PK_COLUMN,
1930: p_level_value_desc_column => MSD_COMMON_UTILITIES_LB.LEVEL_VALUE_DESC_COLUMN,
1931: p_parent_level_id => Relationship_Rec.parent_level_id,
1932: p_parent_value_column => MSD_COMMON_UTILITIES_LB.PARENT_LEVEL_VALUE_COLUMN,

Line 1929: p_level_value_pk_column => MSD_COMMON_UTILITIES_LB.LEVEL_VALUE_PK_COLUMN,

1925: p_dest_table => x_dest_table,
1926: p_plan_id => Relationship_Rec.plan_id,
1927: p_level_id => Relationship_Rec.level_id,
1928: p_level_value_column => MSD_COMMON_UTILITIES_LB.LEVEL_VALUE_COLUMN,
1929: p_level_value_pk_column => MSD_COMMON_UTILITIES_LB.LEVEL_VALUE_PK_COLUMN,
1930: p_level_value_desc_column => MSD_COMMON_UTILITIES_LB.LEVEL_VALUE_DESC_COLUMN,
1931: p_parent_level_id => Relationship_Rec.parent_level_id,
1932: p_parent_value_column => MSD_COMMON_UTILITIES_LB.PARENT_LEVEL_VALUE_COLUMN,
1933: p_parent_value_pk_column => MSD_COMMON_UTILITIES_LB.PARENT_LEVEL_VALUE_PK_COLUMN,

Line 1930: p_level_value_desc_column => MSD_COMMON_UTILITIES_LB.LEVEL_VALUE_DESC_COLUMN,

1926: p_plan_id => Relationship_Rec.plan_id,
1927: p_level_id => Relationship_Rec.level_id,
1928: p_level_value_column => MSD_COMMON_UTILITIES_LB.LEVEL_VALUE_COLUMN,
1929: p_level_value_pk_column => MSD_COMMON_UTILITIES_LB.LEVEL_VALUE_PK_COLUMN,
1930: p_level_value_desc_column => MSD_COMMON_UTILITIES_LB.LEVEL_VALUE_DESC_COLUMN,
1931: p_parent_level_id => Relationship_Rec.parent_level_id,
1932: p_parent_value_column => MSD_COMMON_UTILITIES_LB.PARENT_LEVEL_VALUE_COLUMN,
1933: p_parent_value_pk_column => MSD_COMMON_UTILITIES_LB.PARENT_LEVEL_VALUE_PK_COLUMN,
1934: p_parent_value_desc_column => MSD_COMMON_UTILITIES_LB.PARENT_LEVEL_VALUE_DESC_COLUMN,

Line 1932: p_parent_value_column => MSD_COMMON_UTILITIES_LB.PARENT_LEVEL_VALUE_COLUMN,

1928: p_level_value_column => MSD_COMMON_UTILITIES_LB.LEVEL_VALUE_COLUMN,
1929: p_level_value_pk_column => MSD_COMMON_UTILITIES_LB.LEVEL_VALUE_PK_COLUMN,
1930: p_level_value_desc_column => MSD_COMMON_UTILITIES_LB.LEVEL_VALUE_DESC_COLUMN,
1931: p_parent_level_id => Relationship_Rec.parent_level_id,
1932: p_parent_value_column => MSD_COMMON_UTILITIES_LB.PARENT_LEVEL_VALUE_COLUMN,
1933: p_parent_value_pk_column => MSD_COMMON_UTILITIES_LB.PARENT_LEVEL_VALUE_PK_COLUMN,
1934: p_parent_value_desc_column => MSD_COMMON_UTILITIES_LB.PARENT_LEVEL_VALUE_DESC_COLUMN,
1935: p_update_lvl_table => 0,
1936:

Line 1933: p_parent_value_pk_column => MSD_COMMON_UTILITIES_LB.PARENT_LEVEL_VALUE_PK_COLUMN,

1929: p_level_value_pk_column => MSD_COMMON_UTILITIES_LB.LEVEL_VALUE_PK_COLUMN,
1930: p_level_value_desc_column => MSD_COMMON_UTILITIES_LB.LEVEL_VALUE_DESC_COLUMN,
1931: p_parent_level_id => Relationship_Rec.parent_level_id,
1932: p_parent_value_column => MSD_COMMON_UTILITIES_LB.PARENT_LEVEL_VALUE_COLUMN,
1933: p_parent_value_pk_column => MSD_COMMON_UTILITIES_LB.PARENT_LEVEL_VALUE_PK_COLUMN,
1934: p_parent_value_desc_column => MSD_COMMON_UTILITIES_LB.PARENT_LEVEL_VALUE_DESC_COLUMN,
1935: p_update_lvl_table => 0,
1936:
1937: p_delete_flag => x_delete_flag,

Line 1934: p_parent_value_desc_column => MSD_COMMON_UTILITIES_LB.PARENT_LEVEL_VALUE_DESC_COLUMN,

1930: p_level_value_desc_column => MSD_COMMON_UTILITIES_LB.LEVEL_VALUE_DESC_COLUMN,
1931: p_parent_level_id => Relationship_Rec.parent_level_id,
1932: p_parent_value_column => MSD_COMMON_UTILITIES_LB.PARENT_LEVEL_VALUE_COLUMN,
1933: p_parent_value_pk_column => MSD_COMMON_UTILITIES_LB.PARENT_LEVEL_VALUE_PK_COLUMN,
1934: p_parent_value_desc_column => MSD_COMMON_UTILITIES_LB.PARENT_LEVEL_VALUE_DESC_COLUMN,
1935: p_update_lvl_table => 0,
1936:
1937: p_delete_flag => x_delete_flag,
1938: p_seq_num => l_seq_num

Line 1967: p_level_value_column => MSD_COMMON_UTILITIES_LB.LEVEL_VALUE_COLUMN,

1963: p_source_table => x_source_table,
1964: p_dest_table => x_dest_table,
1965: p_plan_id => Relationship_Rec.plan_id,
1966: p_level_id => Relationship_Rec.level_id,
1967: p_level_value_column => MSD_COMMON_UTILITIES_LB.LEVEL_VALUE_COLUMN,
1968: p_level_value_pk_column => MSD_COMMON_UTILITIES_LB.LEVEL_VALUE_PK_COLUMN,
1969: p_level_value_desc_column => MSD_COMMON_UTILITIES_LB.LEVEL_VALUE_DESC_COLUMN,
1970: p_parent_level_id => Relationship_Rec.parent_level_id,
1971: p_parent_value_column => MSD_COMMON_UTILITIES_LB.PARENT_LEVEL_VALUE_COLUMN,

Line 1968: p_level_value_pk_column => MSD_COMMON_UTILITIES_LB.LEVEL_VALUE_PK_COLUMN,

1964: p_dest_table => x_dest_table,
1965: p_plan_id => Relationship_Rec.plan_id,
1966: p_level_id => Relationship_Rec.level_id,
1967: p_level_value_column => MSD_COMMON_UTILITIES_LB.LEVEL_VALUE_COLUMN,
1968: p_level_value_pk_column => MSD_COMMON_UTILITIES_LB.LEVEL_VALUE_PK_COLUMN,
1969: p_level_value_desc_column => MSD_COMMON_UTILITIES_LB.LEVEL_VALUE_DESC_COLUMN,
1970: p_parent_level_id => Relationship_Rec.parent_level_id,
1971: p_parent_value_column => MSD_COMMON_UTILITIES_LB.PARENT_LEVEL_VALUE_COLUMN,
1972: p_parent_value_pk_column => MSD_COMMON_UTILITIES_LB.PARENT_LEVEL_VALUE_PK_COLUMN,

Line 1969: p_level_value_desc_column => MSD_COMMON_UTILITIES_LB.LEVEL_VALUE_DESC_COLUMN,

1965: p_plan_id => Relationship_Rec.plan_id,
1966: p_level_id => Relationship_Rec.level_id,
1967: p_level_value_column => MSD_COMMON_UTILITIES_LB.LEVEL_VALUE_COLUMN,
1968: p_level_value_pk_column => MSD_COMMON_UTILITIES_LB.LEVEL_VALUE_PK_COLUMN,
1969: p_level_value_desc_column => MSD_COMMON_UTILITIES_LB.LEVEL_VALUE_DESC_COLUMN,
1970: p_parent_level_id => Relationship_Rec.parent_level_id,
1971: p_parent_value_column => MSD_COMMON_UTILITIES_LB.PARENT_LEVEL_VALUE_COLUMN,
1972: p_parent_value_pk_column => MSD_COMMON_UTILITIES_LB.PARENT_LEVEL_VALUE_PK_COLUMN,
1973: p_parent_value_desc_column => MSD_COMMON_UTILITIES_LB.PARENT_LEVEL_VALUE_DESC_COLUMN,

Line 1971: p_parent_value_column => MSD_COMMON_UTILITIES_LB.PARENT_LEVEL_VALUE_COLUMN,

1967: p_level_value_column => MSD_COMMON_UTILITIES_LB.LEVEL_VALUE_COLUMN,
1968: p_level_value_pk_column => MSD_COMMON_UTILITIES_LB.LEVEL_VALUE_PK_COLUMN,
1969: p_level_value_desc_column => MSD_COMMON_UTILITIES_LB.LEVEL_VALUE_DESC_COLUMN,
1970: p_parent_level_id => Relationship_Rec.parent_level_id,
1971: p_parent_value_column => MSD_COMMON_UTILITIES_LB.PARENT_LEVEL_VALUE_COLUMN,
1972: p_parent_value_pk_column => MSD_COMMON_UTILITIES_LB.PARENT_LEVEL_VALUE_PK_COLUMN,
1973: p_parent_value_desc_column => MSD_COMMON_UTILITIES_LB.PARENT_LEVEL_VALUE_DESC_COLUMN,
1974: p_update_lvl_table => 1,
1975: p_delete_flag => x_delete_flag,

Line 1972: p_parent_value_pk_column => MSD_COMMON_UTILITIES_LB.PARENT_LEVEL_VALUE_PK_COLUMN,

1968: p_level_value_pk_column => MSD_COMMON_UTILITIES_LB.LEVEL_VALUE_PK_COLUMN,
1969: p_level_value_desc_column => MSD_COMMON_UTILITIES_LB.LEVEL_VALUE_DESC_COLUMN,
1970: p_parent_level_id => Relationship_Rec.parent_level_id,
1971: p_parent_value_column => MSD_COMMON_UTILITIES_LB.PARENT_LEVEL_VALUE_COLUMN,
1972: p_parent_value_pk_column => MSD_COMMON_UTILITIES_LB.PARENT_LEVEL_VALUE_PK_COLUMN,
1973: p_parent_value_desc_column => MSD_COMMON_UTILITIES_LB.PARENT_LEVEL_VALUE_DESC_COLUMN,
1974: p_update_lvl_table => 1,
1975: p_delete_flag => x_delete_flag,
1976: p_seq_num => l_seq_num

Line 1973: p_parent_value_desc_column => MSD_COMMON_UTILITIES_LB.PARENT_LEVEL_VALUE_DESC_COLUMN,

1969: p_level_value_desc_column => MSD_COMMON_UTILITIES_LB.LEVEL_VALUE_DESC_COLUMN,
1970: p_parent_level_id => Relationship_Rec.parent_level_id,
1971: p_parent_value_column => MSD_COMMON_UTILITIES_LB.PARENT_LEVEL_VALUE_COLUMN,
1972: p_parent_value_pk_column => MSD_COMMON_UTILITIES_LB.PARENT_LEVEL_VALUE_PK_COLUMN,
1973: p_parent_value_desc_column => MSD_COMMON_UTILITIES_LB.PARENT_LEVEL_VALUE_DESC_COLUMN,
1974: p_update_lvl_table => 1,
1975: p_delete_flag => x_delete_flag,
1976: p_seq_num => l_seq_num
1977: ) ;

Line 2178: x_base_uom := MSD_COMMON_UTILITIES_LB .get_default_uom ;

2174: display_message('Profile MSC: Liability Base UOM not set ' ,WARNING) ;
2175:
2176:
2177:
2178: x_base_uom := MSD_COMMON_UTILITIES_LB .get_default_uom ;
2179:
2180: IF x_base_uom is NULL THEN
2181: display_message( 'Could not default the Liability Base UOM ', ERROR) ;
2182: retcode := 2 ;