APPS.OE_UPG_SO_NEW dependencies on OE_UPGRADE_DISTRIBUTION

Line 2960: from oe_upgrade_distribution

2956: end_header_id
2957: into
2958: v_start_header,
2959: v_end_header
2960: from oe_upgrade_distribution
2961: where slab = L_slab
2962: and nvl(line_type,'O') = L_line_type ;
2963:
2964: /* where nvl(alloted_flag,'N') = 'N' */

Line 4420: delete oe_upgrade_distribution

4416: --
4417: Begin
4418: v_type := L_type;
4419:
4420: delete oe_upgrade_distribution
4421: where line_type = v_type;
4422: commit;
4423:
4424:

Line 4552: DELETE FROM oe_upgrade_distribution

4548: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
4549: --
4550: BEGIN
4551:
4552: DELETE FROM oe_upgrade_distribution
4553: WHERE line_type = 'I';
4554:
4555: OPEN line_service_detail_count FOR l_cursor_stmt;
4556:

Line 4667: delete oe_upgrade_distribution

4663: --
4664: Begin
4665: v_type := 'H';
4666:
4667: delete oe_upgrade_distribution
4668: where line_type = v_type;
4669: commit;
4670:
4671:

Line 4783: DELETE oe_upgrade_distribution

4779: --
4780: BEGIN
4781: v_type := 'F';
4782:
4783: DELETE oe_upgrade_distribution
4784: WHERE line_type = v_type;
4785: COMMIT;
4786:
4787:

Line 4879: insert into oe_upgrade_distribution

4875: --
4876: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
4877: --
4878: Begin
4879: insert into oe_upgrade_distribution
4880: (
4881: slab,
4882: start_header_id,
4883: end_header_id,