122:
123: --
124: -- Forward Declarations
125: --
126: PG_DEBUG Number := NVL(FND_PROFILE.value('ONT_DEBUG_LEVEL'), 0);
127:
128:
129:
130: /*--------------------------------------------------------------------------+
1476:
1477:
1478: lStmtNumber := 30;
1479: /* get MRP's default assignment set */
1480: lMrpAssignmentSet := to_number(FND_PROFILE.VALUE('MRP_DEFAULT_ASSIGNMENT_SET'));
1481:
1482: --- The following if condition is added by Renga Kannan
1483: --- If the line is part of buy model then we need not look at the sourcing info
1484: --- we can keep the parents rcv org as the org for this item also. This can be identified
2905: lAssignmentExists := 0;
2906:
2907: lStmtNum := 10;
2908: /* get MRP's default assignment set */
2909: lMrpAssignmentSet := to_number(FND_PROFILE.VALUE('MRP_DEFAULT_ASSIGNMENT_SET'));
2910:
2911:
2912:
2913:
3639: lAssignmentExists := 0;
3640:
3641: lStmtNum := 10;
3642: /* get MRP's default assignment set */
3643: lMrpAssignmentSet := to_number(FND_PROFILE.VALUE('MRP_DEFAULT_ASSIGNMENT_SET'));
3644:
3645: if( p_mode = 'AUTOCONFIG' ) then
3646:
3647: lUPGAssignmentSet := lMrpAssignmentSet ;
4447:
4448: IF gMrpAssignmentSet is null THEN
4449: begin
4450:
4451: gMrpAssignmentSet := to_number(FND_PROFILE.VALUE('MRP_DEFAULT_ASSIGNMENT_SET'));
4452: exception
4453: when others then
4454: raise invalid_mrp_assignment_set ;
4455: end ;
5140: lstmt_num Number;
5141: l_config_creation Varchar2(1);
5142: l_chk_org Varchar2(1) := 'N';
5143:
5144: PG_DEBUG Number := NVL(FND_PROFILE.value('ONT_DEBUG_LEVEL'), 0);
5145:
5146: /* Get all bcso orgs . This is needed determine final xOrgList */
5147: cursor get_bcso_orgs is
5148: select organization_id bcso_org_id