DBA Data[Home] [Help]

APPS.INV_CG_UPGRADE dependencies on MTL_PARAMETERS

Line 95: mtl_parameters WHERE organization_id = l_organization_id AND ROWNUM <

91: END IF;
92: /* Bug 4235102 fix */
93:
94: SELECT primary_cost_method INTO l_primary_cost_method FROM
95: mtl_parameters WHERE organization_id = l_organization_id AND ROWNUM <
96: 2;
97:
98: for c1 in subinventory_cursor
99:

Line 746: from mtl_parameters

742: , outside_processing_account
743: , expense_account
744: , encumbrance_account
745: , primary_cost_method
746: from mtl_parameters
747: where (
748: default_cost_group_id is null and
749: organization_id = l_organization_id
750: );

Line 780: l_table_name := 'mtl_parameters';

776: l_primary_cost_method NUMBER;
777: l_check_cost_group_id NUMBER := NULL;/* Bug 4235102 fix */
778: begin
779:
780: l_table_name := 'mtl_parameters';
781:
782: /* Bug 4235102 fix */
783: /* If there is atleast one record with a costgroup upgrade not needed */
784: BEGIN

Line 788: mtl_parameters

784: BEGIN
785: SELECT default_cost_group_id
786: INTO l_check_cost_group_id
787: FROM
788: mtl_parameters
789: WHERE
790: organization_id = l_organization_id
791: AND ROWNUM=1;
792: EXCEPTION

Line 924: update mtl_parameters

920: -- ** Stamp default cost group on org record
921:
922: -- dbms_output.put_line('before insert ');
923: -- dbms_output.put_line('cost gr is is' || To_char(l_cost_group_id) );
924: update mtl_parameters
925: set default_cost_group_id = l_cost_group_id
926: where organization_id = l_organization_id;
927: -- dbms_output.put_line('after insert');
928: end loop;

Line 954: -- l_return_err := 'mtl_parameters default cost group upgrade:'|| l_msg_data;

950: p_org_id => l_organization_id,
951: p_error_msg => Substr(l_msg_data,1,240),
952: p_proc_name => l_procedure_name);
953:
954: -- l_return_err := 'mtl_parameters default cost group upgrade:'|| l_msg_data;
955:
956: raise_application_error(-20000,l_return_err);
957:
958: when fnd_api.g_exc_unexpected_error THEN

Line 975: -- l_return_err := 'mtl_parameters default cost group upgrade:'||l_msg_data;

971: );
972:
973: l_msg_data := replace(l_msg_data,chr(0),' ');
974:
975: -- l_return_err := 'mtl_parameters default cost group upgrade:'||l_msg_data;
976:
977: INS_ERROR( p_table_name => l_table_name,
978: p_ROWID => l_rowid_info,
979: p_org_id => l_organization_id,

Line 991: -- l_return_err := 'mtl_parameters default cost group upgrade:'||

987:
988: IF(org_cursor%isopen) THEN CLOSE org_cursor; END IF;
989:
990: x_return_status := fnd_api.g_ret_sts_error ;
991: -- l_return_err := 'mtl_parameters default cost group upgrade:'||
992: -- substrb(sqlerrm,1,55);
993:
994:
995: INS_ERROR( p_table_name => l_table_name,

Line 1026: -- from mtl_parameters;

1022: -- ** --------------------------------------------------------
1023: -- */
1024: -- cursor mp_cursor is
1025: -- select organization_id
1026: -- from mtl_parameters;
1027:
1028: -- /*
1029: -- ** --------------------------------------------------------
1030: -- ** On hand records that do not have a default cost group yet

Line 1317: -- from mtl_parameters;

1313: -- ** --------------------------------------------------------
1314: -- */
1315: -- cursor mp_cursor is
1316: -- select organization_id
1317: -- from mtl_parameters;
1318:
1319: -- /*
1320: -- ** --------------------------------------------------------
1321: -- ** Transaction records that do not have a default cost group yet

Line 1645: from mtl_parameters where organization_id = l_transfer_organization_id ;

1641:
1642:
1643: if (l_transfer_cost_group_id is null and l_to_project_id is NOT null) then
1644: select primary_cost_method into l_transfer_cost_method
1645: from mtl_parameters where organization_id = l_transfer_organization_id ;
1646:
1647: if ( l_transfer_cost_method = 1 ) then
1648: l_transfer_cost_group_id := inv_sub_cg_util.get_cg_from_sub(
1649: x_return_status => l_return_status

Line 1871: from mtl_parameters ;

1867: msg_count NUMBER;
1868: msg_data VARCHAR2(240);
1869: l_cost_method number ;
1870: cursor oid_cursor is select organization_id, primary_cost_method
1871: from mtl_parameters ;
1872:
1873: BEGIN
1874:
1875:

Line 1999: -- from mtl_parameters;

1995: -- ** --------------------------------------------------------
1996: -- */
1997: -- cursor mp_cursor is
1998: -- select organization_id
1999: -- from mtl_parameters;
2000:
2001: -- /*
2002: -- ** --------------------------------------------------------
2003: -- ** On hand records that do not have a default cost group yet

Line 2288: -- from mtl_parameters;

2284: -- ** --------------------------------------------------------
2285: -- */
2286: -- cursor mp_cursor is
2287: -- select organization_id
2288: -- from mtl_parameters;
2289:
2290: -- /*
2291: -- ** --------------------------------------------------------
2292: -- ** On hand records that do not have a default cost group yet

Line 2575: -- from mtl_parameters;

2571: -- ** --------------------------------------------------------
2572: -- */
2573: -- cursor mp_cursor is
2574: -- select organization_id
2575: -- from mtl_parameters;
2576:
2577: -- /*
2578: -- ** --------------------------------------------------------
2579: -- ** On hand records that do not have a default cost group yet